OnlineFollowers
Aggregates hourly breakdowns of when a user's Instagram followers are typically online, helping to identify the best posting times for maximum visibility and engagement. This requires the instagram_basic and instagram_manage_insights scopes to access follower activity patterns.
Select
You can use the FromDateTime and ToDateTime columns to filter the results by a timeframe. The driver 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 | A unique string identifier assigned to each Instagram business account. This is used to retrieve or associate insight data with the correct business entity. |
| StartTime | Datetime | The precise timestamp indicating when the measurement period for online follower activity begins, typically used to define the lower bound of the insight window. |
| EndTime | Datetime | The exact timestamp that marks the end of the online follower activity measurement period, defining the upper limit of the analyzed time range. |
| Onlinefollowers | Integer | The recorded number of followers who were actively online during the defined insight interval. This value provides insight into follower engagement trends over time. |
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.
| Name | Type | Description |
| FromDateTime | Datetime | The earliest timestamp from which the underlying insight data is available or was first collected for this account. This is used to define the historical data boundary. |
| ToDateTime | Datetime | The most recent timestamp for which insight data has been collected for this account, indicating the most recent data available in the reporting period. |