A social media report template in Google Sheets, and a place to actually put it
There are a thousand social-media-report-template Google Sheets out there. Here is a sensible structure for one, and how to stop it dying in a Drive folder by pushing the chart into Slack.
A social media report template in Google Sheets, and a place to actually put it
Search "social media report template Google Sheets" and you get approximately ten thousand variations. They are all, broadly, fine. They have tabs for follower count, engagement, reach, top posts, with little sparkline cells and one or two pivot tables. They are also, almost without exception, opened twice and forgotten.
The template isn't the problem. The destination is. A Sheet that lives in Drive is a Sheet nobody reads.
Here's a sensible template structure, followed by where to actually put the output.
The template, in five tabs
You don't need fifteen tabs. Five does the job:
config. Account handles, channels you're reporting on, period (last 7, 28, 90 days), goal numbers if you have them. One place to edit when accounts come and go.
raw. The data dump. Pulled from your social tools (Meta Insights, X Analytics, LinkedIn, TikTok) either by export, by a connector, or by hand if you're at low volume. One row per post or per day. Don't model anything here.
summary. The aggregations. Followers gained, total reach, total engagements, engagement rate, top three posts by reach. This is where pivots and formulas live.
charts. The visualizations. A bar of engagement by channel, a line of follower growth, a top-posts table. This is the only tab that gets seen externally. Treat it like a publishable surface.
scratch. Where the actual thinking happens. Trial pivots, mid-edit charts, the calculation you needed once. Hidden from non-owners.
The thing most templates get wrong is conflating summary and charts. Keeping them separate means you can iterate on the model without breaking what people are looking at.
What to chart
The four charts that earn their place:
- Follower growth — a line over the period, all channels stacked or faceted. Says whether you're growing.
- Engagement rate by post — a bar, top 10 posts. Says what's working.
- Reach by channel — a bar over the period. Says where to invest more time.
- Posting cadence vs engagement — a scatter (posts per week vs total engagement). Says whether posting more is helping.
That's it. A bigger report doesn't get read more carefully; it gets read less.
Where the report goes
Here's the part most templates skip: how do humans consume the report?
Three options, ranked by how much they actually get looked at:
- Sheet link in an email. ~5% click-through. Mostly ignored.
- Slide deck pasted screenshots. Looked at exactly once, in the meeting it was made for.
- The chart, posted to a Slack channel, on a schedule. Read by almost everyone in the channel.
Use Chartcastr to push the four charts from the charts tab into #marketing (or #brand, or #client-acme) weekly. The template stays in Drive. The chart shows up in the channel. The team has something to react to without anyone having to send a "did you see the report?" follow-up.
We covered the cadence question — how often, to whom — in the agency reporting cadence playbook.
The agency variant
For agencies reporting to clients on social media, the upgrade is Slack Connect. The same four charts, posted into a shared #client-acme channel weekly, replace the monthly PDF that everyone hated. We unpacked this pattern in agencies on Slack Connect for client reporting.
Setting it up
- Build the Sheet (or grab any existing template, they're fine).
- Make sure
chartshas the four charts you want to send. - Add the Sheet as a source in Chartcastr.
- Pick the charts, pick
#marketing, pick weekly.
