The Sisense Facebook connector is a standalone connector that allows you to import data from various Facebook APIs into the ElastiCube Manager. After you have downloaded and installed the connector, you can connect to Facebook through a connection string you provide Sisense in the ElastiCube Manager. The connection string is used to authenticate users who connect to Facebook’s APIs. To obtain a connection string, you will need to create a Facebook developers account.

Once you have connected to Facebook, you can import a variety of tables from multiple Facebook APIs.

This page describes how to install the Facebook connector, how to connect to Facebook with a connection string, and what tables you can import into the ElastiCube Manager:

Installing the Facebook Connector

Sisense provides the Facebook connector as a standalone connector that you can download and add to your list of default Sisense connectors.

To install the Facebook connector:

  1. Download the Facebook installation file.
  2. Open the installation file and click Install.
  3. After the installation process is complete, click Close.

The Facebook connector is displayed in the ElastiCube Manager under Add Data > Web Services.

facebook1

Connecting to the Facebook REST API

To access Facebook’s REST API from Sisense, you must provide Sisense with valid Oauth Facebook credentials in a connection string. These credentials are provided by Facebook when you create an application.

Creating an App

To obtain the OAuth client credentials, follow the steps below:

  1. Log into Facebook and navigate to https://developers.facebook.com/apps.
  2. Click + Add a New App.
  3. Define your app’s name and click Create App ID. The Product Setup page is displayed.
  4. In the Product Setup page, click Settings.
    fbsettings
  5. In the Settings page, the OAuth client credentials, App Id and App Secret, are displayed.
    fbsettings1
  6. In the App Domains field, enter localhost.
  7. In the Settings page, click + Add Platform and select Website. The Website area is added to the Settings page.
  8. In the Site URL field, enter http://localhost. This value is represents the callback URL in your connection string where the user will return with the token that verifies that they have granted your app access.
    fbsettings2
  9. In the bottom-right corner of the Settings page, click Save Changes. Facebook requests that you authenticate your account.
  10. Enter your password to authenticate your account and click OK. Your app is saved.

Authenticating through Facebook

After setting the following connection properties, you are ready to connect:

  • OAuthClientId: Set this to the App ID in your app settings.
  • OAuthClientSecret: Set this to the App Secret in your app settings.
  • CallbackURL: Set this to the Return URL in your app settings.
  • InitiateOAuth: Set this to GETANDREFRESH. You can use InitiateOAuth to avoid repeating the OAuth exchange and manually setting the OAuthAccessToken connection property.

Note: When switching accounts, you must sign out of your account and then sign it with the new account.

When you connect the Sisense connector completes the OAuth process:

  1. Extracts the access token from the CallbackURL and authenticates requests.
  2. Refreshes the access token when it expires.
  3. Saves OAuth values in OAuthSettingsLocation to be persisted across connections.

Adding Facebook Tables to your ElastiCube

Sisense uses connection strings to connect to Facebook and import data into the ElastiCube Manager.

The connection string to connect to Facebook has the following structure:

jdbc:Facebook:Property1=Value1;Property2=Value2;

Mandatory properties are OAuthClientId, OAuthClientSecret, and InitiateOAuth.

  • OAuthSettingsLocation: The location of the settings file where OAuth values are saved for each user when InitiateOAuth is set to GETANDREFRESH. Sisense generates this file automatically after you connect to Facebook successfully. See Switching between Accounts for more information.
  • OAuthClientId: Set this to the App ID in your app settings.
  • OAuthClientSecret: Set this to the App Secret in your app settings.
  • InitiateOAuth: Set this to GETANDREFRESH. You can use InitiateOAuth to avoid repeating the OAuth exchange and manually setting the OAuthAccessToken connection property.

In addition, the following are parameters for connection strings to overcome rate limitations:

ThrottleSeconds: Indicates how many seconds to wait until sending another insight request when the ThrottleMaxPercent has been met.
ThrottleMaxPercent: The threshold set for throttling further insight requests. The defaults for ThrottleSeconds and ThrottleMaxPercent are 10 and 95.
RetryWaitTime: The amount of time in milliseconds to wait before retrying to query the Facebook API.
MaximumRequestRetries: The maximum amount of request retries.

Example:

ThrottleSeconds=15;ThrottleMaxPercent=90;Other=RetryWaitTime=60000;MaximumRequestRetries=5;

For a list of all the possible connection string options, click here.

An example of a connection string:

