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_COUNTRY,AUDIENCE_CITY,ONLINE_FOLLOWERS |
| InsightBreakdownValue | String | The values for an insight breakdown. Applies to AUDIENCE_GENDER_AGE, AUDIENCE_COUNTRY, AUDIENCE_CITY. |
| 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. Only 'lifetime' is valid for AUDIENCE_GENDER_AGE, AUDIENCE_COUNTRY, and AUDIENCE_CITY.
The allowed values are day, week, days_28, lifetime. |
| Timeframe | String | Designates how far to look back for data. Required for AUDIENCE_GENDER_AGE, AUDIENCE_COUNTRY, and AUDIENCE_CITY, and takes the place of FromDateTime and ToDateTime inputs for these insights.
The allowed values are last_14_days, last_30_days, last_90_days, prev_month, this_month, this_week. |
| 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. |