Release Notes

September 2022

We have upgraded our Facebook Ad Account connector to version 15.0 of the Facebook API. For more information, see Facebook's .

June 2022

We have upgraded our Facebook Ad Account connector from version 13.0 to 14.0 of the Facebook Graph API. Learn more about the changes in the .

March 2022

We have upgraded our Facebook Ad Account connector from version 12.0 to 13.0 of the Facebook Marketing API. Learn more about the changes in the .

September 2021

We have upgraded our Facebook Ad Account connector from version 11.0 to 12.0 of the Facebook Marketing API. Learn more about the changes in the .

July 2021

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 .

We our Facebook Ad Account connector and replaced it with the new 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 .

June 2021

We have upgraded our connector to support .

March 2021

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

February 2021

We have upgraded our connector to support .

We no longer support the budget_rebalance_flag field because .

December 2020

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 2020

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

April 2020

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

March 2020

We have upgraded our connector to support Facebook and .

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 2020

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

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

December 2019

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 2019

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 2019

We have upgraded both the Facebook Graph API and the Facebook Marketing API to version 4.0. For more details, see .

August 2019

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 2019

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 2019

Now supports multiple accounts with the same name.

January 2019

We have upgraded the Facebook Marketing API to . As Facebook has deprecated the rtb_flag field, we will no longer support it.

November 2018

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 2018

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 2018

We have removed the rule column from the CUSTOM_AUDIENCE_HISTORY table.

July 2018

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 2018

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 2018

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