Release Notes

November 2024

Due to changes to the Facebook API, for the unique_actions and cost_per_unique_action_type custom report fields, we now support only the following action_type breakdowns:

• link_click
• onsite_conversion_messaging_first_reply
• onsite_conversion_total_messaging_connection
• outbound_click

We no longer support the following action_type breakdowns for the unique_actions and cost_per_unique_action_type fields:

• add_payment_info
• add_to_cart
• app_custom_event
• app_custom_event.fb_mobile_achievement_unlocked
• app_custom_event.fb_mobile_activate_app
• app_custom_event.fb_mobile_add_payment_info
• app_custom_event.fb_mobile_add_to_cart
• app_custom_event.fb_mobile_add_to_wishlist
• app_custom_event.fb_mobile_complete_registration
• app_custom_event.fb_mobile_content_view
• app_custom_event.fb_mobile_d2_retention
• app_custom_event.fb_mobile_d7_retention
• app_custom_event.fb_mobile_initiated_checkout
• app_custom_event.fb_mobile_level_achieved
• app_custom_event.fb_mobile_purchase
• app_custom_event.fb_mobile_rate
• app_custom_event.fb_mobile_search
• app_custom_event.fb_mobile_spent_credits
• app_custom_event.fb_mobile_tutorial_completion
• app_custom_event.other
• app_engagement
• app_install
• call_confirm_grouped
• checkin
• click_to_call_call_confirm
• click_to_call_callback_request_submitted
• click_to_call_native_20s_call_connect
• click_to_call_native_60s_call_connect
• click_to_call_native_call_placed
• click_to_join_new_channel_member
• comment
• commerce_event
• complete_registration
• credit_spent
• group_join
• initiate_checkout
• landing_page_view
• lead
• leadgen_grouped
• like
• mobile_app_install
• offline_conversion
• offline_conversion.add_payment_info
• offline_conversion.add_to_cart
• offline_conversion.add_to_wishlist
• offline_conversion.complete_registration
• offline_conversion.initiate_checkout
• offline_conversion.lead
• offline_conversion.other
• offline_conversion.purchase
• offline_conversion.search
• offline_conversion.view_content
• offsite_conversion
• offsite_conversion.fb_pixel_add_payment_info
• offsite_conversion.fb_pixel_add_to_cart
• offsite_conversion.fb_pixel_add_to_wishlist
• offsite_conversion.fb_pixel_complete_registration
• offsite_conversion.fb_pixel_custom
• offsite_conversion.fb_pixel_initiate_checkout
• offsite_conversion.fb_pixel_lead
• offsite_conversion.fb_pixel_purchase
• offsite_conversion.fb_pixel_search
• offsite_conversion.fb_pixel_view_content
• omni_achievement_unlocked
• omni_activate_app
• omni_add_to_cart
• omni_add_to_wishlist
• omni_app_install
• omni_complete_registration
• omni_custom
• omni_initiated_checkout
• omni_level_achieved
• omni_purchase
• omni_rate
• omni_search
• omni_spend_credits
• omni_tutorial_completion
• omni_view_content
• onsite_app_add_to_cart
• onsite_app_purchase
• onsite_app_view_content
• onsite_conversion.add_to_cart
• onsite_conversion.add_to_wishlist
• onsite_conversion.click_to_call
• onsite_conversion.donate
• onsite_conversion.find_location
• onsite_conversion.flow_complete
• onsite_conversion.initiate_checkout
• onsite_conversion.lead
• onsite_conversion.lead_grouped
• onsite_conversion.message_to_buy
• onsite_conversion.messaging_20s_call_connect
• onsite_conversion.messaging_60s_call_connect
• onsite_conversion.messaging_block
• onsite_conversion.messaging_business_calling_call_answered
• onsite_conversion.messaging_business_calling_call_initiated
• onsite_conversion.messaging_business_calling_call_missed
• onsite_conversion.messaging_business_calling_opt_in_accepted
• onsite_conversion.messaging_business_calling_opt_in_denied
• onsite_conversion.messaging_business_calling_opt_in_sent
• onsite_conversion.messaging_conversation_replied_7d
• onsite_conversion.messaging_conversation_started_7d
• onsite_conversion.messaging_order_created_v2
• onsite_conversion.messaging_order_shipped_v2
• onsite_conversion.messaging_user_call_placed
• onsite_conversion.messaging_user_depth_2_message_send
• onsite_conversion.messaging_user_depth_3_message_send
• onsite_conversion.messaging_user_subscribed
• onsite_conversion.messaging_welcome_message_view
• onsite_conversion.other
• onsite_conversion.post_save
• onsite_conversion.purchase
• onsite_conversion.view_content
• onsite_web_add_to_cart
• onsite_web_app_add_to_cart
• onsite_web_app_purchase
• onsite_web_app_view_content
• onsite_web_lead
• onsite_web_purchase
• onsite_web_view_content
• page_engagement
• photo_view
• post
• post_engagement
• post_reaction
• purchase
• rsvp
• search
• video_view
• view_content

