SimpleVideoInsights
Allows the retrieval of simple video insights with a single value in the response.
Table Specific Information
Simple video insights refers to simple insights that can be retrieved from a video. These kinds of insights have a single value in the response and can only be filtered by a few values.
Select
When selecting simple video insights, a Target must be specified. In addition, an InsightName should always be specified. For instance:
SELECT * FROM SimpleVideoInsights WHERE Target = 'myvideoid' AND InsightName = 'TOTAL_VIDEO_VIEWS'
Note: Unlike other types of insights, video insights are only available for the entire lifetime of the video. Breakdowns in smaller units are not possible.
Columns
| Name | Type | Description |
| RowNumber [KEY] | Int | The row number of the result. |
| 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: TOTAL_VIDEO_VIEWS,TOTAL_VIDEO_VIEWS_UNIQUE,TOTAL_VIDEO_VIEWS_AUTOPLAYED,TOTAL_VIDEO_VIEWS_CLICKED_TO_PLAY,TOTAL_VIDEO_VIEWS_SOUND_ON,TOTAL_VIDEO_COMPLETE_VIEWS,TOTAL_VIDEO_COMPLETE_VIEWS_UNIQUE,TOTAL_VIDEO_COMPLETE_VIEWS_AUTO_PLAYED,TOTAL_VIDEO_COMPLETE_VIEWS_CLICKED_TO_PLAY,TOTAL_VIDEO_10S_VIEWS,TOTAL_VIDEO_10S_VIEWS_UNIQUE,TOTAL_VIDEO_10S_VIEWS_auto_played,TOTAL_VIDEO_10S_VIEWS_CLICKED_TO_PLAY,TOTAL_VIDEO_10S_VIEWS_SOUND_ON,TOTAL_VIDEO_AVG_TIME_WATCHED,TOTAL_VIDEO_VIEW_TOTAL_TIME,TOTAL_VIDEO_IMPRESSIONS,TOTAL_VIDEO_IMPRESSIONS_UNIQUE,TOTAL_VIDEO_IMPRESSIONS_VIRAL_UNIQUE,TOTAL_VIDEO_IMPRESSIONS_VIRAL,TOTAL_VIDEO_IMPRESSIONS_FAN_UNIQUE,TOTAL_VIDEO_IMPRESSIONS_FAN |
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. |