Examples

This section describes the metadata and sample reports for the Facebook Adapter.

Reference: Facebook Adapter Metadata

The following table lists and describes the available metadata for the Facebook Adapter.

A metadata name with a "_o" suffix is used to retrieve an object of information from Facebook. This type of metadata should only be used as a secondary file in a JOIN.

A metadata name without a "_o" suffix is used to retrieve specific columns of information from Facebook.

Metadata

Description

application_o

Used to retrieve information about a Facebook application.

comment

Describes the Comment table. Used to retrieve specific information about a Facebook comment.

comment_o

Used to retrieve information about a Facebook comment.

fb_search

Used to search for a Facebook ID for an application, page, or user.

fb_search_posts

Used to search for all public posts containing a specified query string.

friend

Describes friend table. Used to retrieve the IDs for friends of a user.

insights

Describes the Insights table. Used to retrieve specific statistics about a particular Facebook application, page, or domain.

like

Describes the Like table. Used to retrieve the IDs of users who like a given video, post, comment, link, photo, or album.

likes_o

Used to retrieve the IDs and names of users who like a given video, post, comment, link, photo, or album.

page

Describes the Page table. Used to retrieve information about a Facebook page.

profile

Describes the Profile table. Used to retrieve the name, user name/page alias, and type for a Facebook object. For example, user, group, page, event, application.

statuses_o

Used to retrieve posts, comments, and likes for a Facebook application or page.

stream

Describes the Stream table. Used to retrieve Post information.

user

Describes the User table. Used to retrieve information about a user.

fbsampl/app_statuses

Cluster Join used for reporting application posts and comments.

Joins:

from application_o to statuses_o

fbsampl/fb_comment_sentiment

Describes a SQL Server table loaded by the fb_datamigrator_sentiment_load DataMigrator flow. The table contains sentiment scores for Facebook comments. Used when the WAND Sentiment Analysis Adapter is configured.

fbsampl/fb_comments

Describes a SQL Server table loaded by the fb_datamigrator_load DataMigrator flow. The table contains Facebook comments.

fbsampl/fb_comments_to_sentiment

Cluster Join from fb_comments to wandscore; wandscore metadata is created from the WAND Sentiment Analysis Adapter. Used by the fb_datamigrator_sentiment_load DataMigrator flow.

fbsampl/ fb_join_datamodel_excluding_sentiment

Cluster Join used for reporting post, posters, comments, commenters, replies, and repliers.

Joins:

fb_posts to fb_profile

fb_posts to fb_page_info

fb_posts to fb_comments

fb_comments to fb_profile

fb_comments to fb_replies

fb_replies to fb_profile

fbsampl/ fb_join_datamodel_including_sentiment

Cluster Join used for reporting post, posters, comments, commenters, replies, repliers, post sentiment score, comment sentiment score, and reply sentiment score.

Joins:

fb_posts to fb_profile

fb_posts to fb_page_info

fb_posts to fb_comments

fb_comments to fb_profile

fb_comments to fb_replies

fb_replies to fb_profile

fb_posts to fb_post_sentiment

fb_comments to fb_comment_sentiment

fb_replies to fb_comment_sentiment

Used when the WAND Sentiment Analysis Adapter is configured.

fbsampl/fb_page_info

Describes a SQL Server table loaded by the fb_datamigrator_load DataMigrator flow. The table contains Facebook page information.

fbsampl/fb_post_sentiment

Describes a SQL Server table loaded by the fb_datamigrator_sentiment_load DataMigrator flow. The table contains sentiment scores for Facebook posts. Used when the WAND Sentiment Analysis Adapter is configured.

fbsampl/fb_posts

Describes a SQL Server table loaded by the fb_datamigrator_load DataMigrator flow. The table contains Facebook posts.

fbsampl/fb_posts_to_sentiment

Cluster Join from fb_posts to wandscore; wandscore metadata is created from the WAND Sentiment Analysis Adapter. Used by the fb_datamigrator_sentiment_load DataMigrator flow.

