TDV Adapter for Facebook

Build 21.0.8137

InsightsByConsumptionType

Allows retrieval of insights by consumption type.

Table Specific Information

Insights by consumption type refers to any insights that can be retrieved from a page or post that measure how users consumed your content.

Select

When selecting insights, a Target must be specified. In addition, an InsightName and Period should always be specified. For instance:

SELECT * FROM InsightsByConsumptionType WHERE Target = 'mypostid' AND InsightName = 'PAGE_CONSUMPTIONS_BY_CONSUMPTION_TYPE' AND Period = 'day'

Additionally, StartTime and EndTime can be used to specify a range where insight data should be drawn from:

SELECT * FROM InsightsByConsumptionType WHERE Target = 'mypostid' AND InsightName = 'PAGE_CONSUMPTIONS_BY_CONSUMPTION_TYPE' AND Period = 'day' AND EndTime >= '12/1/2015' AND EndTime <= '12/31/2015'

Columns

Name Type Description
RowNumber [KEY] Int The row number of the result.
EndTime Datetime The most recent date this insight data is relevant for.
VideoPlay Long Insight column indication the total for the stated consumption type.
OtherClicks Long Insight column indication the total for the stated consumption type.
PhotoView Long Insight column indication the total for the stated consumption type.
LinkClicks Long Insight column indication the total for the stated consumption type.
ButtonClicks Long Insight column indication the total for the stated consumption 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: PAGE_CONSUMPTIONS_BY_CONSUMPTION_TYPE,PAGE_CONSUMPTIONS_BY_CONSUMPTION_TYPE_UNIQUE,POST_CLICKS_BY_TYPE,POST_CLICKS_BY_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.

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