Release Notes

April 2020

We now add a fivetran_synced column while syncing empty tables and columns from the source.

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 2020

We have made the account_id field mandatory for all levels.

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

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 2019

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 2019

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 2019

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 2019

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 2019

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 2019

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 2019

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 2019

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 2018

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 2018

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.

Documentation