How to Use the Meta Insights Export Analyst Prompt to Turn an Instagram CSV Into Next Month's Plan

Meta Business Suite and the Instagram professional dashboard let you export a month of content data in a few clicks. The hard part is reading it. Boosted posts sit next to organic ones and make everything else look small, averages get pulled around by one viral Reel, and metric names have changed over time, with views now taking the place of impressions in many reports. The Meta Business Suite Insights Export Analyst for Instagram and Facebook: Content CSV Cleanup, Views vs Reach Definitions, Organic vs Boosted Split, Per Format Medians, Saves and Shares Rates, and a Next Month Test Plan prompt cleans the export, defines each metric in plain words, compares formats using medians from your own posts, and ends with a short list of tests to run next month.

What the prompt produces

1. An export hygiene check covering the date range, time zone, row counts by post type, duplicates, missing metrics, and boosted posts.
2. Plain definitions of reach, views, and interactions, with any unclear column marked CHECK.
3. An organic only table with interactions per reach, saves per reach, and shares per reach for every post, rounded to one decimal.
4. Per format medians for Reels, carousels, and images, with the number of posts behind each and a warning when the sample is small.
5. Top and bottom posts ranked by the rate that matches your business goal.
6. A posting time read that describes the data without declaring a best time from a handful of posts.
7. A separate boosted post section explaining why paid reach is not comparable.
8. A next month test plan with two or three single variable tests and the metric that decides each one.

How to fill the inputs

ExportRows is the pasted CSV or table: post date and time, type, reach, views, likes, comments, shares, saves, and a boost flag if you have one.

AccountContext gives the platform, account, date range, and the time zone of the export. Time zone matters for any posting time read.

BusinessGoal says what the account is for, such as class bookings, store visits, or DMs. The prompt picks its main rate based on this.

PeriodNotes lists anything unusual: a boost, a collab, a holiday, or a post that went viral for reasons outside your control.

Reading the example output

The example is a hot yoga studio with ten September posts, one of them boosted:

• Hygiene catches the boost first. Post 9 is flagged and removed from the organic tables, and the output notes that the export has no link click column, which is the closest metric to bookings.
• Every rate shows its math. For post 5, 166 likes plus 14 comments plus 11 shares plus 71 saves equals 262 interactions, and 262 divided by 2240 reach is 11.7 percent.
• Medians tell a clear story. Reels have the highest median reach at 4210 and the highest share rate. Carousels have the highest save rate at 3.2 percent, about twice the Reel rate.
• The goal decides the ranking. Because the studio wants bookings, saves matter, so the two carousels at 3.2 percent saves top the list.
• Timing stays cautious. Both Saturday 9 AM posts did well, but two posts are not enough to call a best time.
• The boosted Reel is judged on bookings, not on its 11800 reach.

Tips for better results

• Export a full month at a time. Short ranges leave each format with too few posts.
• Add a short content note for each row, such as class schedule or pose tutorial. It makes the top and bottom post lines far more useful.
• Pull link in bio taps or profile visits from account insights if your export does not include them.
• Run the same prompt each month with the same columns so trends are comparable.

Mistakes to avoid

• Do not compare boosted reach with organic reach. Paid distribution reaches people who do not follow you.
• Do not use averages when one post is far larger than the rest. Medians are steadier.
• Do not borrow industry benchmarks you cannot source. Your own last month is the better baseline.
• Do not change three things at once in a test. You will not know which change mattered.

Who it is for

Small business owners who post their own content, social media managers reporting to clients each month, and freelancers who want a repeatable analysis instead of screenshots of the dashboard.

Related PromptDig links

Open the Meta Business Suite Insights Export Analyst for Instagram and Facebook: Content CSV Cleanup, Views vs Reach Definitions, Organic vs Boosted Split, Per Format Medians, Saves and Shares Rates, and a Next Month Test Plan prompt and paste your export. For more social media prompts, Browse more prompts. If you have an analytics or reporting prompt that works well, Share a prompt.