Get the weekly social numbers without opening a dashboard

Which metrics should the weekly pull collect?

The ones you already report, fixed as a schema: per platform, follower count, reach or impressions, engagement, and the top three posts with links and their numbers. Same metrics, same definitions, same day and hour every week, because platform numbers drift intraday.

Then the delta note, which no human writes consistently: "LinkedIn reach down 34%, posting volume was down too; Instagram engagement up on one outlier reel." A companion compiles it from the sheet’s own history every week. The rhythm matches weekly reporting, and the numbers feed the same weekly metrics digest the rest of the business reads.

The Friday marketing report

A two-person marketing team reports on four platforms. The routine runs Friday at 7 a.m.: each analytics surface opened in the browser, the schema extracted, a dated row per platform appended to the tracking sheet, and a five-line summary drafted with the week’s deltas and the single best post across platforms.

They arrive at nine to a filled sheet and a draft summary, spend ten minutes sanity-checking and adding the why (the campaign that explains the spike), and forward it. The hour of dashboard hopping is gone. Brand-level listening beyond your own accounts is tracking brand mentions.

What survives a dashboard redesign?

All of it.

The companion reads the screen the way you would, so the platforms’ constant cosmetic changes pass without incident, and a full redesign is a one-line re-point rather than a rewrite.

Numbers are platform-reported and get restated, so treat the week-over-week wiggles as noise and the trend as the signal. It is your own analytics, read in your own browser, with your own logins.

Frequently asked questions