Most dashboards track too much and say too little. Here's how to build an executive dashboard with the 4 metric categories that drive real decisions - revenue, delivery, team, and pipeline.
How to Build a Dashboard That Actually Shows What Matters
You have 14 tabs open. Three spreadsheets. A CRM you half-trust. An invoicing tool with reports you've never figured out. A project management app with a dashboard that nobody set up properly.
And you still can't answer the simplest question in business: "How are we doing?"
Not "how did we do last quarter" - you can dig that up eventually. The question is how you're doing right now. This week. Are you ahead or behind? Is the pipeline healthy or are you about to hit a dry spell? Is the team overloaded or underutilized?
If answering that question takes you more than 30 seconds, you have a dashboard problem.
Why Most Dashboards Fail
Let's be direct about this. The reason most dashboards don't work isn't the tool. It's not that you need a better platform. It's that the dashboard was built wrong from the start.
Too Many Metrics
We audited a 40-person agency last year that had a "master dashboard" with 47 metrics. Forty-seven. Revenue by client, revenue by service line, revenue by month, revenue by quarter, revenue by team member, revenue per hour, revenue compared to last year, revenue compared to forecast. That was just the revenue section.
Nobody looked at it. The CEO had a separate spreadsheet where she tracked the 4 numbers she actually cared about. The dashboard existed to make someone feel thorough. It didn't help anyone make a decision.
More metrics doesn't mean more insight. It means more noise. A dashboard with 47 metrics is a spreadsheet with a nicer font.
Vanity Metrics
Website visitors. Social media followers. Email open rates. App downloads. These feel good. They go up and to the right. They're also almost completely useless for running a business.
Vanity metrics measure activity. You need metrics that measure outcomes. "We got 50,000 website visitors" means nothing. "12 of those visitors booked a call, and 4 became clients worth $8,000 each" means everything.
Every metric on your dashboard should pass one test: if this number changes, do I do something different? If the answer is no, remove it.
No Actions Tied to Numbers
This is the big one. Most dashboards are display-only. They show you numbers. Pretty charts. Maybe a red-yellow-green indicator.
Then what?
A real dashboard doesn't just show you the number - it tells you what to do when the number is off. If your close rate drops below 25%, what happens? If average project margin dips under 40%, who gets notified? If the pipeline has less than 6 weeks of revenue in it, what's the playbook?
Numbers without actions are just decorations.
The 4 Categories That Actually Matter
After building dashboards for dozens of companies, we've landed on four categories. Every business is different, but these four cover the decisions that actually move the needle. We wrote about the specific metrics within each category in the only 12 metrics you need to track - here's the framework for organizing them.
1. Revenue Metrics
This is where your business stands financially. Not last quarter - right now.
What to track:
- Monthly recurring revenue (or monthly revenue run rate). This is the number. Not annual. Not trailing twelve months. What's coming in this month?
- Revenue by source. Where is money coming from? If 80% comes from one client or one channel, that's a risk, not a win.
- Average deal size. Is it going up, down, or sideways? If you're closing more deals but average deal size is shrinking, you're running faster to stay in place.
- Gross margin per service line (or product). Revenue is vanity. Margin is sanity. A $50,000 project at 20% margin makes you less money than a $20,000 project at 60% margin. We break down how to track this at the project level in our agency project profitability tracking guide.
The action: If monthly revenue drops below your operating cost baseline for two consecutive weeks, that's a trigger to accelerate sales activity. Not a metric to watch - a trigger to act.
2. Delivery Metrics
Revenue means nothing if you can't deliver. These metrics tell you if your operations are actually working.
What to track:
- On-time delivery rate. What percentage of projects or services get delivered on schedule? Below 85% means your delivery process has breakdowns to fix.
- Client satisfaction score. NPS, CSAT, or a simple 1-5 rating after each engagement. Pick one and track it consistently.
- Revision/rework rate. How often does work come back? One round of revisions is normal. Three rounds means something broke upstream - bad scoping, unclear briefs, wrong expectations.
- Time to completion. How long does it actually take from kickoff to delivery? Not the estimate. The actual. If you're consistently 30% over estimate, your estimates are wrong.
The action: If on-time delivery drops below 85% for two weeks straight, stop taking new work until the backlog is clear. Sounds extreme. It's not. Overloading a team that's already behind makes everything worse.
3. Team Metrics
Your team is your capacity. If you don't know how your people are doing, you don't know how your business is doing.
What to track:
- Utilization rate. What percentage of available hours are going to billable or productive work? For agencies, healthy is 65-75%. Below 60% means you're overstaffed or work isn't flowing. Above 80% means burnout is coming. We have detailed benchmarks in our utilization rate guide.
- Capacity vs. demand. How many hours of work do you have vs. how many hours your team can handle? This tells you whether to hire, outsource, or slow down sales.
- Bottleneck indicator. Where is work piling up? If one person or one team consistently has a queue, that's your constraint. Everything flows at the speed of the slowest point.
The action: If any team member is above 85% utilization for 3 consecutive weeks, redistribute work or bring in support. Don't wait for them to tell you they're drowning. By the time they do, quality has already slipped.
4. Pipeline Metrics
Pipeline is your future. Revenue tells you today. Pipeline tells you next month and the month after.
What to track:
- Pipeline value by stage. Not total pipeline - pipeline broken down by stage. $500K in "initial conversation" is very different from $500K in "proposal sent." Weight it.
- Pipeline velocity. How fast are deals moving through stages? If average time from first contact to close is 45 days and deals are sitting at 60+ days, they're probably dead.
- Conversion rate by stage. What percentage of leads become proposals? What percentage of proposals close? If you're sending 20 proposals a month and closing 2, the problem isn't lead gen. It's your proposal or your pricing.
- Pipeline coverage ratio. Total weighted pipeline divided by your revenue target. Healthy is 3x. If you need $100K next month, you want $300K in weighted pipeline. Below 2x and you're in trouble.
The action: If pipeline coverage drops below 2x your 90-day revenue target, marketing and sales shift to pipeline-building mode immediately. Not next week. Immediately. Pipeline gaps don't fix themselves.
How to Actually Build It
You have the metrics. Now here's how to put them together without spending three months on a "dashboard project" that never ships.
Step 1: Pick Your Tool
You don't need expensive software. Seriously. Here are three options ranked by complexity:
Google Sheets. Free. Flexible. Everyone knows how to use it. You can build a solid executive dashboard in Sheets with conditional formatting, a few formulas, and manual weekly updates. For a business under $2M, this is probably all you need. The downside: someone has to update it manually, which means it's only as reliable as that person's discipline.
Airtable. Better than Sheets for dashboards because it can pull from integrations. Connect your CRM, project management tool, and invoicing. Build views and dashboards that update automatically. Costs $20-45/user/month depending on your plan. Good middle ground.
Custom-built (Retool, Metabase, or similar). If you have multiple data sources and want everything in one place with real-time updates, a custom dashboard is the way. Pull data from your CRM, project management, invoicing, and time tracking into one view. More setup, but once it's running, it's hands-off.
The tool matters less than the discipline. A Google Sheet someone updates every Monday beats a $50,000 BI platform nobody checks.
Step 2: Design the Layout
One screen. That's the constraint. Your executive dashboard should fit on one screen without scrolling. If you have to scroll, you have too much on it.
Layout that works:
TOP ROW: Revenue This Month | Gross Margin | Cash Position
MIDDLE LEFT: Delivery (on-time %, satisfaction, rework rate)
MIDDLE RIGHT: Team (utilization, capacity chart)
BOTTOM ROW: Pipeline (coverage ratio, velocity, conversion rates)
Each section gets 3-4 numbers. No charts unless they add clarity - a utilization chart over 12 weeks shows trends. A pie chart of revenue by source is usually unnecessary when three numbers would do.
Color coding: green means on track, yellow means watch it, red means act now. Define the thresholds in advance. Green for on-time delivery isn't "looks good" - it's "above 85%." Red isn't "seems bad" - it's "below 70%."
Step 3: Set the Update Cadence
Weekly minimum. A dashboard that updates monthly is a report, not a dashboard. You need to see movement week over week to catch problems early.
Daily if automated. If your data flows in automatically (which it should, eventually), set it to refresh daily. The point of a dashboard is to see problems before they become crises. A weekly update means you could be 6 days late catching something.
Who updates it? One person. Not "the team." Assign a name. At most of our client companies, this is an operations coordinator or a virtual assistant. It takes 30-45 minutes per week for a manual update. The automation ROI of connecting your tools directly is usually worth it after month two.
Step 4: Add the Action Layer
This is what separates a useful dashboard from a wall of numbers.
For every metric, define:
- Green threshold: Target range. No action needed.
- Yellow threshold: Attention needed. Review in this week's ops meeting.
- Red threshold: Immediate action. Who gets notified and what do they do?
Write it down. Put it next to the dashboard. Example:
Metric: Pipeline Coverage Ratio
Green: 3x or above
Yellow: 2x - 3x → Review in Friday pipeline meeting
Red: Below 2x → CEO and Sales Lead meet within 24 hours,
shift to outbound pipeline sprint
Without this, you'll look at the red number, feel stressed, and go back to email. With it, you know exactly what to do.
Step 5: Review and Trim Quarterly
Every 90 days, look at your dashboard and ask: "Did I make a single decision based on this metric in the last 3 months?" If no, remove it. Dashboards grow like weeds. Metrics get added because someone thought they were interesting, not because they drive action.
Start with 12-15 metrics. After a year, you'll probably be down to 8-10 that actually matter. That's progress, not failure.
Common Mistakes
Mixing strategic and tactical metrics. Your executive dashboard tracks business health. It doesn't track how many support tickets were closed today or how many social posts went out. Those belong in team-level dashboards. Keep the layers separate.
Tracking inputs instead of outputs. "Number of proposals sent" is an input. "Close rate" is an output. Track outputs on the executive dashboard. Track inputs at the team level.
Building it and forgetting it. A dashboard is not a one-time project. It's a living tool. If nobody's looking at it in your weekly meeting, it's already dead. Put it on screen in every leadership meeting. Make it the first thing you look at Monday morning.
Making it too pretty. Dashboard design projects that spend 3 weeks on colors and layouts and 1 day on metric selection have it exactly backwards. Get the right numbers first. Make it look good later. An ugly dashboard with the right metrics beats a beautiful one tracking the wrong things.
Start Here
Don't build a dashboard. Build the dashboard. One screen. Four categories. 12-15 metrics with clear thresholds and actions.
Start with Google Sheets if you need to. Update it manually every Monday for a month. See which numbers you actually look at. Then invest in automation and better tooling for the metrics that proved their worth.
At Cedar Operations, we build executive dashboards that pull from all your tools into one view. CRM, project management, invoicing, time tracking - all feeding into a single screen that updates in real time. No spreadsheet wrangling. No tab-switching. Just the numbers that matter, with clear signals for when to act. See if we can build yours.
Frequently Asked Questions
What metrics should I track on my business dashboard?
Focus on four categories: revenue (monthly revenue, margin, average deal size), delivery (on-time rate, satisfaction, rework rate), team (utilization, capacity), and pipeline (coverage ratio, velocity, conversion rates). Every metric should pass one test - if it changes, would you do something different? If not, drop it. Start with 12-15 metrics and trim to 8-10 after a quarter of actual use.
What's the best tool for building a small business dashboard?
Google Sheets works for businesses under $2M with manual weekly updates. Airtable is better if you want integrations with your CRM and project management tools - it costs $20-45/user/month. For multiple data sources with real-time updates, custom-built dashboards using tools like Retool or Metabase are the move. The tool matters less than the discipline of keeping it updated and actually using it in decisions.
How often should I update my business dashboard?
Weekly at minimum. Daily if your data connections allow automatic updates. A dashboard that only refreshes monthly is just a report. The point is catching problems early - a weekly cadence means you could be up to 6 days late spotting a trend. Assign one person to own the update process, and build it into their weekly routine as a non-negotiable task.
How do I get my leadership team to actually use the dashboard?
Put it on screen in every leadership meeting. Make it the first agenda item. Define red/yellow/green thresholds for every metric and write down the specific action for each level. When someone sees a red metric, there should be no ambiguity about what happens next. Dashboards die when they're passive - they survive when every number has a consequence attached to it.
Cedar Operations builds the dashboards, automations, and systems that make your business actually run. See if we're a fit.
Related reading: