Question 1

What TikTok Ads data can I load into BigQuery?

Accepted Answer

Ad accounts, ads, ad groups, campaigns and audiences, along with videos, images and smart creative materials, Smart Plus campaigns and ads, GMV Max campaigns and available locations. On top sit nineteen prebuilt reports: campaign, ad group and ad reports at daily, hourly and lifetime grain, audience reports split by age and gender, country, language or platform, and GMV country reports. Custom reports are available when none of those fit.

Question 2

How does TikTok Ads incremental sync work?

Accepted Answer

It varies by object, which is worth understanding before you plan a schedule. Ads and Smart Plus ads use TikTok's modified after filter and checkpoint at the start of each run. Other entities are read as full snapshots because their APIs offer no usable modified filter. Daily and hourly reports checkpoint on their time dimension and reread the last three days by default. Lifetime reports are always full reads. Default backfill is one year.

Question 3

Why did my TikTok Ads sync stop returning some tables?

Accepted Answer

Usually a scope problem, and the cause catches most people out. Scopes are granular, with account information, ads and ad groups and campaigns, audiences, creatives, Smart Plus, GMV Max and reporting each needing their own read permission. The trap is that changing scopes on the app does not refresh tokens that already exist, so the advertiser has to authorise again before the new permission takes effect. Also note that video and image endpoints only expose the 10,000 most recently modified items.

Question 4

Should I sync the hourly TikTok reports?

Accepted Answer

Only if you will use them, because they multiply rows by twenty four and that shows up in both storage and query cost. If you do take them, partition on the report date so a query for last week does not scan the whole table. The daily reports answer most questions and are far cheaper to keep. This is a good example of where BigQuery pricing rewards being selective about which tables you sync at all.

Question 5

Why load TikTok Ads into BigQuery?

Accepted Answer

Because the numbers inside TikTok stop at TikTok. Finding out whether a campaign brought buyers who came back means putting ad data next to orders, subscriptions or CRM records, and no ad platform can do that. ETL into a data warehouse makes it a plain join, and gives you one place where TikTok, Meta, Google and LinkedIn spend can be compared on the same terms rather than four dashboards that each count differently.

Sync TikTok Ads to BigQuery

Sync TikTok Ads to BigQuery with Polytomic

Nineteen prebuilt reports

Three day reread window

Custom reports supported

Or sync BigQuery to TikTok Ads

Trusted by businesses worldwide

Step-by-step integration guide

Connect TikTok Ads in Polytomic

Connect BigQuery in Polytomic

Create a sync between TikTok Ads and BigQuery

Map fields and enable the sync

Frequently asked questions

The sync and ETL platform that does it all

Powerful data sync

Advanced analytics

Enterprise security

Easy setup

Ready to connect TikTok Ads with BigQuery?