Question 1

What Facebook Ads data can I load into BigQuery?

Accepted Answer

Structure and numbers. The structure side gives you ads, ad sets, campaigns, ad creatives, images and videos. The numbers side is 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 a long list of video watch measures.

Question 2

How should I set up Facebook Ads tables in BigQuery?

Accepted Answer

Partition the insight tables on the report date. Breakdown tables multiply rows fast, since a single day can produce a row per ad per country per device, so partitioning is what keeps a filtered query from scanning years of data. Each table takes one datetime field as its partition key and newer syncs default to monthly. Choose before you start, because BigQuery cannot repartition in place and changing it later needs a full rebuild of the table.

Question 3

How are late Facebook conversions handled?

Accepted Answer

By reading recent days again. Insight reports save their position on the report date, read day by day up to yesterday, then reread the last seven days by default and merge the corrected rows over the old ones. That default can be raised, and the code supports up to 28 days to match how long Meta keeps revising. A restatement that lands outside your window will not refresh by itself, so set the window against your longest attribution window.

Question 4

How much Facebook Ads history can I backfill?

Accepted Answer

Roughly 13 months. That is Meta's limit on how much reporting history the API will return rather than anything Polytomic imposes. The practical consequence is worth acting on early: if you want a longer record than that, start syncing now and let the data warehouse accumulate what Meta will not give you retroactively. Once a day is loaded and past the lookback window it stays put, even after Meta stops serving it.

Question 5

Why load Facebook Ads into BigQuery?

Accepted Answer

Because spend only means something beside what it produced. Meta reports on Meta, so it cannot tell you which campaigns brought customers who stayed, or which audiences produced the best margin. In a data warehouse ad data sits next to CRM and billing data and those become ordinary joins. Scheduled ETL is also what builds you a stable daily history, instead of a dashboard that keeps reattributing under you.

Sync Facebook Ads to BigQuery

Sync Facebook Ads to BigQuery with Polytomic

Ten insight breakdowns

Partition on report date

Throttles under Meta limits

Or sync BigQuery to Facebook Ads

Trusted by businesses worldwide

Step-by-step integration guide

Connect Facebook Ads in Polytomic

Connect BigQuery in Polytomic

Create a sync between Facebook Ads and BigQuery

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