Release Notes

December 2024

We have added two new metadata tables, PAGE_VIDEO_HISTORY and PAGE_VIDEO_THUMBNAILS.

For more information see Facebook's API docs.

October 2024

We removed the following metrics since Facebook has deprecated them for all API versions on September 16, 2024, according to Facebook's changelog:

page_impressions_organic_v2
page_impressions_organic_unique_v2
page_impressions_by_story_type
page_impressions_by_story_type_unique
page_impressions_by_city_unique
page_impressions_by_country_unique
page_impressions_by_locale_unique
page_impressions_by_age_gender_unique
page_impressions_viral_frequency_distribution
page_consumptions_unique
page_consumptions_by_consumption_type
page_consumptions_by_consumption_type_unique
page_places_checkin_total
page_places_checkin_total_unique
page_negative_feedback
page_negative_feedback_unique
page_negative_feedback_by_type
page_negative_feedback_by_type_unique
page_fans_online
page_fans_online_per_day
page_call_phone_clicks_logged_in_unique
page_get_directions_clicks_logged_in_unique
page_website_clicks_logged_in_unique
page_tab_views_login_top_unique
page_tab_views_login_top
page_tab_views_logout_top
page_posts_impressions_organic
page_posts_impressions_organic_unique
post_impressions_by_story_type
post_impressions_by_story_type_unique
post_engaged_users
post_negative_feedback
post_negative_feedback_unique
post_negative_feedback_by_type
post_negative_feedback_by_type_unique
post_engaged_fan
post_clicks_unique
post_clicks_by_type_unique

We also removed the following DAILY PAGE METRIC CATEGORIES because there are no metrics anymore that belong to those categories:

BY_CONSUMPTION_TYPE
BY_FREQUENCY_DISTRIBUTION
BY_PROFILE_TAB
BY_STORY_TYPE

We also removed the following reporting tables because there are no metrics anymore that belong to those tables:

PAGE_METRICS_BY_AGE_GENDER
PAGE_METRICS_BY_CONSUMPTION_TYPE
PAGE_METRICS_BY_FREQUENCY_DISTRIBUTION
PAGE_METRICS_BY_PROFILE_TAB
PAGE_METRICS_BY_STORY_TYPE
PAGE_METRICS_BY_TIME
PAGE_METRICS_BY_TYPE
POST_METRICS_BY_STORY_TYPE

May 2024

We have added a new field, unshimmed_url, to the POST_ATTACHMENT_HISTORY table.

We have added a new field, full_picture, to the POST_HISTORY table.

April 2024

We have upgraded our Facebook Pages connector to version 18.0 of the Graph API. We are gradually rolling out this change to all existing connectors. For more information, see Graph API's changelog.

As part of the upgrade, we have added a new column is_expired to the POST_HISTORY table.

We have restored the following metrics, since they will no longer be deprecated for API versions on March 14, 2024, according to Facebook's Out-Of-Cycle Changes documentation:

page_actions_post_reactions_anger_total
page_actions_post_reactions_haha_total
page_actions_post_reactions_like_total
page_actions_post_reactions_love_total
page_actions_post_reactions_sorry_total
page_actions_post_reactions_wow_total
post_activity_by_action_type
post_activity_by_action_type_unique

March 2024

We have added the following new tables to support Facebook Reels:

LIFETIME_REEL_METRICS_BY_TYPE
LIFETIME_REEL_METRICS_TOTAL
REEL_HISTORY
UNIQUE_LIFETIME_REEL_METRICS_TOTAL

You can view the full list of metrics for reel insights in Facebook's documentation.

We are gradually rolling out this change to all our Facebook Pages connectors.

February 2024

We removed the following metrics, since they will be deprecated for all API versions on March 14, 2024, according to Facebook's Out-Of-Cycle Changes documentation:

page_actions_post_reactions_anger_total
page_actions_post_reactions_haha_total
page_actions_post_reactions_like_total
page_actions_post_reactions_love_total
page_actions_post_reactions_sorry_total
page_actions_post_reactions_wow_total
page_call_phone_clicks_by_age_gender_logged_in_unique
page_call_phone_clicks_logged_in_by_city_unique
page_call_phone_clicks_logged_in_by_country_unique
page_consumptions
page_content_activity
page_content_activity_by_action_type
page_content_activity_by_action_type_unique
page_content_activity_by_age_gender_unique
page_content_activity_by_city_unique
page_content_activity_by_country_unique
page_content_activity_by_locale_unique
page_cta_clicks_by_age_gender_logged_in_unique
page_cta_clicks_logged_in_by_city_unique
page_cta_clicks_logged_in_by_country_unique
page_engaged_users
page_fans_by_like_source_unique
page_fans_by_like_source
page_fans_by_unlike_source_unique
page_fans_by_unlike_source
page_fans_gender_age
page_get_directions_clicks_by_age_gender_logged_in_unique
page_get_directions_clicks_logged_in_by_city_unique
page_get_directions_clicks_logged_in_by_country_unique
page_impressions_frequency_distribution
page_places_checkin_mobile_unique
page_places_checkin_mobile
page_places_checkins_by_age_gender
page_places_checkins_by_country
page_places_checkins_by_locale
page_positive_feedback_by_type_unique
page_positive_feedback_by_type
page_posts_impressions_frequency_distribution
page_views_by_age_gender_logged_in_unique
page_views_by_profile_tab_logged_in_unique
page_views_by_profile_tab_total
page_views_external_referrals
page_views_logged_in_total
page_views_logged_in_unique
page_views_logout
page_website_clicks_by_age_gender_logged_in_unique
page_website_clicks_logged_in_by_city_unique
page_website_clicks_logged_in_by_country_unique
post_activity
post_activity_by_action_type
post_activity_unique
post_impressions_fan_paid_unique
post_impressions_fan_paid

