Facebook Adapter Examples

fb_search

Used to search for a Facebook ID for a page or user.

fb_search_places

Used to search for places containing a specified query string.

likes_o

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

page_insights_o

Used to retrieve specific statistics about a particular Facebook page.

page_o

Used to retrieve information about a Facebook page.

page_picture_o

Used to retrieve a picture for a Facebook page or user.

posts_comments_o

Used to retrieve Posts and Comments for a Facebook page.

profile_o

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

replies_o

Used to retrieve replies for comments.

user_friends_o

Used to retrieve friends for a Facebook user.

user_o

Used to retrieve information about a user.

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/page_insights_cluster

Cluster Join used for reporting page and page statistics.

Joins:

page_o to page_insights_o

page_picture_cluster_o

Cluster Join used for reporting page and page picture statistics.

Joins:

page_o to page_picture_o

fbsampl/page_posts_comments_o

Cluster Join used for reporting page posts and comments.

Joins:

page_o to posts_comments_o

fbsampl/posts_comments_replies_o

Cluster Join used for reporting page, posts, comments, and replies.

Joins:

• page_o to posts_comments_o
• posts_comments_o to replies_o

fbsampl/ user_friends_picture_cluster_o

Cluster Join for reporting user information, number of friends, and user picture.

Joins:

• user_o to user_friends_o
• user_o to page_picture_o

fbsampl/ user_picture_cluster_o

Cluster Join for reporting user information and user picture.

Joins:

user_o to page_picture_o

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 or user.

Uses fb_search.

fbsampl/fb_search_places

Search for places containing a specified query string.

Uses:

fb_search_places

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/page_insights_o

Reports metrics for a specific page.

Uses:

fbsampl/page_insights_cluster_o

page_o

Reports page information for a specific page.

Uses:

fbsampl/page_picture_cluster_o

fbsampl/page_posts_comments_o

Reports Facebook page posts and related comments.

Uses:

fbsampl/page_posts_comments_o

fbsampl/page_posts_comments_replies_o

Reports Facebook page posts and related comments including replies.

Uses:

fbsampl/page_posts_comments_replies_o

fbsampl/page_posts_likes_o

Reports users who liked particular posts.

Uses:

fbsampl/page_posts_comments_o and likes_o

fbsampl/profile_o

Reports the type for an Object ID (Page or User).

Uses:

profile_o

fbsampl/user_o

Reports user information for a Facebook user.

Uses:

fbsampl/user_friends_picture_cluster_o

fbsampl/fb_datamigrator_load

Process flow to run the following data flows:

• fbsampl/fb_load_page
• fbsampl/fb_load_posts
• fbsampl/fb_load_comments_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_replies

Data flow to load Facebook comments and replies.

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_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.