jdbc:facebook:OAuthClientId=11276856774486;OAuthClientSecret
=064c70d78567jm2b7e7e4224fad;InitiateOAuth=GETANDREFRESH;Version=2.8;CallbackURL=http://localhost/;

To add Facebook data:

  1. In ElastiCube Manager, click Add Data and then, Facebook. The Connect to Facebook window is displayed.
    facebook2
  2. In Datasource Connection String, enter your connection string.
  3. Click Connect to Server. Facebook is displayed in the Select Database list.
  4. Click OK. Sisense connects to Facebook and displays a list of tables available for you to import. For a list of tables you can import, see Facebook Tables.
  5. Select the relevant tables and click Add. The tables are displayed in the ElastiCube Manager.

Switching between Accounts

When you connect to the Facebook data source, Sisense saves your OAuth values in the file OAuthsettings.txt file located at …\Users\xxx\AppData\Roaming\CData\Facebook Data Provider on your Sisense server. To connect to the Facebook data source with another user on the same machine, you must delete the OAuthsettings.txt file. Sisense will then generate a new file for that user.

Another option to support multiple users is to define the location and file name of an OAuthsettings file for each unique user in your connection string through the OAuthSettingsLocation parameter. When each user connects to the data source, Sisense generates the OAuth file with the file name you specify in the location you define. In the examples below, two users are allowed to access the Facebook data source and for each user, Sisense generates a file that contains that user’s OAuth values in the location defined in the string.

jdbc:facebook:OAuthSettingsLocation=C:\facebook\auth\john.txt;OAuthClientId=11276856774486;OAuthClientSecret
=064c70d78567jm2b7e7e4224fad;InitiateOAuth=GETANDREFRESH;Version=2.8;CallbackURL=http://localhost/;

jdbc:facebook:OAuthSettingsLocation=C:\facebook\auth\sally.txt;OAuthClientId=11276856774486;OAuthClientSecret
=064c70d78567jm2b7e7e4224fad;InitiateOAuth=GETANDREFRESH;Version=2.8;CallbackURL=http://localhost/;

In the example above, to OAuth files are created, one for John and one for Sally in the location C:\facebook\auth\.

This is useful if you support many users who each need to access the Facebook data source.

Connection String Options

The following is the full list of the options you can configure in the connection string for this provider:

Aggregate Format: The format aggregate or collection columns should return in.
Authenticate As Page: The name or Id of a page to authenticate as when making requests to Facebook.
Auto Cache: The AutoCache property controls automatic caching of data.
Cache Connection: The connection string for the cache database.
Cache Driver: The database driver to be used to cache data.
Cache Location: Specifies the path to the cache when caching to a file.
Cache Metadata: Whether or not to cache the table metadata. The cache will be stored in memory unless CacheConnection or CacheLocation are set.
Callback URL: The OAuth callback URL to return to when authenticating. This value must match the callback URL you specify in your app settings.
Firewall Password: A password, if authentication is required to connect through a firewall.
Firewall Port: The TCP port for the firewall FirewallServer — see the description of the FirewallServer option for details.
Firewall Server: Specify a firewall name or IP address to authenticate requested connections, if necessary.
Firewall Type: The type of firewall to connect through.
Firewall User: The user name to authenticate with the firewall.
Initiate OAuth: Set this property to initiate the process to obtain or refresh the OAuth access token when you connect.
Location: A path to the directory that contains the schema files defining tables, views, and stored procedures.
Logfile: A path to the log file.
Max Log File Size: A string specifying the maximum size in bytes for a log file (ex: 10MB). When the limit is hit, a new log is created in the same folder with the date and time appended to the end.
OAuth Access Token: The access token for connecting using OAuth.
OAuth Client Id: The client Id assigned when you register your application with an OAuth authorization server.
OAuth Client Secret: The client secret assigned when you register your application with an OAuth authorization server.
OAuth Settings Location: The location of the settings file where OAuth values are saved when InitiateOAuth is set to GETANDREFRESH or REFRESH.
Offline:Use offline mode to get the data from the cache instead of the live source.
Other: The other parameters necessary to connect to a data source, such as username and password, when applicable.
Pagesize: The maximum number of results to return per page from Facebook.
Proxy Auth: Scheme The proxy server authorization scheme (default: BASIC).
Proxy Auto Detect: This indicates whether to use the default system proxy settings or not. Set ProxyAutoDetect to FALSE to use custom proxy settings. This takes precedence over other proxy settings.
Proxy Password:A password, if authenticating with a proxy server.
Proxy Port: The TCP port for the proxy ProxyServer (default: 80).
Proxy Server: If a proxy server is given, then the HTTP request is sent to the proxy instead of the specified server.
Proxy SSL Type: The SSL type to use when connecting to the proxy server (default: AUTO).
Proxy User: A user name, if authentication is to be used for the proxy.
Pseudo Columns: Indicates whether or not to include pseudo columns as columns to the table.
Query Cache: The time duration, in seconds, for which the in-memory cached data is reused.
Readonly: You can use this property to enforce read-only access to Facebook from the provider.
RTK: The runtime key used for licensing.
Search Terms: Default SearchTerms if none are specified. Used for some tables, such as Users, where SearchTerms may be specified.
SSL Server Cert: The certificate to be accepted from the server when connecting using TLS/SSL.
Support Enhanced SQL: If set to true, the provider will cache the entire table in memory and issue the current query against the memory cache. Allows queries with aggregate functions that are otherwise unsupported. The entire memory cache is discarded after the query is executed, unlike QueryCache.
Tables: Comma-separated list of tables to be listed. For example: Tables=TableA,TableB,TableC.
Target: A default target if none is specified. Used for some tables, such as Comments, where a target may be specified.
Timeout:The value in seconds until the timeout error is thrown, canceling the operation.
Verbosity: The verbosity level that determines the amount of detail included in the log file.
Version: The Facebook Graph API version to use.

