AccountFollowersNonfollowers
The number of accounts that followed and the number of accounts that unfollowed or stopped using Instagram during the selected time period. For this view, the Metric Type is total_value and Breakdown(dimension) is follow_type. Requires the instagram_basic and instagram_manage_insights scopes.
Select
The 本製品 will use the Instagram APIs to process filters that refer to a date range or InstagramBusinessAccountId and will process other filters client-side within itself.
- Metric supports the '=,IN' operator.
The default query returns results for the 'follows_and_unfollows' metric.
SELECT * FROM AccountFollowersNonfollowers SELECT * FROM AccountFollowersNonfollowers WHERE FromDateTime='2023-06-20T00:00:00Z' AND ToDateTime='2023-07-12T00:00:00Z'
To retrieve the result for other metrics, then explicitly specify the Metric in where clause. For example:
SELECT * FROM AccountFollowersNonfollowers WHERE Metric = 'reach' SELECT * FROM AccountFollowersNonfollowers WHERE Metric IN ('follows_and_unfollows', 'reach')
Columns
Name | Type | Description |
InstagramBusinessAccountId | String | The unique identifier for the Instagram business account Id. |
Metric | String | Metric Type. Default value is follows_and_unfollows.
使用できる値は次のとおりです。follows_and_unfollows, reach |
Follower | Int | The number of accounts that followed the Instagram business account |
Nonfollower | Int | The number of accounts that unfollowed the Instagram business account |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
Name | Type | Description |
FromDateTime | Datetime | The earliest time for insight data to have been collected. |
ToDateTime | Datetime | The latest time for insight data to have been collected. |