How to build a one page monthly marketing report
Build a monthly marketing report that fits on one page shows cost per customer and produces a decision instead of a deck nobody opens twice.
The deck that answers the wrong question
Most monthly marketing reports run to a dozen slides and still leave the owner unsure whether to keep spending. They open with impressions. They close with a plan for next month. Somewhere in the middle sits one number the owner actually wanted which is what a customer cost this month compared with last month.
A one page report is not a shorter deck. It is a different document with a different job. Its job is to put the same six or seven figures in front of the same people every month so a change is visible without anyone reading a paragraph.
What it costs and what it deliberately leaves out
The page does not diagnose anything. It will tell you cost per customer rose and it will not tell you why. Diagnosis belongs in a separate conversation with whoever runs the channel. Keeping the two apart is what stops the page growing back into a deck.
It also excludes anything your systems cannot supply reliably every month. If your CRM does not record source then the page carries no source split until it does. Cost is time rather than software. Expect two or three hours to agree definitions and build the first version and under an hour each month after that. A spreadsheet is sufficient. Buying a dashboard tool before the definitions are settled simply automates a report you have not agreed on.
Who needs this and who should not build it
Do not build it if you run one channel and spend a small fixed amount each month. Checking enquiry count and bank deposits weekly tells you everything the page would and takes two minutes. A monthly report at that scale creates a meeting to justify itself.
Also do not build an outcomes report in the first two months of a new campaign or a new SEO programme. The page will show a cost per customer figure based on almost no customers and someone will act on it. That is worse than having no report. Report on activity and leading indicators until the volume supports a rate.
It earns its place when you run two or more channels or when you report to anyone who is not involved daily. Partners investors and lenders all read one page and none of them read fourteen slides.
What goes on the page
Use six lines down the left and thirteen columns across. The lines are spend total enquiries qualified enquiries new customers cost per new customer and revenue booked. The columns are the last twelve months and the current one. Nothing else belongs in the grid. A thirteen month view means you see seasonality rather than mistaking Diwali for growth.
Below the grid put one line per channel in plain words. What changed and what is being done about it. Two sentences maximum each. Resist the urge to add graphs. If a number needs a chart to be legible the problem is usually that the definition is wrong.
Set the definitions once and write them at the foot of the page. What counts as an enquiry. What makes it qualified. Whether revenue is recorded when invoiced or when received. Whether spend includes agency fees and GST. These choices matter less than their stability. A changed definition destroys every comparison above it.
How to tell the report is working
The honest test is whether the review produced a decision. A report that is read and discussed and leads to nothing being changed or reaffirmed is costing an hour of several salaries a month. Over a quarter you should be able to point to at least one budget change that came from the page.
The flattering metrics are the ones easiest to put on it. Impressions reach followers and engagement rate all move in pleasing directions during an expensive month and none of them tie to a customer. If a line on your page cannot be connected to money within two steps then it is decoration.
The common mistake
The common mistake is letting the page grow. Someone asks a question in a review and a row gets added to answer it. A quarter later there are twenty rows and the page has become the deck it replaced. The report then stops being read and the business goes back to deciding budget on instinct.
The quieter and more expensive version is changing a definition mid year. A team starts counting newsletter subscribers as enquiries and cost per enquiry drops by half. Nothing improved. The business raises spend on a channel because the measuring stick got shorter. Fix the definitions and treat a change to them as a decision requiring a note on the page.
One owner and one source for each number
Name the person who produces the page and name the system each line comes from. Spend comes from the invoice or the ad account. Customers come from the accounting system. Enquiries come from the CRM. When two systems could answer the same question pick one and record the choice.
That single rule removes most of the arguments a monthly review generates. The meeting then spends its time on what to do rather than on which dashboard is telling the truth.
This guide explains how something works. It is not legal, tax or financial advice, and rules change. Confirm anything regulatory with a qualified professional before you act on it.