Facebook Page Insights

Last updated on Jan 07, 2025

Objects	Metrics
Page Call Phone Clicks	- page_call_phone_clicks_logged_in_unique
Page Consumption	- page_consumptions_by_consumption_type - page_consumptions_by_consumption_type_unique - page_consumptions_unique
Page Feedback	- page_negative_feedback - page_negative_feedback_by_type - page_negative_feedback_by_type_unique - page_negative_feedback_unique
Page Get Direction Clicks	- page_get_directions_clicks_logged_in_unique
Page Places Check In	- page_places_checkin_total - page_places_checkin_total_unique
Page Tab Views	- page_tab_views_login_top - page_tab_views_login_top_unique - page_tab_views_logout_top
Page Website Clicks	- page_website_clicks_logged_in_unique

Note: Hevo no longer supports ingesting data for the metrics listed in the tables above. As a result, the corresponding Destination tables are not updated, and these objects are excluded from the Data Model.

Specific metrics associated with these objects:

Objects	Metrics
Page CTA Clicks	- page_cta_clicks_logged_in_total - page_cta_clicks_logged_in_unique
Page Fans	- page_fans_online - page_fans_online_per_day
Page Impressions	- page_impressions_organic_unique_v2 - page_impressions_by_country_unique - page_impressions_by_city_unique - page_impressions_by_locale_unique - page_impressions_organic_v2 - page_impressions_by_story_type_unique - page_impressions_by_story_type - page_impressions_viral_frequency_distribution - page_impressions_by_age_gender_unique

Note: Hevo no longer supports ingesting data for the metrics listed in the tables above, so the corresponding Destination columns are also not updated.

Facebook Pages uses Facebook’s Marketing API to fetch insights data for a Facebook page as a whole (such as followers and impressions), and for page posts (such as likes, shares, comments, and video plays). You can replicate the data of one or multiple Facebook pages, including details such as posting and activity history, page insights including page views, post impressions, and insights on posted stories or Ads to a Destination database or data warehouse using Hevo Pipelines.

The Facebook Pages admin user must authorize Hevo to access the Facebook Pages APIs for reading the page and posts-related insights data for the selected pages.

Note: The data is ingested only for posts made by the page owner.

Getting Started

Data Sync

Prerequisites

An active Facebook (FB) account with privileges to manage one or more FB pages exists.
You are assigned the Team Administrator, Team Collaborator, or Pipeline Administrator role in Hevo to create the Pipeline.

Configuring Facebook Pages as a Source

Perform the following steps to configure Facebook Pages as the Source in your Pipeline:

Click PIPELINES in the Navigation Bar.
Click + CREATE PIPELINE in the Pipelines List View.
On the Select Source Type page, select Facebook Pages.
On the Configure your Facebook Pages account page, do one of the following:
- Select a previously configured account and click CONTINUE.
- Click Add Facebook Pages account and perform the following steps to configure an account:
  1. Log in to your Facebook Pages account, and click Continue as <Company Name> in the pop-up dialog.
  2. Select one of the following options:
    - Opt in to all current and future business (Default): Hevo gets access to all the existing businesses in your Business Manager account(s) and the ones you create in the future.
    - Opt in to current businesses only: Hevo gets access only to the businesses in the Business Manager account(s) you select. You can select the accounts individually or click the Select all option to grant access to all the accounts.
      
      Note: As part of the Facebook Marketing API update to v18.0, Hevo requires business management permission to replicate data from your Facebook Pages account(s).
  3. Click Continue.
  4. Select one of the following to choose the pages you want to replicate:
    - Opt in to all current and future Pages: Hevo gets access to all the existing pages in the account and the ones you create in the future.
    - Opt in to current Pages only (Default): Hevo gets access only to the pages you select. You can select the pages individually or click the Select all option to grant access to all the pages.
  5. Click Continue.
  6. Review the permissions requested by Hevo and click Save to authorize Hevo to access the data.
  7. Click Got it in the confirmation dialog.
Note: If you enable Advanced Protection, such as two-factor authentication or password changes, you will need to reauthorize Hevo; otherwise, the Pipeline will be marked as failed.
On the Configure your Facebook Pages Source page, specify the following:
- Pipeline Name: A unique name for your Pipeline, not exceeding 255 characters.
- Pages: The pages whose data you want to replicate. Select one or more pages from the drop-down. Default selection: All.
- Historical Sync Duration: The duration for which you want to ingest the existing data from the Source. Default duration: 1 Month.
  
  Note: You can fetch data for daily_page or unique_page metrics for a period more than three months by changing the position of these objects to any past date up till two years from the current date, in the Pipeline Overview page. Any data ingested from the Source using the Change Position action is billable.
Click TEST & CONTINUE.
Proceed to configuring the data ingestion and setting up the Destination.

