Instagram Insights post analytics dashboard template for Google Sheets

Analyze your Instagram Reels, images, and carousels with KPIs like impressions, reach, engagement rate, saves, comments, and more.

By Porter

This template is built by the same marketers behind all our tutorials, support, and our template gallery.

Data sources included

+40,000 marketers have downloaded our dashboards

Questions you can answer using this Instagram Insights dashboard template

  • What is the total reach and impressions for my Instagram posts?
  • How does my post engagement rate trend over time?
  • What is the growth of my Instagram followers over time?
  • How many post saves and comments have I received?
  • Which posts (Reels, images, etc.) have the highest impressions and engagement rates?
  • What are the month-over-month trends for post reach, impressions, and engagement rate?
  • What is the best time to post on Instagram to maximize reach and engagement?
  • How do likes, comments, and saves vary across different posts (Reels, images)?
  • How does follower growth correlate with post performance (reach, impressions, engagement)?
  • What are the top-performing posts based on metrics like reach, saves, comments, and engagement rate?
  • How do different post types (Reels, images) perform in terms of impressions, reach, and engagement?

How to set up this Google Sheets template?

Copy the Instagram Insights post analytics dashboard template for Google Sheets in one click and automate your reporting

Follow these steps:


  • Step 1: Make a copy of the template.

  • Step 2: Download the extension and authorize your profile.

  • Step 3: Choose the accounts you want to pull data from.

  • Step 4: Use our prebuilt queries or build one from scratch to automate your data collection. Alternatively, you can input data manually.

  • Step 5: Set up automatic refresh to keep your dashboard updated.


Metrics and dimensions included

Customize the template’s metrics and dimensions as you like. See all available Instagram fields.

Metrics

  • Visibility

    • Post impressions
    • Post reach

  • Customizable charts

    • Post Reactions
    • Post Likes
    • Post Saves
    • Post Shares
    • Post Comments
    • Post engagement
    • Post Engagement Rate

Dimensions

  • Date

    • Time progress: hours, days, weeks, month, quarter, and year.
    • Status: overspending or underspending
    • By day, week, month, quarter, or year.

  • Post type

    • Image
    • Video
    • Carousel

  • Post picture

    • Post picture
    • Post URL

Features

You can customize your marketing reports directly in Google Sheets with your logo, colors, and branding.
Set up email alerts using conditional notifications when a cell value changes.
Edit all charts and change style values, and then paste them on your Google Slides so they can auto sync.

Utilize functions like SUMIF, VLOOKUP, IF, and ARRAYFORMULA to calculate key metrics like CPA, ROAS, and CTR, automating calculations and combining data fields.

Pull your historical marketing data automatically using our Google Sheets marketing extension.

Filter by date, campaign, channel, and more to get the insights you need.
Set, track, and achieve marketing goals with real-time updates.
Set sync intervals to match your reporting needs, whether daily, weekly, or monthly.
Connect Google Analytics, Facebook Ads, Instagram, LinkedIn, and more to create a unified view of your marketing performance.

FAQs

An Instagram Insights post analytics dashboard report should include key metrics such as Total Reach, Impressions, and Engagement (likes, comments, saves, shares) for each post, providing a clear view of how well your content performs with your audience. Tracking the Engagement Rate per post is essential for understanding content effectiveness and audience engagement.

The dashboard should also track Follower Growth over time, showing New Followers gained during a selected period to assess audience growth. Monitoring post performance trends like month-over-month changes in reach, impressions, and engagement helps identify patterns in user behavior.

Additionally, featuring insights into your top-performing posts, such as Best Performing Posts by engagement, reach, or saves, will spotlight the content driving the most interaction. Visualizations of trends in reach, impressions, and engagement over time provide a clear perspective on performance shifts, helping guide future strategies. Including metrics like Saves and Best Time to Post based on engagement levels will also help optimize your posting schedule for maximum impact.
Include an auto-sync feature for real-time data updates from Instagram Insights.

While this template is designed specifically for Instagram Insights, you can use Google Sheets’ multichannel connectors such as LinkedIn Ads, GA4, Shopify to integrate data from other marketing platforms. By combining insights from different sources, you can create a unified view of your overall marketing performance.

To set up email alerts, use the built-in notifications feature in Google Sheets. You can create custom rules to trigger email alerts based on specific conditions, such as when your actual spend exceeds the budget or when pacing percentages hit certain thresholds.

Yes, you can fully customize the charts in the dashboard. You can choose different chart types, adjust colors, fonts, and styles, add data labels, legends, and trendlines, and customize axes and gridlines to match your reporting needs.