Facebook Ads Insights

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.

---

Features

---

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.

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. 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.

Syncing empty tables and columns

Fivetran can sync empty tables and columns for your Facebook Ad Insights connector. For more information, see our Features documentation.

---

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
• monthfor 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<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.

Updating data

Updates occur as frequently as every 15 minutes.