Facebook Posts

Facebook Posts

This document provides step-by-step instructions for integrating Facebook Posts data into Panoply. The following items will be covered:

Facebook Posts Data Integration

To integrate Facebook posts 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 Posts. Facebook Posts is listed under APIs.
  4. In the Data Sources – Facebook Posts screen, click Login With Facebook.
  5. A Facebook dialog box confirms whether you want to allow Panoply to use your account. Click Continue as {name}.
    Note: It will also ask whether you want to change your app usage settings. If you have platform apps disabled, you will have to enable them through this dialog in order for data ingestion to work. This setting should remain enabled until data ingestion is completed.
  6. Click Done.
  7. Another Facebook dialog asks what Facebook data Panoply can access. Make your selections and click Next.
  8. In the Data Sources – Facebook Posts screen, select which data to import.
  9. Select the date range for which you would like to collect data.
  10. (Optional) To customize the ingestion from your data source, review the advanced options.
  11. Click Collect.

The Data Sources – Facebook Posts window will go gray while the data integration is pending. A small green progress bar will appear below Facebook Posts once the integration has begun. A prompt will appear asking if you would like to set up the integration of another data source. Multiple data integrations can be set up 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 Posts window to include Destination, Primary Key, Exclude, Parse String and Truncate table

Destination - Default is facebook_posts_{__tablename}, where __tablename is the table name from the schema for this data source. See Data Schema for more detail about each table.

Primary Key - Default is {date}-{postId}. The primary key here determines which field(s) to use as the deduplication key when ingesting data.

Data Schema

The Facebook Posts data elements ingested by Panoply are listed below. Additional information is available in the Facebook Graph API reference documentation.

Facebook Posts - A set of data collected from the graph.facebook.com/v3.2/{post-id} API endpoint. For more information, see GET /v3.2/post-id HTTP/1.1 in the Facebook Post section of the Graph API documentation. This data will be divided into two tables in Panoply:

  • facebook_posts - Contains the post title and metadata on all of your posts
  • facebook_posts_lifetime - Contains the text/content of the posts themselves and additional metadata

Internal fields - In addition to the data schema details noted below, Panoply creates __updatetime and __senttime internal fields on all tables.

facebook_posts

As noted above, the default table in Panoply for this data is labeled facebook_posts and contains the following fields:

Column Data Type Description
id Text The post ID. Generated from date of posting
date Date Date post was __
created_time Date Date and time post was created
postid Text Facebook-generated unique identifier for the post in question
postname Text The title of the post

facebook_posts_lifetime

As noted above, the default table for this data is labeled by Panoply as facebook_posts_lifetime and contains the following fields:

Column Data Type Description
id Text ID string generated from the Facebook-assigned postid
date Date  
created_time Date Date and time post was originally created
postid Text Facebook-generated unique identifier for post
postname Text Content of post
post_video_length Number Length of video attached to post

Other possible data fields

In addition to the data fields described here, it is also possible to collect the following data types from the Facebook Posts API endpoint:

Column Data Type Description
actions Object Action links from post
admin_creator Object Name of admin creator of post
allowed_advertising_objects String Objectives under which this post can be advertised
application App The app used to publish the post
backdated_time Int The time to which the post was backdated, if applicable
call_to_action Object The type of call to action used in the post
can_reply_privately Boolean Boolean indicating whether page viewer can respond privately
caption String The caption associated with a shared link
child_attachments Object Sub-shares of a multi-link share post
description String A description of a link in the post
from Object Name and ID of profile that created post
full_picture String URL to full-sized version of photo associated with post
icon String Link to icon representing post
instagram_eligibility String Whether post can be promoted on Instagram
is_hidden Boolean Indicates whether post is hidden
is_instagram_eligible String Whether post can be promoted on Instagram
is_published Boolean Indicates whether scheduled post was published
link String Link attached to this post
message String Status message in post
feed_targeting Object Object that controls news feed targeting for this post
age_max Int Maximum age
age_min Int Minimum age of viewer (must be 13+)
message_tags String Array containing profiles tagged in post
name String Name of link
object_id String ID of any uploaded photo or video attached to post
parent_id String  
permalink_url String URL for permalink to post
picture String URL to resized version of photo associated with post
place Place Location information attached to post
privacy Object Privacy settings on post
promotable_id String ID of post to use for promotion
properties Object List of properties for any attached video (e.g., length)
shares Object Shares count of post. Share count may include deleted posts posts made invisible for privacy reasons
source String URL to any Flash movie or video file attached to the post
status_type enum Type of status
story String Deprecated
story_tags Array Deprecated, now replaced by message_tags
targeting Object Targeting information for post
to Profile[] Profiles mentioned/targeted in post
type enum Object type of post
updated_time Datetime Time when created/commented on/edited. Behavior depends on type of post
with_tags JSON Object Profiles tagged as being ‘with’ publisher of post

Note: Data types described here are sourced from Facebook documentation and may differ after Panoply ingestion.