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.

friend

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

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

Cluster Join used for reporting page posts and comments.

Joins:

page to stream

stream to comment_o

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_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/page_posts_comments	Reports Facebook page posts and related comments. Uses: fbsampl/page_posts_comments
fbsampl/posts_comments	Reports Facebook user posts and related comments. Uses: fbsampl/posts_comments

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.
friend	Describes friend table. Used to retrieve the IDs for friends of a user.
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/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_posts_comments	Cluster Join used for reporting page posts and comments. Joins: page to stream stream to comment_o
fbsampl/posts_comments	Cluster Join used for reporting user posts and comments. Joins: stream to comment_o