Module 6: The one-page monthly report
All this instrumentation pays off in a single page you (or your team) actually read. This module builds it in a spreadsheet in under an hour.
Building the spreadsheet
Keep formulas simple: month-over-month change percentages, cost per conversion per channel. Fancy dashboards die; a spreadsheet you understand lives. If you have a team, share it with view access and walk through it in 10 minutes monthly — shared numbers create shared priorities.
Resist adding columns for the first three months. Every extra metric is a future maintenance burden and a distraction from the decisions that matter. When someone asks "can we also track X," the answer is: "What decision would X change?" If there's a good answer, add it. If not, it waits. The spreadsheet earns new columns; it doesn't collect them.
ONE-PAGE MONTHLY REPORT
MONTH: ___
TRAFFIC BY SOURCE: [top 3 + change vs last month]
CONVERSIONS: [total + by source]
COST PER LEAD/CUSTOMER: [by channel]
VS LAST MONTH: [up/down + why]
THIS MONTH'S DECISION: [one specific action]
OWNER: ___ · DUE: ___
Building a 12-tab dashboard that impresses everyone and informs no one. The more complex the report, the less it's read. One page, five questions, one decision — that's the whole system. Complexity is procrastination dressed as thoroughness.
Build brief
Who needs to see your numbers — a partner, a spouse, yourself — and what decision would the report help them make?
Saved
The 30-minute monthly ritual
First Monday of the month, 30 minutes, same routine: (1) Pull last month's numbers into the spreadsheet (10 min). (2) Compare to prior month and same month last year; flag anything up or down more than 20% (5 min). (3) Check Search Console for new ranking opportunities and coverage errors (5 min). (4) Write the 1–3 decisions in the Decisions tab (5 min). (5) Put the actions on your calendar (5 min).
The calendar step is where reports become results. "Update the pricing page CTA" isn't done until it's a calendar event with a date. Analytics that doesn't produce scheduled actions is a hobby.
Do this for six months before judging the system. Month one feels clumsy; month six feels like a superpower — you'll spot trends, kill losers early, and fund winners with confidence instead of gut feel.
The 30-minute monthly ritual
10 min
Pull last month's numbers
Into the spreadsheet from GA4 and your ad platforms.
5 min
Compare and flag
Against prior month and last year; flag anything up or down more than 20%.
5 min
Check Search Console
New ranking opportunities and coverage errors.
5 min
Write the decisions
1–3 decisions the numbers drove, in the Decisions tab.
5 min
Calendar the actions
An action isn't done until it's a calendar event with a date.
Build brief
What would you do differently next month if you knew exactly which channel brought your best customers?
Saved
Sharing numbers with stakeholders
If you report to a partner, boss, or client, lead with decisions, not data. "We moved $400 from Facebook to Google Ads because Ads delivered quote forms at $38 vs $121" beats a 12-slide deck of charts. One page: what happened, what it means, what we're doing next. That's the whole report.
Always include spend alongside results — marketing without cost context is meaningless. And include one "learning" per month, even from failures: "LinkedIn produced zero leads at $200 spend; pausing." Documented failures prevent repeated failures, which is a genuine ROI.
Set expectations about timelines: SEO and content compound over quarters; paid channels respond in weeks. When a stakeholder asks why organic isn't moving in month two, your spreadsheet's trend lines are the calm, factual answer.
One more rule for stakeholder reports: never present a problem without a proposed next step. "Conversions dropped 18%" creates anxiety; "Conversions dropped 18% — the contact form broke on mobile March 12th, it's fixed, and we're watching this week's numbers" creates confidence. You're not just the messenger of data; you're the interpreter who turns it into a plan.
End every report with the same three lines: what we decided, who's doing it, and when we'll review it. Decisions without owners evaporate; owners without deadlines drift. Three lines, every month, and your reporting becomes the operating system for the business — not just a summary of it.
Decisions, not data
The 12-slide deck vs. the one-pager
| The 12-slide deck | The one-pager | |
|---|---|---|
| Opens with | Charts | What happened |
| Includes | Everything | Spend, results, one learning |
| Ends with | Questions | What we are doing next |
Create the spreadsheet with last month's numbers (even rough ones). An imperfect report you actually review beats a perfect system you never build.
What's the most important tab in the monthly report spreadsheet?
Your turn: Write 3 decisions this month's numbers should drive — budget shifts, page fixes, channels to kill or fund — plus the calendar date each action happens.
Saved.