Facebook Page Insights

Last updated on Feb 20, 2023

Facebook Pages uses Facebook’s Graph 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/Ads to a Destination database or data warehouse using Hevo Pipelines.

For creating Pipelines using this Source, Hevo provides you a fully managed BigQuery data warehouse as a possible Destination. This option remains available till the time you set up your first BigQuery Destination irrespective of any other Destinations that you may have. With the managed warehouse, you are only charged the cost that Hevo incurs for your project in Google BigQuery. The invoice is generated at the end of each month and payment is recovered as per the payment instrument you have set up. You can now create your Pipeline and directly start analyzing your Source data. Read Hevo Managed Google BigQuery.

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.

Configuring Facebook Pages as a Source

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

Click PIPELINES in the Asset Palette.
Click + CREATE in the Pipelines List View.
In the Select Source Type page, select Facebook Pages.
In the Configure your Facebook Pages Account page, click + ADD FACEBOOK PAGES ACCOUNT.
Log in to your Facebook Pages account, and click Continue as <Company Name>.
Select one or more pages whose data you want to replicate and click Next.
Authorize Hevo by enabling all the permissions and clicking Done.
Click OK in the confirmation dialog.
In the Configure your Facebook Pages Source page, specify the following:
- Pipeline Name: A unique name for your Pipeline.
- Pages: Select one or more pages whose data you want to replicate.
- Historical Sync Duration: The duration for which the existing data in the Source must be ingested. Default duration: 1 Year.
  
  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.
Click TEST & CONTINUE.
Proceed to configuring the data ingestion and setting up the Destination.

Data Replication

Default Pipeline Frequency	Minimum Pipeline Frequency	Maximum Pipeline Frequency	Custom Frequency Range (Hrs)
24 Hrs	12 Hrs	24 Hrs	12-24

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

Historical Data: In the first run of the Pipeline, Hevo ingests historical data on the basis of the historical sync duration selected 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 data ingestion is complete, every subsequent run of the Pipeline fetches new and updated data for the reports.
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 - Consumption Type - 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 - Consumption Type - 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

The post data and metrics are ingested and uploaded only for the past 90 days due to Facebook Pages API 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.

Revision History

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

Date	Release	Description of Change
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.