SimpleInsights
Allows the retrieval of simple insights with a single value in the response.
Table Specific Information
Simple insights refers to simple insights that can be retrieved from a page or post. These kinds of insights have a single value in the response and can only be filtered by a few values.
Select
When selecting simple insights, a Target must be specified. In addition, an InsightName and Period should always be specified. For instance:
SELECT * FROM SimpleInsights WHERE Target = 'mypageid' AND InsightName = 'PAGE_IMPRESSIONS' AND Period = 'day'
Note that multiple insights may be specified via the IN operator. For example:
SELECT * FROM SimpleInsights WHERE Target = 'mypageid' AND InsightName IN ('PAGE_IMPRESSIONS', 'PAGE_ENGAGED_USERS') AND Period = 'day'
Additionally, StartTime and EndTime can be used to specify a range where insight data should be drawn from:
SELECT * FROM SimpleInsights WHERE Target = 'mypageid' AND InsightName = 'PAGE_IMPRESSIONS' AND Period = 'day' AND EndTime >= '12/1/2015' AND EndTime <= '12/31/2015'
Note: Please be aware that not all periods are available for all insights. Some will have day/week/days_28 available. Others may only have lifetime. It is best to check against Facebook to see what periods are and are not supported. They can be found here: https://developers.facebook.com/docs/graph-api/reference/insights
Columns
| Name | Type | Description |
| RowNumber [KEY] | Int | The row number of the result. |
| EndTime | Date | The most recent date this insight data is relevant for. |
| Value | Long | Insight column for a singular value response. |
| Target | String | The target of the insight. This must always be specified. |
| InsightName | String | The name of the insight. This must always be specified. The available values are: PAGE_ACTIONS_POST_REACTIONS_ANGER_TOTAL,PAGE_ACTIONS_POST_REACTIONS_HAHA_TOTAL,PAGE_ACTIONS_POST_REACTIONS_LIKE_TOTAL,PAGE_ACTIONS_POST_REACTIONS_LOVE_TOTAL,PAGE_ACTIONS_POST_REACTIONS_SORRY_TOTAL,PAGE_ACTIONS_POST_REACTIONS_WOW_TOTAL,PAGE_CONSUMPTIONS,PAGE_CONSUMPTIONS_UNIQUE,PAGE_ENGAGED_USERS,PAGE_FAN_ADDS,PAGE_FAN_ADDS_UNIQUE,PAGE_FAN_REMOVES,PAGE_FAN_REMOVES_UNIQUE,PAGE_FANS,PAGE_FANS_ONLINE,PAGE_FANS_ONLINE_PER_DAY,PAGE_IMPRESSIONS,PAGE_IMPRESSIONS_FREQUENCY_DISTRIBUTION,PAGE_IMPRESSIONS_ORGANIC,PAGE_IMPRESSIONS_ORGANIC_UNIQUE,PAGE_IMPRESSIONS_PAID,PAGE_IMPRESSIONS_PAID_UNIQUE,PAGE_IMPRESSIONS_UNIQUE,PAGE_IMPRESSIONS_VIRAL,PAGE_IMPRESSIONS_VIRAL_FREQUENCY_DISTRIBUTION,PAGE_IMPRESSIONS_VIRAL_UNIQUE,PAGE_IMPRESSIONS_NONVIRAL,PAGE_IMPRESSIONS_NONVIRAL_UNIQUE,PAGE_NEGATIVE_FEEDBACK,PAGE_NEGATIVE_FEEDBACK_UNIQUE,PAGE_PLACES_CHECKIN_MOBILE,PAGE_PLACES_CHECKIN_MOBILE_UNIQUE,PAGE_PLACES_CHECKIN_TOTAL,PAGE_PLACES_CHECKIN_TOTAL_UNIQUE,PAGE_POST_ENGAGEMENTS,PAGE_POSTS_IMPRESSIONS,PAGE_POSTS_IMPRESSIONS_ORGANIC,PAGE_POSTS_IMPRESSIONS_ORGANIC_UNIQUE,PAGE_POSTS_IMPRESSIONS_PAID,PAGE_POSTS_IMPRESSIONS_PAID_UNIQUE,PAGE_POSTS_IMPRESSIONS_UNIQUE,PAGE_POSTS_IMPRESSIONS_VIRAL,PAGE_POSTS_IMPRESSIONS_VIRAL_UNIQUE,PAGE_CONTENT_ACTIVITY,PAGE_VIDEO_COMPLETE_VIEWS_30S,PAGE_VIDEO_COMPLETE_VIEWS_30S_AUTOPLAYED,PAGE_VIDEO_COMPLETE_VIEWS_30S_CLICK_TO_PLAY,PAGE_VIDEO_COMPLETE_VIEWS_30S_ORGANIC,PAGE_VIDEO_COMPLETE_VIEWS_30S_PAID,PAGE_VIDEO_COMPLETE_VIEWS_30S_REPEAT_VIEWS,PAGE_VIDEO_COMPLETE_VIEWS_30S_UNIQUE,PAGE_VIDEO_REPEAT_VIEWS,PAGE_VIDEO_VIEWS,PAGE_VIDEO_VIEWS_AUTOPLAYED,PAGE_VIDEO_VIEWS_CLICK_TO_PLAY,PAGE_VIDEO_VIEWS_ORGANIC,PAGE_VIDEO_VIEWS_PAID,PAGE_VIDEO_VIEWS_UNIQUE,PAGE_VIEWS_TOTAL,PAGE_VIEWS_LOGGED_IN_TOTAL,PAGE_VIEWS_LOGGED_IN_UNIQUE,PAGE_VIEWS_LOGOUT,PAGE_VIEWS_UNIQUE,POST_CLICKS,POST_CLICKS_UNIQUE,POST_ENGAGED_USERS,POST_IMPRESSIONS,POST_IMPRESSIONS_FAN,POST_IMPRESSIONS_FAN_PAID,POST_IMPRESSIONS_FAN_PAID_UNIQUE,POST_IMPRESSIONS_FAN_UNIQUE,POST_IMPRESSIONS_ORGANIC,POST_IMPRESSIONS_ORGANIC_UNIQUE,POST_IMPRESSIONS_PAID,POST_IMPRESSIONS_PAID_UNIQUE,POST_IMPRESSIONS_UNIQUE,POST_IMPRESSIONS_VIRAL,POST_IMPRESSIONS_VIRAL_UNIQUE,POST_NEGATIVE_FEEDBACK,POST_NEGATIVE_FEEDBACK_UNIQUE,POST_ACTIVITY,POST_ACTIVITY_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_LENGTH,POST_VIDEO_VIEW_TIME,POST_VIDEO_VIEW_TIME_ORGANIC,POST_VIDEO_VIEWS_10S,POST_VIDEO_VIEWS_10S_AUTOPLAYED,POST_VIDEO_VIEWS_10S_CLICKED_TO_PLAY,POST_VIDEO_VIEWS_10S_ORGANIC,POST_VIDEO_VIEWS_10S_PAID,POST_VIDEO_VIEWS_10S_SOUND_ON,POST_VIDEO_VIEWS_10S_UNIQUE,POST_VIDEO_VIEWS_ORGANIC,POST_VIDEO_VIEWS_ORGANIC_UNIQUE,POST_VIDEO_VIEWS_PAID,POST_VIDEO_VIEWS_PAID_UNIQUE,POST_VIDEO_VIEWS_SOUND_ON |
| Period | String | The period for the insight. This controls how rows will be broken up (by day, week, 28 days, or lifetime). This must always be specified.
The allowed values are day, week, days_28, lifetime. |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source. For more information, see the WHERE clause section.
| Name | Type | Description |
| FromDateTime | String | The earliest time for insight data to have been collected. |
| ToDateTime | String | The latest time for insight data to have been collected. |