We have updated the Quickstart packages for the following connectors:

• Amplitude to version 0.5.0
• Apple Search Ads to version 0.4.1
• Facebook Ads to version 0.8.0
• HubSpot to version 0.20.0
• Iterable to version 0.13.0
• Jira to version 0.19.0
• LinkedIn Ad Analytics to version 0.9.1
• Recurly to version 0.5.1
• Reddit Ads to version 0.3.1
• Zendesk Support to version 0.18.1

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

October 2024

The BASIC_AD_ACTION_VALUES prebuilt report is now the child table of the BASIC_AD prebuilt report.

September 2024

We have added a new prebuilt report, BASIC_AD_ACTION_VALUES.

August 2024

We have removed the messenger_sponsored_message column from the CREATIVE_HISTORY table because it is no longer supported by Facebook's Marketing API.

July 2024

We have added a new column, picture, to the AD_VIDEO_HISTORY table.

We have added a new prebuilt report, MARKETING_MIX_MODELING. The report fetches data on the adset level and contains the spend and impressions metrics. See Facebook's Marketing Mix Modeling documentation for more information.

• We have upgraded our Facebook Ads connector to version 19.0 of the Facebook API. For more information, see Facebook's summary of Graph API v19.0 and Marketing API v19.0.

• We now support the following breakdowns in our custom report tables:

  • video_asset
  • coarse_conversion_value
  • fidelity_type
  • hsid
  • is_conversion_id_modeled
  • postback_sequence_index
  • redownload
  • skan_campaign_id

• We now support the following fields in our custom report tables:

  • website_purchase_roas
  • ad_click_actions
  • ad_impression_actions
  • auction_bid
  • auction_competitiveness
  • auction_max_competitor_bid
  • catalog_segment_actions
  • catalog_segment_value_mobile_purchase_roas
  • catalog_segment_value_omni_purchase_roas
  • catalog_segment_value_website_purchase_roas
  • cost_per_15_sec_video_view
  • cost_per_2_sec_continuous_video_view
  • cost_per_ad_click
  • cost_per_dda_countby_convs
  • cost_per_one_thousand_ad_impression
  • created_time
  • dda_countby_convs
  • instagram_upcoming_event_reminders_set
  • interactive_component_tap
  • place_page_name
  • qualifying_question_qualify_answer_rate
  • video_play_retention_0_to_15s_actions
  • video_play_retention_20_to_60s_actions
  • video_play_retention_graph_actions
  • video_time_watched_actions
  • wish_bid

• We have deprecated the following fields in our custom report tables:

  • cost_per_estimated_ad_recallers
  • estimated_ad_recall_rate
  • gender_targeting
  • labels
  • location
  • unique_actions
  • unique_clicks
  • unique_ctr
  • unique_inline_link_click_ctr
  • unique_inline_link_clicks
  • unique_link_clicks_ctr
  • unique_outbound_clicks
  • unique_outbound_clicks_ctr
  • action_converted_product_id

May 2024

We now support the new Engaged-view attribution window with a 1 day value. This window refers to engaged-view conversions that are counted when a skippable video ad is played for at least 10 seconds or at least 97% of its total length if it’s shorter than 10 seconds, then a person takes an action within one day.

Learn more in Facebook's Engaged-view documentation and Graph API parameters documentation.

March 2024

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:

• conversion_rate_ranking
• engagement_rate_ranking
• quality_ranking

The existing reports won't be affected, but these fields will not be available for new reports.

November 2023

We have added a new AD_VIDEO_THUMBNAIL table. We are gradually rolling out this change to all existing connectors.

October 2023

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 2023

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 2023

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 2023

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 2023

We have added a new field, video_video_id, to the CREATIVE_HISTORY table.

March 2023

We can now fetch creative entities with large thumbnail images (up to 600 x 600).

February 2023

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 2022

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 2022

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 2022

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 2022

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 2022

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 the brand_lift_studies field
• ADSET_SCHEDULE stores ad set data for the adset_schedule field
• LOOKALIKE_TARGET_COUNTRY_NAME stores target_country_names field data for a custom audience lookalike_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 2022

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 2021

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 2021

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 2021

We have added support for lifetime aggregation with prebuilt and custom reports.

July 2021

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 2021

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 2021

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 2021

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.