JDBC Driver for Facebook

Build 22.0.8462

InsightsByFeedbackType

Allows retrieval of insights by feedback type.

Table Specific Information

Insights by feedback type refers to any insights that can be retrieved from a page or post that measure what kind of feedback was left.

Select

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

SELECT * FROM InsightsByFeedbackType WHERE Target = 'mypostid' AND InsightName = 'PAGE_POSITIVE_FEEDBACK_BY_TYPE' AND Period = 'day'

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

SELECT * FROM InsightsByFeedbackType WHERE Target = 'mypostid' AND InsightName = 'PAGE_POSITIVE_FEEDBACK_BY_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 Date The most recent date this insight data is relevant for.
Like Long Insight column indication the total for the positive feedback type.
Comment Long Insight column indication the total for the positive feedback type.
Link Long Insight column indication the total for the positive feedback type.
Answer Long Insight column indication the total for the positive feedback type.
Claim Long Insight column indication the total for the positive feedback type.
Rsvp Long Insight column indication the total for the positive feedback type.
HideAllClicks Long Insight column indication the total for the negative feedback type.
HideClicks Long Insight column indication the total for the negative feedback type.
UnlikePageClicks Long Insight column indication the total for the negative feedback type.
ReportSpamClicks Long Insight column indication the total for the negative feedback type.
XButtonClicks Long Insight column indication the total for the negative feedback 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_NEGATIVE_FEEDBACK_BY_TYPE,PAGE_NEGATIVE_FEEDBACK_BY_TYPE_UNIQUE,PAGE_POSITIVE_FEEDBACK_BY_TYPE,PAGE_POSITIVE_FEEDBACK_BY_TYPE_UNIQUE,POST_NEGATIVE_FEEDBACK_BY_TYPE,POST_NEGATIVE_FEEDBACK_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) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462