Tiktok Ads Connector

Start moving your Tiktok Ads data with fully managed data pipelines. Get clean normalized data ready for analytics, easy to setup and analyze with AI in minutes.

View more about the Tiktok Ads connector in the Weld documentation

ad

id

30 more tiktok-ads tables

Explore available Tiktok Ads data

Browse all the data tables available for the Tiktok Ads connector, in our interactive ERD data viewer.

View the Tiktok Ads Data Schema

Transform and model Tiktok Ads data

Get clean data models from your Tiktok Ads data. Weld makes it easy to transform and model with the powerful built in SQL editor and AI Assistant.

Tiktok Ads

raw.tiktok_ads.table1

raw.tiktok_ads.table2

Get started with Tiktok Ads SQL Templates

Get inspiration on how to model your data, with our collection of foundational SQL templates we have battle-tested at Weld. All the templates work out of the gate with the Weld data integrations for Tiktok Ads.

Account Report

Generates an account report for the TikTok Ads integration. It retrieves data from the `ad_daily_report`, `advertiser`, and `ad` tables, and joins them based on specific conditions. The resulting report includes aggregated metrics such as impressions, clicks, spend, reach, conversion, likes, comments, shares, profile visits, follows, video watched durations, and video view percentages.

Ad Group Report

Generates an ad group report for the TikTok Ads integration. It retrieves data from various tables such as ad_group_daily_report, ad_group, advertiser, and campaign. The report includes metrics like impressions, clicks, spend, reach, conversion, and engagement metrics such as likes, comments, and shares. The data is grouped by date, account, campaign, and ad group.

Campaign Report

Generates a campaign report for the TikTok Ads integration. It retrieves data from the `campaign_daily_report`, `campaign`, and `advertiser` tables. The report includes metrics such as clicks, impressions, spend, reach, conversions, likes, comments, shares, profile visits, follows, video views, and various calculated metrics like CPC, CTR, and CPM. The data is grouped by date, account ID, account name, campaign ID, and campaign name.

Ad Report

Generates an ad report by joining multiple tables from the TikTok Ads integration. It retrieves data such as impressions, clicks, spend, reach, conversions, likes, comments, shares, and various video metrics for each ad group. The report also includes information about the advertiser, campaign, account, currency, gender, audience type, and budget.

View all Tiktok Ads templates