TDV Adapter for Facebook

Build 21.0.8137

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.

Copyright (c) 2022 CData Software, Inc. - All rights reserved.
Build 21.0.8137