Facebook Ad Insights Release Notes – Fivetran Support Portal

June 2022link

We have upgraded our Facebook Ad Insights connector from version 13.0 to 14.0 of the Facebook Graph API. Learn more about the changes in the Facebook Graph API v14.0 changelog.

March 2022link

We have upgraded our Facebook Ad Insights connector from version 12.0 to 13.0 of the Facebook Marketing API. Learn more about the changes in the Facebook Marketing API v13.0 changelog.

September 2021link

We have upgraded our Facebook Ad Insights connector from version 11.0 to 12.0 of the Facebook Marketing API. Learn more about the changes in the Facebook Marketing API v12.0 changelog.

July 2021link

We have upgraded our Facebook Ad Insights connector from version 10.0 to 11.0 of the Facebook Marketing API. Learn more about the changes in the Facebook Marketing API v11.0 changelog.

We sunset our Facebook Ad Insights connector and replaced it with the new Facebook Ads connector that allows to sync reporting data as well as metadata. We will continue to support existing Facebook Ad Insights connectors by gradually migrating them to the new Facebook Ads connector.

June 2021link

We have upgraded our Facebook Ad Insights connector from version 9.0 to 10.0 of the Facebook Marketing API. Learn more about the changes in the Facebook Marketing API v10.0 changelog.

We have changed the data type of the instant_experience_outbound_clicks field from LONG to List<AdsActionStats> to support the new Facebook API version. Now, the field provides detailed information about the number of clicks on links in an Instant Experience that take users off Facebook-owned properties. To ensure data integrity, re-sync any reports where you have used this field.

March 2021link

We now support the timeframe_months field for connectors created using the Create a Connector endpoint. Learn more about Facebook Ad Insights connector management in our REST API documentation.

February 2021link

We have upgraded our Facebook Ad Insights connector from version 7.0 to 9.0 of the Facebook Marketing API and handled deprecations and updates. Learn more about the deprecations and changes in the Facebook Marketing API v8.0 changelog and Facebook Marketing API v9.0 changelog.

We have deprecated the 28 days click and view attribution windows to support Facebook API changes.

January 2021link

We have updated the default click attribution window to 7 days and the view attribution window to 1 day to support Facebook API changes.

October 2020link

You can now opt to specify no attribution window or select a single attribution window when you configure the connector. Depending on your requirements, set both or either of the Click Attribution Window and View Attribution Window fields to NONE in the connector setup form.

September 2020link

We have added support for the video_continuous_2_sec_watched_actions field.

July 2020link

We have added a new table, IMAGE_CROPS. This table stores the image_crops values that are part of the image_asset breakdown response.

Note: Fivetran only syncs the IMAGE_CROPS table if you have selected the image_asset breakdown.

We now support the conversion value of the action_report_time parameter. Previously, we retrieved your data using the default value impression. In the connector setup form, set the Show Advanced Options toggle to ON and then select the value you want to use.

April 2020link

We have changed the data type of the following fields from LONG to DOUBLE:

cpc
cpm
cpp
ctr
unique_ctr
unique_link_clicks_ctr
unique_inline_link_click_ctr
social_spend
cost_per_inline_link_click
cost_per_inline_post_engagement
cost_per_unique_click
cost_per_unique_inline_link_click
cost_per_estimated_ad_recallers
estimated_ad_recall_rate
estimated_ad_recallers

March 2020link

We have upgraded our connector to support Facebook Graph API v6.0 and Marketing API v6.0.

We have made the account_id field mandatory for all levels.

We have removed support for the following fields because Facebook has deprecated them:

relevance_score
video_10_sec_watched_actions
cost_per_10_sec_video_view

We have replaced the video_10_sec_watched_actions field with video_thruplay_watched_actions in the ACTION_VIDEO_SOUND and ACTION_VIDEO_VIEW_TYPE tables per Facebook’s replacement guidelines.

For more information, see the Facebook Changelog.

December 2019link

We have added support for following fields and action_breakdowns:

Fields:
- website_purchase_roas
- purchase_roas
- conversion_rate_ranking
- conversion_values
- conversions
- cost_per_conversion
- cost_per_estimated_ad_recallers
- cost_per_thruplay
- engagement_rate_ranking
- estimated_ad_recall_rate
- estimated_ad_recallers
- full_view_impressions
- full_view_reach
- instant_experience_clicks_to_open
- instant_experience_clicks_to_start
- instant_experience_outbound_clicks
- quality_ranking
- video_p95_watched_actions
- video_play_actions
- video_play_curve_actions
- video_thruplay_watched_actions
Action Breakdowns:
- action_carousel_card_id
- action_carousel_card_name

We now sync ads with the IN_PROGRESS or WITH_ISSUES Facebook status. Previously we omitted ads with either of these statuses.

October 2019link

You can now select how many months of reporting data you’d like to include in your initial sync. Choose from the following options:

3 months
6 months (default)
12 months
24 months
All time

September 2019link

We have upgraded both the Facebook Graph API and the Facebook Marketing API to version 4.0. For more details, see Facebook’s API documentation.

We have added a new prebuilt report, DELIVERY_DEVICE.
We have deprecated two prebuilt reports, DELIVERY_PLACEMENT and DELIVERY_PLACEMENT_AND_DEVICE.
We no longer support the following fields because Facebook has deprecated them:
- video_p95_watched_actions
- video_avg_percent_watched_actions
We have removed the deprecated fields (video_p95_watched_actions and video_avg_percent_watched_actions) from two prebuilt reports, ACTION_VIDEO_SOUND and ACTION_VIDEO_VIEW_TYPE.

July 2019link

We will sunset service versions 3, 4, and 5 of our Facebook Ad Insights on October 1, 2019.

You need to upgrade to our newest version, service version 6, by October 1, 2019. To upgrade, create a new Facebook Ad Insights connector and sync into a new schema.

The newest version of the Facebook Ad Insights connector supports daily, weekly and monthly aggregation with prebuilt reports. This new implementation generates a new schema. You can review the schema information in our docs.

May 2019link

You can now configure your Facebook Ad Insights connector through the Fivetran REST API. This feature is in BETA and available only for Standard and Enterprise accounts.

April 2019link

We have added an option to select your report configuration type in our setup form. You can use it to sync standard prebuilt reports.
Now supports week and month aggregations.
Now supports multiple accounts with the same name.

March 2019link

We have removed the following tables from Facebook Ad Insights. They are now included in the Facebook Ad Account connector with much more detail:

ACCOUNT
CAMPAIGN
ADSET
AD

January 2019link

We have upgraded the Facebook Marketing API to version 3.2. As Facebook has deprecated the total_action_value field, we will no longer support it. (https://developers.facebook.com/docs/graph-api/changelog/version3.2#marketing-api)

July 2018link

Facebook has deprecated a number of fields, so we will no longer support them. You can find a complete list of deprecated fields in Facebook’s API Changelog.

We have added additional information about the following features to our Facebook Ad Insights documentation:

Prebuilt reports
Generic, hourly, and action breakdowns
Possible combinations of generic, hourly, and action breakdowns

Link to Facebook Ad Insights documentation

April 2018link

Occasionally, export jobs submitted to the Facebook API will fail randomly. We now re-try failed jobs three times.

We will no longer sync the video_15_sec_watched_actions field, because Facebook has dropped it.