A sales dashboard with only seven numbers

Every Monday the owner asks one question, "how much did we book?", and every Monday the answer is a number that explains nothing. A better review uses seven figures that come from dates already in your enquiry record: leads, replies, meetings, quotes, orders, order value and the count of quotes that have gone stale. None needs a formula you have to defend. What turns them into a dashboard is that you read them in pairs, and each pair points at one decision.

Fix the definitions before anyone draws a chart

A number with two meanings is worse than no number, so agree each one in writing.

Set the reply target yourself. A business with calls all day will pick a different figure from one that answers by evening. What matters is that "replied" means a person wrote or spoke about the enquiry, not that an auto-acknowledgement went out. Likewise, "meeting" must have a floor. A shop that logs every two-minute call as a meeting will see a healthy line that means nothing.

Pair one: leads against replies

If leads rise and replies do not, you are paying to bring enquiries to a desk that cannot cope. Do not raise the budget. Fix response first, and the note on where enquiries leak shows how to find the break.

Pair two: meetings against quotes

Many meetings and few quotes means people are talking but nobody asks for the job, or qualifying is too loose. Few meetings and many quotes means quotes are going out as price lists to people nobody has spoken to. Both cases look fine when you watch only quotes.

Pair three: quotes against stale quotes

When orders are thin and the stale count is high, buyers are not saying no. They are saying nothing, and no one is asking. This is the cheapest pair to act on, since the remedy is a phone call.

Pair four: orders against value

A rising order count with falling value means you are winning smaller jobs. That may be fine, or it may be a sign that your larger quotes are failing. The count alone would hide it.

A box plant in Ludhiana

Here is an invented example. A corrugated box plant in Ludhiana sells cartons to hosiery makers and cycle-part exporters, and the owner's review had been "how much did we book", and some weeks were large and some thin, with no reason the owner could name.

With the seven numbers on one sheet, the first surprise was in the meetings column. It was high every week, which made the sales head look busy. When the owner asked what counted, the answer was any call that happened, including a buyer asking where a truck was. After the ten-minute rule went in, meetings halved, and the pair with quotes finally said something: plenty of quotes were going to people nobody had spoken to for ten minutes.

The second finding was the stale column, a long list of quotes for repeat box sizes that nobody had touched. The first reading was that those buyers had gone elsewhere. A salesperson pointed out that some were simply waiting for a new print design to be approved on their side. They agreed one rule: any quote past the limit gets one call, and the answer is written as "waiting on buyer", "lost" or "ordered elsewhere". About half turned out to be waiting, a few had gone elsewhere, and the rest nobody could classify because the original contact had left the buyer's company. The owner stopped reading a quiet week as a bad one, but the unclassified pile showed that contact names were not being kept, which became the next job.

What stays off the page

Everything else can wait. No percentages, no ranking of salespeople, no source breakdown on the front page. A source view is useful, but as a separate sheet you open when leads move. Work out a conversion percentage from two counts when you need one. If you add an eighth item, remove one, or the page stops fitting in one look.

Do not put a target beside each figure until you know your normal range. A target set earlier is a guess, and a team that misses a guess stops believing the sheet.

When seven is the wrong number

If you sell by tender or a few large orders a year, leads and replies mean little. Replace them with tenders reviewed, tenders submitted and tenders awaiting a decision. If you sell the same items on reorder, drop meetings and track repeat orders against buyers who have not ordered in their usual interval.

If a number cannot be counted from your record, do not estimate it. Leave it blank and make filling it the first job; a missing meetings count means meetings are not being logged, which is a finding in itself. The fuller note on how to create a sales dashboard for management covers layout and what to bring to a review.

All seven come from five dates: arrival, first reply, meeting, quote and order. If one is missing from your record, adding it comes before any dashboard. Agreeing the definitions with you is what sales metrics and KPI development covers, and the rest of our sales work sits under sales.

Fill one tab and read it aloud

Make one tab with the seven rows, fill it from the last period of your own records, and read the four pairs aloud at your next sales meeting. If the sheet shows gaps you cannot close alone, tell us what you need.