OnlineFollowers
Query Online Followers insights as hourly totals. Requires the instagram_basic and instagram_manage_insights scopes.
Select
You can use the FromDateTime and ToDateTime columns to filter the results by a timeframe. The connector uses the Instagram API to process filters that refer to a timeframe or Id and will process other filters client-side within itself.
-
The default query returns results as hourly totals during the last 7 days.
SELECT * FROM OnlineFollowers
-
The maximum timeframe you can specify with the FromDateTime and ToDateTime columns is 30 days (2592000 s).
SELECT * FROM OnlineFollowers WHERE FromDateTime = '2018/01/01' AND ToDateTime = '2018/01/30'
Columns
| Name | Type | Description |
| InstagramBusinessAccountId | String | The unique identifier for the business account. |
| StartTime | Datetime | The start datetime of the insight. |
| EndTime | Datetime | The end datetime of the insight. |
| Onlinefollowers | Integer | The number of the online followers at the specific time. |
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. |