Facebook Tables

The table below describes the tables you can import from various Facebook APIs. Facebook limits the number of calls and the amount of data that you can retrieve from their APIs. These limitations depend on which Facebook API you are using and your account type. When you reach a limit, Sisense returns the error provided by Facebook. For example, if you receive any of the following error codes, this usually indicates that you have reached one of Facebook’s limitations:

  • error code = 4, CodedException
  • error code = 32, CodedException
  • error code = 17,  User request limit reached

If you encounter one of these errors, refer to the Facebook API that exposed the table for more details regarding that API’s limitations.

Note: Some Facebook tables require custom SQL, the table below provides examples of custom SQL statements you can use to access the relevant table.

Available Tables

NameDescription
CommentsQuery the Comments for a Target. Comments may also be inserted based on a Target or deleted based on Id.

When querying comments, either the Target or the Id of the comment must be specified. For example, to retrieve all the comments about a specific post, your SELECT statement could look something like this:

SELECT * FROM Comments WHERE Target = '15526475270_410830705612736'

Alternatively, you can specify the Id to retrieve a specific comment. For example: SELECT * FROM Comments WHERE Id = '15526475270_410830705612736_5193593'
LikesQuery the Likes for a Target. Alternatively, lists Pages that the specified User or Page Likes. Authentication is required to use this table.
MilestonesQuery a list of Milestones for the given Page. Milestones may only be inserted, updated, or deleted when authenticating as the target Page. Unless you are using the option Authenticate As Page, you need to supply a Target when retrieving milestones. For instance:

SELECT * FROM Milestones WHERE Target='facebook'
PostsQuery the Posts for a Target based on either the Target or Id. Posts can also be inserted based on a Target, or deleted based on Id. This table requires authentication.
UsersQuery Users by SearchTerms or Id.

 

Available Views

NameDescription
AdAccountsQuery the Ad Accounts available for a User. Accessing Ad Account information requires the ads_read permission.
AdCreativesQuery information about an Ad Creative or the Ad Creatives on a specific Ad Account, Ad Set, or Ad. Accessing Ad Creative information requires the ads_read permission.
AdInsightsQuery an Ad Report. Accessing Ad Report information requires the ads_read permission.

When requesting AdInsights, a Target must be specified. This indicates what element to retrieve the insights from. It can be an AdAccount, Campaign, AdSet, or an Ad. For example:

view source SELECT * FROM AdInsights WHERE Target = 'act_123456'

A date range can be specified using DateStart and DateEnd, or DatePreset must also be specified. For example:

view source SELECT DateStart, DateEnd, AdAccountId, Spend, Impressions FROM AdInsights WHERE Target = 'act_123456' AND DateStart >= '01/01/2015' AND DateEnd <= '03/31/2015'

view source SELECT DateStart, DateEnd, AdAccountId, Spend, Impressions FROM AdInsights WHERE Target = 'act_123456' AND DatePreset='last_90_days'

