September 2021link
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 Facebook Marketing API v12.0 changelog.
July 2021link
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.
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.
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_rolecolumn from theACCOUNT_HISTORYtable.
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_namebusiness_manager_timezone_idbusiness_manager_primary_pagebusiness_manager_updated_bybusiness_manager_created_bybusiness_manager_update_timebusiness_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_namebusiness_manager_timezone_idbusiness_manager_primary_pagebusiness_manager_updated_bybusiness_manager_created_bybusiness_manager_update_timebusiness_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_MEDIAandCAROUSEL_MEDIA_URL_TAG. -
We have added six new fields to the
CREATIVE_HISTORYtable:carousel_ad_linkpage_linktemplate_page_linkpage_messagetemplate_descriptionlink_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.