Question 1

What Facebook Ads data can I sync to Snowflake?

Accepted Answer

The structure and the numbers. On the structure side: ads, ad sets, campaigns, ad creatives, images and videos. On the numbers side there are ten daily ad level insight tables, one base table plus breakdowns by action type, country, platform and device, impression device, age, gender, age with gender, and publisher platform. Metrics cover spend, impressions, reach, frequency, clicks, CPC, CPM, CTR, link clicks, conversions and their values, and a long list of video watch metrics.

Question 2

How does Polytomic handle late Facebook conversions?

Accepted Answer

By reading recent days again. Insight reports save their place on the report date and read day by day up to yesterday, then reread the last seven days by default so restated numbers get corrected. You can raise that, and the code supports up to 28 days to match how long Meta keeps revising. Anything restated outside your window will not refresh on its own, so set the window to match your longest attribution window.

Question 3

How far back can I backfill Facebook Ads data?

Accepted Answer

About 13 months. That is a Meta limit on how much reporting history the API will return, not something Polytomic imposes, so if you need a longer record than that the answer is to start syncing now and let the data warehouse build the history you cannot get retroactively. Once a day is loaded and past the lookback window, it stays put in Snowflake even after Meta stops serving it.

Question 4

Does Facebook Ads sync capture deleted campaigns?

Accepted Answer

No, and it is better to be plain about that. There is no delete feed for this connector, so treat it as a snapshot source. Entity tables like campaigns and ad sets are read in full each run, which means a full read can show that something is gone, but no delete event is produced. Report rows get restated inside the lookback window rather than deleted. If you need tidy reconciliation, schedule a periodic full read.

Question 5

Why sync Facebook Ads into a data warehouse?

Accepted Answer

Because spend only means something next to what it earned. Meta reports on Meta, so it cannot tell you which campaign brought in customers who stayed, or which audience produced the best margin. ETL into a data warehouse puts ad data beside CRM and billing data so those joins are just SQL. It also gives you a daily record that stops moving, instead of a dashboard that keeps reattributing under you.

Sync Facebook Ads to Snowflake

Sync Facebook Ads to Snowflake with Polytomic

Seven day lookback

Ten insight breakdowns

Stays under Meta limits

Or sync Snowflake to Facebook Ads

Trusted by businesses worldwide

Step-by-step integration guide

Connect Facebook Ads in Polytomic

Connect Snowflake in Polytomic

Create a sync between Facebook Ads and Snowflake

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