Bengaluru and Erode, India — working with clients in other time zones

Analytics

A one-page monthly marketing report that leads to decisions

How to build a monthly report short enough to be read: a handful of numbers, commentary that explains change, and decisions with named owners.

A campaign performance dashboard

The monthly report arrives as a long deck, or a dashboard link with dozens of charts. Impressions, reach, followers, sessions and bounce rate each come with a green or red arrow. The owner scrolls through and asks whether things are going well, and nobody gives a straight answer. The meeting ends with no change to what the team will do next month.

Start from the decisions the report must support

A report exists to help someone decide what to do next, so write down those decisions before choosing any numbers. For most small businesses they come down to three: where next month's budget goes, what needs fixing, and what should stop. Every figure on the page should inform at least one. If it does not, it belongs in the working dashboard of the person running that channel, not in the report the owner reads.

Take a warehousing and third-party logistics company that wins most of its business through enquiries from manufacturers and brands. The owner does not need the reach of last Tuesday's LinkedIn post. They need to know whether enough qualified enquiries arrived to keep the sales team busy, what those enquiries cost, and whether anything is broken.

The numbers that earn a place

The top of the page is a small table. For a business that sells through enquiries, these rows usually cover it.

  • Qualified enquiries, taken from the CRM or sales register rather than from ad platforms
  • Total marketing spend, including agency fees and production as well as media
  • Cost per qualified enquiry
  • Qualified enquiries by channel
  • Proposals sent or deals won from marketing-sourced enquiries, if sales record them
  • One website health measure, such as organic clicks from Search Console or completed enquiry forms

Show each row for this month, last month and the same month last year. The year-on-year column matters for Indian businesses, where festivals, the monsoon and the March year-end shift demand in a pattern that repeats. A dip in November may be normal. A dip against last November deserves a sentence.

Commentary that explains rather than narrates

Under the table, write a short paragraph for each change that matters. Narration repeats the table in words: enquiries fell this month. Commentary gives the reason, how sure you are, and what follows.

  • What changed, in one line.
  • Why, marked as confirmed or suspected. 'The quote form failed on mobile for nine days after a plugin update, confirmed' is a very different message from 'probably seasonal, checking against last year'.
  • What it means for next month.

Comment only on movements bigger than the usual month-to-month variation. If every small dip gets a paragraph, the one that matters gets lost. Finish the section with a single line of data notes covering anything that affects comparison, such as a tracking change, a new filter or a paused campaign.

A report that changes nothing about next month is a record, not a report.

End with a decisions box

The last block on the page is the one most reports leave out. It lists what will happen because of this month's results, each item with an owner and a date.

  • Continue: what is working and keeps its budget.
  • Change: what will be adjusted and how, such as shifting budget between campaigns.
  • Stop: what will be paused, and what you expect to happen as a result.
  • Investigate: questions the numbers raised that need an answer before the next report.

Open each report by listing last month's decisions and whether they were carried out. Over a year, that habit gives you a plain record of what the business tried and what happened, which is more useful than any chart.

Keep the format fixed

Use the same template every month so readers know where to look. A Google Sheet or a single Looker Studio page connected to your data sources can fill the table automatically. The commentary and decisions should be written by a person, because that is where judgement comes in. Set a fixed date for the report, name who reads it, and hold to one page even in a busy month. Anything that needs more space goes into an appendix that the page links to. Send the report a day before the meeting, so the discussion starts with the decisions rather than a reading of the table.

The takeaway

Before your next report, write down the three decisions it should help you make, and remove every number that does not feed one of them.


Written by Fibvo — Bengaluru and Erode, India — working with clients in other time zones. Questions, or think we have it wrong? Tell us.

Keep reading

Related articles

Next step

Tell us what you are trying to grow.

Send the problem in a paragraph. We will reply within one working day with an honest view of whether we can help, and what it is likely to cost.

Call +91 93451 90983 WhatsApp us