Sales key performance indicators, and where the numbers come from

What sales key performance indicators are

A sales key performance indicator is a metric used to guide decision-making. It tracks progress toward a named goal, almost always revenue, over a named period, and someone changes what they do when it moves. That second clause is the whole test. Calls logged is a metric; it becomes a KPI in a business where calls reliably become orders, and it stays a reporting metric everywhere else. Our guide on KPI in sales properly breaks down the KPI vs. metric distinction. The short version: every KPI is a metric, and very few metrics deserve the promotion.

Five of the guides ranking for this term in September 2026 count nine, 15, 20, 21, and 25 KPIs apiece. That is 90 KPIs across five articles, most of them defined for organizations with sales managers, RevOps analysts, and rep leaderboards. This article covers 12, sized for teams of one to ten where the owner is also the analyst, and spends its second half on the question those lists settle in a sentence: how any of this gets tracked.

Six fields feed every sales KPI

Every pipeline and conversion KPI on those lists is arithmetic on a handful of fields recorded per deal: when it opened, when it changed stage and to what, when it closed and how, what it was worth, and who worked it. Add one pair recorded per inquiry, when it arrived and when you first replied, and you can compute everything here except customer acquisition cost, which needs your books.

That sounds too obvious to state, which is probably why nobody states it. It matters because the fields are cheap to define and expensive to collect. Anyone can write the win rate on a whiteboard. Getting a close date and an outcome recorded on all 40 deals a small team works on in a quarter, every quarter, is the actual job, and it is the step most KPI programs fail at. Everything downstream, the dashboard included, is only as truthful as these six fields. Get them wrong, and the dashboard is wrong with great confidence.

12 sales KPIs, grouped by the question they answer

Most guides group these by category, revenue here, activity there. Grouping by the question you want answered is more useful because it tells you which numbers to read together.

Are we putting enough in?

New opportunities created per week are the purest leading indicator in sales. Count the deals opened each week, or sum their value; the only field it needs is a created date, which every tool records unasked. A slow two weeks here show up nowhere this month and everywhere next quarter.

Lead response time is the number of minutes from a new inquiry to your first reply. A 2011 Harvard Business Review audit of 2,241 companies found firms replying within an hour were about seven times as likely to qualify the lead as firms that waited even an hour longer. It takes two timestamps, arrival and reply, and it is usually the cheapest number on this list to improve.

Activity volume, calls or meetings per week, earns KPI status only when deals reliably start with a knowable amount of outreach, the way a mortgage broker does. The formula is a count. The weakness is the data: logged activity is the first field people stop maintaining, so an activity KPI is exactly as honest as the logging behind it.

Is the pipeline healthy?

These three are the sales pipeline metrics people usually mean when they say the pipeline needs a look.

Pipeline coverage is the open pipeline value divided by the revenue target still to be closed this period. The folk rule says hold 3x your target. Derive your own instead: the multiple you need is roughly one over your win rate, so at a 25% win rate, you want about 4x. Fields required: deal amounts, stages, and a written target.

Stage-to-stage conversion is the share of deals that enter one stage and make it to the next. It is the number that locates where deals die, at proposal, say, instead of merely confirming that they die. It is also the first KPI here that a spreadsheet cannot produce, because it requires the history of stage changes, whereas a spreadsheet only stores the current stage.

Time in stage is the average number of days a deal spends at each step, and it is used as a stale-deal alarm. Flag anything that has sat still for two weeks and decide whether it becomes a task or a closed loss. Same requirement: stage-change timestamps.

Are the deals converting?

Win rate is deals won as a share of all deals decided either way, wins plus losses. Two warnings: Published sales KPI benchmarks for win rate land anywhere from 15% to 35%, depending on the source, so your own trend is the only benchmark worth keeping. And the ranking guides compute conversion rate against three different denominators: leads currently in the pipeline, all leads for the period, or quotes sent. Pick one denominator, write the definition down, and never move it mid-year.

Sales cycle length is the average number of days from opportunity creation to deal close, which requires both dates for every finished deal. Watch the drift, because cycles stretch when nobody owns the next step. The level sets your planning horizon: on a 60-day cycle, the last month of a quarter is already determined by its first month.

Quota attainment is revenue closed divided by the target, times 100. On a two-person team, it is less a leaderboard and more a monthly honesty check, and it works the same way when the only rep is you. Needs a target somebody wrote down, which is rarer than it sounds.

