Linking TikTok Ads as a source
Let AI connect your sources for you
Skip the manual setup — run this in your project and the wizard auto-detects your databases and APIs and connects them to PostHog.
Contents
You can sync data from TikTok Ads reports by configuring it as a source in PostHog. The supported tables include entity tables, performance reports, and optional website attribution reports:
- Ad Groups
- Campaigns
- Ads
- Ad Groups Report: Filter by
adgroup_ids - Campaign Report: Filter by
campaign_ids - Ad Report: Filter by
ad_ids
Additional reports will be added based on user feedback we receive via our in-app support form.
Website attribution tables
TikTok Ads sources on API v2.0 can optionally sync daily website attribution reports at the campaign, ad group, and ad level:
campaign_website_attribution_reportad_group_website_attribution_reportad_website_attribution_report
These tables use TikTok's Reporting API v2.0 and provide click-attributed website purchase metrics:
cta_complete_payment– Number of website purchases attributed to ad clicks.cta_complete_payment_value– Total value of website purchases attributed to ad clicks.complete_payment– Total website purchases (all attribution).spend– Total spend for the reporting period.
These tables are off by default. Enable them in the table selection step when configuring your source.
New TikTok Ads sources default to API v2.0. Existing sources pinned to v1.3 keep their current table catalog and do not see these tables until the source version is changed to v2.0.
Upgraded Smart+ campaigns: In v2.0 website attribution tables,
ad_ididentifies the ad asset group rather than the legacy creative. Do not join this ID directly to legacy creative-level ad IDs for those campaigns.
Requirements
- A TikTok Ads account with permission to access data from accounts you want to sync.
Configuring PostHog
Connect PostHog to your TikTok Ads account. The TikTok account must have permission to access data.
- In PostHog, go to the Data pipelines tab.
- Open the + New drop-down menu in the top-right and select Source.
- Find TikTok Ads in the sources list and click Link.
- Select an existing TikTok Ads integration, or create a new one by clicking Connect.
- Select the advertiser account you want to sync from the dropdown.
- (Optional) Add a prefix for the table name.
Configuration
| Option | Type | Required |
|---|---|---|
TikTok Ads account | oauth | Yes |
TikTok Ads Advertiser ID | oauth-account-select | Yes |
Supported tables
| Table | Description | Sync method | Incremental field | Primary key |
|---|---|---|---|---|
advertiser_report | Daily advertiser spend, including the amount charged to cash rather than vouchers. | Incremental, Full refresh | stat_time_day | — |
campaigns | An advertising campaign in your TikTok Ads account, with its objective and budget. | Full refresh | — | — |
ad_groups | An ad group within a campaign, defining targeting, placement, and bidding. | Full refresh | — | — |
ads | An individual ad creative within an ad group. | Full refresh | — | — |
campaign_report | Daily performance metrics for each campaign. | Incremental, Full refresh | stat_time_day | — |
ad_group_report | Daily performance metrics for each ad group. | Incremental, Full refresh | stat_time_day | — |
ad_report | Daily performance metrics for each ad. | Incremental, Full refresh | stat_time_day | — |
creative_videos | A video asset in your TikTok Ads creative library, joinable to the video used by an ad. Requires creative asset read access on the authorized advertiser; without it TikTok refuses the request and this table can't sync. | Full refresh | — | — |
creative_images | An image asset in your TikTok Ads creative library, joinable to the images used by an ad. Requires creative asset read access on the authorized advertiser; without it TikTok refuses the request and this table can't sync. | Full refresh | — | — |
campaign_demographic_report | Daily campaign performance broken down by the viewer's gender and age bucket. | Incremental, Full refresh | stat_time_day | — |
campaign_country_report | Daily campaign performance broken down by the viewer's country. | Incremental, Full refresh | stat_time_day | — |
campaign_platform_report | Daily campaign performance broken down by the viewer's operating system. | Incremental, Full refresh | stat_time_day | — |
ad_group_demographic_report | Daily ad group performance broken down by the viewer's gender and age bucket. | Incremental, Full refresh | stat_time_day | — |
ad_group_country_report | Daily ad group performance broken down by the viewer's country. | Incremental, Full refresh | stat_time_day | — |
ad_group_platform_report | Daily ad group performance broken down by the viewer's operating system. | Incremental, Full refresh | stat_time_day | — |
ad_demographic_report | Daily ad performance broken down by the viewer's gender and age bucket. | Incremental, Full refresh | stat_time_day | — |
ad_country_report | Daily ad performance broken down by the viewer's country. | Incremental, Full refresh | stat_time_day | — |
ad_platform_report | Daily ad performance broken down by the viewer's operating system. | Incremental, Full refresh | stat_time_day | — |
campaign_website_attribution_report | Daily website purchases and purchase value, including conversions attributed to ad clicks. Requires API v2.0. | Incremental, Full refresh | stat_time_day | — |
ad_group_website_attribution_report | Daily website purchases and purchase value, including conversions attributed to ad clicks. Requires API v2.0. | Incremental, Full refresh | stat_time_day | — |
ad_website_attribution_report | Daily website purchases and purchase value, including conversions attributed to ad clicks. Requires API v2.0. | Incremental, Full refresh | stat_time_day | — |
Troubleshooting
Finding your account ID manually
If the advertiser account dropdown in step 5 doesn't load, you can find your account ID manually in TikTok Ads Manager:
- Go to the TikTok Ads Manager dashboard.
- Click your account name in the top right and open the dropdown.
- Find your ad account ID, or check the dashboard URL, e.g.
https://ads.tiktok.com/i18n/dashboard?aadvid=ID_HERE
