Facebook Ads Insightslink
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.
Featureslink
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 guidelink
Follow our step-by-step Facebook Ads Insights setup guide to connect Facebook Ads Insights with your destination using Fivetran connectors.
Sync overviewlink
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 windowlink
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.
Schema informationlink
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 aggregationweek
for Week aggregationmonth
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
, orad_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 thead_id
and/orad_name
fields -
Adset
level: If you select theadset_id
and/oradset_name
fields -
Campaign
level: If you select thecampaign_id
and/orcampaign_name
and/orobjective
fields -
Account
level: If you selected none of the fields listed aboveNote: 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
andadset_id
fields, we query onAd
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<AdsActionStats>
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.
Prebuilt reportslink
We support a set of Pre-built Reports from our end.
Updating datalink
Updates occur as frequently as every 15 minutes.