A marketing dashboard is a single screen that shows whether your marketing is producing revenue. That’s the whole job. Most of the ones we audit do something else: they show how much activity happened (impressions, clicks, sessions, followers) and leave the owner to guess whether any of it turned into booked work.
If you run an HVAC company, a law firm, or a small medical practice, you don’t need 40 widgets. You need about seven numbers, pulled from the places where leads and revenue actually live, laid out so you can read them in under two minutes on a Monday morning. This post walks through exactly what those seven numbers are, what to cut, and how to build the thing without buying another software subscription.
Why most marketing dashboards fail service businesses
Most dashboard templates and “marketing dashboard examples” you’ll find online are built for ecommerce or SaaS companies. They assume a checkout page fires a purchase event, so every sale is attributed automatically. Service businesses don’t work that way. A lead calls on a Tuesday, gets a quote on Thursday, and signs three weeks later. The sale happens in a CRM, a spreadsheet, or a field-service tool, not on your website.
So the typical dashboard stops at “form submissions” and “calls,” and calls them conversions. That’s where the trouble starts. Two hundred form fills can contain thirty real leads once you filter out spam, wrong numbers, and out-of-area inquiries. A dashboard that counts all two hundred as wins will tell you your marketing is working right up until the month the bank account says otherwise.
The fix isn’t a prettier chart. It’s changing what you measure so every number on the screen is one step closer to money.
The 7 numbers a service-business dashboard needs
1. Qualified leads, by source
Count only the leads that were a real person, in your service area, asking for something you sell. Break them out by source: Google Ads, Google Business Profile, organic search, Meta, referrals. This is the number everything else divides into, so it has to be clean. If your tracking is counting spam, fix that first (our walkthrough on Google Ads conversion tracking that counts real leads covers it).
2. Cost per qualified lead
Spend divided by qualified leads, per channel. Not cost per click, and not cost per form fill. If you’ve been judging campaigns on a blended average, split it out. It’s common to see one channel at $35 per qualified lead and another at $140 hiding inside the same average. Our post on how to calculate cost per lead explains why this number alone can mislead you, which is why it’s number two and not number one.
3. Booked jobs (or appointments, or signed cases)
The count of leads that turned into actual work. For a plumber, that’s a dispatched job. For a dental practice, a scheduled new-patient visit. For a law firm, a signed retainer. This is the number that moves a dashboard from reporting activity to reporting results, and it’s the one most dashboards are missing, because it requires someone to tell the system what happened after the phone call.
4. Revenue by source
Dollars closed, tied back to the channel that produced the lead. This is the line that settles arguments. It’s also the hardest to get, since it means connecting your CRM or invoicing data to your lead source. It’s worth the effort. We’ve seen owners cut a channel they thought was their best performer once revenue by source appeared next to it.
5. Revenue per ad dollar (ROAS)
Revenue divided by ad spend, by channel. If you’re not sure what counts as healthy for a service business, our honest answer on what is a good ROAS has the ranges. A 4x ROAS on a low-margin job is a different story than 4x on a high-margin one, so keep margin in mind when you read it.
6. Lead-to-job close rate and response time
What percentage of qualified leads become booked jobs, and how fast did you first respond? Both belong on the dashboard because marketing gets blamed for problems that happen after the lead arrives. If your close rate drops from 40% to 25% while lead quality is flat, the issue is likely follow-up speed or the sales process, not the ads. Putting it on the same screen stops the wrong team from taking the blame.
7. Spend and results vs. last period
One trend line comparing this month to last month (or this week to last week) for total spend, qualified leads, and revenue. Service businesses are seasonal, so also compare against the same month last year when you have it. Without context, any single month’s number tells you very little.
What to cut from your marketing dashboard
Everything below can live in a deeper report for whoever manages the channel. It doesn’t belong on the owner’s screen:
- Impressions and reach. They’re inputs, not outcomes.
- Click-through rate and cost per click. Useful for tuning ads, irrelevant to whether the business is growing.
- Website sessions and bounce rate. Traffic without lead context is noise.
- Social followers and likes. Unless you can show they produce booked work, leave them off.
- Raw form submissions. Replace with qualified leads.
A good test: for each widget, ask “what decision would I make differently if this number changed?” If the answer is nothing, remove it.
A teardown of the layout we use
Here’s the structure, top to bottom. You can build this in any tool.
| Row | What it shows | Why it’s there |
|---|---|---|
| Top strip | Total spend, qualified leads, booked jobs, revenue, ROAS (this period vs. last) | Answers “are we making money from marketing?” in five seconds |
| Middle left | Qualified leads and cost per qualified lead, by channel | Shows which channels are efficient |
| Middle right | Revenue and ROAS, by channel | Shows which channels are profitable, which is different from efficient |
| Bottom left | Lead-to-job close rate and average first-response time | Separates marketing problems from sales problems |
| Bottom right | 12-month trend of spend vs. revenue | Gives seasonality context |
Notice the difference between the middle two rows. A channel can be cheap per lead and still lose money if those leads rarely close. Keeping efficiency and profitability side by side is what stops you from optimizing for the wrong thing.
How to build it without buying new software
You can do this with free or already-owned tools. Here’s the order we’d tackle it:
- Fix the lead data first. Set up call tracking and form tracking so every lead carries a source. Filter spam. Without this step, everything downstream is wrong. (See call tracking for small business.)
- Create one shared lead log. A spreadsheet or CRM with columns for date, source, qualified (yes/no), booked (yes/no), and revenue. Someone has to update the last three columns. This is the manual step most businesses skip, and it’s the one that makes the dashboard honest.
- Connect your ad platforms. Pull spend from Google Ads and Meta into the same place as the lead log. Looker Studio is free and handles this well.
- Build the five-row layout above. Start with the top strip. If you only get one row done, make it that one.
- Review it weekly. A dashboard nobody looks at is just decoration. Pick a recurring 15-minute slot.
Our team has built these for accounts ranging from small local shops to ones spending well into six figures a month, and the pattern holds: the businesses that tie spend to revenue to the cent make better budget decisions, because they stop arguing about opinions and start reading the same screen.
Common mistakes
- Trusting platform-reported conversions. Google and Meta each take credit for the same lead. Reconcile against your own lead log.
- Skipping the offline step. If revenue never makes it back into the data, you’re stuck at cost per lead forever.
- Too many metrics. Past about ten widgets, people stop reading.
- Looking at one month. A single bad month in a seasonal business usually means nothing.
Frequently asked questions
What does a marketing dashboard do?
It puts your most important marketing numbers on one screen so you can see what’s working without opening five platforms. For a service business, the best ones connect ad spend to booked jobs and revenue.
How do I create a marketing dashboard?
Clean up your lead tracking, keep a shared log of which leads became jobs and revenue, connect your ad accounts to a free tool like Looker Studio, and build a simple layout around seven core numbers. The steps above walk through it.
What are the main types of dashboards?
Dashboards are usually grouped as strategic (high-level business goals), operational (day-to-day activity), analytical (deeper trend analysis), and tactical (a specific team or channel). An owner’s marketing dashboard is mostly strategic, with a link to tactical reports for whoever runs each channel.
What KPIs should be on a marketing dashboard?
Qualified leads, cost per qualified lead, booked jobs, revenue by source, ROAS, close rate and response time, and a period-over-period trend. Everything else is secondary.
The short version
A marketing dashboard earns its place if it helps you decide where the next dollar goes. Track qualified leads, tie them to booked jobs and revenue, keep efficiency and profit side by side, and cut the rest. If you’d rather see what this looks like on a real account, our team can walk you through the reporting we build for clients.
