The dashboard you
actually need.
Analytics · 9 October 2026 · 4 minute read
A marketing dashboard is not a place to put every number you can access. It is a decision tool, and a decision tool with forty metrics on it does not help anyone decide anything.
A small business needs four questions answered on one screen: how many enquiries came in, where they came from, what each one cost, and how many turned into customers. Everything else is diagnostic detail that belongs one level down.
Why most dashboards go unused
The usual failure is not technical. It is that the dashboard was built to display data rather than to answer a question, so nobody can say what they would do differently based on it.
Three symptoms that it has happened to yours.
- It has more than a dozen numbers on it.
- It shows impressions, reach and followers above the numbers that involve money.
- Nobody has opened it in a month, including the person who built it.
The test for every metric is simple and quite ruthless: if this number moved by twenty percent, what would I do? If there is no answer, it is not a dashboard metric. It may still be worth looking at occasionally, but not here.
The four questions
How many enquiries did we get? The single most important number in a small business, and the one most often buried beneath traffic figures. Count real enquiries, by every route they arrive: form, phone, email, direct message, walk in.
Where did they come from? Grouped broadly: search, paid search, paid social, organic social, referral, direct. Enough to tell you where to put the next dollar, not so granular that you need to interpret it.
What did each one cost? Total marketing spend divided by enquiries, and then by source where you can. This is the number that turns an argument about whether marketing is working into a calculation.
How many became customers, and what were they worth? Without this, you will optimise toward the source that produces the most enquiries rather than the best ones, and those are frequently not the same source.
If you track only one thing, track cost per enquiry by source. Almost every budget decision falls out of it.
What to leave off
Not because these are worthless, but because they do not belong on the screen you look at weekly.
- Followers. It moves slowly, it responds to things that have nothing to do with revenue, and it invites the wrong behaviour.
- Impressions and reach. Diagnostic. Useful when something has gone wrong, misleading as a headline.
- Bounce rate and time on page. Genuinely useful when investigating a specific page. On a dashboard they produce opinions rather than decisions.
- Keyword positions, in bulk. A handful of commercially important terms, perhaps. A table of two hundred, no.
- Anything you cannot act on. The test above applies to everything.
Weekly and monthly are different jobs
Most dashboards fail by trying to do both on one screen.
Weekly is operational. Enquiries this week against the last few weeks, spend, anything that broke. Five numbers, two minutes, and the only question is whether anything needs attention right now.
Monthly is directional. Cost per enquiry by source, conversion to customer, revenue attributed, what changed and what you are doing about it. This one deserves a written paragraph, because the sentence explaining why a number moved is worth more than the number.
Build it where you will actually look
The right tool is the one already open on your screen. A dashboard in a system you visit weekly beats a better dashboard in a system you have to remember to open.
- A spreadsheet. Underrated. Free, flexible, and filling it in by hand each week makes you read the numbers rather than glance at them. For many small businesses this is genuinely the right answer.
- Looker Studio. Connects directly to GA4 and Google Ads, updates itself, free. The usual trap is that because it is easy to add charts, people add charts.
- Notion or a similar workspace. Good when the dashboard needs to sit next to the plan, the notes and the decisions rather than on its own. The numbers have to be entered or synced, which is a cost, but the context it gains is often worth more than the automation it loses.
- The platform's own reporting. Fine for channel level detail. Not a dashboard, because each platform will tell you it was responsible for everything.
Where the numbers come from
A dashboard is only as honest as its inputs, and the most common failure is that enquiries arriving by phone or direct message never enter it at all. That systematically understates whichever channel drives them.
Before building anything, make sure conversions are tracked correctly and every route an enquiry can arrive by is counted somewhere. A beautiful dashboard built on partial data is worse than no dashboard, because it is persuasive.
A starting layout
- Enquiries this period, with the previous period beside it.
- Enquiries by source, six groups at most.
- Spend, split into media and everything else.
- Cost per enquiry, total and by source.
- Enquiries to customers, as a count and a rate.
- One sentence on what changed and why.
That is the whole thing. If it does not fit on one screen, something on it is not earning its place.
Common questions
What should a small business marketing dashboard include?
Enquiries received, where they came from, what each one cost, and how many became customers. Those four answer almost every budget decision a small business has to make. Impressions, reach and follower counts are diagnostic and belong one level down, not on the main screen.
What is the best tool for a marketing dashboard?
The one you will actually open. Looker Studio connects directly to GA4 and Google Ads and updates itself. A spreadsheet filled in weekly is slower but makes you read the numbers. A workspace like Notion is good when the dashboard needs to sit next to the plan and the decisions.
How often should I look at my marketing numbers?
Weekly for operations, a handful of numbers to check nothing has broken. Monthly for direction, with cost per enquiry by source and a written sentence explaining what changed. Daily checking produces reactions to noise rather than decisions.
Why do my platform numbers not match my dashboard?
Every platform uses its own attribution model and time window, and each will claim credit for the same customer. Pick one source as the one you make decisions from, treat the others as directional, and compare everything against your own count of real enquiries.
Where to start
Not sure which of these is costing you the most?
I'll look at your website, your social presence and how you show up in local search, and tell you plainly which one is the problem. Written findings in five business days. All I need is your website address.