Skip to main content

TikTok API Connector

Connect TikTok to import campaign, advertising and performance data for reporting and analysis.

Print on demand with TikTok ADS Manager - Print on Demand ...

Overview

TikTok Ads API provides programmatic access to campaign, ad group, and creative performance metrics for paid TikTok advertising campaigns. It supports In-Feed Ads, Spark Ads, Branded Content, TopView Ads, and Spark Ads, enabling marketers to monitor performance, optimise campaigns, and integrate TikTok data into dashboards.

Data handled by the integration:

Account & Campaign Data

  • Advertiser accounts and account IDs

  • Campaigns and ad groups

  • Campaign objectives (traffic, conversions, app installs, brand awareness, engagement)

  • Budgets, bids, and pacing configuration

  • Campaign and ad group status (active, paused, completed)

Creative & Ad Data

  • Creative metadata: ad ID, format, type (video, image, Spark Ads)

  • Associated campaign and ad group

  • Media assets (video, image), captions, call-to-actions

  • Approval status and policy compliance

Performance Metrics

  • Impressions, clicks, CTR

  • Cost, CPC, CPM, spend

  • Conversions and conversion value

  • Video metrics: views, watch time, completion rate

  • Engagement metrics: likes, shares, comments, saves

  • App install metrics (for app campaigns)

Audience & Targeting

  • Demographics (age, gender, location)

  • Device type (mobile, tablet)

  • Interests, behaviours, and custom audience segments

  • Retargeting and lookalike audiences

Metadata & Reference Tables

  • Account, campaign, and ad group hierarchy

  • Ad format and creative type definitions

  • Conversion event definitions

  • Geographic and demographic mappings

Granularity:

This integration retrieves data at: Account, Campaign, Ad group, Ad and Creative Levels which can be broken down by device type, location and demographic.

Purpose:

  • Monitor TikTok ad campaign performance

  • Analyse ad group and creative effectiveness

  • Track conversions, CTR, and engagement metrics

  • Optimise targeting, bidding, and creative strategy

  • Build dashboards integrating TikTok Ads with other paid channels

  • Conduct historical campaign audits and performance analysis

Refresh Cadence:

Data is refreshed daily.

Update Modes:

Append (for data table), Refresh (for metadata)

TikTok Ads API Authentication

When authenticating a connection to TikTok, you will have to log in using an account that has access to the advertiser IDs you wish to pull data for.

Once you have logged in to TikTok through the authentication link we share with you, you will be presented with the option of providing various levels of access.
​
For us to establish a fully functioning connection, we require a minimum of "Ads Management" and "Reporting" permissions.

See figure below for reference:

Job Configuration

Job 1: TikTok Ads – Delivery Import

Field

Value

Feed

tiktok

Status

1 (active)

Job Label

TikTok Ads - Delivery Import

Lookback Qty

5

Lookback Unit

day

First Run Hour

5

Poll Frequency

24

Update Mode

append

Create Target

true

Date Column

stat_time_day

Targets

Type

Table

Description

Priority

Update Mode

Create Target

data

tiktok_data_ad

TikTok Ads - Delivery Data

1

append

true

Job 2: TikTok Ads – Meta Refresh

Field

Value

Feed

tiktok

Status

1 (active)

Job Label

TikTok Ads - Meta Refresh

Lookback Qty

1

Lookback Unit

day

First Run Hour

7

Poll Frequency

24

Update Mode

refresh

Create Target

true

Targets

Type

Table

Description

Priority

lookup

tiktok_meta_campaign

Campaign Meta

1

lookup

tiktok_meta_adgroup

AdGroup Meta

2

lookup

tiktok_meta_ad

Ad Meta

3

Connection Configuration

Key

Description

Type

Required

Notes

tiktok_advertiser_id

TikTok Advertiser IDs

text

true

Comma-delimited list of advertiser IDs

tiktok_app_id

TikTok App ID

hidden

true

Used internally

tiktok_app_secret

TikTok App Secret

hidden

true

Used internally

Dimensions

Dimension Name

Field Source

Campaign [TikTok]

tiktok_meta_campaign.campaign_name

AdGroup [TikTok]

tiktok_meta_adgroup.adgroup_name

Ad [TikTok]

tiktok_meta_ad.ad_name

Base Metrics

Metric Name

Formula

Rounding

Prefix

Spend [TikTok]

SUM(tiktok_data_ad.spend)

2

£

Clicks [TikTok]

SUM(tiktok_data_ad.clicks)

0

Impressions [TikTok]

SUM(tiktok_data_ad.impressions)

0

Comments [TikTok]

SUM(tiktok_data_ad.comments)

0

Profile Visits [TikTok]

SUM(tiktok_data_ad.profile_visits)

0

Shares [TikTok]

SUM(tiktok_data_ad.shares)

0

Button Click [TikTok]

SUM(tiktok_data_ad.button_click)

0

Video Watched 2s [TikTok]

SUM(tiktok_data_ad.video_watched_2s)

0

Video Watched 6s [TikTok]

SUM(tiktok_data_ad.video_watched_6s)

0

Video Views Quartile - 25%

SUM(tiktok_data_ad.video_views_p25)

0

Video Views Quartile - 50%

SUM(tiktok_data_ad.video_views_p50)

0

Video Views Quartile - 75%

SUM(tiktok_data_ad.video_views_p75)

0

Video Views - 100% [TikTok]

SUM(tiktok_data_ad.video_views_p100)

0

Video Views [TikTok]

SUM(tiktok_data_ad.video_play_actions)

0

Composite Metrics

Metric Name

Formula

Round

Prefix

Suffix

CTR [TikTok]

{Clicks [TikTok]} / {Impressions [TikTok]} * 100

2

%

CPC [TikTok]

{Spend [TikTok]} / {Clicks [TikTok]}

2

£

CPM [TikTok]

({Spend [TikTok]} / {Impressions [TikTok]}) * 1000

2

£

CPV [TikTok]

{Spend [TikTok]} / {Video Views [TikTok]}

2

£

VTR [TikTok]

{Video Views - 100% [TikTok]} / {Impressions [TikTok]} * 100

2

%

VCR [TikTok]

{Video Views - 100% [TikTok]} / {Video Views [TikTok]} * 100

2

%

Datasource Joins

Source Table

Joins

tiktok_data_ad

ad_id → tiktok_meta_ad.ad_id
​adgroup_id → tiktok_meta_adgroup.adgroup_id
​campaign_id → tiktok_meta_campaign.campaign_id

Did this answer your question?