Overview
The TikTok Ads data connector enables the ingestion of both delivery and metadata from TikTok’s advertising API. It is composed of two job streams—one for delivery metrics and one for metadata refresh. This integration facilitates campaign performance analysis with a comprehensive set of metrics and joins to enrich reporting capabilities.
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 |
|
Status |
|
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 |
|
Targets
Type | Table | Description | Priority | Update Mode | Create Target |
data |
| TikTok Ads - Delivery Data | 1 | append | true |
Job 2: TikTok Ads – Meta Refresh
Field | Value |
Feed |
|
Status |
|
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 |
| Campaign Meta | 1 |
lookup |
| AdGroup Meta | 2 |
lookup |
| Ad Meta | 3 |
Connection Configuration
Key | Description | Type | Required | Notes |
| TikTok Advertiser IDs | text | true | Comma-delimited list of advertiser IDs |
| TikTok App ID | hidden | true | Used internally |
| TikTok App Secret | hidden | true | Used internally |
Dimensions
Dimension Name | Field Source |
Campaign [TikTok] |
|
AdGroup [TikTok] |
|
Ad [TikTok] |
|
Base Metrics
Metric Name | Formula | Rounding | Prefix |
Spend [TikTok] |
| 2 | £ |
Clicks [TikTok] |
| 0 |
|
Impressions [TikTok] |
| 0 |
|
Comments [TikTok] |
| 0 |
|
Profile Visits [TikTok] |
| 0 |
|
Shares [TikTok] |
| 0 |
|
Button Click [TikTok] |
| 0 |
|
Video Watched 2s [TikTok] |
| 0 |
|
Video Watched 6s [TikTok] |
| 0 |
|
Video Views Quartile - 25% |
| 0 |
|
Video Views Quartile - 50% |
| 0 |
|
Video Views Quartile - 75% |
| 0 |
|
Video Views - 100% [TikTok] |
| 0 |
|
Video Views [TikTok] |
| 0 |
|
Composite Metrics
Metric Name | Formula | Round | Prefix | Suffix |
CTR [TikTok] |
| 2 |
| % |
CPC [TikTok] |
| 2 | £ |
|
CPM [TikTok] |
| 2 | £ |
|
CPV [TikTok] |
| 2 | £ |
|
VTR [TikTok] |
| 2 |
| % |
VCR [TikTok] |
| 2 |
| % |
Datasource Joins
Source Table | Joins |
|
|
Summary
The TikTok Ads integration provides a complete view of campaign performance, combining delivery metrics and metadata for detailed breakdowns by campaign, ad group, and ad. With robust metrics around engagement, video views, and costs, it supports performance monitoring and optimization use cases across brands leveraging TikTok for paid media.