IGrowth & StrategyGuide
Sales KPIs for Small Businesses: Five Numbers Every Owner Should Know
Close rate, pipeline value, quote time, customer value, and repeat purchase rate: what they tell you and how to track them without a big system.
Key takeaways
- Five metrics are enough to steer the sales of a small business.
- Each of them can be tracked in a spreadsheet. A CRM is not a prerequisite.
- The trend from month to month matters more than the exact value.
- Every metric points to a spot in the sales process. That is where you act, not on the number itself.
Why is revenue alone not enough as a metric?
Revenue shows what went well in sales weeks or months ago. It says nothing about what is going wrong right now. If you only watch revenue, you notice a problem once it has already reached your bank account. By then the causes are long past: the inquiries that sat idle in spring, the quotes nobody followed up on.
Practitioners therefore distinguish two kinds of numbers. A lagging indicator measures a result that can no longer be changed, such as revenue or profit. A leading indicator measures something that precedes the result and that you can still influence, such as the number of open quotes. Sales KPIs (key performance indicators) are leading indicators. They show whether enough quotes are out, how many of them become orders, and how long that takes.
For a small business, five numbers are enough. Together they form the Five-Number Compass: three of them look ahead at new business, two look at the existing customer base. You need nothing more to see which direction your sales is heading. The central question, then: which metrics does a small business need to steer its sales, and how does it collect them? To answer it, we first present the five numbers, work through them in an example, show how to collect them without a CRM, and finally turn to what trends and typical patterns tell you.
Revenue is the rearview mirror. You can only steer with the numbers that come before it.
The Five-Number Compass: which sales KPIs do I need?
| Metric | Formula | Answers the question | Data source |
|---|---|---|---|
| Close rate | Accepted quotes ÷ decided quotes | How many quotes become orders? | Quote list |
| Pipeline value | Sum of all open quotes in euros | How much order volume is in progress? | Quote list |
| Quote time | Days from inquiry to quote and from quote to decision | How fast do we work, and how fast does the customer decide? | Quote list |
| Customer value | Revenue per customer over the entire relationship | What is a won customer worth? | Accounting |
| Repeat purchase rate | Customers who bought again ÷ all customers of the previous year | Do customers come back? | Accounting |
1. Close rate
The close rate tells you what share of your quotes turns into an order. Calculate with decided quotes, meaning those that were followed by a yes or a no. Open quotes do not belong in the calculation, otherwise the rate drops in every month in which you quote a lot. Also track the rate by value: if you win many small orders and lose the big ones, your rate looks good by count and weak in euros.
2. Pipeline value
Pipeline is the term for your stock of ongoing sales opportunities. The pipeline value is the sum of all open quotes in euros. It shows what you will live on in the coming months. It only becomes meaningful together with the close rate: open quotes worth 200,000 euros mean roughly 60,000 euros of expected order intake at a rate of 30 percent. Only count quotes for which a next contact has been agreed. Everything else inflates the number.
3. Quote time
Quote time consists of two stretches. The first runs from the inquiry to the quote being sent and is entirely in your hands. The second runs from the quote to the customer’s decision and depends on how consistently you follow up. Measure both separately in days. In many businesses the first stretch is the fastest lever because it depends solely on your own workflow.
4. Customer value
Customer value is the revenue a customer brings over the entire relationship. To start, the average is enough: total revenue of the last three years divided by the number of customers in that period. The number answers a question that is otherwise decided by gut feeling: how much time and money may winning a new customer cost? It gets more precise if you use the contribution margin instead of revenue, meaning revenue minus the costs caused directly by the order.
5. Repeat purchase rate
The repeat purchase rate shows how many customers buy again within a year. It is the most honest verdict on your work, because here customers vote with their money. A falling rate is an early warning of problems in delivery or in the care after the order. In project business with infrequent purchases, you can instead count the share of customers who refer you or ask about a follow-on order.
How do I calculate the metrics? A worked example
A fictional business with twelve employees serves as the example. All numbers are freely chosen. Last quarter, 60 inquiries came in and turned into 40 quotes. Of these, 30 have been decided and 9 became orders. 10 quotes worth a combined 150,000 euros are still open.
- Inquiries
- Quotes67% of previous stage
- Decided quotes75% of previous stage
- Orders30% of previous stage
Worked example with freely chosen numbers. Close rate: 9 ÷ 30 = 30 percent.
Worked example
These four values alone tell a story. Around 45,000 euros can be expected from the open pipeline. If the business needs 120,000 euros of new orders per quarter, something is missing, and that is visible today rather than three months from now. The eight days until the quote also show where things jam: more than a week passes before the customer has anything in hand at all.
How do I track sales KPIs without a CRM?
To start, a spreadsheet with one row per quote is enough. Five columns yield close rate, pipeline value, and quote time automatically. Customer value and repeat purchase rate are already in your accounting. You only need to have them pulled once a year.
| Customer | Inquiry on | Quote on | Amount | Status | Decision on |
|---|---|---|---|---|---|
| Customer A | Sep 2 | Sep 5 | €12,000 | won | Sep 19 |
| Customer B | Sep 4 | Sep 16 | €30,000 | open | · |
| Customer C | Sep 9 | Sep 12 | €8,000 | lost | Oct 10 |
| Customer D | Sep 15 | Sep 24 | €18,000 | open | · |
Worked example
Pick a fixed day
Compile the values once a month, always on the same day, for example the first Monday. A fixed rhythm beats any elaborate analysis that happens only twice.
Keep the list current
Every quote is entered on the day it is sent, every decision on the day it is made. Five minutes a week are enough.
Write the five values on one sheet
One month per row, the five metrics as columns. This sheet is your compass.
Read it after three months
With three values you have a line instead of a dot. Only the line tells you something.
Why does the trend matter more than the single value?
In small businesses, metrics fluctuate heavily. With ten decided quotes a month, a single order changes the close rate by ten percentage points. A single monthly value is therefore almost worthless. What is meaningful is the direction over several months, or a rolling average over three months.
Worked example: no single month looks dramatic. Only the line shows that the duration has doubled within six months.
The example shows why you need a line. From month to month only one day is added, and nobody in the business would notice. Over half a year, the customer’s waiting time has more than doubled. The cause is not in the number. It lies in the workflow: perhaps only one person still does the calculations, perhaps the quotes have become more elaborate. The metric tells you where to look.
What do I conclude from the numbers? Four typical patterns
Metrics are not an end in themselves. Each one points to a spot in the sales process. The following overview helps you get from the number to the cause.
| Pattern | Likely cause | First step |
|---|---|---|
| Many quotes, low close rate | You quote too early or to the wrong people. | Clarify need, budget, and decision-maker before quoting. |
| Good rate, little pipeline | You lack conversations, not persuasiveness. | Build a second source of inquiries. |
| Long time until the quote | Quoting depends on one person or starts from zero every time. | Introduce building blocks and a fixed deadline. |
| Long time until the decision | Nobody follows up after the quote. | Agree the follow-up date during the conversation. |
| Falling repeat purchase rate | Delivery does not keep what sales promised. | Review the handover from sales to delivery. |
It is striking that almost every cause is a workflow and not a talent. A long quote time is nearly always a process issue and often the fastest lever. That is why metrics and process belong together: the number shows the spot, the process is the repair. If you only measure without changing the workflow, you end up with tidy spreadsheets and the same revenue.
Numbers as control
- Metrics are requested when revenue is bad.
- Each value is commented on individually.
- The question is: who is to blame?
- The team dresses up the list.
Numbers as a compass
- Metrics are compiled on the same day every month.
- The line over several months is what gets looked at.
- The question is: where in the workflow does it come from?
- The team maintains the list because it helps them.
When is a CRM worth it for reporting?
A spreadsheet reaches its limits once several people write quotes at the same time, more than about thirty cases are open, or you need reports by source, product, and salesperson. Then a CRM is worth it, meaning software for managing contacts and sales opportunities. It calculates the metrics continuously and reminds you of steps that are due.
The switch is easy if the spreadsheet worked beforehand. Then you know which fields you need, which stages your sales has, and which five numbers belong on the dashboard. If you start with the software instead, you are offered fifty metrics and end up reading none.
How to get started
Getting started takes less than two hours. Afterwards you have a baseline against which every future month can be compared.
- Set up the quote list: customer, inquiry on, quote on, amount, status, decision on.
- Enter all quotes from the last three months.
- Calculate close rate, pipeline value, and both stretches of quote time.
- Ask your tax advisor or bookkeeper for two numbers: average revenue per customer and the share of last year’s customers who bought again.
- Put a fixed monthly date in your calendar on which you update the five values.
- Pick the metric with the most conspicuous value and look at the matching spot in your workflow.
Nothing more is needed to start. After three months you have your compass, and decisions about advertising, staff, and prices rest on numbers instead of impressions.
Back to the opening question: a small business steers its sales with five numbers, three for new business and two for the existing customer base, and it collects them with a simple quote list and two figures from bookkeeping. The compass becomes meaningful only over several months, because the trend shows more than a single value. Revenue remains important, but it only confirms what these five numbers signaled earlier.
Frequently asked questions
Which sales KPIs matter most for small businesses?
Five metrics are enough: close rate, pipeline value, quote time, customer value, and repeat purchase rate. The first three show how new business is going, the last two how solid the customer base is. All five can be tracked with a quote list and your accounting.
How do you calculate the close rate?
Divide the number of accepted quotes by the number of decided quotes in a period. Do not count open quotes. For example, 9 orders from 30 decided quotes give a close rate of 30 percent.
What is a good close rate?
There is no universal value, because the rate depends on industry, order size, and qualification. A business that only quotes after thoroughly clarifying the need naturally has a higher rate than one that sends everyone a quote. What counts is how your own rate develops over the months.
What does pipeline value mean in sales?
Pipeline value is the sum of all open quotes in euros. Multiplied by the close rate, it gives a rough preview of order intake in the coming months. Only count quotes for which a next contact has been agreed.
How often should I review sales KPIs?
Once a month on the same day is enough for most small businesses. Customer value and repeat purchase rate change slowly and only need to be recalculated once a year. Regularity matters more than frequency, because only several values in a row show a trend.
Do I need a CRM to track KPIs?
No. A spreadsheet with one row per quote delivers close rate, pipeline value, and quote time. A CRM pays off when several people write quotes or the number of open cases makes the spreadsheet hard to read.
