March 2022link
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 Facebook Marketing API v13.0 changelog.
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_role
column from theACCOUNT_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
andCAROUSEL_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.