📱 Social Media

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

Turn a Meta Business Suite or Instagram Insights content export into decisions: clean the CSV, define views, reach, and interactions the way Meta reports them, separate boosted posts from organic, compare formats with medians from your own data, read saves and shares per reach, and leave with a small test plan instead of borrowed industry benchmarks.

0.0
0Reviews
P
October 7, 2026

Prompt

Act as a social media analyst who reads Meta Business Suite and Instagram professional dashboard exports every month for small businesses, knows that Meta now reports views where it used to report impressions, and refuses to compare a client against industry averages nobody can source.

Inputs:
- The exported content rows as pasted CSV: post ID or date, publish time, post type (Reel, carousel, image, story), reach, views, likes, comments, shares, saves, and any boost or ad flag: [ExportRows]
- Account, platform, date range of the export, and the time zone the export uses: [AccountContext]
- What the business wants from the account (class sign ups, store visits, DMs, link clicks): [BusinessGoal]
- Anything unusual in the period (holiday, a paid boost, a collab post, a viral moment): [PeriodNotes]
- Output format: [Format]

Generate:
1. An export hygiene check: confirm date range and time zone from AccountContext, count rows by post type, flag duplicates, missing metrics, and any row that is a boosted or paid post using PeriodNotes and the boost flag.
2. Metric definitions in plain words: reach as unique accounts, views as total times content was played or shown, interactions as likes plus comments plus shares plus saves. Note that metric names in the export can change, so mark any column whose meaning is unclear as CHECK.
3. An organic only table that excludes boosted rows, with per post interactions per reach, saves per reach, and shares per reach as percentages, rounded to one decimal.
4. Per format medians (not averages) for reach, views, and each rate, with the number of posts behind each median and a warning when a format has fewer than five posts.
5. Top and bottom posts by the rate that best matches BusinessGoal, with one line on what the content was if ExportRows includes it.
6. A posting time read that only describes what the data shows, with sample size, and does not declare a best time from a handful of posts.
7. The boosted post section: report it separately and explain why its reach should not be compared with organic posts.
8. A next month test plan: two or three tests, each with one variable changed, how many posts it needs, and which metric decides it.

Constraints:
- Use only numbers in ExportRows and show the arithmetic for any rate. Never quote industry benchmarks or follower growth not in the Inputs.
- Keep it to what a small business owner can act on; no em dashes.

Instructions

Replace every [bracket] with your details before running. Works on ChatGPT, Claude, and Gemini.

Generated Output

This image was generated using the prompt above.

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 - Result

Examples

Example Input

AccountContext: Instagram professional account for Juniper Hot Yoga, export from Meta Business Suite content tab, Sept 1 to Sept 30, times in America/Denver
ExportRows:
1, Reel, Tue 07:30, reach 4210, views 9850, likes 212, comments 18, shares 41, saves 66
2, Carousel, Wed 12:00, reach 1890, views 3120, likes 140, comments 9, shares 6, saves 52
3, Image, Thu 18:00, reach 960, views 1240, likes 71, comments 4, shares 1, saves 3
4, Reel, Sat 09:00, reach 6120, views 15400, likes 301, comments 25, shares 88, saves 97
5, Carousel, Mon 07:30, reach 2240, views 3980, likes 166, comments 14, shares 11, saves 71
6, Image, Tue 18:00, reach 870, views 1100, likes 58, comments 2, shares 0, saves 2
7, Reel, Thu 12:00, reach 2980, views 6400, likes 150, comments 7, shares 19, saves 30
8, Carousel, Sat 09:00, reach 2650, views 4600, likes 188, comments 21, shares 15, saves 84
9, Reel, Sun 10:00, reach 11800, views 19300, likes 260, comments 12, shares 20, saves 25, boosted
10, Image, Fri 07:30, reach 1010, views 1350, likes 77, comments 6, shares 2, saves 5
BusinessGoal: more first class bookings from the link in bio
PeriodNotes: post 9 was boosted for 5 days to promote the October intro offer
Format: hygiene, tables, findings, test plan

Example Output

Export hygiene
- Range Sept 1 to Sept 30, times in America/Denver. 10 rows: 4 Reels, 3 carousels, 3 images. No duplicates, no blank metrics.
- Row 9 is boosted (flag plus PeriodNotes). It is excluded from the organic tables below.
- No link click or profile visit column in this export: CHECK the account insights page for link in bio taps, since that is closest to BusinessGoal.

Definitions used
- Reach: unique accounts that saw the post. Views: total plays or displays, so one person can count more than once. Interactions: likes + comments + shares + saves.

Organic posts (rates per reach)
| # | Type | Reach | Interactions | Int/reach | Saves/reach | Shares/reach |
| 1 | Reel | 4210 | 337 | 8.0% | 1.6% | 1.0% |
| 2 | Carousel | 1890 | 207 | 11.0% | 2.8% | 0.3% |
| 3 | Image | 960 | 79 | 8.2% | 0.3% | 0.1% |
| 4 | Reel | 6120 | 511 | 8.3% | 1.6% | 1.4% |
| 5 | Carousel | 2240 | 262 | 11.7% | 3.2% | 0.5% |
| 6 | Image | 870 | 62 | 7.1% | 0.2% | 0.0% |
| 7 | Reel | 2980 | 206 | 6.9% | 1.0% | 0.6% |
| 8 | Carousel | 2650 | 308 | 11.6% | 3.2% | 0.6% |
| 10 | Image | 1010 | 90 | 8.9% | 0.5% | 0.2% |
Example arithmetic, post 5: 166 + 14 + 11 + 71 = 262; 262 / 2240 = 11.7%.

Per format medians (organic)
| Format | Posts | Reach | Views | Int/reach | Saves/reach | Shares/reach |
| Reel | 3 | 4210 | 9850 | 8.0% | 1.6% | 1.0% |
| Carousel | 3 | 2240 | 3980 | 11.6% | 3.2% | 0.5% |
| Image | 3 | 960 | 1240 | 8.2% | 0.3% | 0.1% |
Warning: 3 posts per format is a small sample. Treat these as directions, not rules.

Findings
- Reels reach the most new accounts (median 4210) and get shared most, so they suit discovery.
- Carousels get saved at about twice the Reel rate (3.2% vs 1.6%). Saves suggest people want to come back, which fits a booking goal.
- Top for the goal: post 5 and post 8 (carousels, 3.2% saves). Bottom: post 6 (image, 0.2% saves, 0 shares).
- Timing: both Sat 09:00 posts did well (4 and 8), but that is 2 posts. Do not call it the best time yet.

Boosted post
- Post 9 reached 11800 accounts with 317 interactions (2.7% per reach). Paid reach includes people who do not follow the studio, so its rate is not comparable to organic posts. Judge the boost by intro offer bookings in October instead.

Next month test plan
1. Carousel with a booking step on the last slide vs the same carousel without it: 2 posts each, decide on link in bio taps.
2. Replace plain images with carousels for class schedule posts: 3 posts, decide on saves per reach.
3. Two Reels posted Sat 09:00 vs two posted Tue 07:30 with similar topics: decide on reach, then revisit.

Reviews (0)

Please login to leave a review.
Loading reviews...