Question 1

What Google Ads data can I load into ClickHouse?

Accepted Answer

The dated performance reports for campaigns, ad groups, ads, keywords, search terms, geography, demographics and conversion actions, plus the resource objects behind them such as campaigns, ad groups, budgets, labels and conversion action definitions. Reports carry the numbers and resources carry the naming that makes those numbers readable, so most teams take both and join them once loaded.

Question 2

How is the sorting key chosen, and can I change it?

Accepted Answer

Polytomic creates keyed tables ordered on the identity column, which is a safe default rather than an optimal one. ClickHouse gets most of its speed from the sorting key matching how you filter, and on ad reporting that usually means date first. There is no automatic selection based on cardinality or dates, and no PARTITION BY is emitted either, so on a large search term table it is worth creating the table shape you want and letting the sync populate it.

Question 3

Do restated Google Ads conversions get corrected?

Accepted Answer

Yes, provided they land inside the lookback. Dated reports read one day at a time and the last eight days are read again by default, arriving as newer versions that supersede the earlier ones. Google attributes conversions after the fact, so a day keeps moving for a while. If your conversion windows exceed eight days, widen the lookback, because anything restated outside it stays wrong until a full resync.

Question 4

Does Google Ads sync capture deleted campaigns?

Accepted Answer

No. There is no delete feed for this connector, so treat it as a snapshot source regardless of what the destination supports. Entity tables like campaigns and ad groups are read in full each run, so a full read reveals something has gone, but no delete event is produced. Report rows are restated within the lookback rather than removed. Schedule a periodic full read if your reporting counts campaigns.

Question 5

Why keep ad data in the same store as product events?

Accepted Answer

Because the question worth answering is what happened after the click, and that lives in your event data. Google reports on Google, so tying a campaign to activation, retention or revenue means both datasets in one engine. If ClickHouse is already where your product events land, ETL into a data warehouse brings spend to meet them rather than adding another system to join across.

Sync Google Ads to ClickHouse

Sync Google Ads to ClickHouse with Polytomic

Eight day default window

Ordered on the identity

Manager accounts work

Or sync ClickHouse to Google Ads

Trusted by businesses worldwide

Step-by-step integration guide

Connect Google Ads in Polytomic

Connect ClickHouse in Polytomic

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