[Facebook Ads Insights, Facebook Ad Insights gives you information about the performance of your Facebook ads. You can find more information about it on , “Facebooks documentation page”, ., Features, Feature Name, Supported, Notes, Capture Deletes, Custom Data, Data Blocking, Column Hashing, Re-sync, check, Connector level, History, API Configurable, check, Priority-first sync, dbt Package, Setup guide, Follow our step-by-step , Facebook Ads Insights setup guide, to connect Facebook Ads Insights with your destination using Fivetran connectors., Sync overview, “Fivetran continuously updates throughout the day, updating the current days totals. You can sync all accounts or specify specific accounts to sync.”, To sync your Insights data, we need the following permissions:, ads_management, ads_read, , business_management, Attribution window, An attribution window is the length of time after a person viewed or clicked your ad that you will give that ad credit for subsequent actions. This is particularly relevant to conversion actions, such as a purchase.nBy default, Facebook uses an attribution window of 1-day view and 28-day click. This means your reporting table will show these actions if they happened within 1 day of someone seeing your ad or within 28 days of someone clicking on your ad., Schema information, We provide two types of reports:, Prebuilt Report, Custom Report, For either kind of report, we deliver a single main table named after the table name of the connector. The table contains the fields you selected in the setup form., Depending on the aggregation you select, we provide the corresponding column:, date, for Day aggregation, week, for Week aggregation, month, for Month aggregation, The primary key is a composite of these three fields:, the , id, at the “level” that was queried (, account_id , campaign_id , adset_id or , ad_id, ) , aggregation column , the (non-action) breakdowns, Depending on the fields you selected while configuring the connector, we query at different levels:, Ad, level: If you select the , ad_id, and/or , ad_name, fields, Adset, level: If you select the , adset_id, and/or , adset_name, fields, Campaign, level: If you select the , campaign_id, and/or , campaign_name, and/or , objective, fields, Account, level: If you selected none of the fields listed above, Note: If you selected fields that correspond to more than one level, we query at the most granular level. For example, if you select both the , ad_id, and , adset_id, fields, we query on , Ad, level., If you select an action breakdown and field or fields, Fivetran creates a secondary table or tables. We name secondary tables with the main table name appended with the field names. , We create separate tables for fields with of the type , list, listed in the , Facebook Ad Insights field documentation, ., The primary key is a composite of the “level” , id aggregation column you selected (, date , week, or , month, ), and the non-action breakdowns. The action breakdowns are columns in the table, and the field , value, is the number of actions to occur. , Note: The action data is hierarchical: a simple sum of all actions will , not equal, the field , total_actions, . See , Actions you can measure in Facebook Ads Reporting, for more information., Updating data, Updates occur as frequently as every 15 minutes.]