Release Noteslink
March 2024link
We have upgraded our Facebook Ads connector to version 18.0 of the Facebook API. For more information, see Facebook's summary of Graph API v18.0 and Marketing API v18.0.
We have deprecated the following insight metrics:
quality_ranking
conversion_rate_ranking
engagement_rate_ranking
Existing reports won't be affected, but the fields will not be available for new reports.
November 2023link
We have added a new AD_VIDEO_THUMBNAIL
table. We are gradually rolling out this change to all existing connectors.
October 2023link
We have transferred pre-built reports from the connector setup form to the Schema tab of your Fivetran dashboard. Pre-built reports are now included by default and are treated as metadata tables, which means the only configurable option for them is select or deselect. This change is applicable to all new connectors created after October 13, 2023. You can now use the Connector Management API to modify pre-built reports in the same way as metadata tables. To do so, submit API requests to the Modify a Connector Schema Config endpoint.
September 2023link
We have removed the status_processing_progress
and status_value
fields from the AD_VIDEO_HISTORY
table as the structure of the video_status
object has changed and the corresponding API document has not been updated. We will add columns to align with the new structure as soon as the Facebook document is updated.
June 2023link
We have upgraded our Facebook Ads connector to version 17.0 of the Facebook API. For more information, see Facebook's release of Graph API v17.0 and Marketing API v17.0.
We have removed the has_advertiser_opted_in_odax
column from the ACCOUNT_HISTORY
table.
We have removed the ad_strategy_id
and ad_strategy_group_id
columns from the CAMPAIGN_HISTORY
table.
We have added a new value, mixed
, to the action_report_time
parameter.
May 2023link
We have implemented incremental sync for the following tables:
CAMPAIGN_HISTORY
AD_SET_HISTORY
AD_HISTORY
During the sync, Fivetran only fetches entities that have the updated_time
value greater than the cursor value. The cursor can be reset by triggering a full or table-specific re-sync. For more information, read our Facebook Ads documentation.
April 2023link
We have added a new field, video_video_id
, to the CREATIVE_HISTORY
table.
March 2023link
We can now fetch creative entities with large thumbnail images (up to 600 x 600).
February 2023link
We have upgraded our Facebook Ads connector to version 16.0 of the Facebook API. For more information, see Facebook's v16.0 changelog.
September 2022link
We have upgraded our Facebook Ads connector to version 15.0 of the Facebook API. For more information, see Facebook's v15.0 changelog.
August 2022link
We have added two new breakdowns, app_id
and skan_conversion_id
.
We have added two new tables, AD_IMAGE_HISTORY
and AD_VIDEO_HISTORY
. For more details, see Facebook's /adimages and /advideos endpoints documentation.
July 2022link
We have added two new fields, cost_per_inline_link_click
and inline_link_click_ctr
, to the COMMON_FIELDS
fields group for Prebuilt Reports.
June 2022link
We have upgraded our Facebook Ads connector to version 14.0 of the Facebook API. For more information, see Facebook's v14.0 changelog.
We have added the following new fields to the AD_SET_HISTORY
table:
promoted_object_custom_conversion_id
promoted_object_custom_event_str
promoted_object_offline_conversion_data_set_id
promoted_object_pixel_aggregation_rule
promoted_object_pixel_rule
promoted_object_retention_days
Learn more in Facebook's Ad Set, Promoted Object documentation.
February 2022link
We have upgraded our Facebook Ads connector to version 13.0 of the Facebook API. For more information, see Facebook's v13.0 changelog.
We have added three new tables:
AD_STUDY
stores ad campaign data for thebrand_lift_studies
fieldADSET_SCHEDULE
stores ad set data for theadset_schedule
fieldLOOKALIKE_TARGET_COUNTRY_NAME
storestarget_country_names
field data for a custom audiencelookalike_spec
We have added a new field, has_advertiser_opted_in_odax
, to the ACCOUNT_HISTORY
table. Learn more in Facebook's Ad Account documentation.
We have added a new field, preview_shareable_link
, to the AD_HISTORY
table. Learn more in Facebook's Ad documentation.
We have added two new fields, ad_strategy_group_id
and bid_strategy
, to the CAMPAIGN_HISTORY
table. Learn more in Facebook's Campaign documentation.
We have added the following new fields to the CREATIVE_HISTORY
table:
link_destination_display_url
source_instagram_media_id
thumbnail_id
platform_customizations
template_url_spec
Learn more in Facebook's Ad Creative documentation.
We have added the following new fields to the CUSTOM_AUDIENCE_HISTORY
table:
lookalike_origin_event_name
lookalike_origin_event_source_name
lookalike_product_set_name
Learn more in Facebook's Custom Audience documentation.
January 2022link
Now, when you set the Sync all metadata toggle to FALSE in the connector setup form, we automatically deselect the corresponding tables on the Schema tab and exclude them from syncs. Previously, we did not deselect the tables on the Schema tab.
October 2021link
Now, during connector setup, if you don't provide the business_management
permission to access the business details fields, the connector setup tests pass with a warning. The warning lists the fields that we’ll skip during the sync. In addition, we generate a warning alert on your Fivetran dashboard. Previously, the setup tests failed without this permission.
We have added two new fields, approximate_count_lower_bound
and approximate_count_upper_bound
, to the CUSTOM_AUDIENCE_HISTORY
table.
We have removed the approximate_count
field because it has been deprecated.
September 2021link
We no longer support the is_in_middle_of_local_entity_migration
field for Ad accounts (ACCOUNT_HISTORY
table) because it has been deprecated.
We have added a new metadata table, CUSTOM_CONVERSIONS_HISTORY
, to store custom conversions names.
We have added a new table TARGETING_OPTIMIZATION_TYPES
with the following fields:
index
ad_set_id
ad_set_updated_time
key
value
We have added the Use unified attribution setting toggle to the setup form. It controls the use_unified_attribution_setting
query parameter. When this parameter is set to true
, the Facebook API returns your ads results using the unified attribution settings defined at ad set level, and ignores the use_account_attribution_setting
parameter.
See Facebook's API documentation for more details.
We have added the Sync all metadata toggle to the setup form. It controls the sync_metadata
query parameter. When this parameter is set to false
, we only sync report data without including metadata.
We have upgraded our Facebook Ads 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.
August 2021link
We have added support for lifetime aggregation with prebuilt and custom reports.
July 2021link
Our Facebook Ads connector is now generally available. Read our Facebook Ads connector documentation.
We have upgraded our Facebook Ads 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.
June 2021link
We have upgraded our Facebook Ads connector from version 9.0 to 10.0 of the Facebook Marketing API and handled deprecations and updates. Learn more about the deprecations and changes in the Facebook Marketing API v10.0 changelog.
NOTE: Starting from version 10.0, Facebook API returns a maximum of 37 months' worth of data.
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.
We no longer support the attribution_spec
field for ad accounts because it has been deprecated.
We now support the following fields in the ACCOUNT_HISTORY
table:
extended_credit_invoice_group
failed_delivery_checks
is_in_3ds_authorization_enabled_market
is_in_middle_of_local_entity_migration
We now support the conversion_domain
and issues_info
fields in the AD_HISTORY
table.
We now support the following fields in the AD_SET_HISTORY
table:
asset_feed_id
daily_min_spend_target
daily_spend_cap
is_dynamic_creative
issues_info
learning_stage_info
lifetime_min_spend_target
lifetime_spend_cap
multi_optimization_goal_weight
optimization_sub_event
review_feedback
We now support the following fields in the CAMPAIGN_HISTORY
table:
ad_strategy_id
budget_remaining
is_skadnetwork_attribution
last_budget_toggling_time
lifetime_budget
pacing_type
promoted_object
smart_promotion_type
special_ad_categories
special_ad_category
special_ad_category_country
topline_id
We now support the following fields in the CREATIVE_HISTORY
table:
authorization_category
bundle_folder_id
categorization_criteria
category_media_source
destination_set_id
dynamic_ad_voice
effective_authorization_category
effective_instagram_media_id
enable_direct_install
messenger_sponsored_message
object_store_url
place_page_set_id
playable_asset_id
We now support the following fields in the CUSTOM_AUDIENCE_HISTORY
table:
customer_file_source
external_event_source
pixel_id
April 2021link
We have combined the Facebook Ad Account and Facebook Ad Insights connectors into the new Facebook Ads connector to provide meta and reporting data in one place.
Read our Facebook Ads connector documentation.
March 2021link
We now support the timeframe_months
field for Facebook Ads connectors created using the Create a Connector endpoint. Learn more about Facebook Ads connector management in our REST API documentation.
We have released pre-built, dbt Core-compatible data models for Facebook Ads. Find the models in Fivetran's dbt hub or data models documentation. Learn more about our dbt Core integration in our Transformations for dbt Core documentation*.
* dbt Core is a trademark of dbt Labs, Inc. All rights therein are reserved to dbt Labs, Inc. Fivetran Transformations is not a product or service of or endorsed by dbt Labs, Inc.
We have upgraded our Facebook Ads 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 Facebook Marketing API v8.0 changelog and Facebook Marketing API v9.0 changelog.