Facebook Pages

Facebook Pages

This document describes the Facebook Pages data source. Continue reading to learn more about:

Collecting Data

WARNING Facebook requires the logged in user to have permissions to the data. If the permissions are not in place, some of the data will not be available.

To configure this data source and collect Facebook Pages data:

  1. On the Data Sources page, click Add Data Source.
  2. Search for Facebook Pages, then select the Facebook Pages source to continue to the next step.
  3. On the General tab:
    • Click Login and follow Facebook’s authorization process to allow Panoply to access Facebook Posts data.
    • Select the Facebook Pages from which to collect data. 
    • Select the Metrics to collect.
      • Panoply will show a list of the pages that your Facebook account has access to once you have logged in.
      • The metrics are defined by the Page Insights object of the Facebook Graph API.
      • To better understand the data available, see the Data Dictionary.
    • Select a Date Range.
      • The Date Range determines how many days of historical data to collect.
      • If this is a first-time collection, we recommend using the default selection. This will speed up the initial collection.
  4. (Optional) On the Advanced tab you can set the Advanced Options, however, we do not recommend changing advanced options unless you are an experienced Panoply user.
    • The Destination is the target table for the data. The default for the Facebook Posts data source is facebook_posts_{resource}, where resource is the table name from the schema for this data source, for example facebook_posts_{insights}.
  5. Click Save Changes and then you can Click **Collect.
    • The data source appears grayed out while the collection runs.
    • You may add additional data sources while this collection runs.
    • You can monitor this collection from the Jobs page or the Data Sources page. 
    • After a successful collection, navigate to the Tables page to review the data results.

Generated Tables

This section details all the tables that Panoply generates for the Facebook Pages data source.

All the generated tables are classified into these two groups:

  • Metadata tables
  • Insights tables

Metadata tables

Metadata tables store information regarding your selected Facebook Page (s), such as the category and description of the page, email and operating hours that are listed in its About section (if the page is for a business) , the year and month when the page was first created and more.

These tables are always created for a Facebook Pages data source. They’re based on the Page or Pages you’ve selected when configuring the data source, and not on the metric categories (more on this on the next section).

The main metadata table is named facebook_pages_metadata while the rest have the facebook_pages_metadata prefix in their table names. They are:

  1. facebook_pages_metadata_category_list
  2. facebook_pages_insights_metadata_connected_instagram_account
  3. facebook_pages_metadata_emails
  4. facebook_pages_metadata_hours
  5. facebook_pages_metadata_instagram_business_account
  6. facebook_pages_metadata_location
  7. facebook_pages_metadata_messenger_ads_default_icebreakers
  8. facebook_pages_metadata_insights_page_about_story
  9. facebook_pages_metadata_start_info
  10. facebook_pages_metadata_voip_info

Insights tables

The second group of tables store metrics about your Facebook Pages and their posts. Facebook provides a great number of metrics and Panoply creates a series of tables based on the information provided by the Facebook Graph API. The primary table facebook\_pages\_insights contains all of the metrics in a single table. For some metrics, Panoply also creates other tables, and for some of those tables, we nest information for several metrics.

The tables are named based on the metrics contained in them. These tables are only created when your Facebook Pages pass this data to Panoply, for example, you will only have data for facebook\_pages\_insights\_page\_fan\_adds if your Page(s) has data that includes new fan adds.

The Page Insights object of the Facebook Graph API provides a detailed list of metrics under each category.

Listed below are the tables that Panoply creates for each metric category.

1. Page Content

2. Page CTA Clicks

3. Page Engagement

4. Page Impressions

5. Page Posts

6. Page and Post Stories

7. Page Post Engagement

  • All Page Post Engagement metrics are contained in the Insights main table, and no additional tables are generated.

8. Page Post Impressions

  • All Page Post Impressions metrics are contained in the Insights main table, and no additional tables are generated.

9. Page Post Reactions

  • All Page Post Reactions metrics are contained in the Insights main table, and no additional tables are generated.

10. Page Reaction

11. Page User Demographic

12. Page Video View

13. Page Views

14. Page Video Posts

  • All Page Video Posts metrics are contained in the Insights main table, and no additional tables are generated.

15. Video Ad Breaks

  • All Video Ad Breaks metrics are contained in the Insights main table, and no additional tables are generated.

Data Dictionary

Metadata Tables

