The native Facebook Ads Data Transfer in BigQuery now allows adjusting the refresh window to set how many days of data should be fetched in each run. The table has become historical, accumulating data instead of daily reloads.
Key Updates:
- Adjustable Refresh Window: Users can now set the number of days of data to be fetched in each run.
- Historical Table: The table now accumulates data historically instead of being cleared and reloaded daily with only new data.
- Schema Changes: Some column data types have changed, such as dates shifting from integers to proper date formats. While beneficial, these changes come with some challenges.
The feature is currently in preview and is less stable compared to previous data transfer preview features. Despite the instability, it remains a viable alternative to expensive ELT tools for basic Facebook data needs.
Limitations
- Minimum Interval: The minimum interval time between recurring Facebook Ads transfers is 24 hours.
- Supported Tables: Only a fixed set of tables is supported; custom reports aren't.
- Transfer Duration: Transfers have a maximum duration of six hours.
- Incremental Transfers: Not supported.
- Data Transfer: Supports transfer of data from up to one day (yesterday) to the AdInsights and AdInsightsActions tables.
- Access Token Expiry: The long-lived user access token expires after 60 days.
These updates aim to enhance data management and accessibility for Facebook Ads data in BigQuery. For more details about Facbook Ads BigQuery transfer, visit Google Cloud help.
