Business Growth
Sales KPIs for Small Business: What to Track and How to Calculate Each One
Sales KPIs for small business: the handful of sales metrics worth tracking, the formula for each one, how to tell leading from lagging indicators, how to use sales velocity, a simple weekly scorecard, mistakes to avoid, and a Claude workflow for building your sales dashboard from a spreadsheet export.
AI Educator, AI Tools and Training Club · November 1, 2026 · 8 min read
The short version
- A sales KPI is a number you check regularly to see whether your sales effort is on track. A small business needs a handful of them, not a dashboard of thirty.
- Track a mix of leading indicators you control, like new conversations and proposals sent, and lagging indicators that show results, like revenue, win rate, and average deal size.
- Pick one person to update the numbers, review them at the same time every week, and use them to decide one thing to change. A KPI nobody acts on is just decoration.
Which sales KPIs should a small business track?
A small business should track a short list of sales KPIs that cover the whole path from first conversation to closed deal: how many new opportunities you create, how many you win, how much each deal is worth, how long deals take to close, and how much revenue you bring in against your target. Those five numbers tell you whether you have a pipeline problem, a closing problem, a pricing problem, or a speed problem.
My strong opinion: if you are a small team, tracking fewer numbers well beats tracking many numbers badly. Start with five, look at them every week, and only add a new one when a real question comes up that the five cannot answer.
Leading vs lagging sales KPIs
Lagging indicators tell you what already happened, such as revenue closed last month. They matter, but by the time you see them it is too late to change them. Leading indicators measure the activity that drives future results, such as new conversations started this week. You can change those today.
| Type | Examples | What it tells you |
|---|---|---|
| Leading | New opportunities created, discovery calls held, proposals sent, follow-ups completed | Whether enough activity is happening to hit next month's number |
| Lagging | Revenue closed, win rate, average deal size, sales cycle length | Whether that activity is turning into results |
Leading and lagging sales KPIs
Watch both. If revenue is down but leading numbers are healthy, the problem is usually in closing or pricing. If leading numbers are down, revenue will follow, and the fix is more prospecting. How to Do Sales Prospecting covers a simple weekly system for that.
The core sales KPIs and how to calculate them
| KPI | How to calculate it | What it tells you |
|---|---|---|
| Revenue vs target | Revenue closed in the period compared with your goal for that period | Whether you are on track overall |
| New opportunities | Count of qualified prospects who entered your pipeline in the period | Whether you are filling the top of the pipeline |
| Win rate | Deals won divided by total opportunities that reached a decision | How well you close |
| Average deal size | Total value of deals won divided by the number of deals won | Whether your pricing and packaging are working |
| Sales cycle length | Average number of days from first contact to closed deal | How long cash takes to arrive after a conversation starts |
| Pipeline value | Total value of all open opportunities | How much revenue could close soon |
| Customer acquisition cost | What you spent on sales and marketing in a period divided by new customers won in that period | Whether each new customer is worth what it cost to win |
Core sales KPIs for a small business
How to use sales velocity
Sales velocity pulls four of the core KPIs into one number that shows how fast your pipeline turns into revenue. The formula is the number of opportunities, multiplied by average deal size, multiplied by win rate, divided by sales cycle length in days. The result is roughly how much revenue your pipeline produces per day.
Here is an illustrative example, not a benchmark. Say you have 20 open opportunities, an average deal size of $3,000, a win rate of 25 percent, and a 30 day sales cycle. That is 20 times $3,000 times 0.25, divided by 30, which comes to $500 a day.
The value of the formula is that it shows you four levers. You can raise velocity by creating more opportunities, raising your average deal size, improving your win rate, or shortening your cycle. Most small businesses find the cheapest lever is the sales cycle: faster follow-up and clearer next steps. How to Build a Sales Cadence helps with exactly that.
A simple weekly sales scorecard
Put this in a spreadsheet. One row per week, one column per KPI, and a short notes column for what you decided to change.
| Week | New opportunities | Proposals sent | Deals won | Revenue closed | Win rate | Notes and next action |
|---|---|---|---|---|---|---|
| Week 1 | ||||||
| Week 2 | ||||||
| Week 3 | ||||||
| Week 4 |
Weekly sales scorecard template
Win rate and average deal size jump around a lot week to week when deal counts are small. Look at them monthly or over a rolling few months, and use the weekly view mainly for leading numbers. Tie the scorecard back to your targets using How to Set Sales Goals.
How to pick the right KPIs for your business
- Start from your goal. If the goal is more revenue, track the KPIs that feed it. If the goal is better clients, track average deal size and win rate on your best-fit customers.
- Match your sales process. If you sell with proposals, track proposals sent and proposal win rate. If you sell through calls, track calls held. How to Create a Sales Process for a Small Business helps you map the stages first.
- Prefer numbers you can collect without effort. If a KPI takes an hour to calculate every week, it will stop getting calculated.
- Track recurring revenue differently. If you sell subscriptions or memberships, add retention or renewal numbers, because a new customer who leaves quickly is not really a win.
Sales KPI mistakes to avoid
- Tracking so many numbers that nobody looks at any of them.
- Only tracking revenue, so you find problems a month too late.
- Counting every lead as an opportunity, which makes win rate look terrible and pipeline value look huge. How to Qualify Sales Leads helps you draw that line.
- Changing definitions halfway through the quarter.
- Drawing big conclusions from a few deals. With small numbers, one lucky or unlucky week can swing a rate a long way.
- Reviewing the numbers without deciding on a single next action.
How to build your sales KPI dashboard with Claude
Claude is good at turning a messy export into clean KPIs and at spotting what changed since last week. Use the Claude desktop app with a spreadsheet or CRM export.
- Export your deals to a spreadsheet with the date created, date closed, stage, value, and outcome for each.
- Paste in your written KPI definitions so Claude calculates them the same way every time.
- Ask Claude to calculate each KPI for the last few weeks and show the trend, and to list any rows with missing dates or values instead of guessing.
- Ask it which single KPI moved the most and what the likely causes are, based only on the data you gave it.
- Decide on one change for the coming week and write it in your scorecard notes.
If you want to project future revenue from these numbers, How to Use AI for Sales Forecasting builds on the same data.
Frequently asked questions
What are the most important sales KPIs for a small business?
Start with revenue against target, new opportunities created, win rate, average deal size, and sales cycle length. Together they show whether a shortfall comes from too few opportunities, weak closing, low prices, or slow deals.
How do you calculate win rate?
Divide the number of deals won by the total number of opportunities that reached a decision in the same period. Decide in advance how you treat deals that went quiet, and keep that rule consistent.
What is the sales velocity formula?
Sales velocity equals the number of opportunities, multiplied by average deal size, multiplied by win rate, divided by the length of your sales cycle. It estimates how much revenue your pipeline produces per day or per period.
What is the difference between leading and lagging sales indicators?
Leading indicators measure activity that drives future sales, such as new conversations or proposals sent. Lagging indicators measure results that already happened, such as revenue closed or win rate.
How often should you review sales KPIs?
Review leading indicators weekly so you can adjust activity quickly. Review rates like win rate and average deal size monthly or over a rolling period, because they swing a lot when deal counts are small.