Release Notes
October 2020
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 2020
We have added support for the video_continuous_2_sec_watched_actions
field.
July 2020
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 theimage_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 2020
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 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 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
andDELIVERY_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
andvideo_avg_percent_watched_actions
) from two prebuilt reports,ACTION_VIDEO_SOUND
andACTION_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.