Skip to main content

TikTok API Connector

Updated this week
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)

For more information on this connector and its use cases please follow this link

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?