Why five numbers beat a fifty-widget dashboard
Dashboards fail through bloat. A screen with fifty KPIs gets admired once, screenshotted for a board pack, then ignored, because no owner has the time to interrogate fifty numbers and no business changes fifty things at once. Five numbers, checked at the same time every week, outperform any amount of tooling, because the value is not in knowing the figures. It is in noticing when they move.
A number earns one of the five slots only if it passes three tests: you can influence it within a month, it changes meaningfully week to week, and a bad reading points to an obvious first action. Vanity metrics like follower counts fail all three. The five below fit most small businesses, with a swap noted where service and product firms differ.
Number one: cash runway
Runway is how many months you could operate if revenue stopped tomorrow. Compute it simply: current bank balance divided by your average monthly net outflow over the last three months. Use three months of history rather than last month alone, because a single VAT quarter or annual insurance payment will otherwise distort it. And subtract money that is not yours before you start: VAT collected and corporation tax accruing belong to HMRC, and counting them as runway is one of the most common small-business traps.
Set thresholds in advance so the number triggers action rather than anxiety. Under three months: act this week, chasing debtors, deferring spend and arranging finance before you need it, because credit is cheapest when you do not. Over six months: decide deliberately whether the surplus is a reserve or fuel for growth, rather than letting it sit by default.
Need a hand with this?
Our team delivers Analytics & Data for UK businesses — with a free initial consultation, transparent fixed quotes and no lock-in contracts. Tell us what you're working on →
Numbers two and three: pipeline and capacity
Pipeline is the value of open opportunities weighted by how likely they are to close. Assign rough stage probabilities, for example 10% for a fresh enquiry, 50% once a proposal is sent, 90% on a verbal yes, and total the weighted value. The absolute figure matters less than the trend: a falling pipeline predicts a quiet quarter long before the bank balance does. Ecommerce businesses can substitute forward order value or repeat-customer rate.
Capacity tells you whether you can deliver what the pipeline promises. For service firms, track utilisation: billable hours divided by available hours. Persistently low utilisation is a sales problem; utilisation pinned near the ceiling for weeks is a burnout and hiring signal, because there is no room to absorb a new win. Product and retail businesses should track stock cover instead: weeks of stock remaining at the current rate of sale, which flags both looming stockouts and cash sleeping on shelves.
Numbers four and five: leads and a sentiment proxy
Count qualified leads per week: form fills, quote requests, booked calls and trackable phone enquiries, minus the spam. Wire up GA4 key events for forms, use call tracking if the phone matters to you, or simply tally the inbox every Friday. Consistency beats sophistication here; a hand-counted number measured the same way every week is worth more than a perfect number measured occasionally.
Full NPS survey programmes are overkill below a certain size, so use a proxy for customer sentiment. Good options: the average score of new Google reviews that week, your repeat-purchase rate, or a single-question email after every completed job asking how likely the customer is to recommend you on a 0 to 10 scale. Pick one, keep it for at least six months, and resist upgrading it. The point is a consistent early-warning light, not a research programme.
Build it in an hour with free tools
- 1. Create a Google Sheet with five rows, one per metric, and a column per week. Backfill four weeks of history so trends exist from day one.
- 2. List your sources next to each row: bank feed or accounting software (Xero, QuickBooks and FreeAgent all export easily), your CRM (HubSpot's free tier is fine), GA4, and your review platform.
- 3. Add a four-week rolling average column beside each metric, so one odd week cannot panic you.
- 4. Apply conditional formatting with red, amber and green thresholds you set once and adjust quarterly.
- 5. Optionally connect the sheet to Looker Studio for a shareable one-page view; both tools are free.
- 6. Book a recurring 15-minute calendar slot: Monday morning, before email.
Manual entry is a feature at first, not a flaw. Typing the numbers forces you to look at them. Automate the feeds later, once the ritual has survived a couple of months.
Key Takeaway
Track five numbers every Monday: cash runway (bank balance divided by average monthly net outflow, minus HMRC's money), stage-weighted pipeline, utilisation or stock cover, qualified leads per week, and one customer-sentiment proxy such as new review scores. Build it in a free Google Sheet with four-week rolling averages and red-amber-green formatting, book a recurring 15-minute Monday slot, and ask three questions of each figure: what changed, why, and what single action follows this week.
The Monday ritual that makes it work
Ask three questions of each number: what changed, do I know why, and what single action follows this week? Limit yourself to one or two actions across all five metrics, because a list of ten actions on a Monday morning is a list of zero by Friday. Judge trends on the four-week average, not the single week, and resist redesigning the dashboard for at least three months; fiddling with metrics is a well-disguised form of avoiding them.
Once the habit holds, share the dashboard with your team monthly. Numbers that only the owner sees change nothing. And if you reach the point where you want the feeds automated, pulling GA4, your CRM and your accounting data into one live view, our analytics team at Thind Global builds exactly that for small businesses.
