Facebook Ads: only re-extract recent or active creatives (creative_history)
Since Meta retired Graph API ids (multi-ID) requests, the Facebook Ads connector fetches every creative one request at a time, and it re-extracts every historical creative on every sync. creative_history is upsert-only, so re-extracting unchanged creatives adds nothing.
Repeated extraction volume: about 427k creative rows re-extracted per sync on one of our connections and 575k on the other (one Nov 5 sync wrote 740,275 rows in total).
Sync duration: 16 minutes per sync before Oct 22, now 4 to 7 hours, with repeated rescheduling from Meta rate limits (21 rescheduled syncs on Nov 4 alone).
Data freshness: we sync every 6 hours, so our Meta data is now up to about 12 hours old instead of 6. On Nov 4 we were still missing 45% of the day's ad spend the next afternoon. This spend feeds our daily customer acquisition cost reporting.
Request: an option to re-extract only creatives updated recently (updated_time) or belonging to active ads (effective_status), with an optional periodic full refresh.
Please sign in to leave a comment.
Comments
0 comments