Marketing Dashboard for SMEs: What to Track and Why
See which numbers connect marketing spend to enquiries and revenue, without crowding your weekly review. Learn where the data should come from, who should own it and what a new marketing hire should inherit.
An SME marketing dashboard should show whether marketing is producing enquiries and revenue you can trace, with eight to twelve numbers on one page. Track enquiry sources, costs, conversion, pipeline, revenue and spend in a single view, give one person responsibility for it and review it every week.
What should an SME marketing dashboard show?
Show the connection between money spent, enquiries received and customers won. Pull the numbers from your CRM, ad accounts and finance records into a consistent view that someone checks every week.
Use weekly figures for enquiries and follow-ups, with monthly figures for revenue and spend. Label those periods clearly so you aren't comparing this week's leads with last month's sales.
The weekly review matters more than the software you build it in. If you're about to hire someone to run marketing, establish the numbers and their definitions before they start. Agree what they'll be responsible for improving.
What is a marketing dashboard for, in a business your size?
In a £1m to £50m founder-led business, a marketing dashboard should show whether marketing is producing enquiries and revenue, then give someone a reason to act. If nobody changes anything after looking at it, you've added another report to the pile.
Don't make the Monday meeting depend on someone opening an ad account, Google Analytics, the CRM and a spreadsheet to assemble the totals. Agree how those numbers will be collected before the meeting, so the discussion can concentrate on decisions.
The Department for Science, Innovation and Technology's business data study found that only 46% of businesses handling digital data agreed that data analysis supports their business decisions. Having data available doesn't establish that it's being used.
The ONS study of management practices in Great Britain includes the use of KPIs among the practices it measures. It found that management practice scores were positively related to turnover, profitability and productivity, while KPIs were the lowest-scoring area in both 2019 and 2020.
That study covers 2016 to 2020, so it's older evidence. It doesn't tell you what return a dashboard would produce in your business.
Which marketing KPIs should an SME track?
Track the numbers that connect spend to enquiries, then enquiries to revenue. For most founder-led businesses, build the marketing dashboard around ten core KPIs and two optional ones, with a source system and review frequency for each.
12 marketing KPIs for an SME dashboard
| KPI | What it shows | Where the data comes from | How often to check |
|---|---|---|---|
| Enquiries by source | Which channels bring in leads | CRM source field | Weekly |
| Qualified enquiries | How many leads are worth a sales conversation | CRM stage | Weekly |
| Cost per enquiry by channel | What each lead costs you | Ad platforms and CRM | Weekly |
| Enquiry-to-opportunity rate | How many leads turn into real sales conversations | CRM pipeline | Weekly |
| Opportunity-to-won rate | How many sales conversations become customers | CRM pipeline | Monthly |
| Sales cycle length | How long it takes from enquiry to won deal | CRM dates | Monthly |
| Pipeline value | The value of open opportunities | CRM | Weekly |
| Revenue by source | Which channels produce paying customers | CRM, matched to finance | Monthly |
| Spend by channel | Where the money is going | Ad platforms, invoices and finance | Monthly |
| Return on spend by channel | Revenue won for each pound spent | Revenue by source divided by spend | Monthly or quarterly |
| Website enquiry conversion rate (optional) | How many website visitors get in touch | Google Analytics 4 | Monthly |
| Speed to first response (optional) | How quickly someone follows up a new lead | CRM activity timestamps | Weekly |
I'd start a smaller marketing dashboard with four numbers: enquiries by source, cost per enquiry, enquiry-to-opportunity rate and revenue by source. They connect activity to sales without crowding the page.
I'd also keep speed to first response visible if leads sit unanswered, because it gives the team a specific job to fix. Agree what counts as a qualified enquiry and an opportunity before comparing the totals.
Which numbers should you leave off?
Leave off numbers that don't change a decision about spend, follow-ups or sales. Keep follower counts, impressions, page views and email open rates in the channel reports used by the people running that work.
I leave those off the founder's page because they can rise without telling you whether enquiries are turning into customers. You can still open the relevant channel report when you need to explain a change.
My test is whether a number could move sharply this week without changing any decision you make. If it could, keep it off the weekly page (founders can become surprisingly attached to a flattering graph). That leaves more time to discuss the numbers someone can act on.
Where does the dashboard data come from?
Build the marketing dashboard on your CRM records for enquiries, pipeline and won deals, then match revenue to finance. Use ad accounts for advertising spend and Google Analytics 4 for website behaviour.
Set up source tracking before building the page. If enquiries arrive without a source, the channel breakdown will contain gaps or a large amount of “other”. A tidy chart won't fix that.
The guide to marketing attribution and lead tracking covers the CRM fields, tagged links and lead capture work that sit underneath these numbers. Decide who corrects missing sources and how new enquiries should be recorded.
Expect differences between Google Analytics and the CRM. Google's attribution documentation explains that GA4's attribution models give no credit to direct visits unless the whole path consists of direct visits.
That means its channel totals won't necessarily match the source recorded against a CRM contact. Use the CRM as your agreed lead record, document the difference and check revenue against finance.
How do you build a marketing dashboard with tools you already have?
Start with the tools you already pay for. Choose the route that gives you the agreed numbers with a level of upkeep someone can actually manage.
- Use your CRM's own reports. HubSpot's dashboard documentation and Pipedrive's Insights documentation describe their reporting and dashboard tools. Check whether your account can produce the source and pipeline reports you need, then work out how to bring spend alongside them.
- Put a reporting tool on top. Google's Looker Studio provides reporting through connected data sources. Check the connections you need for CRM, advertising and analytics data, and name the person responsible for maintaining them.
- Use a shared spreadsheet. Export the agreed figures from each system weekly and keep the layout fixed. Move to automated connections once you know which numbers the team actually uses.
I'd take a spreadsheet someone reviews every Monday over a live dashboard nobody opens, because the review is where decisions happen. Automation can reduce the collection work later.
Before buying anything new, give every number in the marketing dashboard a named source system and a person who fixes it when it's wrong. Check the available reporting in your current accounts first.
Who should own the dashboard, and how often should you review it?
Give one named person responsibility for the page and review it weekly in a short, fixed slot. Ownership means correcting bad data, explaining changes and recording the next action (sending it round doesn't count).
Without a marketing lead, you can give that responsibility to an operations manager, a commercial lead or yourself. When a marketing manager starts, agree explicitly which parts they'll own and which depend on sales or finance.
Set aside 20 minutes and work through these steps:
- Explain what moved and why.
- Decide what you're changing this week because of it.
- Name the number you don't trust and the person fixing it.
Record unresolved data problems alongside the decision. At the next review, check whether the person responsible has corrected them rather than quietly carrying the same uncertainty forward.
What does a good one-page marketing dashboard look like?
Arrange the page from money in to money out, with the enquiries and sales stages between them. I'd keep the layout fixed because you need to compare the same numbers without relearning the page each week.
At the top, put revenue won this month by source alongside spend this month by channel. Label both periods and make clear what costs are included.
Next, show pipeline value and the number of open opportunities, including the change from last week. Under that, put enquiries this week by source with qualified enquiries alongside.
Then show enquiry-to-opportunity and opportunity-to-won conversion rates, plus average sales cycle length. At the bottom, include cost per enquiry by channel and speed to first response.
Leave a notes box for what changed and what the team is doing about it. Keep definitions and date ranges visible so the page can be understood without its owner having to explain every row.
What should a new marketing hire inherit on day one?
Give them a working marketing dashboard built on source data they can trust, with clear responsibility for the numbers they'll improve. Include access to the underlying accounts and the definitions used for enquiries, opportunities and won deals.
If none of that exists, make the setup work explicit in the job brief. Otherwise, you're asking someone to build the measurement while also judging them on results it can't yet show.
The guide to what to put in place before you hire a marketing director covers the wider preparation around tracking, accounts and responsibility. If those foundations already work and you need senior direction, hire the leader. You don't need Founder Engine simply because you're recruiting.
The Growth Install is one way to put tracking and a dashboard in place alongside the work they'll measure. It runs for 90 days and installs three agreed growth workflows, each in one agreed area, on your own accounts with the people who'll own them.
You keep ownership of your accounts, systems and dashboard when the engagement ends. It covers the agreed workflows rather than every marketing channel or the responsibilities of a whole department.
Questions founders ask
What's the difference between a marketing dashboard and a marketing report?
A dashboard is a fixed, recurring view of the numbers used to make decisions. A report explains a period or piece of work in more depth, such as a quarterly campaign review. Use the report when you need the context behind a change on the weekly page.
Should the dashboard show leads or revenue?
Show both, because they answer different questions. Enquiries tell you what is arriving, while revenue shows which sources have produced paying customers. Keep the sales cycle visible so you don't judge this week's enquiries solely against this week's revenue.
Can I build a dashboard if my CRM data is messy?
Yes, but keep the gaps visible rather than filling them with guesses. Start with the last three months, correct source fields where you have evidence and agree rules for recording new enquiries. Older records can remain imperfect while you improve the current data.
How long does it take to build a useful marketing dashboard?
The time depends on whether your CRM already records sources, stages and deal values consistently. If it does, start with a basic spreadsheet using those records. If it doesn't, fix tracking first and use the weekly review to improve the first version (nobody's is perfect).
If you want help working out where growth is getting stuck, talk to Founder Engine.