VideoInsightsByReactionType
Allows the retrieval of video insights by reaction type.
Table Specific Information
Video insights by reaction type refers to video insights that can be measured by the type of reaction.
Select
When selecting video insights, a Target must be specified. For instance:
SELECT * FROM VideoInsightsByReactionType WHERE Target = 'myvideoid'
Note: Unlike other types of insights, video insights are only available for the entire lifetime of the video. Separation into smaller units is not possible.
Columns
| Name | Type | Description |
| RowNumber [KEY] | Int | The row number of the result. |
| Like | Long | Total like reactions. |
| Love | Long | Total love reactions. |
| Wow | Long | Total wow reactions. |
| Haha | Long | Total haha reactions. |
| Sorry | Long | Total sorry reactions. |
| Anger | Long | Total anger reactions. |
| Target | String | The target of the insight. This is a video and must always be specified. |
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. |