I noticed that Instagram Followers metric is a static number which shows just the current number of followers. However, it would be useful to have a trend as well to see how the number of followers was changing over time (for example, like in Facebook Insights). Is it possible to add this data?
Currently, the Instagram API only provides current follower counts, but here's how you can build historical trends yourself:
Set up daily data pulls
-
Schedule daily refreshes of your "Instagram Followers" metric
-
Send to Google Sheets/BigQuery to store historical data
Create trend reports
-
Connect Looker Studio to your stored data
-
Build visualizations showing follower growth over time
I'll convert this to an idea request for our product team to consider.
Thanks for sharing
Hi
Thank you for the reply! Can you please provide more details about how I can schedule daily refreshes?
Best regards,
Hi
Since the Instagram Insights API only stores story data for 24 hours, you'll need to proactively capture and store it for historical analysis.
One way to work around this is to automate this with Supermetrics for Google Sheets:
Step-by-Step guide:
Enable historical data collection
-
Use the Combine new results with old settings in your query
-
This preserves old data while appending fresh results daily
Set up daily refreshes
-
Schedule your query to run automatically every 24 hours
-
Choose a time before Instagram's data disappears (e.g., 23 hours after posting)
Visualise trends
-
Connect your Google Sheet to Looker Studio
-
Build dashboards with rolling 7/30/90-day views
See more here:
-
Detailed walkthrough: Instagram Stories Data Workaround
Important Notes
-
This works for organic Stories only (promoted content requires Facebook Ads connector)
-
For follower trends, apply the same method to "Followers" metrics
Let me know if you'd like help tweaking your query!
Sign up
Already have an account? Login
Ask questions from other Community members, comment on other people's posts and get access to exclusive Community content by logging in.
Log in with Facebook Login with LinkedInLog in to Supermetrics Community
No account yet? Create an account
Ask questions from other Community members, comment on other people's posts and get access to exclusive Community content by logging in.
Log in with Facebook Login with LinkedInEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.