Question 1

What Facebook Ads data can I load into ClickHouse?

Accepted Answer

Structure and numbers. Structure gives ads, ad sets, campaigns, ad creatives, images and videos. Numbers arrive as ten daily ad level insight tables: a base table plus breakdowns by action type, country, platform and device, impression device, age, gender, age with gender, and publisher platform. Metrics run from spend, impressions, reach, frequency and clicks through CPC, CPM and CTR to conversions, conversion values and video watch measures.

Question 2

What storage does the ClickHouse side need?

Accepted Answer

A bucket or container you own, and unusually you can pick any of the three major clouds. Polytomic writes Parquet chunks of roughly 150 megabytes, uploads them to your S3 bucket, Azure container or Google Cloud Storage bucket, then has ClickHouse read them directly using its matching table function. The important detail is that ClickHouse itself must be able to reach that storage, not just Polytomic, and the server needs the external source grant that goes with whichever cloud you chose.

Question 3

How are late Facebook conversions corrected?

Accepted Answer

By reading recent days again. Insight reports checkpoint on the report date, read day by day up to yesterday, then reread the last seven days by default, with those rows arriving as newer versions that supersede the earlier ones. The window can be raised, and up to 28 days is supported to match how long Meta keeps revising. Anything restated outside your window will not refresh on its own.

Question 4

How do I stop breakdown tables getting unwieldy?

Accepted Answer

Be selective about which you take, since a single day can produce a row per ad per country per device and taking all ten when you use two is how a table nobody queries gets built. Beyond that, ClickHouse rewards a sorting key that matches your filters, and the created tables are ordered on the identity rather than the date. On the breakdowns you keep, it is worth creating the table with the key you want first.

Question 5

Why load ad platform data into ClickHouse?

Accepted Answer

Because the comparison worth making is between spend and behaviour, and behaviour is usually the larger dataset. Meta reports on Meta, so working out which campaigns brought people who stayed means joining ads to events. ETL into a data warehouse puts them in the same engine, and if that engine is already handling your event volume it will handle the ad tables without noticing.

Sync Facebook Ads to ClickHouse

Sync Facebook Ads to ClickHouse with Polytomic

Ten insight breakdowns

Any of three clouds

Throttles under Meta limits

Or sync ClickHouse to Facebook Ads

Trusted by businesses worldwide

Step-by-step integration guide

Connect Facebook Ads in Polytomic

Connect ClickHouse in Polytomic

Create a sync between Facebook 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 Facebook Ads with ClickHouse?