Facebook Pages

Facebook Pages

This document provides instructions for integrating Facebook Pages data into Panoply. The following items will be covered:

Facebook Pages Data Integration

To integrate Facebook Pages data into Panoply using default selections, complete the following steps. For more advanced options, complete the following and refer to the subsequent sections for detailed information.

  1. Click Data Sources in the navigation menu.
  2. Click the Add Data Source button.
  3. In the Data Sources – Choose Source Type window, select Facebook Pages. Facebook Pages is listed under Most Popular and under APIs.
  4. In the Data Sources – Facebook Pages screen, click Login With Facebook.
  5. A Facebook dialog box confirms whether you want to allow Panoply to manager your Pages and manage your Page and App insights data. Click OK.
  6. In the Data Sources – Facebook Pages screen, select the Facebook Pages for which to import data.
  7. (Optional) To customize the ingestion from your data source, review the advanced options.
  8. Click Collect.

The Data Sources – Facebook Pages window will appear grayed out while the data integration is pending. A small green progress bar appears below Facebook Pages.

You will be prompted to set up the integration of another data source. You can set up multiple data integrations without impacting the ingestion of the already scheduled or pending data integrations.

From the Data Sources main menu, you can monitor the data ingestion status of the scheduled and pending data integrations. After the data ingestion is complete, you can clean or transform your data in the Tables menu.

Advanced Options

Clicking Show next to Advanced will expand the Data Sources - Facebook Pages window to include Destination, Primary Key, Exclude, Parse string, and Truncate table.

Data Schema

Panoply ingests the following data elements for Facebook Pages content. Additional detail is available in the Facebook Graph API Reference documentation.

Naming patterns:

  • The _unique suffix indicates that this metric shows the number of unique users who performed a specific action. Metrics generated with the _unique suffix are approximate and may not be 100% accurate.
  • The _login and _logout suffixes indicate whether someone was logged into or out of Facebook.
Column Description Values for period
page_views The number of times a Page has been viewed by logged in and logged out people. day, week, days_28
page_views_unique The number of people logged in and logged out of Facebook who have viewed the Page. day, week, days_28
page_views_login The number of times a Page has been viewed by people logged in to Facebook. day, week, days_28
page_views_login_unique The number of people logged in to Facebook who have viewed the Page. day, week, days_28
page_views_logout The number of times a Page has been viewed by people not logged in to Facebook. day
page_impressions The number of times any content from your Page or about your Page entered a person’s screen. This includes posts, check-ins, ads, social information from people who interact with your Page and more. day, week, days_28
page_impressions_unique The number of people who had any content from your Page or about your Page enter their screen. This includes posts, check-ins, ads, social information from people who interact with your Page and more. day, week, days_28
page_impressions_paid The number of times any content from your Page or about your Page entered a person’s screen through paid distribution such as an ad. day, week, days_28
page_impressions_paid_unique The number of people who had any content from your Page or about your Page enter their screen through paid distribution such as an ad. day, week, days_28
page_impressions_organic The number of times any content from your Page or about your Page entered a person’s screen through unpaid distribution. This includes posts, check-ins, social information from people who interact with your Page and more. day, week, days_28
page_impressions_organic_unique The number of people who had any content from your Page or about your Page enter their screen through unpaid distribution. This includes posts, check-ins, social information from people who interact with your Page and more. day, week, days_28
page_impressions_viral The number of times any content from your Page or about your Page entered a person’s screen with social information attached. Social information displays when a person’s friend interacted with you Page or post. This includes when someone’s friend likes or follows your Page, engages with a post, shares a photo of your Page and checks into your Page. day, week, days_28
page_impressions_viral_unique The number of people who had any content from your Page or about your Page enter their screen through with social information attached. As a form of organic distribution, social information displays when a person’s friend interacted with you Page or post. This includes when someone’s friend likes or follows your Page, engages with a post, shares a photo of your Page and checks into your Page. day, week, days_28
page_posts_impressions The number of times your Page’s posts entered a person’s screen. Posts include statuses, photos, links, videos and more. day, week, days_28
page_posts_impressions_unique The number of people who had any of your Page’s posts enter their screen. Posts include statuses, photos, links, videos and more. day, week, days_28
page_posts_impressions_paid The number of times your Page’s posts entered a person’s screen through paid distribution such as an ad. day, week, days_28
page_posts_impressions_paid_unique The number of people who had any of your Page’s posts enter their screen through paid distribution such as an ad. day, week, days_28
page_posts_impressions_organic The number of times your Page’s posts entered a person’s screen through unpaid distribution. day, week, days_28
page_posts_impressions_organic_unique The number of people who had any of your Page’s posts enter their screen through unpaid distribution. day, week, days_28
page_posts_impressions_viral The number of times your Page’s posts entered a person’s screen with social information attached. Social information displays when a person’s friend interacted with you Page or post. This includes when someone’s friend likes or follows your Page, engages with a post, shares a photo of your Page and checks into your Page. day, week, days_28
page_posts_impressions_viral_unique The number of people who had any of your Page’s posts enter their screen with social information attached. As a form of organic distribution, social information displays when a person’s friend interacted with you Page or post. This includes when someone’s friend likes or follows your Page, engages with a post, shares a photo of your Page and checks into your Page. day, week, days_28
page_engaged_users The number of people who engaged with your Page. Engagement includes any click. day, week, days_28
page_consumptions The number of times people clicked on any of your content. day, week, days_28
page_consumptions_unique The number of people who clicked on any of your content. day, week, days_28
page_places_checkin_total The number of times people checked into a place. day, week, days_28
page_places_checkin_total_unique The number of people who checked into a place. day, week, days_28
page_places_checkin_mobile The number of times people checked into a place using mobile phones. day, week, days_28
page_places_checkin_mobile_unique The number of people who checked into a place using mobile phones. day, week, days_28
page_negative_feedback The number of times people took a negative action (e.g., un-liked or hid a post). day, week, days_28
page_negative_feedback_unique The number of people who took a negative action (e.g., un-liked or hid a post). day, week, days_28
page_fan_adds The number of new people who have liked your Page. day
page_fan_adds_unique The number of new people who have liked your Page. day, week, days_28
page_fan_removes Unlikes of your Page. day
page_fan_removes_unique Unlikes of your Page. day
page_video_views The number of times your Page’s videos played for at least 3 seconds, or for nearly their total length if they’re shorter than 3 seconds. During a single instance of a video playing, we’ll exclude any time spent replaying the video. day, week, days_28
page_video_views_paid The number of times your Page’s promoted videos played for at least 3 seconds, or for nearly their total length if they’re shorter than 3 seconds. For each impression of a video, we’ll count video views separately and exclude any time spent replaying the video. day, week, days_28
page_video_views_organic The number of times your Page’s videos played for at least 3 seconds, or for nearly their total length if they’re shorter than 3 seconds, by organic reach. During a single instance of a video playing, we’ll exclude any time spent replaying the video. day, week, days_28
page_video_views_autoplayed The number of times your Page’s videos automatically played for at least 3 seconds, or for nearly their total length if they’re shorter than 3 seconds. During a single instance of a video playing, we’ll exclude any time spent replaying the video. day, week, days_28
page_video_views_click_to_play The number of times your Page’s videos played for at least 3 seconds, or for nearly their total length if they’re shorter than 3 seconds, after people clicked play. During a single instance of a video playing, we’ll exclude any time spent replaying the video. day, week, days_28
page_video_views_unique The number of people who viewed your Page’s videos for at least 3 seconds, or for nearly their total length if they’re shorter than 3 seconds. During a single instance of a video playing, we’ll exclude any time spent replaying the video. day, week, days_28
page_video_repeat_views The number of times your Page’s videos were replayed for at least 3 seconds, or for nearly their total length if they’re shorter than 3 seconds. day, week, days_28
page_video_complete_views_30s The number of times your Page’s videos played for at least 30 seconds, or for nearly their total length if they’re shorter than 30 seconds. During a single instance of a video playing, we’ll exclude any time spent replaying the video. day, week, days_28
page_video_complete_views_30s_paid The number of times your Page’s promoted videos played for at least 30 seconds, or for nearly their total length if they’re shorter than 30 seconds. For each impression of a video, we’ll count video views separately and exclude any time spent replaying the video. day, week, days_28
page_video_complete_views_30s_organic The number of times your Page’s videos played for at least 30 seconds, or for nearly their total length if they’re shorter than 30 seconds, by organic reach. During a single instance of a video playing, we’ll exclude any time spent replaying the video. day, week, days_28
page_video_complete_views_30s_autoplayed The number of times your Page’s automatically played videos played for at least 30 seconds, or for nearly their total length if they’re shorter than 30 seconds. During a single instance of a video playing, we’ll exclude any time spent replaying the video. day, week, days_28
page_video_complete_views_30s_click_to_play The number of times your Page’s videos played for at least 30 seconds, or for nearly their total length if they’re shorter than 30 seconds, after people clicked play. During a single instance of a video playing, we’ll exclude any time spent replaying the video. day, week, days_28
page_video_complete_views_30s_unique The number of people who viewed your Page’s videos for at least 30 seconds, or for nearly their total length if they’re shorter than 30 seconds. During a single instance of a video playing, we’ll exclude any time spent replaying the video. day, week, days_28
page_video_complete_views_30s_repeat_views The number of times your Page’s videos replayed for at least 30 seconds, or for nearly their total length if they’re shorter than 30 seconds. day, week, days_28