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.
Featureslink
| Feature Name | Supported | Notes |
|---|---|---|
| Capture deletes | check | CAMPAIGN_HISTORY, AD_SET_HISTORY, AD_HISTORY and CREATIVE_HISTORY tables. |
| Custom data | check | ACCOUNT_ATTRIBUTION and AD_SET_ATTRIBUTION tables. All fields in these tables are custom fields except primary and foreign keys. |
| Data blocking | check | Column level |
| Column hashing | check | |
| Re-sync | check | Connector level |
| History | check | |
| API configurable | check | |
| Priority-first sync | ||
| Private networking | ||
| Fivetran data models |
Setup guidelink
Follow our step-by-step Facebook Ad Account setup guide to connect Facebook Ad Account with your destination using Fivetran connectors.
Sync overviewlink
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:
ads_managementads_readbusiness_managementmanage_pagespages_show_list
At every update frequency, we retrieve all Ad Accounts, Ads, Campaigns, Ad Sets, Ad Creatives and their related entities.
Schema informationlink
This schema applies to all Facebook Ad Account connectors
To zoom, open the ERD in a new window.Schema noteslink
The *_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.