Instagram Insights stories tracker dashboard template for Google Sheets

Track and analyze your Instagram Stories’ performance beyond the 24-hour limit. With Porter, your story images and data are securely stored, allowing you to review visibility, engagement, and trends over time for a complete historical view.

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 overall visibility of my Instagram Stories in terms of impressions and reach?
  • How are my stories performing in terms of engagement, including exits, replies, taps, and swipes?
  • Which stories have the best visibility, engagement rate, and replies, and how can I replicate their success?
  • What is the optimal time of day to post stories for maximum visibility and engagement?
  • How does the format (image vs. video) impact impressions and engagement?
  • How are my story impressions and engagement trends evolving over time?
  • Which stories generate the highest taps forward or backward, and why?
  • How do story exits correlate with overall performance and engagement rates?
  • What factors contribute to a story being labeled as a “Winner” or “Loser” based on its metrics?
    How does each story’s score relate to its performance in visibility and engagement metrics?

How to set up this Google Sheets template?

Copy the Instagram Insights stories tracker 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

    • Stories Impressions
    • Stories reach

  • Customizable charts

    • Story exits
    • Stories replies
    • Stories taps (forward)
    • Stories swipe (forward)
    • Stories taps (backwards)
    • Story engagement rate

Dimensions

  • Date

    • Time progress: hours, days, weeks, month, quarter, and year.

  • Content type

    • Video
    • Image

  • Stories performance

    • Story performance: winner or loser based on the targets

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

In an Instagram Insights Stories tracker dashboard template for Google Sheets, you should include key metrics such as story impressions, reach, exits, replies, taps (forward/backward), and swipe data to measure visibility and engagement.

Additionally, provide a section highlighting the best-performing stories by visibility, engagement rate, and replies. Incorporate charts that track daily and monthly trends in impressions and engagement, as well as optimal posting times.

Compare story formats (image vs. video) and historical data to help identify patterns in audience interaction, allowing for data-driven optimization of future stories.

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.