TDV Adapter for Facebook

Build 21.0.8137

VideoInsightsByActionType

Allows the retrieval of video insights by story action type.

Table Specific Information

Video insights by action type refers to video insights that can be retrieved that detail totals for types of stories.

Select

When selecting video insights, a Target must be specified.

SELECT * FROM VideoInsightsByActionType WHERE Target = 'myvideoid'

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.
Like Long Total likes.
Comment Long Total comments.
Share Long Total shares.
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.

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