Social Media Analytics

From spreadsheet cells to a weekly story

Most teams receive a CSV, a PDF, or a studio screenshot. The hard part is turning those columns into a narrative your stakeholders repeat.

This rehearsal view mimics the rhythm of a Friday metrics pass: pick a window, narrow the network, read four headline numbers, glance at a trend strip, then scan distribution and format lift. None of the figures here come from your accounts. They exist so you notice layout before you notice vanity.

When you switch channels, watch how reach and engagement decouple. Instagram-style audiences often show higher rates on smaller bases, while broad Meta pages inflate reach while thinning rate. Training your eyes on those pairs prevents panic when a real dashboard flips green on one line and red on another.

Three desks reading one KPI sheet

When the headline number smiles, open the denominator

Big reach feels like a win. Without the same period’s impressions definition, though, you might compare apples to pixels.

We recommend logging definitions beside every screenshot: unique versus total, platform-native versus third-party, paid versus organic. If you skip that step, even accurate math misleads the room.

Short audits beat long decks. Spend ten minutes each week rewriting one sentence about what moved, why you think it moved, and what you will try next. The sentence matters more than another chart tile.

Sticky-note definitions

Teams argue less when everyone writes the same glossary once.

Reach

Unique accounts that saw at least one impression during the window. Some suites still label overlapping subsets, so ask whether duplicates across placements were removed.

Impressions

Total deliveries, including repeats. A single person scrolling past the same post twice counts twice here while reach might count them once.

Engagement

Platform-specific bundle of taps, saves, shares, comments, and sometimes clicks. Never assume your export matches another vendor’s bundle without reading the footnote.

Engagement rate

Actions divided by a base the platform chooses, often followers, sometimes reach, occasionally impressions. The engagement rate calculator forces you to state the base out loud.

Reporting hygiene on noisy weeks

Launches, outages, and influencer takeovers all leave fingerprints. When a spike appears, capture the campaign name, the budget line, and the creative ID in the same row as the metric screenshot. Future-you will not remember which tab belonged to Tuesday’s test.

If your organization runs both paid social and lifecycle email, separate assisted conversions before you let social take credit for a blast that landed the same hour. The rehearsal flow above is intentionally simple so you remember to ask for those splits when the real sheet arrives.

Five minutes before the stand-up

• Confirm whether the window is rolling or calendar-aligned.
• Scan rate before raw counts so you spot denominator shifts early.
• Pick one channel that underperformed and one hypothesis, not five.
• Decide whether finance needs the ROI sheet this week or next.
• Close the loop on last week’s experiment with a single line of outcome text.

We still prefer native exports for contracts. This page exists so junior reviewers learn the shape of a credible deck before they touch customer data. Treat every mock delta as a reminder to ask where the real proof lives.