fbsampl/fb_profile

Describes a SQL Server table loaded by the fb_datamigrator_load DataMigrator flow. The table contains name, user name/page alias, and type information for a Facebook object. For example, user, group, page, event, application.

fbsampl/fb_replies

Describes a SQL Server table loaded by the fb_datamigrator_load DataMigrator flow. The table contains Facebook replies.

fbsampl/fb_replies_to_sentiment

Cluster Join from fb_replies to wandscore; wandscore metadata is created from the WAND Sentiment Analysis Adapter. Used by the fb_datamigrator_sentiment_load DataMigrator flow.

fbsampl/fb_user

Describes a SQL Server table loaded by the fb_datamigrator_load DataMigrator flow. The table contains user information.

fbsampl/full_model

Cluster Join used for reporting page posts, comments, post and comment likes, and post and comment user information.

Joins:

page to stream

stream to comment

comment to like

like to user

comment to user

stream to like

stream to user

fbsampl/page_ids

Describes a FIX format file which contains the Facebook page IDs that are used to define which posts, comments, and replies of a Facebook page are to be loaded by the fb_datamigrator_load DataMigrator flow into the various SQL Server tables.

fbsampl/page_insights

Cluster Join used for reporting page and page statistics.

Joins:

page to insights

fbsampl/page_posts_comments

Cluster Join used for reporting page posts and comments.

Joins:

page to stream

stream to comment_o

fbsampl/ pageids_page_posts_comments

Cluster Join used by the fb_datamigrator_load DataMigrator flow.

Joins:

fbsampl/page_ids to fbsampl/page_posts_comments

fbsampl/posts_comments

Cluster Join used for reporting user posts and comments.

Joins:

stream to comment_o

Sample Report	Description
fbsampl/app_comments	Reports on posts and comments for a Facebook application. Uses: fbsampl/app_statuses
fbsampl/app_likes	Reports on likes for a Facebook application. Uses: fbsampl/app_statuses
fbsampl/fb_create_datamodel	Creates the SQL Server tables used for the Facebook data model loaded by the fb_datamigrator_load and fb_datamigrator_sentiment_load DataMigrator flows. As a prerequisite, a SQL Server connection called socialmedia must be configured as well as the creation of a SQL Server database called Facebook.
fbsampl/fb_delete_datamodel	Deletes the SQL Server tables used for the data model.
fbsampl/fb_page_drill	Page information drill report. Uses: fbsampl/fb_page_info
fbsampl/fb_page_posts_ comments_replies_report	Reports Facebook page posts with related comments and replies. Uses: fbsampl/fb_join_datamodel_excluding_sentiment
fbsampl/fb_page_posts_comments_ replies_scored_report	Reports Facebook page posts with related comments and replies including sentiment scoring. Uses: fbsampl/fb_join_datamodel_including_sentiment
fbsampl/fb_search	Search for the ID and name for a page, application, or user. Uses fb_search.
fbsampl/fb_search_posts	Search for all public posts containing a specified query string. Uses: fb_search_posts
fbsampl/fb_tagcloud_drill_excluding_ sentiment	Drill to posts, comments, and replies from the tag cloud. The Words Analysis adapter must be configured. Uses: fbsampl/fb_join_datamodel_excluding_sentiment
fbsampl/fb_tagcloud_drill_including_ sentiment	Drill to posts, comments, replies, and sentiment from the tag cloud. The Words Analysis adapter must be configured. Uses: fbsampl/fb_join_datamodel_including_sentiment
fbsampl/fb_tagcloud_drill_post_excluding_ sentiment	Reports on a specific post with related comments and replies. The Words Analysis adapter must be configured. Uses: fbsampl/fb_join_datamodel_excluding_sentiment
fbsampl/fb_tagcloud_drill_post_including_ sentiment	Reports on a specific post with related comments, replies, and sentiment. The Words Analysis adapter must be configured. Uses: fbsampl/fb_join_datamodel_including_sentiment
fbsampl/fb_tagcloud_posts_ comments_replies	Tag cloud graph for posts, comments, and replies. The Words Analysis adapter must be configured. Uses: fbsampl/fb_join_datamodel_excluding_sentiment wan_document (Words Analysis metadata)
fbsampl/fb_user_drill	User information drill report. Uses: fbsampl/fb_user
fbsampl/insights	Reports metrics for a specific page or application. Uses: insights
fbsampl/page_insights	Reports metrics for a specific page. Uses: fbsampl/page_insights
fbsampl/page_posts_comments	Reports Facebook page posts and related comments. Uses: fbsampl/page_posts_comments
fbsampl/page_posts_comments_replies	Reports Facebook page posts and related comments including replies. Uses: fbsampl/page_posts_comments and comment
fbsampl/posts_comments	Reports Facebook user posts and related comments. Uses: fbsampl/posts_comments

