Back
Case Study 07

Instagram Audit

An education brand with around 5,000 followers was posting and getting nothing back — 6.6 likes per post on average, and 24 of the last 25 posts had zero comments. I pulled 8 months of live data, benchmarked it against the sector, and turned the diagnosis into an operator playbook with a 30-day roadmap.

My Role Social Audit & Strategy
The Problem

An active account engaging at one-tenth the sector floor — with no clear answer why.

The Solution

An evidence-based audit isolating 4 root causes plus a playbook the team could run Monday.

Skills Demonstrated
Social Audit Engagement Analysis Sector Benchmarking Content Strategy Operator Playbooks Data Visualization
25
Posts Analyzed
8 mo
Of Live Data
4
Root Causes
30 days
To Operational

The account was technically active — posts going up, content getting made, brand assets in place. But the numbers told a different story. Engagement rate sat at 0.14%, against a 1–3% sector floor for education accounts of that size. Average likes per post landed at 6.6, where 45–137 would be expected for a 4–5K-follower edu account. Twenty-four of the most recent twenty-five posts had zero comments.

The team didn't need someone to tell them engagement was low — they could see that. They needed someone to tell them why, with evidence, and what to do Monday.

I pulled 8 months of post-level data live from the account — no estimates, no extrapolation. Each post got tagged by format, hook style, hashtag mix, posting day, and time-since-last-post. Numbers got scored against education-sector benchmarks rather than generic Instagram averages.

The pattern surfaced fast. Three multi-week silences (8 weeks, 9 weeks, 5 weeks) inside the 8-month window. Each silence reset the algorithm's read on the account. Posts during consistent stretches averaged 9.3 likes; posts following silences averaged 2.7. Same brand, same content quality, three times the engagement — the difference was cadence.

I isolated four independently fixable root causes: posting inconsistency, wrong format mix, hooks written for the brand instead of the scroller, and hashtag misalignment. Each got its own evidence section, its own fix, and its own owner.

The deliverable wasn't a strategy document — it was an operator playbook. Cadence rules. Hook templates. A 30-day roadmap with checkpoints. Something the person actually running the account could open and execute.

Reframed the problem from content to system. Better captions wouldn't fix this — the account needed new operating rules.
Quantified the cadence cost. Consistent-posting weeks delivered 3.4× the engagement of post-silence weeks.
Identified the hook gap. Every post was written from the brand's perspective rather than for the person scrolling — the single highest-leverage fix.
Replaced hashtag scatter with a sector-aligned mix. The account was using broad-reach tags that buried it; the fix was niche tags that matched.
Designed five content pillars grounded in the brand's actual top performers, not generic best practices.
Delivered a 30-day operational roadmap with a 3-posts-per-week cadence rule, hook templates, and weekly checkpoints.
Tools Used
Instagram Analytics Python · matplotlib Google Slides