How to turn Instagram Insights exports into a useful content report
Turn Instagram Insights into a useful report by aligning post identifiers and export windows, separating Reels, carousels, Stories, and static posts, and connecting reach with saves, shares, comments, profile actions, and follows. Use rates with visible denominators and preserve metric definitions over time.
From the field · Instagram content creator
Compare Reels, carousels, and static posts for a small brand
Reels lead reach, carousels lead saves, and static launch posts lead profile visits. Some posts were boosted, and one collaboration exposed the brand to a larger audience.
Columns used in the example
post_id · publish_time · format · topic · paid_flag · collaboration_flag · reach · saves · shares · profile_actions · follows
Follow it with your own file
- Join exports by stable post ID and store export timestamp.
- Separate paid, collaboration, and organic distribution.
- Calculate objective-specific rates with documented denominators.
- Compare repeated topic-format combinations and plan the next content mix.
Check: Every post and metric must trace to one export window, paid and organic populations must remain distinct, and conclusions must use more than one post where possible.
Where to look for exceptions
- Formats and post ages are mixed in one ranking.
- Engagement rate has no documented denominator.
- Story rows disappear or change after their measurement window.
The decision hiding in the data
Exports may arrive from different views and dates, Story metrics expire, and formats receive different distribution. Comparing lifetime reach for an old carousel with a two-day-old Reel answers little.
Before the result leaves your desk
- Post IDs and export dates stored
- Formats separated
- Paid distribution flagged
- Rate denominators named
- Patterns use several posts
Before touching the file
- Align post ID, publish time, format, topic, campaign, and export timestamp.
- Use comparable age windows where possible and label lifetime measures.
- Analyze reach, depth, sharing, profile action, and follower outcomes distinctly.
- Use several posts by topic and format, keeping paid or collaborative distribution separate.
Choose the approach that matches the evidence and repetition
| Approach | When it works | What to verify |
|---|---|---|
| Reach | Audience exposure | Paid and collaboration effects |
| Saves and shares | Utility and advocacy | Small denominator volatility |
| Profile actions and follows | Creator/business outcome | Attribution window |
Build the result step by step
- Create a content key: Align post ID, publish time, format, topic, campaign, and export timestamp.
- Standardize windows: Use comparable age windows where possible and label lifetime measures.
- Separate objectives: Analyze reach, depth, sharing, profile action, and follower outcomes distinctly.
- Compare patterns: Use several posts by topic and format, keeping paid or collaborative distribution separate.
Different formats can do different jobs
A content report should not force reach, saving, sharing, and profile action into one score unless weights reflect a real objective. Showing the journey lets a creator choose a mix rather than chase one platform signal.
Where this usually goes wrong
Metric definitions, API availability, and export behavior change. Store the definition and export date, and do not backfill an unavailable metric with zero.
Doing these steps in Prepyr
Prepyr accepts CSV files only. Export the worksheet or table you need as a UTF-8 CSV first; workbook formulas, formatting, macros, charts, and other sheets will not be included. Describe the result you need: Analyze Instagram Insights exports and create a content performance report. Check the columns selected, preview any proposed changes, and compare the output with the source before applying or exporting it.
Prepyr steps used here: Multi File analysis · Charts · Reports · Reusable workflows
An Instagram report that explains which content formats support each objective and turns that evidence into a balanced, testable publishing plan.
Questions readers usually ask next
What denominator should Instagram engagement rate use?
It depends on the question. Reach, impressions, and followers answer different exposure bases, so name the denominator explicitly.
Can Reels and carousels be ranked together?
Compare within format first, then compare objective-level outcomes with format and distribution context visible.