Flow	Description
fbsampl/fb_datamigrator_load	Process flow to run the following data flows: fbsampl/fb_load_page fbsampl/fb_load_posts fbsampl/fb_load_comments fbsampl/fb_load_replies fbsampl/fb_load_profile_posters fbsampl/fb_load_profile_commenters fbsampl/fb_load_profile_repliers fbsampl/fb_load_pages fbsampl/fb_load_users
fbsampl/ fb_datamigrator_sentiment_load	Process flow to run the following data flows: fbsampl/fb_load_post_sentiment fbsampl/fb_load_comment_sentiment fbsampl/fb_load_reply_sentiment
fbsampl/fb_load_comment_sentiment	Data flow to load sentiment scores for Facebook comments.
fbsampl/fb_load_comments	Data flow to load Facebook comments.
fbsampl/fb_load_page	Data flow to load Facebook page information for pages identified in the fbsampl/page_ids.ftm file.
fbsampl/fb_load_pages	Data flow to load Facebook page information for people that have either posted, commented, or replied from a Facebook page.
fbsampl/fb_load_post_sentiment	Data flow to load sentiment scores for Facebook posts.
fbsampl/fb_load_posts	Data flow to load Facebook posts.
fbsampl/fb_load_profile_commenters	Data flow to load Facebook user and page profile information for commenters. For example, ID, name, and commenter type (page/user).
fbsampl/fb_load_profile_posters	Data flow to load Facebook user and page profile information for posters. For example, ID, name, and poster type (page/user).
fbsampl/fb_load_profile_repliers	Data flow to load Facebook user and page profile information for repliers. For example, ID, name, and replier type (page/user).
fbsampl/fb_load_replies	Data flow to load Facebook replies.
fbsampl/fb_load_reply_sentiment	Data flow to load sentiment scores for Facebook replies.
fbsampl/fb_load_users	Data flow to load Facebook user information for people that have either posted, commented, or replied.

