Question 1

What TikTok Ads data can I load into ClickHouse?

Accepted Answer

Ad accounts, ads, ad groups, campaigns and audiences, plus videos, images and smart creative materials, Smart Plus campaigns and ads, GMV Max campaigns and available locations. On top sit nineteen prebuilt reports covering campaign, ad group and ad performance at daily, hourly and lifetime grain, audience reports split by age and gender, country, language or platform, and GMV country reports. Custom reports handle anything else.

Question 2

Why did my first sync fail to connect?

Accepted Answer

Most often the port. ClickHouse connections here use the native protocol, so the port should be 9440 with TLS or 9000 without, and pointing at the HTTP port will not work. After that the usual culprits are grants: the account needs SELECT, INSERT, CREATE TABLE, DROP TABLE, TRUNCATE and ALTER, plus the external source grant matching your staging cloud, which is READ ON S3 for AWS and Google Cloud Storage or READ ON AZURE for Azure. If Polytomic must create the database, CREATE DATABASE is needed too.

Question 3

Which parts of TikTok avoid a full read?

Accepted Answer

Ads and Smart Plus ads, which use TikTok's modified after filter and checkpoint at the start of each run. Every other entity is a full snapshot because those endpoints offer no usable modified filter. On the reporting side, daily and hourly reports checkpoint on their time dimension and reread the last three days, while lifetime reports are always read whole. Default backfill is one year.

Question 4

Why are some TikTok tables missing after a scope change?

Accepted Answer

Because existing tokens do not pick up new scopes. Permissions are granular, with account information, ads and ad groups and campaigns, audiences, creatives, Smart Plus, GMV Max and reporting each needing their own read grant, and updating the app does not refresh a token issued earlier. The advertiser has to authorise again. Separately, video and image endpoints only ever expose the 10,000 most recently modified items, which can look like missing data but is not a permissions problem.

Question 5

Why put ad spend in ClickHouse?

Accepted Answer

Because measuring a campaign properly means looking at what people did afterwards, and that dataset is usually far bigger than the ad tables. ETL into a data warehouse puts spend beside those events so the analysis happens in one engine, and gives you one place where TikTok, Meta, Google and LinkedIn compare on the same terms rather than four dashboards that each count differently.

Sync TikTok Ads to ClickHouse

Sync TikTok Ads to ClickHouse with Polytomic

Nineteen prebuilt reports

Native protocol only

Three day reread window

Or sync ClickHouse to TikTok Ads

Trusted by businesses worldwide

Step-by-step integration guide

Connect TikTok Ads in Polytomic

Connect ClickHouse in Polytomic

Create a sync between TikTok Ads and ClickHouse

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 ClickHouse?