← Insights

Operations

Business KPIs that earn their place on the wall

July 2026 · 6 min read

Most KPI dashboards fail in one of two directions. Either they track three vanity numbers that only ever go up, or they track forty things and become wallpaper - a grid so dense that nobody's eye knows where to land, so nobody reads it, so it drifts a month out of date and dies. A good dashboard sits between the two: a small set of numbers, each one earning its place, presented so a busy person can read the health of the business in the time it takes to pour a coffee.

Getting there is less about the software and more about two decisions - which numbers, and how you colour them - plus a couple of pieces of arithmetic that most spreadsheets get quietly wrong.

Choose few, and choose across the business

The instinct is to measure everything you can. Resist it. Around ten company-level KPIs is the sweet spot - enough to see the whole business, few enough that each one is doing real work. The test for any candidate is simple: if this number moved, would someone change a decision? If not, it is data, not a KPI, and it belongs in a report you open when you need it, not on the wall.

Spread the ten across the business, not down one department. A dashboard that is all finance tells you the score but not why; a dashboard that mixes revenue and margin with delivery, quality, customers and people tells you where the score is coming from. Revenue, gross margin, new customers, churn, on-time delivery, an NPS or satisfaction score, utilisation, cost per unit - a handful from each corner beats ten flavours of the same corner.

Colour with the grain, not against it

Here is the mistake that undermines more dashboards than any other. Someone builds a RAG - red, amber, green - and wires it so that a bigger number is greener. It works beautifully for revenue and disastrously for churn, because now a churn rate that is falling (good) turns red, and a churn rate that is climbing (bad) turns a reassuring green. The colours are lying, and the moment a leader spots one lie they stop trusting the whole board.

The fix is direction-aware RAG. Each KPI declares whether higher or lower is better, and the colour respects it. Revenue up is green; churn down is green; cost per unit down is green. It sounds obvious and almost nothing does it, because the naive version is easier to build - but a dashboard is only worth having if its colours can be believed at a glance, and this is what makes them believable.

The year-to-date trap

The second silent error is the year-to-date roll-up. A dashboard that sums every KPI to date will hand you a correct annual revenue and a completely meaningless "gross margin of 847 percent" - because you cannot add up a percentage. Revenue and orders shipped are totals; you sum them. Margin, churn, utilisation and satisfaction are rates and scores; you average them. A YTD figure that does not know the difference is worse than no YTD at all, because it looks authoritative while being nonsense. Build the roll-up to treat each KPI as what it is, and the year-to-date column becomes trustworthy instead of decorative.

Show the trend, not just the score

A single month's RAG tells you where you are; it does not tell you where you are heading, and heading is usually the more important question. A green that has been sliding from strong to only-just-green for four months is a warning; a red that has been climbing back is a success in progress. A compact twelve-month strip of colour per KPI - red, amber and green reading left to right - shows the direction of travel next to the current value, so the review talks about momentum rather than a single snapshot.

• Cap it near ten. Every KPI you add past that dilutes the ones that matter. If a new one earns its place, retire an old one.
• Agree the definitions once. Half the arguments in a review are two people measuring "on-time" differently. Write the definition into the sheet so everyone measures the same thing.
• Set green and amber thresholds deliberately. A target you can defend turns a colour from decoration into a decision.
• Enter clean actuals and let the board do the rest. The value of a dashboard is that the RAG, the YTD and the trend update themselves - your job is the numbers going in and the decisions coming out.

A dashboard earns its place on the wall when a leader can trust every colour at a glance - which means direction-aware RAG, a YTD that knows sum from average, and few enough numbers that each one still means something.

Do that and the monthly review changes character. Instead of ten minutes spent arguing about whether a number is really red, the conversation goes straight to the two that are, and what to do about them. That is a dashboard leaders read - because it never wastes their trust.