Query Online Followers insights as hourly totals. Requires the instagram_basic and instagram_manage_insights scopes.
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. You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false, in which case any search criteria that refers to other columns will cause an error.
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'
|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 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.
|FromDateTime||Datetime||The earliest time for insight data to have been collected.|
|ToDateTime||Datetime||The latest time for insight data to have been collected.|