It is Monday, half past eight. The garage is not open yet. The owner has three browser tabs open: the online booking calendar, the accounting package, and a spreadsheet he updates on Sunday evenings. He wants to know one thing — was last week a good week? — and twenty minutes later he mostly has a feeling.

That is not a data problem. It is a question problem. Before a dashboard is worth building, you need to know which numbers you would genuinely use to change something.

A number you would never act on is decoration

Test each candidate with one sentence: if this moves a fifth up or down, what do I do differently?

"Website visitors" nearly always fails that test. A restaurant changes nothing because visits fell twelve per cent. But "reservations for next week, compared with the same day last week" decides whether you bring in an extra pair of hands on Saturday.

Keep the numbers where you can finish the sentence. Park the rest. You can revisit them once you know you actually read the first five.

Five numbers that fit most small businesses

These are starting points, not a prescription. Name yours in your own words — the words you would use on the phone.

Work coming in. Enquiries, reservations, bookings, quote requests. Count them all in one place, whatever the channel: phone, form, WhatsApp, someone at the door.

How much of it becomes work. Of ten enquiries, how many turned into a paying job. One fraction, once a week.

Capacity used. Booked hours against available hours, covers against seats, ramps against opening days. This is the number that tells you whether being busy also paid.

Average order value. Turnover divided by number of jobs. Slow movement here says more than one full week does.

Money still outstanding. What has been invoiced and not paid, and how old the oldest unpaid item is.

Five is deliberate. Three is too thin to understand a week; twelve means nobody reads it. Notice what is absent, too: none of this needs new software. Four of the five already sit in your booking system and your accounting package.

Start with a weekly email, not a dashboard

In our experience the first version belongs in your inbox on Monday morning, five lines long, with nothing to log into. A dashboard you have to remember to open is a dashboard you look at for two weeks.

So the honest first version is this: someone sits down for fifteen minutes on Friday and puts five numbers into the same email template. Yes, by hand. That has two benefits. You find out within a month whether you really read it. And you discover which of the five is genuinely hard to pull out of the systems — that is exactly the number automation has to solve, and now you know it before paying for anything.

Put last week's figure next to each one. A number without a comparison is a pub quiz answer. Two columns and an arrow up or down is enough.

When a dashboard earns its keep

There are three signals. More than one person needs the same numbers and you would rather not be the source. You would look more than once a week — kitchen and floor, workshop and front desk. Or the numbers come from three or more systems and the copying costs you more than half an hour a week.

There is a quieter fourth signal: the manual email has run long enough that you know the definitions will not change next month. Definitions are the real work. Does a cancelled reservation count? A no-show? Is a job "in" at the enquiry or at the confirmation? Two people with different answers, and the dashboard becomes a debate instead of a decision.

After that, keep it on one screen. No scrolling, no tabs, no date pickers. Five numbers, last week beside them, and the time of the last refresh — so you can see whether you are looking at today or at something that has been frozen since Tuesday.

What to do this week

  • Write five numbers on paper and finish the sentence for each: if this moves a fifth, I do this differently.
  • Block fifteen minutes on Friday and send yourself the first weekly email, with last week's figures alongside.
  • After four weeks, cross out what you never used, and note which number was hardest to collect.

When you are ready to turn that email into something that reads your calendar and accounts on its own, we at ITSysPro are happy to spend half an hour on it with you — starting with the five numbers, not the technology.