Question 1

How do restated conversions get corrected?

Accepted Answer

Ad Insights is incremental by account and date, and each ETL run rereads a trailing window so restated numbers overwrite what was there before. The default is seven days. Meta revises insights for up to twenty eight, so set the lookback to twenty eight if you need complete attribution coverage rather than leaving it where it starts.

Question 2

How does the data actually get loaded?

Accepted Answer

Through a staging table. Rows arrive as multi row inserts of up to a thousand at a time, capped at roughly 256 MiB of parameters, after which Polytomic runs an UPDATE joining the target to staging, clears the matched rows, and inserts whatever remains. MySQL has no bulk copy path equivalent to the one Postgres offers, so everything lands as batched INSERT.

Question 3

What can I load into MySQL?

Accepted Answer

Ads, ad sets, campaigns, ad creatives, ad images and ad videos on the object side. On the reporting side, Ad Insights plus its breakdowns: action type, country, platform and device, impression device, age, gender, age and gender, and publisher platform.

Question 4

How many breakdowns should I turn on?

Accepted Answer

As few as you actually report on. Each breakdown multiplies the row count by its own cardinality and action type grows fastest of the set. Turning them all on is the most reliable way to make these tables unmanageable inside a transactional database that is also serving your application.

Question 5

What happens to campaigns Meta removes?

Accepted Answer

Not on their own. Objects are reread each run and rows that stop appearing are marked through the deleted at column rather than being dropped, which means historical spend still joins to campaigns that no longer exist in Meta. Enable hard delete propagation if you would rather they were physically removed.

Sync Facebook Ads to MySQL

Sync Facebook Ads to MySQL with Polytomic

Nine insight breakdowns

Twenty eight day window

Loaded by batched insert

Or sync MySQL to Facebook Ads

Trusted by businesses worldwide

Step-by-step integration guide

Connect Facebook Ads in Polytomic

Connect MySQL in Polytomic

Create a sync between Facebook Ads and MySQL

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