Most dashboards get built, admired for a week, and then nobody opens them again.
That’s not a data problem. It’s a design problem. The dashboard got built to show off numbers when it should’ve been built to help you make a call.
Here’s the thing. Almost everything written about dashboards comes from dashboard software companies, and it’s written for analysts at big corporations. Chart types. Refresh rates. Color schemes. It all assumes someone gets paid to stare at the screen all day.
You don’t have that person. You’ve got you, on your phone, between meetings or at 9pm at the kitchen table. You need to know in under a minute: is anything on fire, and do I need to decide something?
These nine rules are for that person.
1. Start with the questions, not the data
The usual way to build a dashboard: list every number your software can spit out, pick the interesting ones, arrange them on a screen. You get a screen full of numbers and zero answers.
Flip it. Start with the questions that actually keep you up at night. For most owners it’s some version of these five:
- Am I going to run out of money, and when?
- Am I actually making money on the work we’re doing?
- Is my marketing turning into customers, or just activity?
- What changed since last month, and why?
- What are the two or three decisions in front of me right now?
Every number on the dashboard has to help answer one of those. If it doesn’t, it goes one click down or it goes away.
2. One screen, seven numbers or fewer
If the first screen scrolls, it’s not a dashboard. It’s a report.
Seven isn’t a rule of nature. It’s about how many numbers a small team can actually hold in their heads. For a typical service business, the first screen looks something like this:
| Number | Question it answers |
|---|---|
| Cash, next 13 weeks | Am I going to run out of money? |
| Profit margin by job or client | Am I making money on the work? |
| Work sold but not done yet, in weeks | Is next quarter covered? |
| Quotes out vs. what we need to close | Is the quarter after that covered? |
| Revenue vs. plan, year to date | Are we where we said we’d be? |
| Marketing spend traced to signed customers | Is marketing working? |
| One number about the work itself | How busy the team is, jobs finished on time, repeat clients, whatever your business runs on |
Everything else is a click away. Job-by-job detail, client-by-client detail, channel-by-channel marketing. All useful. None of it on screen one.
3. Every number gets a line and a person
A number by itself is trivia. A number with a line it shouldn’t cross is a warning. A number with a line and a person who acts when it’s crossed is a decision you already made.
Before a number goes on the dashboard, write two things next to it: the level where it becomes a problem, and who has to do something about it.
“Margin under 32% on any job over $50k: the project lead looks at it that week.” “Cash drops under six weeks of payroll: owner and bookkeeper meet before Friday.”
Green, yellow, red only mean something when they follow those rules. Coloring a number red because it went down is decoration. Coloring it red because it crossed the line you drew ahead of time is a decision waiting to happen.
4. Show the trend and the reason, not the snapshot
One month’s number tells you almost nothing. Thirteen months of the same number tells you whether this month is normal and which way things are heading.
Put the trend next to every headline number. Then skip the “up 8%, down 4%” column. “Revenue down 8% from last month” isn’t an explanation. It’s the same fact said twice.
The dashboard should point at the reason. Which two projects slipped. Which client paid late. Which ad channel stopped turning into customers. If the dashboard can’t carry the reason, the written page has to. More on that in rule eight.
5. Numbers about the future beat numbers about the past
Most dashboards are all history. Last month’s revenue, last month’s margin, last month’s spend. History’s useful. You just can’t decide anything about it. It already happened.
Give the forward-looking numbers the top row. A 13-week cash forecast tells you about a payroll problem in week nine while you’ve still got eight weeks to fix it. Work sold but not started tells you whether you’re about to run out of work or run out of people. Quotes out tells you whether the marketing you paid for three months ago is about to land.
If your systems can’t produce a forward-looking number yet, fix that first. It matters more than anything else on this list.
6. Make the numbers agree before anyone sees them
In most $2-20M businesses, the accounting software, the project tool, and the marketing platform each report revenue. None of them match. The bookkeeper’s number is right for taxes. The project tool’s number is right for tracking jobs. The CRM’s number is right for commissions. And the leadership meeting turns into an argument about whose spreadsheet is right.
A good dashboard ends that argument before it starts. Every number has one source and one definition, written down where everyone can see it.
“Revenue: from the accounting system, counted when earned.” “Job margin: what we billed minus what our people’s time really cost us, plus materials and subcontractors, from the project tool, checked against the books every month.”
Whoever keeps the dashboard does the matching up before the meeting. The meeting is for deciding, not for auditing.
7. Monthly beats real time
Dashboard companies sell real-time updates as a feature. For an owner it’s mostly a trap. Real-time numbers get you reacting to noise: a slow Tuesday, a big invoice that posted on the 1st instead of the 31st.
Monthly lines up with when the books close. It lets you compare this month to last month fairly. And it keeps the inputs simple. Once a month, someone exports from your accounting, project, and marketing tools into a shared folder. No integrations to babysit. No logins to hand out. Fifteen minutes.
One exception: cash. When cash is tight, the 13-week forecast gets updated every week. Everything else stays monthly.
8. Pair the dashboard with a page
This is the rule that separates dashboards people use from dashboards people ignore. The dashboard is the sidekick. The real product is a written page.
Every month, someone writes one page off the dashboard. What changed. Why it changed. The two or three decisions in front of the business, each with a recommendation. And at the bottom, a running list: what got decided last month, and what happened next.
The page does what a dashboard can’t. It carries the reason behind the number. It forces someone to recommend something. And that running list means decisions stop disappearing between meetings, because last month’s call gets a status update on this month’s page.
We wrote up the whole format in how to run a monthly operating review.
9. Build it for the phone at 9pm
The reader is tired and on a phone. Build for that person.
Plain labels, not field names from the software. Full words, not abbreviations, unless it’s one your whole team already uses. Numbers big enough to read without pinching. A layout that works top to bottom, because that’s how a phone scrolls. If a number needs a footnote to make sense, rewrite the label until it doesn’t.
This is a teamwork tool too. A dashboard the whole team can read without a translator is a dashboard the whole team will actually read.
How this keeps a small team on the same page
When a small leadership team is out of sync, it’s rarely about strategy. It’s because everyone’s looking at different numbers, defined differently, at different times. Ops has a spreadsheet. Sales has the CRM. The bookkeeper has the books. Everyone’s right about something, and the meeting gets eaten by sorting out whose numbers to trust.
A dashboard built on these nine rules fixes that:
- Same numbers. One screen, seven numbers, everyone knows what they are.
- Same definitions. Written down. One source per number. Matched up before anyone sees it.
- Same lines. Everyone knows ahead of time what counts as a problem and who owns it.
- Same rhythm. One monthly meeting, 45 minutes, off the same page.
Quick agenda for that meeting: ten minutes on what changed, fifteen on why, fifteen on decisions, five on last month’s list. No slides. The page and the dashboard are the only materials.
What to leave off
Some numbers feel important and aren’t. Website traffic. Followers. Email open rates. Proposals sent. Hours logged. Those are activity numbers. They belong to the people doing the activity, not on the owner’s first screen.
Simple test: if the number moved 20% either way, would you do anything different? No? It’s not a dashboard number. Marketing earns its spot on screen one as spend traced to signed customers. Not clicks.
Where to start
You don’t need software. A spreadsheet with seven numbers, thirteen months of history, a line and a name next to each one, and a one-page write-up every month will beat most dashboards that cost real money.
If the matching-up and the writing are the parts you don’t have time for, that’s what we do. Our Executive Dashboards service is a live dashboard plus the monthly one-page write-up, fed by fifteen minutes of your exports.
Either way: build the page before you build the dashboard.
Questions owners ask
- How many KPIs should be on an executive dashboard?
- Seven or fewer on the first screen. For a $2-20M service business that's usually: cash for the next 13 weeks, profit margin by job or client, work sold but not done yet, revenue vs. plan, marketing spend traced to signed customers, and one or two numbers about how the work is going. Everything else lives one click down.
- What is the difference between an executive dashboard and an operating review?
- The dashboard shows the numbers. The operating review is a one-page write-up that says what changed, why, and what to decide. A dashboard without the write-up gets built, admired, and ignored. The write-up is what turns numbers into decisions.
- How often should an executive dashboard be updated?
- Monthly, for most owner-run businesses. Real-time dashboards get you reacting to noise. Monthly lines up with when the books close, lets you compare this month to last month fairly, and gives every number a chance to mean something before you act on it.
- Which KPIs should a service business track on an executive dashboard?
- Forward-looking numbers first: cash for the next 13 weeks, work sold but not done yet, and how much you're quoting compared to what you need to close. Then margin by job or client after the true cost of your people's time, revenue vs. plan, and marketing spend traced to signed customers. Leave clicks, followers, and activity counts off.