Facebook Pages

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.

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

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.

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 a Source in Hevo:

1. Connect Hevo to Facebook Pages

  1. Click PIPELINES in the Asset Palette.

  2. Click + CREATE in the Pipeline List View.

  3. In the Select Source Type page, select Facebook Pages.

  4. In the Configure your Facebook Pages Account page, click + ADD FACEBOOK PAGES ACCOUNT.

    Add Facebook Pages Account

  5. Log in to your Facebook Pages account, and click Continue as <Company Name>.

    Continue as ABC Company

  6. Select one or more pages whose data you want to replicate and click Next.

    Select pages

  7. Authorize Hevo by enabling all the permissions in the page that is displayed and clicking Done.

    Authorize Hevo

  8. Click OK in the confirmation dialog.

    Confirm updates

2. Configure Facebook Pages in Hevo

  1. After you complete Step 8 above, in the Configure your Facebook Pages Source page, specify the following:

    FB Settings

    1. Pipeline Name: A unique name for your Pipeline.

    2. Pages: Select one or more pages whose data you want to replicate.

    3. Historical Sync Duration: The duration for which the past data must be ingested.

      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.

  2. Click TEST & CONTINUE.

  3. Proceed to configuring the data ingestion and setting up the Destination.

Data Replication

  • Historical Data: Hevo loads all page data and metrics on the basis of the historical sync duration specified during Pipeline creation.

    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 changed data since the previous run.

  • 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:

FB Pages erd

Data Model

The following is the list of tables (objects) that are created at the Destination when you run the Pipeline:

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 Daily 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 All time 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 All time post level metrics grouped on the basis of the following categories:
- Action Type
- Age Gender
- Country
- Locale
- Type
- Total

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.

Last updated on 12 Nov 2020