Data Replication

For Teams Created	Default Ingestion Frequency	Minimum Ingestion Frequency	Maximum Ingestion Frequency	Custom Frequency Range (in Hrs)
Before Release 2.21	24 Hrs	12 Hrs	24 Hrs	12-24
After Release 2.21	6 Hrs	30 Mins	24 Hrs	1-24

Note: The custom frequency must be set in hours as an integer value. For example, 1, 2, or 3 but not 1.5 or 1.75.

Historical Data: The first run of the Pipeline ingests historical data for the selected objects on the basis of the historical sync duration specified at the time of creating the Pipeline and loads it to the Destination. Default duration: 1 Month.

Note: You can fetch data for Daily Page or Unique Page metrics for a period more than three months by changing the position of these objects to any past date up till two years from the current date, in the Pipeline Overview page.
Incremental Data: Once the historical load is complete, data is ingested as per the ingestion frequency in Full Load or Incremental mode, as applicable.
Data Refresh: Data for the last 90 days is refreshed on a rolling basis for all data objects.

Schema and Primary Keys

Hevo uses the following schema to upload the records in the Destination database:

Data Model

Hevo ingests the following data from your Facebook account:

Object	Description & Update Frequency
Daily Page Metrics	Daily page metrics, grouped on the basis of the following categories: - Action Type - Age Gender - City - Country - Frequency Distribution - Like Source - Paid Non-paid - Locale - Story Type - Time - Type - Unlike Source - Total - Profile Tab
Lifetime Post Metrics	All time post-level metrics grouped on the basis of the following categories: - Action Type - Age Gender - Country - Locale - Type - Total
Page	All page details such as bio, about, likes, creation date, page type, hours, products. Metrics such as likes and shares are subject to change daily. Other details such as bio and working hours are subject to a page owner’s preference.
Post	All posts-related activity and metrics such as likes, views, and shares, from the feed, fetched and updated for the past 14 days.
Post Attachments	Attachment details for posts, such as, description, type, and URLs.
Post Tagged Object	Details related to an entity tagged on any post, such as name, type, and related post details.
Post Video Property	All properties related to a video included in a post such as description, length, and source.
Unique Page Metrics	Individual page-level metrics grouped on the basis of the following categories: - Action Type - Age Gender - City - Country - Frequency Distribution - Like Source - Paid Non-paid - Locale - Story Type - Time - Type - Unlike Source - Total - Profile Tab
Unique Lifetime Post Metrics	Individual post-level metrics grouped on the basis of the following categories: - Action Type - Age Gender - Country - Locale - Type - Total

Additional Information

Read the detailed Hevo documentation for the following related topics:

Limitations

Limitations

All page data is limited to the past two years due to Facebook Pages API limitations.

Note: To fetch data for daily_page or unique_page metrics for a period more than three months, change the position of the object to any past date up till two years from the current date, in the Pipeline Overview page.
Hevo does not load an Event into the Destination table if its size exceeds 128 MB, which may lead to discrepancies between your Source and Destination data. To avoid such a scenario, ensure that each row in your Source objects contains less than 100 MB of data.

Revision History

Refer to the following table for the list of key updates made to this page:

Date	Release	Description of Change
Jan-07-2025	NA	Updated the Limitations section to add information on Event size.
Jan-06-2025	2.31.2	Updated the warning container in the page overview to include information about the upgrade to Marketing API v21.0.
Nov-05-2024	NA	Added a note in the Configuring Facebook Pages as a Source section to indicate that enabling Advanced Protection requires reauthorizing Hevo for existing Pipelines.
Aug-29-2024	NA	Updated section, Limitations to remove the limitation on ingesting post data and metrics only from the last 90 days.
Jul-01-2024	2.25	Updated the page overview to: - Add a warning container to inform about the upgrade to Marketing API v19.0, - Remove the note about the upgrade to Marketing API v18.0.
Mar-05-2024	2.21	Updated the ingestion frequency table in the Data Replication section.
Jan-29-2024	2.19.3	Added a note in the page overview about the Marketing API v18.0 update.
Oct-03-2023	NA	Updated the se
Oct-03-2023	NA	Updated the section, Configuring Facebook Pages as a Source as per the latest Facebook UI.
Feb-20-2023	NA	Updated section, Configuring Facebook Pages as a Source to update the information about historical sync duration.
Sep-05-2022	NA	Updated section, Data Replication to reorganize the content for better understanding and coherence.
Dec-06-2021	1.77	Updated the Data Model section to correct the definitions of Lifetime Post Metrics and Unique Page Metrics.
Oct-25-2021	NA	Added the Pipeline frequency information in the Data Replication section.
Jul-26-2021	NA	Added a note in the Overview section about Hevo providing a fully-managed Google BigQuery Destination for Pipelines created with this Source.