[Facebook Ad Account, 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, ., Features, Featurexa0Namexa0xa0xa0xa0, 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, Column Hashing, Re-sync, check, Connector level, History, check, API Configurable, check, Priority-first sync, dbt Package, Setup guide, Follow our step-by-step , Facebook Ad Account setup guide, to connect Facebook Ad Account with your destination using Fivetran connectors., Sync overview, 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_management, ads_read, business_management, manage_pages, pages_show_list, At every update frequency, we retrieve , all, Ad Accounts, Ads, Campaigns, Ad Sets, Ad Creatives and their related entities., Schema information, This schema applies to all Facebook Ad Account connectors, To zoom, open ERD in new window, Schema notes, The , *_HISTORY, ” tables capture versions of these objects as they are updated. This isnt 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, .]