Social Analytics Reporting Narrative Builder

Example output

Social performance report — Hollow Creek Kombucha, last 30 days (Instagram + TikTok)

Headline: Followers kept growing and one TikTok video broke out to 410,000 views, but average reach on Instagram fell by about 27% — worth a closer look next period, not a five-alarm fire.

The 60-second version
Instagram grew from 18,400 to 19,650 followers, a solid 6.8% gain. At the same time, average reach per post dropped from roughly 12,000 to 8,700. Those two numbers moving in opposite directions usually means one of two things: the platform showed our posts to fewer non-followers, or the posting mix shifted toward content that resonates less broadly. On TikTok, one video — the ginger-lemon flavor reveal — hit 410,000 views against a normal average of 3,200, a genuine outlier worth understanding, not just celebrating.

What's driving the reach drop
Without a post-by-post breakdown of format (Reels versus static images versus carousels) and posting times, this is an assumption to validate: reach often falls when an account posts more static images relative to video, since the algorithm currently favors video across most platforms. Pull the format mix for the 30 days before and after the drop and check whether it correlates. It's also worth checking whether posting frequency slipped — gaps of more than two or three days between posts can quietly suppress reach on the posts that follow.

Why the TikTok spike matters more than the number itself
A single video at 410,000 views against a 3,200 average isn't luck — it's a signal about what this audience wants more of. The ginger-lemon reveal likely worked because it showed something new and specific rather than a lifestyle or brand-voice post. The next three TikToks should test whether that pattern repeats: another flavor reveal, a "making of" moment, and a taste-reaction video, so we learn whether it was the flavor-reveal format or something specific to that flavor driving the number.

Follower growth in plain language
Instagram added about 1,250 net new followers this period, a healthy pace for the account's current size. Growth alone doesn't tell us whether the reach drop is a platform issue or a content issue — a growing account with falling reach usually means existing followers are seeing less, which is the piece to watch most closely next period.

Recommendations for next period
1. Shift posting mix toward video-first formats on Instagram for the next two weeks and compare reach.
2. Re-run the flavor-reveal format on TikTok at least twice more to confirm the pattern, not the fluke.
3. Track posting-day gaps against reach dips to rule out a consistency issue before assuming an algorithm shift.

Bottom line for leadership
Hollow Creek Kombucha's audience is growing and one piece of content proved the brand can break out on TikTok. The Instagram reach dip is the one number that needs a follow-up test next period, not a rewrite of the whole strategy — this is a formats-and-consistency question first, before it's treated as a bigger problem.

Want this trimmed into a 3-bullet executive summary for the CEO update?