Was the deal worth it?

The average deal size is revenue won divided by the number of deals won. Movement tells you more than the number itself; sliding sizes usually mean discounts have become routine. Deal size also sets the scale of everything upstream: a $150,000 target is 100 deals at $1,500 each or 10 deals at $15,000 each.

Repeat purchase rate, or retention, is included in the set when revenue depends on the same customers returning. Retention rate is customers at the end of a period, minus any acquired during that period, divided by customers at the start, multiplied by 100. This is also the formula the top guides keep fumbling over: two of the five counted above publish retention as 1 divided by churn, which returns 500% retention on 20% churn. Subtracting churn from 100% gets you the real figure.

Customer acquisition cost is the total sales and marketing spend divided by new customers won, and it earns its slot once you buy advertising. It is the one number here that your CRM cannot compute on its own, because the cost side lives in your books, not your pipeline.

How to track sales KPIs

Asking how to track sales comes down to deciding where those six fields will live. There are three homes.

Memory is the default, and it fails without a sound. Nobody decides to stop tracking; the whiteboard just stops getting updated somewhere around week five.

A spreadsheet is the second home, and for one person, it is a respectable one. If you want a sales KPI template for Excel, here it is in a sentence: one sheet, one row per deal, eight columns holding deal name, contact, amount, stage, created date, close date, outcome, and next step with its date. From those columns, ordinary formulas produce win rate, average deal size, cycle length, quota attainment, and coverage, five of the 12. That column list is the entire template. The downloads vendors' gate behind email forms contain the same eight columns with nicer borders.

What Excel cannot give you is anything built on events instead of states. Overwriting the stage cell destroys the stage history, which forfeits stage conversion and time in the stage. Nothing timestamps your first reply, which forfeits response time. You can add a date column for each stage and ask everyone to fill it in by hand; in my experience, that discipline holds for about three weeks. And the sheet survives only until a second person starts editing it.

So the working rule: a spreadsheet serves one person, one pipeline, and deals in the low dozens. The day you want to know where deals stall, or the day a colleague joins, you have outgrown it. Which CRM to move to is its own decision, and our pipeline management tools guide compares seven of them with verified pricing.

What belongs on a sales KPI dashboard

One screen, or it is a report. Five to seven tiles, each showing the trend against a target instead of a lone number, because 28% means nothing until you can see it was 34% last quarter. Split the reading cadence: the leading tiles, new opportunities, response time, coverage, get a look every Friday; the lagging tiles, win rate, deal size, cycle length, get a monthly one. Give each tile an owner.

The role-based dashboard suites in the enterprise guides, one for the CRO, another for each rep, solve a coordination problem a six-person team does not have. Build one sales KPI dashboard, put it where the team already looks, and let the Friday review start from it. A dashboard nobody opens is wallpaper with a login.

Tracking sales KPIs in a CRM

The reason every guide on this subject ends at a CRM, ours included, is mechanical. Inside one, the six fields record themselves: dragging a card to a new stage writes the timestamp, and closing a deal writes the date, the outcome, and the amount in one motion. The counting stops being homework, and homework is what killed the whiteboard and the sheet. People search for CRM KPIs as if they were a separate species; they are the same 12 numbers with the collection cost removed.

Disclosure first: Bigin is ours, a pipeline-first CRM built for small businesses. Its dashboards pull win rate, time in stage, and stage drop-off straight off the board the team already works in, so most of this article's arithmetic computes itself. The free plan includes 1 user, 1 pipeline, and 500 records; Express, the first paid plan, is $7 per user per month billed annually; figures checked against our own pricing page on September 2, 2026. Run the same check on anyone who quotes you a price, including us.

One customer example, since the list above stays abstract. Eduvisors, an education consultancy, picked a single KPI to fix, lead conversion, used Bigin to make every follow-up systematic instead of remembered, and moved conversion from around 25% to around 30%. Nothing in that story is clever, which is rather the point.

A working set of five to seven

Twelve KPIs are a menu, and a menu is for ordering from. Take five to seven. A defensible starter set for a small team is win rate, average deal size, cycle length, coverage, response time, and new opportunities per week; our KPI meaning guide walks that exact set backward from a revenue goal into weekly targets. Read the leading ones on Fridays and the lagging ones monthly, and change the set at most quarterly. Try Bigin for 15 days, card not required: import the sheet and count how many of the 12 you never compute by hand again.

---

Edited by Anubhav Sarker