Facebook Ad Insights gives you information about the performance of your Facebook ads. You can find more information about it on Facebook’s documentation page.
|Data Blocking||check||Column level|
Follow our step-by-step Facebook Ads Insights setup guide to connect Facebook Ads Insights with your destination using Fivetran connectors.
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:
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. By 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.
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:
datefor Day aggregation
weekfor Week aggregation
monthfor Month aggregation
The primary key is a composite of these three fields:
idat the “level” that was queried (
- aggregation column
- the (non-action) breakdowns
Depending on the fields you selected while configuring the connector, we query at different levels:
Adlevel: If you select the
Adsetlevel: If you select the
Campaignlevel: If you select the
Accountlevel: 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
adset_idfields, we query on
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<AdsActionStats> listed in the Facebook Ad Insights field documentation.
The primary key is a composite of the “level”
id, aggregation column you selected (
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.
Syncing empty tables and columnslink
Fivetran can sync empty tables and columns for your Facebook Ads Insights connector. For more information, see our Features documentation.
Updates occur as frequently as every 15 minutes.