facebook_pages_metadata

The primary or parent table of all metadata-related tables. In this case, metadata is information about the page itself, as opposed to the insights tables which contain information about page interaction. These tables store data regarding the Facebook Page or Pages you’ve selected on the configuration page of your Facebook Pages data source. Most of this data is listed in the About section of your Page or Pages.

The Page object of Facebook’s Graph API is your primary reference for understanding all of the metadata tables. If there are additional references specific to each table, we’ll list them within the description of the table.

facebook_pages_metadata_category_list

This table stores the category names that describe or classify the Page. Each category defined for your Page is saved as one record inside this table.

Additional reference: Page Category

facebook_pages_metadata_connected_instagram_account

A table to store the Instagram account connected to a Page via page settings.

facebook_pages_metadata_emails

A table to store the emails listed in the About section of your Page.

facebook_pages_metadata_hours

A table to store your Page’s range of opening hours for a day.

The opening hours for a day can have 2 different hour ranges. The fields that represent the range of opening hours for a day are in the form of {day}_{number}_{status}.

{day} is the first three characters of the day of the week, {number} should be either 1 or 2 to allow for the two different hours ranges per day. {status} should be either “open” or “close” to delineate the start or end of a time range.

An example would be “mon_1_open” with value 17:00 and “mon_1_close” with value 21:15, which would represent a single opening range of 5 pm to 9:15 pm on Mondays. If one specific day is open 24 hours, the range should be specified as 00:00 to 24:00.

 

facebook_pages_metadata_instagram_business_account

A table to store the Instagram account linked to a Page during an Instagram business conversion flow.

 

facebook_pages_metadata_location

A table to store the location information of your Page. They consist of country, state, city, and ZIP.

Additional reference:

 

facebook_pages_metadata_messenger_ads_default_icebreakers

A table to store the default Ice Breakers of your Page.

Ice breakers provide a way for users to start a conversation with your Page with a list of frequently asked questions.

 

facebook_pages_metadata_page_about_story

A table to store the Page About Story of your Page.

A Page About Story is a document located in your Page’s About section. It tells your Page’s story with rich text and images and can be updated as your story evolves.

Additional reference:

 

facebook_pages_metadata_start_info

A table to store the information of when the entity represented by the Page was started or founded.

Additional references:

 

facebook_pages_metadata_voip_info

A table to store a Page’s VOIP (Voice over Internet Protocol) information, whether or not the Page can be reached or called via apps or services that use VOIP technology.

Additional reference:

 


Insights Tables

facebook_pages_insights

The primary or parent table of all insights-related tables, facebook_pages stores metrics that belong to different categories. The number of columns this table contains will depend on which metric categories you’ve selected when you configured the Facebook Pages data source.

 

Page Content

Facebook Graph API Reference:

facebook_pages_insights_page_tab_views_login_top

A table to store the number of times users logged in to Facebook saw tabs on your Page.

 

facebook_pages_insights_page_tab_views_login_top_unique

A table to store the number of users logged in to Facebook who saw tabs on your Page.

 

facebook_pages_insights_page_tab_views_logout_top

A table to store the number of times users not logged in to Facebook saw tabs on your Page.

 

Page CTA Clicks

Facebook Graph API Reference:

facebook_pages_insights_page_total_actions

This table stores the number of clicks on your Page’s contact info and call-to-action button.

 

facebook_pages_insights_page_call_phone_clicks_by_age_gender_logged_in_unique

This table provides the number of people who logged in to Facebook and clicked the Call Now button on your Page, broken down by age and gender.

 

facebook_pages_insights_page_cta_clicks_by_site_logged_in_unique

A table to store the number of people who are logged in to Facebook and clicked on the CTA button, broken down by www, mobile, API or other.

 

facebook_pages_insights_page_cta_clicks_logged_in_total

A table to store the total number of clicks on the Page CTA button by people who are logged in to Facebook.

 

facebook_pages_insights_page_cta_clicks_logged_in_unique

A table to store the unique number of clicks on the Page CTA button by people who are logged in to Facebook.

 

Page Engagement

Facebook Graph API Reference:

facebook_pages_insights_page_fans_online

A table to store the number of your fans who saw any posts on Facebook on a given day, broken down by hour of the day in PST/PDT.

 

Page Impressions

Facebook Graph API Reference:

facebook_pages_insights_page_impressions_by_story_type

