Question 1

What can a ClickHouse model send to TikTok Ads?

Accepted Answer

Custom audiences and offline conversion events. For audiences each row the model returns becomes a member, matched on email or phone number. For conversions you can report events that happened away from TikTok, which is how the platform learns about an outcome that completed in your product or billing system. One behavioural table can drive both.

Question 2

How does a large audience query stay manageable?

Accepted Answer

By reading in deterministic chunks. Alongside the tracking position, the table's primary or sorting key can be used to break the read into predictable pieces rather than pulling one enormous result set. That matters more on ClickHouse than on most sources, since audience models often sit on top of very large event tables. If a query does exceed the server memory allowance, that specific error is recognised and retried rather than failing the run.

Question 3

What TikTok limits should I design around?

Accepted Answer

Three. Audiences below 1,000 members are not usable in targeting, which TikTok documents and enforces in its interface even though the API has accepted smaller ones in testing. Membership processing carries a 48 hour service level, so a freshly built audience is not immediately available. And an advertiser cannot hold more than 400 audiences, which matters if the plan was a segment per campaign.

Question 4

Does membership reconcile against the model?

Accepted Answer

Not on TikTok. Add mode adds and remove mode removes, both available, but there is no mirror mode reconciling the audience against your model automatically, which Microsoft and Meta both offer. A shrinking audience therefore needs a second model describing who should come out, run as a remove sync beside the add one. That is two syncs rather than one, so decide before the audience is built.

Question 5

Why not just upload a list?

Accepted Answer

Because a list is a snapshot of a query, and the query keeps changing. Behavioural segments move week to week, and an upload freezes the definition on the day somebody ran it. The other gain is quality: a seed list built from actual product behaviour is a far better input to a lookalike than one filtered on whatever attributes the ad platform happens to hold.

Sync ClickHouse to TikTok Ads

Sync ClickHouse to TikTok Ads with Polytomic

Chunked along the sorting key

Real limits to plan for

Email and phone hashed

Or sync TikTok Ads to ClickHouse

Trusted by businesses worldwide

Step-by-step integration guide

Connect ClickHouse in Polytomic

Connect TikTok Ads in Polytomic

Create a sync between ClickHouse and TikTok Ads

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 ClickHouse with TikTok Ads?