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 adapter 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'
|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.|