JDBC Driver for Facebook

Build 22.0.8462

InstagramAccountInsights

Allows you to get insights for an Instagram Business Account. Requires the instagram_basic and instagram_manage_insights scopes.

Columns

Name Type Description
RowNumber [KEY] String The row number of the result.
EndTime Date The most recent date this insight data is relevant for.
Value Long Insight column for a singular value response.
Description String The period for the insight. This controls how rows will be broken up (by day, week, 28 days, or lifetime). This must always be specified.

The allowed values are day, week, days_28, lifetime.

InsightName String The name of the insight. This must always be specified. The available values are: IMPRESSIONS,REACH,FOLLOWER_COUNT,EMAIL_CONTACTS,PHONE_CALL_CLICKS,TEXT_MESSAGE_CLICKS,GET_DIRECTIONS_CLICKS,WEBSITE_CLICKS,PROFILE_VIEWS,AUDIENCE_GENDER_AGE,AUDIENCE_LOCALE,AUDIENCE_COUNTRY,AUDIENCE_CITY,ONLINE_FOLLOWERS
Period String The period for the insight. This controls how rows will be broken up (by day, week, 28 days, or lifetime). This must always be specified.

The allowed values are day, week, days_28, lifetime.

Target String The target of the insight. This value correspond to the InstagramBusinessAccountId of the Pages view. You can also set it to 'Target IN (SELECT InstagramBusinessAccountId FROM Pages)'. This 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) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462