Metadata	Description
application_o	Used to retrieve information about a Facebook application.
comment	Describes the Comment table. Used to retrieve specific information about a Facebook comment.
comment_o	Used to retrieve information about a Facebook comment.
fb_search	Used to search for a Facebook ID for an application, page, or user.
fb_search_posts	Used to search for all public posts containing a specified query string.
friend	Describes friend table. Used to retrieve the IDs for friends of a user.
insights	Describes the Insights table. Used to retrieve specific statistics about a particular Facebook application, page, or domain.
like	Describes the Like table. Used to retrieve the IDs of users who like a given video, post, comment, link, photo, or album.
likes_o	Used to retrieve the IDs and names of users who like a given video, post, comment, link, photo, or album.
page	Describes the Page table. Used to retrieve information about a Facebook page.
profile	Describes the Profile table. Used to retrieve the name, user name/page alias, and type for a Facebook object. For example, user, group, page, event, application.
statuses_o	Used to retrieve posts, comments, and likes for a Facebook application or page.
stream	Describes the Stream table. Used to retrieve Post information.
user	Describes the User table. Used to retrieve information about a user.
fbsampl/app_statuses	Cluster Join used for reporting application posts and comments. Joins: from application_o to statuses_o
fbsampl/fb_comment_sentiment	Describes a SQL Server table loaded by the fb_datamigrator_sentiment_load DataMigrator flow. The table contains sentiment scores for Facebook comments. Used when the WAND Sentiment Analysis Adapter is configured.
fbsampl/fb_comments	Describes a SQL Server table loaded by the fb_datamigrator_load DataMigrator flow. The table contains Facebook comments.
fbsampl/fb_comments_to_sentiment	Cluster Join from fb_comments to wandscore; wandscore metadata is created from the WAND Sentiment Analysis Adapter. Used by the fb_datamigrator_sentiment_load DataMigrator flow.
fbsampl/ fb_join_datamodel_excluding_sentiment	Cluster Join used for reporting post, posters, comments, commenters, replies, and repliers. Joins: fb_posts to fb_profile fb_posts to fb_page_info fb_posts to fb_comments fb_comments to fb_profile fb_comments to fb_replies fb_replies to fb_profile
fbsampl/ fb_join_datamodel_including_sentiment	Cluster Join used for reporting post, posters, comments, commenters, replies, repliers, post sentiment score, comment sentiment score, and reply sentiment score. Joins: fb_posts to fb_profile fb_posts to fb_page_info fb_posts to fb_comments fb_comments to fb_profile fb_comments to fb_replies fb_replies to fb_profile fb_posts to fb_post_sentiment fb_comments to fb_comment_sentiment fb_replies to fb_comment_sentiment Used when the WAND Sentiment Analysis Adapter is configured.
fbsampl/fb_page_info	Describes a SQL Server table loaded by the fb_datamigrator_load DataMigrator flow. The table contains Facebook page information.
fbsampl/fb_post_sentiment	Describes a SQL Server table loaded by the fb_datamigrator_sentiment_load DataMigrator flow. The table contains sentiment scores for Facebook posts. Used when the WAND Sentiment Analysis Adapter is configured.
fbsampl/fb_posts	Describes a SQL Server table loaded by the fb_datamigrator_load DataMigrator flow. The table contains Facebook posts.
fbsampl/fb_posts_to_sentiment	Cluster Join from fb_posts to wandscore; wandscore metadata is created from the WAND Sentiment Analysis Adapter. Used by the fb_datamigrator_sentiment_load DataMigrator flow.
fbsampl/fb_profile	Describes a SQL Server table loaded by the fb_datamigrator_load DataMigrator flow. The table contains name, user name/page alias, and type information for a Facebook object. For example, user, group, page, event, application.
fbsampl/fb_replies	Describes a SQL Server table loaded by the fb_datamigrator_load DataMigrator flow. The table contains Facebook replies.
fbsampl/fb_replies_to_sentiment	Cluster Join from fb_replies to wandscore; wandscore metadata is created from the WAND Sentiment Analysis Adapter. Used by the fb_datamigrator_sentiment_load DataMigrator flow.
fbsampl/fb_user	Describes a SQL Server table loaded by the fb_datamigrator_load DataMigrator flow. The table contains user information.
fbsampl/full_model	Cluster Join used for reporting page posts, comments, post and comment likes, and post and comment user information. Joins: page to stream stream to comment comment to like like to user comment to user stream to like stream to user
fbsampl/page_ids	Describes a FIX format file which contains the Facebook page IDs that are used to define which posts, comments, and replies of a Facebook page are to be loaded by the fb_datamigrator_load DataMigrator flow into the various SQL Server tables.
fbsampl/page_insights	Cluster Join used for reporting page and page statistics. Joins: page to insights
fbsampl/page_posts_comments	Cluster Join used for reporting page posts and comments. Joins: page to stream stream to comment_o
fbsampl/ pageids_page_posts_comments	Cluster Join used by the fb_datamigrator_load DataMigrator flow. Joins: fbsampl/page_ids to fbsampl/page_posts_comments
fbsampl/posts_comments	Cluster Join used for reporting user posts and comments. Joins: stream to comment_o