Setting Up Your 5-Metric Dashboard
Why Five Metrics Beat Fifty
Most small business owners either track everything and act on nothing, or track nothing and wonder why revenue feels unpredictable. A five-metric dashboard solves both problems by giving you exactly enough signal to make good decisions without burying you in noise.
This is chapter 2 of Marisol Vega’s guide series The Small Business Deal Command Center. In chapter 1 we mapped the deal pipeline itself. Now we build the instrument panel you’ll check every week to know whether that pipeline is healthy, stalling, or quietly leaking revenue.
The Logic Behind Limiting Yourself to Five
There is a real cost to adding metrics. Every number you track takes time to collect, time to interpret, and mental energy every time you look at it. When a dashboard has twenty-plus rows, business owners do one of two things: they skim it so fast it becomes wallpaper, or they get pulled into investigating interesting-but-irrelevant fluctuations instead of running their business.
Five is not an arbitrary number. It maps roughly to the number of things a person can hold in working memory and compare simultaneously without losing the thread. It also maps to the five stages where a deal can break down: it can fail to enter your pipeline, stall partway through, close at a low rate, close at a low value, or churn before it generates repeat revenue. One metric per failure mode gives you complete diagnostic coverage with minimal overhead.
The goal is not to be data-driven in a general sense. The goal is to spot a specific problem early enough to fix it. Five focused metrics do that. Twenty scattered metrics usually do not.
The Five Metrics and What Each One Tells You
1. New Opportunities Added (Weekly)
This is the top-of-funnel count: how many new potential deals entered your pipeline in the past seven days. It is a pure volume number, and it answers the most fundamental question a business can ask: is the front door open?
Track it as a raw count, not a rolling average, so you can see week-to-week swings clearly. A single slow week is noise. Three slow weeks in a row is a signal that something upstream — a referral source, an ad campaign, a networking habit — has quietly stopped working.
Set a simple baseline target based on your historical average, then flag any week that falls more than 20–25% below it. You do not need statistical significance here. You need an early warning.
2. Pipeline Velocity (Days Per Stage)
Pipeline velocity measures how long deals spend in each stage of your funnel — proposal sent, contract out, negotiation, whatever stages you defined in chapter 1. It is the single most useful diagnostic tool in this dashboard because it tells you where deals are getting stuck, not just whether they are.
Calculate it by taking the average age of open deals at each stage. If your typical deal moves from first contact to signed contract in three weeks and you suddenly see deals sitting in the proposal stage for five weeks on average, you have a specific problem in a specific place. That is actionable. A generic “pipeline health score” is not.
Check pipeline velocity weekly for deals that are aging past your normal threshold, and monthly for trend analysis. A deal sitting at 1.5x your typical stage duration deserves a specific follow-up action, not just a mental note.
3. Conversion Rate by Stage
Conversion rate measures what percentage of deals move from one stage to the next. Track it at each transition: prospect to qualified lead, qualified lead to proposal, proposal to contract, contract to close. You do not need a single overall close rate — that number hides too much.
The reason to break it out by stage is that different drop-off points have different causes and different fixes. If 70% of prospects become qualified leads but only 30% of qualified leads get a proposal, the problem is in your qualification or follow-up process, not your closing skills. If 80% of proposals turn into contracts but only 40% of contracts close, the problem is likely in your negotiation or pricing. Treating those as the same issue would send you in the wrong direction.
A practical way to calculate this: at the end of each month, count the deals that entered a given stage and the deals that successfully exited it. That ratio is your stage conversion rate. Do this consistently and you will build a baseline within two to three months that makes anomalies obvious.
4. Average Deal Value
Average deal value is the mean revenue per closed deal over a rolling period — typically 90 days to smooth out noise. It tells you whether you are winning the right deals, not just deals.
This metric becomes powerful when you track it alongside conversion rate. A rising close rate paired with a falling average deal value often means you are unconsciously downgrading your offer to win deals — discounting, descoping, or gravitating toward smaller clients because they are easier to close. That pattern feels like progress on the inside and erodes margins on the outside.
Conversely, a falling close rate paired with a rising average deal value might mean you are moving upmarket successfully, and the lower close rate is expected. Without this metric you would interpret that as a problem. With it, you can see it might be a good sign.
Track average deal value separately for different service lines or client categories if your business has meaningful segments. A blended average across very different deal types can mislead you about the health of either one.
5. Pipeline Coverage Ratio
Pipeline coverage ratio is the total value of all open deals in your pipeline divided by your revenue target for the next 90 days. If you need $50,000 in revenue over the next quarter and you have $150,000 in open deals, your coverage ratio is 3x.
This is the one metric on the dashboard that directly connects today’s pipeline to next quarter’s revenue. It answers the question every business owner has but rarely asks explicitly: do I have enough in progress to hit my number, given my historical close rate?
The right coverage ratio for your business depends on your close rate. If you close 50% of deals, you need at least a 2x coverage ratio to hit your target — and realistically 2.5x or 3x to account for timing slippage. If you close 30% of deals, you need roughly a 3.5x ratio as a minimum. Build your own target once you have two to three quarters of data on your actual close rates.
When coverage drops below your target ratio, that is not a future problem. It is a current problem that will show up in revenue in 60 to 90 days. Acting on it now is the entire point of having this metric.
Building the Actual Dashboard
You do not need specialized software to start. A shared spreadsheet with five columns updated weekly is enough to get real value from this system. What matters is consistency, not tooling.
Structure your tracker with these elements:
- A deal log — one row per deal, with columns for entry date, current stage, stage entry date, estimated value, and status (open, closed-won, closed-lost).
- A weekly summary tab — where you paste the five calculated metrics each week so you can see trends over time, not just the current snapshot.
- A simple traffic-light system — green for on-target, yellow for approaching threshold, red for below threshold. Color coding lets you scan the dashboard in under 30 seconds.
If you move to a CRM later, these same five metrics translate directly. Most small-business CRMs can generate them from deal data with minimal configuration. The advantage of starting in a spreadsheet is that you build the habit and understand the calculations before you automate them. When a tool produces a number you do not understand, you cannot trust it or act on it.
How to Use the Dashboard in Practice
Set aside 15 minutes every Monday morning — or whatever day starts your work week — and update the five metrics. That is the full maintenance cost of this system. The review itself should follow a simple sequence:
- Is new opportunity volume on track? If not, what specifically changed?
- Are any deals aging past their normal stage duration? Which ones need a specific action this week?
- Has stage conversion rate shifted meaningfully this month? In which stage?
- Is average deal value holding steady? If it has moved, do I understand why?
- Is my pipeline coverage ratio healthy for the next 90 days? If it is low, what am I doing this week to add pipeline?
The point of the weekly review is not to analyze. It is to generate a short action list. If a metric is green, move on. If it is yellow or red, identify one specific action you can take this week. That discipline is what converts measurement into results.
The Practical Takeaway
A five-metric dashboard will not tell you everything about your business. It will tell you the five things you actually need to act on. New opportunities tells you whether the pipeline is being fed. Velocity tells you where it is clogged. Stage conversion tells you where it leaks. Average deal value tells you whether you are winning the right work. Coverage ratio tells you whether next quarter is safe.
Set it up this week, even in a basic spreadsheet. Run it for 60 days. By then you will have a baseline, and the numbers will start talking to you in plain language. That is the foundation everything else in this series builds on.