The available values for DatePreset are:

  • today
  • yesterday
  • this_week
  • last_week
  • last_7_days
  • last_14_days
  • last_28_days
  • last_30_days
  • last_90_days
  • this_month
  • last_month
  • this_quarter
  • last_3_months


The TimeIncrement can used to specify how many days should be included in each report row. For instance:

view source SELECT DateStart, DateEnd, AdAccountId, Age, Spend, Impressions FROM AdInsights WHERE Target = 'act_123456' AND DatePreset='last_90_days' AND TimeIncrement='7' view source SELECT DateStart, DateEnd, AdAccountId, Age, Spend, Impressions FROM AdInsights WHERE Target = 'act_123456' AND DatePreset='last_90_days' AND TimeIncrement='monthly'

The Level column can be used to specify what level insights are retrieved at. This can be set to ad,adset,campaign, or account. For example: view source SELECT DateStart, DateEnd, AdAccountId, Age, Spend, Impressions FROM AdInsights WHERE Target = 'act_123456' AND Level='campaign'
AdInsightsActionsQuery an Ad Report. Accessing Ad Report information requires the ads_read permission.

AdInsightsActions represents a breakdown of the Actions column from the AdInsights. See AdInsights for general information on querying AdInsights.

When requesting AdInsightsActions, a Target must be specified. This indicates what element to retrieve the insights from. It can be an AdAccount, Campaign, AdSet, or an Ad. For instance:

SELECT * FROM AdInsights WHERE Target = 'act_123456'

In comparison to all of the available selection criteria from AdInsights, only the breakdowns listed below are available. Other than that, ActionAttributionWindows is available to input a comma separated list of attribution windows. For instance:

SELECT * FROM AdInsightsActions WHERE Target='act_123456' AND level='ad' AND ActionAttributionWindows='1d_view,7d_view,28d_click'

Columns

Age:  The age range for the metrics in this row. This is a breakdown column and selecting this column will cause results to be further broken down by this metric.
Country: The country for the metrics in this row. This is a breakdown column and selecting this column will cause results to be further broken down by this metric.
FrequencyValue:  The number of times an ad in your Reach and Frequency campaign was served to each person. This is a breakdown column and selecting this column will cause results to be further broken down by this metric.
Gender:  The gender for the metrics in this row. This is a breakdown column and selecting this column will cause results to be further broken down by this metric.
HStatsByAdvertiserTZ: Time period over which the stats were taken for the advertiser. This is a breakdown column and selecting this column will cause results to be further broken down by this metric.
HStatsByAudienceTZ: Time period over which the stats were taken for the audience. This is a breakdown column and selecting this column will cause results to be further broken down by this metric.
ImpressionDevice: The devices used to view the Ad. This is a breakdown column and selecting this column will cause results to be further broken down by this metric.
Placement: The placement of the Ad on the screen. This is a breakdown column and selecting this column will cause results to be further broken down by this metric.
PlatformPosition: The position on the platform.
ProductId: The product Id advertised in the Ad. This is a breakdown column and selecting this column will cause results to be further broken down by this metric.
PublisherPlatform: The platforms the ads were published on.
Region: The region someone viewed the Ad from. This is a breakdown column and selecting this column will cause results to be further broken down by this metric.
AdsQuery information about an Ad or the Ads in a specific Ad Set, Campaign, or Ad Account. Accessing Ad Information requires the ads_read permission.
AdScheduledReportsQuery the Scheduled Reports for a given Ad Account. Accessing Scheduled Report information requires the ads_read permission.
AdSetsQuery information about an Ad Set or the Ad Sets on a specific Campaign or Ad Account. Accessing Ad Set information requires the ads_read permission.
AlbumsQuery Albums associated with a Target. Accessing Album information typically requires the user_photos permission.
ApplicationsQuery the Application specified by the Id.
BooksQuery the Books a User is interested in. Accessing Book information typically requires the user_books permissions.
CampaignsQuery information about a Campaign or the Campaigns on a specific Ad Account. Accessing Campaign information requires the ads_read permission.

For example:

SELECT * FROM Campaigns WHERE Target = 'act_123456'
EventsQuery the Events for a Target based on either the Target or SearchTerms. May require the user_events permission.
FriendsQuery Friends of the authenticated User or Target User. Requires the user_friends permission. A Target may be specified to request Friend information for, but Friends may only be retrieved for the authenticated User or Friends of the authenticated User that use the same Facebook app.
GamesQuery the Games a User is interested in. Accessing Game information may require the user_likes and user_interests permissions.
GroupsQuery the Groups based on the supplied SearchTerms, Id, or Target. Groups may require the user_groups permission.
InsightsByConsumptionTypeAllows retrieval of insights by consumption type.

SELECT *
FROM InsightsByConsumptionType
where target ='xxxxxxx' and InsightName = 'PAGE_CONSUMPTIONS_BY_CONSUMPTION_TYPE' and Period = 'day'


The following are values for the parameters InsightName:

PAGE_CONSUMPTIONS_BY_CONSUMPTION_TYPE
PAGE_CONSUMPTIONS_BY_CONSUMPTION_TYPE_UNIQUE
InsightsByFeedbackTypeAllows retrieval of insights by feedback type.

SELECT *
FROM InsightsByFeedbackType
where target ='xxxxxxx' and InsightName = 'PAGE_NEGATIVE_FEEDBACK_BY_TYPE' and Period = 'day'

The following are values for the parameters InsightName:

PAGE_NEGATIVE_FEEDBACK_BY_TYPE
PAGE_NEGATIVE_FEEDBACK_BY_TYPE_UNIQUE
PAGE_POSITIVE_FEEDBACK_BY_TYPE
PAGE_POSITIVE_FEEDBACK_BY_TYPE_UNIQUE
POST_NEGATIVE_FEEDBACK_BY_TYPE
POST_NEGATIVE_FEEDBACK_BY_TYPE_UNIQUE
InsightsByLikeSourceTypeAllows retrieval of insights by like source type.

The following are values for the parameters InsightName:

PAGE_FANS_BY_LIKE_SOURCE
PAGE_FANS_BY_LIKE_SOURCE_UNIQUE
PAGE_FANS_BY_UNLIKE_SOURCE_UNIQUE
InsightsByPaidStatusAllows retrieval of insights by paid status.

The following are values for the parameters InsightName:

PAGE_IMPRESSIONS_BY_PAID_NON_PAID
PAGE_IMPRESSIONS_BY_PAID_NON_PAID_UNIQUE
POST_IMPRESSIONS_BY_PAID_NON_PAID
POST_IMPRESSIONS_BY_PAID_NON_PAID_UNIQUE
PAGE_POSTS_IMPRESSIONS_BY_PAID_NON_PAID
PAGE_POSTS_IMPRESSIONS_BY_PAID_NON_PAID_UNIQUE
InsightsByTabTypeAllows retrieval of insights by tab type

The following are values for the parameters InsightName:

PAGE_TAB_VIEWS_LOGIN_TOP_UNIQUE
PAGE_TAB_VIEWS_LOGIN_TOP
PAGE_TAB_VIEWS_LOGOUT_TOP
LeadValuesQuery information about a lead. Accessing Lead Information requires the ads_read permission.
MusicQuery the Music a User is interested in. Accessing Music requires the user_likes and user_interests permissions.
PagesQuery the Pages based on the supplied SearchTerms or Id.
PermissionsQuery the Permissions the User has granted the current application.
PhotosQuery Photos associated with a Target. Accessing Photo information typically requires the user_photos permission.
PlacesQuery the Places based on the supplied SearchTerms or Id. Places are stored as Pages in Facebook.
ScheduledReportRunsQuery a list of the recently completed runs of a given Scheduled Report. Accessing Scheduled Report information requires the ads_read permission.
SimpleInsightsAllows the retrieval of simple insights with a single value in the response.

The following are values for the parameters InsightName:

PAGE_STORIES
POST_STORIES
POST_STORYTELLERS
PAGE_IMPRESSIONS
PAGE_IMPRESSIONS_UNIQUE
PAGE_IMPRESSIONS_PAID
PAGE_IMPRESSIONS_PAID_UNIQUE
PAGE_IMPRESSIONS_ORGANIC
PAGE_IMPRESSIONS_ORGANIC_UNIQUE
PAGE_IMPRESSIONS_VIRAL
PAGE_IMPRESSIONS_VIRAL_UNIQUE
PAGE_IMPRESSIONS_FREQUENCY_DISTRIBUTION
PAGE_IMPRESSIONS_VIRAL_FREQUENCY_DISTRIBUTION
PAGE_ENGAGED_USERS
PAGE_CONSUMPTIONS
PAGE_CONSUMPTIONS_UNIQUE
PAGE_PLACES_CHECKIN_TOTAL
PAGE_PLACES_CHECKIN_TOTAL_UNIQUE
PAGE_PLACES_CHECKIN_MOBILE
PAGE_PLACES_CHECKIN_MOBILE_UNIQUE
PAGE_NEGATIVE_FEEDBACK
PAGE_NEGATIVE_FEEDBACK_UNIQUE
PAGE_FANS_ONLINE
PAGE_FANS_ONLINE_PER_DAY
PAGE_FANS
PAGE_FAN_ADDS
PAGE_FAN_ADDS_UNIQUE
PAGE_FAN_REMOVES
PAGE_FAN_REMOVES_UNIQUE
PAGE_VIEWS
PAGE_VIEWS_UNIQUE
PAGE_VIEWS_LOGIN
PAGE_VIEWS_LOGIN_UNIQUE
PAGE_VIEWS_LOGOUT
PAGE_VIDEO_VIEWS
PAGE_VIDEO_VIEWS_PAID
PAGE_VIDEO_VIEWS_ORGANIC
PAGE_VIDEO_VIEWS_AUTOPLAYED
PAGE_VIDEO_VIEWS_CLICK_TO_PLAY
PAGE_VIDEO_VIEWS_UNIQUE
PAGE_VIDEO_REPEAT_VIEWS
PAGE_VIDEO_COMPLETE_VIEWS_30S
PAGE_VIDEO_COMPLETE_VIEWS_30S_PAID
PAGE_VIDEO_COMPLETE_VIEWS_30S_ORGANIC
PAGE_VIDEO_COMPLETE_VIEWS_30S_AUTOPLAYED
PAGE_VIDEO_COMPLETE_VIEWS_30S_CLICK_TO_PLAY
PAGE_VIDEO_COMPLETE_VIEWS_30S_UNIQUE
PAGE_VIDEO_COMPLETE_VIEWS_30S_REPEAT_VIEWS
PAGE_POSTS_IMPRESSIONS
PAGE_POSTS_IMPRESSIONS_UNIQUE
PAGE_POSTS_IMPRESSIONS_PAID
PAGE_POSTS_IMPRESSIONS_PAID_UNIQUE
PAGE_POSTS_IMPRESSIONS_ORGANIC
PAGE_POSTS_IMPRESSIONS_ORGANIC_UNIQUE
PAGE_POSTS_IMPRESSIONS_VIRAL
PAGE_POSTS_IMPRESSIONS_VIRAL_UNIQUE
POST_IMPRESSIONS
POST_IMPRESSIONS_UNIQUE
POST_IMPRESSIONS_PAID
POST_IMPRESSIONS_PAID_UNIQUE
POST_IMPRESSIONS_FAN
POST_IMPRESSIONS_FAN_UNIQUE
POST_IMPRESSIONS_FAN_PAID
POST_IMPRESSIONS_FAN_PAID_UNIQUE
POST_IMPRESSIONS_ORGANIC
POST_IMPRESSIONS_ORGANIC_UNIQUE
POST_IMPRESSIONS_VIRAL
POST_IMPRESSIONS_VIRAL_UNIQUE
POST_CONSUMPTIONS
POST_CONSUMPTIONS_UNIQUE
POST_ENGAGED_USERS
POST_NEGATIVE_FEEDBACK
POST_NEGATIVE_FEEDBACK_UNIQUE
POST_VIDEO_AVG_TIME_WATCHED
POST_VIDEO_COMPLETE_VIEWS_ORGANIC
POST_VIDEO_COMPLETE_VIEWS_ORGANIC_UNIQUE
POST_VIDEO_COMPLETE_VIEWS_PAID
POST_VIDEO_COMPLETE_VIEWS_PAID_UNIQUE
POST_VIDEO_VIEWS_ORGANIC
POST_VIDEO_VIEWS_ORGANIC_UNIQUE
POST_VIDEO_VIEWS_PAID
POST_VIDEO_VIEWS_PAID_UNIQUE
TaggedByQuery information about Posts, Statuses, Photos, and other entities that have tagged the User or Page. This view is a derivative of the Wall connection where only entries that have tagged the Target User or Page will be returned. In general it is only available for Pages.
TelevisionQuery the TV shows a User is interested in. Accessing Television information may require the user_likes and user_interested permissions.
VideosQuery Videos from a Target. Normally requires the user_videos permission.
WallQuery Posts from the Wall of a Target.