We also removed the following DAILY PAGE METRIC CATEGORIES, because there are no metrics anymore that belong to those categories:

BY_ACTION_TYPE
BY_EXTERNAL_REFERRAL
BY_LIKE_SOURCE
BY_UNLIKE_SOURCE

January 2024

We have added a new field, followers_count, to the PAGE table.

November 2023

We have added a new table, POST_COMMENT_HISTORY.

We have added a new column, comment_count, to the POST_HISTORY table. We are gradually rolling out these changes to all existing connectors.

June 2023

We have upgraded our Facebook Pages connector to version 17.0 of the Graph API. We are gradually rolling out this change to all existing connectors. For more information about the changes, see Graph API's changelog.

May 2023

We have added the following new columns to the POST_ATTACHMENT_HISTORY table to store the URL address and size information for the image inside of the post attachment:

media_image_src
media_image_height
media_image_width

March 2023

We have upgraded our Facebook Pages connector to version 16.0 of the Facebook Graph API. Learn more about the changes in the Facebook Graph API v16.0 changelog.

We have added a new metric, post_video_views_60s_excludes_shorter, to the LIFETIME_POST_METRICS_TOTAL table. For more information, see Facebook's API documentation.

February 2023

We have added a new table, LIFETIME_POST_METRICS_BY_VIDEO_INTERVAL, to preserve the following metrics represented as intervals:

post_video_retention_graph
post_video_retention_graph_clicked_to_play
post_video_retention_graph_autoplayed

See Facebook's API documentation for more information.

December 2022

We have added the following fields to the LIFETIME_POST_METRICS_TOTAL table:

post_video_retention_graph
post_video_retention_graph_clicked_to_play
post_video_retention_graph_autoplayed

October 2022

We have upgraded our Facebook Pages connector from version 14.0 to 15.0 of the Facebook API. Learn more about the changes in the Facebook API v15.0 changelog.

June 2022

We have upgraded our Facebook Pages connector from version 13.0 to 14.0 of the Facebook Graph API. Learn more about the changes in the Facebook Graph API v14.0 changelog.

March 2022

We have upgraded our Facebook Pages 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.

December 2021

We have released pre-built, dbt Core-compatible data models for Facebook Pages. Find the model in Fivetran's dbt hub. 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.

September 2021

We have upgraded our Facebook Pages 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

Our Facebook Pages connector is now generally available.

Read our Facebook Pages connector documentation.

July 2021

We have upgraded our Facebook Pages connector from version 6.0 to 11.0 of the Facebook Pages API and Facebook Insights API. We handled deprecations and updates. Learn more about the deprecations and changes in the Facebook Pages API v11.0 changelog.

We no longer support multiple fields for the Pages that have been migrated to the New Pages Experience.

We have added a new table, DAILY_PAGE_METRICS_BY_EXTERNAL_REFERRAL. This table contains external domains that refer traffic to your Page.

We now support the following fields in the tables below:

page_fans_online_per_day in the DAILY_PAGE_METRICS_TOTAL table
post_video_length and post_video_views_15s in the LIFETIME_POST_METRICS_TOTAL table
post_reactions_by_type_total in the LIFETIME_POST_METRICS_BY_TYPE table

May 2021

We have added three new tables:

DAILY_POST_METRICS_TOTAL
UNIQUE_DAILY_POST_METRICS_TOTAL
DAILY_POST_METRICS_BY_LOCALE

These tables contain daily post video metrics.

January 2021

The Facebook Pages connector now supports priority-first sync. Priority-first syncs fetch your most recent data first so that it's quickly ready for you to use. Facebook Pages priority-first syncs fetch the most recent thirty days' worth of data from the page insights tables. To learn more, see our priority-first sync documentation.

December 2020

We have expanded the public API endpoints Create a Connector and Modify a Connector. Now you can authorize the following connectors by adding the auth section to payloads:

May 2020

Facebook Pages allows you to sync your Facebook Page's content, posts, and related insights and metrics.

Read our Facebook Pages connector documentation.

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