Facebook Ad Account provides a history of the settings of your Facebook Ad Accounts, Campaigns, Ad Sets, Ads, and Ad Creatives. You can find more information on Facebook documentation.
|Data blocking||check||Column level|
|Fivetran data models|
Follow our step-by-step Facebook Ad Account setup guide to connect Facebook Ad Account with your destination using Fivetran connectors.
You can sync all accounts or select specific accounts to sync.
To sync Ads, Ad Accounts, Ad Creatives, Ad Sets, Campaigns, and related entities, we need the following permissions:
At every update frequency, we retrieve all Ad Accounts, Ads, Campaigns, Ad Sets, Ad Creatives and their related entities.
This schema applies to all Facebook Ad Account connectorsTo zoom, open the ERD in a new window.
*_HISTORY tables capture versions of these objects as they are updated. This isn’t a perfect record of every change, but rather captures the delta of changes between syncs. To query them, use
SORT BY id and
ORDER BY updated_time.