A table to store the total impressions of posts published by a friend about your Page by type.

 

facebook_pages_insights_page_impressions_by_story_type_unique

A table to store the number of people who saw posts published by a friend about your Page by type.

 

facebook_pages_insights_page_impressions_frequency_distribution

A table to store the number of people your Page reached, broken down by how many times people saw any content about your Page.

 

facebook_pages_insights_page_impressions_viral_frequency_distribution

A table to store the number of people your Page reached from a story published by a friend, broken down by how many times people saw stories about your Page.

 

Page Posts

Facebook Graph API Reference:

facebook_pages_insights_page_posts_impressions_frequency_distribution

A table to store the number of people who saw your Page posts, broken down by how many times people saw your posts.

 

Page and Post Stories

Facebook Graph API Reference:

facebook_pages_insights_page_content_activity_by_action_type

A table to store the number of stories about your Page’s stories, by Page story type.

Facebook Graph API Reference:

 

facebook_pages_insights_page_content_activity_by_action_type_unique

A table to store the number of people talking about your Page’s stories, by Page story type.

 

Page Post Engagement

The Page Post Engagement metrics are found in the main Insights table.

Facebook Graph API Reference:

Page Post Impressions

The Page Post Engagement metrics are found in the main Insights table.

Facebook Graph API Reference:

Page Post Reactions

The Page Post Reactions metrics are found in the main Insights table.

Facebook Graph API Reference:

Page Reactions

Facebook Graph API Reference:

facebook_pages_insights_page_actions_post_reactions_total

A table for storing the daily total post reactions of a page by type. These reaction types are “anger”, “haha”,like”, “love”, “sorry”, andwow”.

 

Page User Demographics

Facebook Graph API Reference:

facebook_pages_insights_page_fans_by_like_source

This table stores the number of fans who have liked your page, sorted by  the most common places where people can like your Page.

 

facebook_pages_insights_page_fans_by_like_source_unique

This table stores the number of unique fans who have liked your page, sorted by  the most common places where people can like your Page.

 

facebook_pages_insights_page_fans_by_unlike_source

A table to store the number of people who unliked your Page, broken down by the most common ways people can unlike your Page.

 

facebook_pages_insights_page_fans_by_unlike_source_unique

A table to store the number of people who unliked your Page, broken down by the most common ways people can unlike your Page.

 

facebook_pages_insights_page_fans_city

A table to store the aggregated Facebook location data, sorted by city, about the people who like your Page.

 

facebook_pages_insights_page_fans_country

A table to store the number of people, aggregated per country, that like your Page. Only the 45 countries with the most people that like your Page are included.

 

facebook_pages_insights_page_fans_gender_age

A table to store the number of people who saw any of your posts at least once, grouped by age and gender. This number is an estimate.

 

facebook_pages_insights_page_fans_locale

A table to store the aggregated language data about the people who like your Page based on the default language setting selected when accessing Facebook.

 

Page Video Views

Facebook Graph API Reference:

facebook_pages_insights_page_video_views_by_paid_non_paid

A table to store the number of times videos have played for at least 3 seconds, or for nearly their total length if they’re shorter than 3 seconds, broken down by total, paid, and non-paid.

 

Page Views

Facebook Graph API Reference:

facebook_pages_insights_page_views_by_profile_tab_total

A table to store the number of people who have viewed each Page profile tab.

 

facebook_pages_insights_page_views_by_profile_tab_logged_in_unique

A table to store the number of people logged in to Facebook who have viewed your Page’s profile, broken down by each tab.

 

facebook_pages_insights_page_views_by_internal_referer_logged_in_unique

A table to store the number of people logged in to Facebook who have viewed your Page, broken down by the internal referer within Facebook.

 

facebook_pages_insights_page_views_by_site_logged_in_unique

A table to store the number of people logged in to Facebook who have viewed your Page profile, broken down by the type of device.

 

facebook_pages_insights_page_views_by_referers_logged_in_unique

This table stores the number of logged-in page visit counts (unique users) by referral source.

 

Page Video Posts

The Page Video Posts metrics can be found in the main Insights table.

Facebook Graph API Reference:

Video Ad Breaks

The Video Ad Breaks metrics can be found in the main Insights table.

Facebook Graph API Reference:

Getting started is easy! Get all your data in one place in minutes.
Try Free