InsightsByStoryType
Allows retrieval of insights by like story type.
Table Specific Information
Insights by story type refers to any insights that can be retrieved from a page or post that measure the types of stories that have occurred.
Select
When selecting insights, a Target must be specified. In addition, an InsightName and Period should always be specified. For instance:
SELECT * FROM InsightsByStoryType WHERE Target = 'mypostid' AND InsightName = 'POST_ACTIVITY_BY_ACTION_TYPE' AND Period = 'lifetime'
Additionally, FromDateTime and ToDateTime can be used to specify a range where insight data should be drawn from:
SELECT * FROM InsightsByStoryType WHERE Target = 'mypostid' AND InsightName = 'POST_ACTIVITY_BY_ACTION_TYPE' AND Period = 'lifetime' AND FromDateTime >= '08/20/2025' and ToDateTime <= '09/19/2025'
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. DEPRECATED. To be removed in v26. |
| UserPost | Long | Insight column indication the total for the stated story type. DEPRECATED. To be removed in v26. |
| PagePost | Long | Insight column indication the total for the stated story type. DEPRECATED. To be removed in v26. |
| Checkin | Long | Insight column indication the total for the stated story type. DEPRECATED. To be removed in v26. |
| Fan | Long | Insight column indication the total for the stated story type. DEPRECATED. To be removed in v26. |
| Question | Long | Insight column indication the total for the stated story type. DEPRECATED. To be removed in v26. |
| Coupon | Long | Insight column indication the total for the stated story type. DEPRECATED. To be removed in v26. |
| Event | Long | Insight column indication the total for the stated story type. DEPRECATED. To be removed in v26. |
| Mention | Long | Insight column indication the total for the stated story type. DEPRECATED. To be removed in v26. |
| Other | Long | Insight column indication the total for the stated story type. DEPRECATED. To be removed in v26. |
| Share | Long | Insight column indication the total for the stated story type. |
| Like | Long | Insight column indication the total for the stated story type. |
| Comment | Long | Insight column indication the total for the stated story type. |
| 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: POST_ACTIVITY_BY_ACTION_TYPE, POST_ACTIVITY_BY_ACTION_TYPE_UNIQUE |
| Period | String | The period for the insight. 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. |