Facebook Ad Account Release Notes – Fivetran Support Portal

July 2021link

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

We have upgraded our Facebook Ad Account 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 connector to support Facebook Marketing API v10.0.

March 2021link

We have deprecated the ACCOUNT_ATTRIBUTION table because Facebook has deprecated the attribution_spec field.

February 2021link

We have upgraded our connector to support Facebook Marketing API v9.0.

We no longer support the budget_rebalance_flag field because Facebook has deprecated the field.

December 2020link

We have removed the CREATIVE_HISTORY_ASSET_FEED_SPEC_LINK_URL child table from the CREATIVE_HISTORY table. We now sync the link URL data in JSON format to the asset_feed_spec field of the CREATIVE_HISTORY table. Be sure to update your queries.

May 2020link

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

April 2020link

We have added a new column, daily_budget, to the CAMPAIGN_HISTORY table.

March 2020link

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

We have added a new child table, CREATIVE_HISTORY_ASSET_FEED_SPEC_LINK_URLS, to the CREATIVE_HISTORY table. This table stores the link URLs for Placement Asset Customization, Dynamic Creative, and Segment Asset Customization features.

February 2020link

We have made a couple of schema changes to be in sync with Facebook API changes:

We have added a new table, USER_TASK.
We have deprecated the user_role column from the ACCOUNT_HISTORY table.

December 2019link

We now sync archived ad data in the AD_HISTORY table and archived ad_set data in the AD_SET_HISTORY table. Previously we did not sync data for ad and ad_set records with archived status, because the Facebook API’s default settings exclude archived data.

November 2019link

We now sync archived campaign data in the CAMPAIGN_HISTORY table. Previously, we did not sync this data because the Facebook API’s default settings exclude archived data.

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.

August 2019link

We have added a new table, APP_LINK.

If we encounter an error when we try to sync a creative, then we skip that creative for that account and give a warning in the dashboard.

The warning includes the creative and the error with their respective accounts as follows.

Account ID	Creative ID	Error
account_1	creative_1	The creative is invalid
account_2	creative_2	The creative might be deleted or you lack permissions to see it

We have added back the following fields in the AD_ACCOUNT_HISTORY table.

business_manager_name
business_manager_timezone_id
business_manager_primary_page
business_manager_updated_by
business_manager_created_by
business_manager_update_time
business_manager_created_time

Facebook have granted us business_management permissions so once again we are able to sync these fields. You have to reconnect so that we can get new access_token with business_management permission.

July 2019link

We have removed the following fields from the AD_ACCOUNT_HISTORY table.

business_manager_name
business_manager_timezone_id
business_manager_primary_page
business_manager_updated_by
business_manager_created_by
business_manager_update_time
business_manager_created_time

Facebook recently changed the permissions required to fetch these fields. We now require business_management permissions to sync these fields. We’ve submitted the Fivetran App to Facebook App Review so that Facebook will grant business_management permissions for it. After approval, we will sync these fields again.

April 2019link

Now supports multiple accounts with the same name.

January 2019link

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

November 2018link

We have removed the FAILED_DELIVERY_CHECKS table from the Facebook Ad Account connector due to data retrieval problems and lack of analytical utility.

October 2018link

We have added two new tables, CAROUSEL_MEDIA and CAROUSEL_MEDIA_URL_TAG.
We have added six new fields to the CREATIVE_HISTORY table:
- carousel_ad_link
- page_link
- template_page_link
- page_message
- template_description
- link_description

September 2018link

We have removed the rule column from the CUSTOM_AUDIENCE_HISTORY table.

July 2018link

We have added a new column, bid_strategy, in the AD_SET_HISTORY table.

Version 3 of the Facebook API has deprecated the following fields:

TABLE	COLUMNS
AD_SET_HISTORY	is_autobid, is_average_price_pacing
CAMPAIGN_HISTORY	kpi_custom_conversion_id, kpi_type
CUSTOM_AUDIENCE_HISTORY	pixel_id, external_event_source_*

June 2018link

We have made continual improvements to make it easier for you to know which of your links was clicked.

We have added a new table, URL_TAG.

We have added the link_caption, link_message, template_caption, and template_message columns to and removed the url_tags column from the CREATIVE_HISTORY table.

April 2018link

Facebook Ad Account provides a history of the settings of your Facebook Ads Accounts, Campaigns, Ad Sets, Ads, and Ad Creatives.

Link to Facebook Ad Account documentation