Reporting & Forecasting
12 Sales KPIs Every Sales Manager Should Track (With Formulas)
A KPI is only useful when everyone calculates it the same way. Here are twelve, each with its formula, the record it reads and how to interpret it, plus the five that earn a slot in the weekly pipeline review.
Key takeaways
- A sales metric becomes a KPI when it has a target, an owner and a formula two people can calculate to the same number.
- Pair every lagging KPI with the leading one that feeds it: quota attainment with pipeline coverage, win rate with next-step coverage.
- Win rate counts closed deals only, won ÷ (won + lost); open deals in the denominator make it look worse than it is.
- The weekly pipeline review needs five numbers: quota attainment to date, pipeline coverage, new pipeline created, next-step coverage and close dates pushed this week.
- Read win rate, deal size, cycle length and sales velocity monthly, because one week on a small team is too few closed deals to mean anything.
The 12 sales KPIs a sales manager should track are pipeline coverage, new pipeline created, lead-to-deal conversion, first meetings held, next-step coverage, quota attainment, win rate, average deal size, sales cycle length, close-date slippage, forecast accuracy and sales velocity. Nearly every input comes from the lead, deal and activity records in a CRM such as Senitix CRM.
The first five are leading indicators you can still act on, the next six are lagging indicators that explain the result, and sales velocity combines four inputs into expected revenue per day.
What is the difference between sales KPIs and sales metrics?
Sales metrics are every number your selling produces: calls logged, deals created, quotes sent. A metric becomes a KPI when it has a target, one person answers for it, and its formula is precise enough that two people calculating it get the same number.
Sales performance metrics that fail that last test turn the weekly review into an argument about definitions. Customer acquisition cost and lifetime value are left out here because they need cost and revenue data from finance that a CRM does not usually hold; for how CRM records connect from lead to deal, see our guide to what a CRM is.
Leading vs. lagging: which sales KPIs predict the quarter?
A leading indicator moves before the result, while there is still time to change it. A lagging indicator is final once the period closes: accurate, but too late to act on. Revenue booked last quarter is lagging; open pipeline closing this quarter is leading.
The test: can this number still change the current period’s outcome? Pair every lagging KPI with the leading one that feeds it, such as quota attainment with pipeline coverage, so a miss arrives with a warning attached.
The 12 KPIs at a glance: formula, data source and cadence
Copy this table into the document where your team defines its sales KPIs; the third column names the record and fields each input is read from.
| KPI | Formula | Data source in the CRM | Cadence |
|---|---|---|---|
| 1. Pipeline coverage (leading) | Open pipeline closing this period ÷ quota still to close | Deal: amount, close date, stage; quota | Weekly |
| 2. New pipeline created (leading) | Count and total amount of deals created in the period | Deal: created date, amount, owner | Weekly |
| 3. Lead-to-deal conversion (leading) | Leads converted to deals ÷ all leads, same creation cohort | Lead: created date, status, source | Monthly |
| 4. First meetings held (leading) | Completed first meetings per rep per week | Activity: type, status, owner, date | Weekly, per rep |
| 5. Next-step coverage (leading) | Open deals with a future-dated activity ÷ all open deals | Activities linked to each open deal | Weekly |
| 6. Quota attainment (lagging) | Closed-won amount ÷ quota for the same period | Won deals: amount, close date; quota | Weekly, to date |
| 7. Win rate (lagging) | Deals won ÷ (deals won + deals lost) | Deal: won or lost outcome, close date | Monthly |
| 8. Average deal size (lagging) | Closed-won amount ÷ number of won deals | Won deals: amount, one currency | Monthly |
| 9. Sales cycle length (lagging) | Total days from created to won ÷ number of won deals | Won deals: created date, close date | Monthly |
| 10. Close-date slippage (lagging) | Deals pushed out of the period ÷ deals due in it at the start | Weekly snapshot of close dates | Weekly count, quarterly rate |
| 11. Forecast accuracy (lagging) | 1 − (|forecast − actual| ÷ actual) | Forecast snapshot; won amount | Quarterly |
| 12. Sales velocity (combined) | (Qualified open deals × average deal size × win rate) ÷ cycle length in days | KPIs 7, 8, 9 and open deals | Monthly |
Five leading sales KPIs that warn you mid-quarter
1. Pipeline coverage
Formula: open pipeline with a close date in the period ÷ quota still to be closed in the period.
The often-quoted 3x is a rule of thumb. The coverage you need is roughly the inverse of your win rate by value: if one dollar in four closes, you need about four dollars of pipeline per dollar of quota left. Coverage sitting mostly in the first stage is weaker than it looks.
2. New pipeline created
Formula: the number and total amount of deals created in the period.
It decides next quarter: with a 60-day cycle, a thin week of deal creation today becomes a coverage gap two months from now. The FAQ below shows how to set a weekly target.
3. Lead-to-deal conversion rate
Formula: leads created in a given month that later became deals ÷ all leads created that month.
Measure by creation cohort, not by the month the conversion happened; otherwise a large list import in March inflates April. Split the rate by lead source to see which channels produce deals rather than names.
4. First meetings held
Formula: completed first meetings per rep per week.
Count meetings held, not calls logged: meetings are harder to inflate and sit closer to pipeline. If your CRM lets an admin define activity types, give first meetings their own type so they do not vanish among follow-ups.
5. Next-step coverage
Formula: open deals with at least one future-dated activity ÷ all open deals.
A deal with nothing scheduled is not being worked, whatever its stage says. The deals that fail this test are the first item on a pipeline review’s agenda.
Six lagging sales KPIs that explain the result
6. Quota attainment
Formula: closed-won amount in the period ÷ quota for the same period.
Read the distribution, not just the total: a team at 100% carried by two reps far above target is hiding a pipeline problem. Track the share of reps at or above quota beside it.
7. Win rate
Formula: deals won ÷ (deals won + deals lost), for deals closed in the period.
Example: a team with 40 won, 60 lost and 100 still open has a 40% win rate, not 20%, because open deals do not belong in the denominator. Decide once whether deals disqualified in the first stage count as lost, and compare win rates only under that rule. Our article on calculating win rate covers the other denominator decisions and the dollar version.
8. Average deal size
Formula: total closed-won amount ÷ number of won deals, in a single currency.
One large deal can move the average by itself, so read the median next to it. For subscription deals, state whether the amount is annual contract value (ACV) or total contract value (TCV); mixing the two makes the number meaningless.
9. Sales cycle length
Formula: the sum of days from deal created to deal won ÷ number of won deals.
Measure lost deals on a separate line: they tend to die slowly, and mixed in they stretch the average. Compare by segment as well: a $15,000 deal and a $150,000 deal do not share a timeline.
10. Close-date slippage
Formula: deals due in the period when it began that were later pushed beyond it ÷ all deals due in the period when it began.
It needs a weekly snapshot of open deals and close dates. A pushed close date is a forecast change even when nobody announces it, so count the week’s pushes in the weekly review and the rate at quarter end.
11. Forecast accuracy
Formula: 1 − (|forecast − actual| ÷ actual), with the forecast taken on a fixed date, such as the first day of the quarter’s second month.
Without a fixed snapshot date, the forecast drifts toward the actual and accuracy looks perfect. Track the direction of the miss too: always landing below forecast is an optimism pattern, not bad luck.
Sales velocity: the KPI built from four inputs
Formula: (qualified open deals × average deal size × win rate) ÷ sales cycle length in days, which gives expected revenue per day. It only works when each input uses the same definition as its own KPI.
Example: a 12-rep B2B SaaS team in Austin has 180 qualified open deals, a $30,000 average deal size, a 24% win rate and a 62-day cycle. Velocity is 180 × $30,000 × 0.24 ÷ 62, or about $20,900 a day. With 56 days left in the quarter, that points to roughly $1.17 million against $1.38 million of quota still to close.
The gap tells the manager which lever to pull: more qualified deals, a higher win rate, larger deals or a shorter cycle. Velocity is a throughput estimate, not a forecast; it assumes the coming weeks behave like the past ones. Our sales velocity walkthrough shows which lever is cheapest to pull.
Which 5 sales KPIs belong in a weekly pipeline review?
A weekly pipeline review needs one scoreboard and four early warnings:
- Quota attainment to date, which also gives coverage its denominator.
- Pipeline coverage for this quarter and the next.
- New pipeline created this week, against the weekly target.
- Next-step coverage, with the named list of deals that fail it.
- Close dates pushed this week, deal by deal, with the owner’s reason.
Win rate, deal size, cycle length and velocity belong in the monthly review, since a 12-rep team closes too few deals in a week for them to mean much; forecast accuracy is quarterly.
Example: in week 5 of 13, the Austin team has closed $420,000 against a $1.8 million quarterly quota. Its $3.9 million of pipeline closing this quarter covers the remaining $1.38 million 2.8 times, while a 24% win rate calls for about 4.2. That sets the agenda: the coverage gap first, then the 31 open deals with no next step, then the six close dates that moved since last Monday.
What mistakes make sales KPIs misleading?
- Changing a definition mid-year. If “qualified” moves from the first stage to the second, restate the history, or the trend line records a policy change rather than a performance change.
- Rewarding activity volume. A target on calls logged produces more logged calls. Tie activity KPIs to outcomes such as meetings held.
- Trusting a stage without evidence. A deal in a proposal stage with no proposal sent inflates every stage-weighted number. Agree what must be true at each stage and check it in the review.
- Skipping the baseline. Rolling out a new CRM? Take a first reading of each KPI before go-live; our guide to CRM benefits explains how.
How to track these KPIs in Senitix CRM
In Senitix CRM, deals move through your own stages on a list or a Kanban board, each with an amount, a close date, a probability and an owner. Qualifying a lead creates the contact, the account and the deal in one step, so conversion is countable. Tasks, calls and meetings are logged against the deal they belong to with a due date, which is what next-step coverage reads. Each stage can show guidance text and up to five key fields, so reps see what the team agreed must be true before a deal moves on; nothing blocks the move.
Reports are built from templates on standard and custom fields, respect each user’s permissions, and can be exported or delivered on a schedule, so a weekly report of open deals and their close dates becomes your slippage snapshot. Dashboards are assembled from saved reports, and how many of each a workspace can build grows with the plan. Where the categorized forecast grid is available, it rolls open deals up by forecast category against each rep’s quota, keeps a manager’s adjustment separate and compares forecast with actual. See reports, dashboards and forecasts in Senitix CRM, and plan details on the pricing page.
You can get started with no credit card and no time limit, and build your first KPI report on real deals.
Frequently asked questions
How many sales KPIs should a sales team track?
Track all twelve, but not in one meeting. Five belong in the weekly pipeline review, first meetings belong in each rep’s one-on-one, and the rest are read monthly or quarterly. Before adding a thirteenth, retire one: every number on the agenda needs an owner who can explain a change in it, and a meeting with more numbers than time discusses none of them well.
Should SDRs and account executives track the same sales KPIs?
No. SDRs own the top of the funnel, so their KPIs are leading ones: first meetings held and lead-to-deal conversion for the leads they work. Account executives own what happens after qualification: pipeline coverage, next-step coverage, win rate and quota attainment. Sharing one team KPI, such as new pipeline created, keeps the handoff between the two roles honest.
How do you set a weekly target for new pipeline?
Work backward from quota. Divide the quarter’s quota by your win rate to get the pipeline you must create, then divide by the weeks available. Example: a $1.8 million quota and a 24% win rate need $7.5 million of new pipeline, about $577,000 a week over 13 weeks. Start counting one sales cycle before the quarter begins, because pipeline created late cannot close in time.
Can you track sales KPIs in a spreadsheet instead of a CRM?
For a few weeks, yes. But a spreadsheet only holds what someone typed in on the day they typed it. It cannot show which close dates moved last week or which deals have nothing scheduled unless someone rebuilds that history by hand. Those are the early warnings, which is why the CRM record, not the sheet, should be the source.
Keep reading
Reporting & Forecasting
What a Sales Dashboard Should Show: A Layout for Sales Managers
The six-tile sales dashboard layout for reps and managers, what each tile answers, and the drill-down rule that keeps every number checkable.
Reporting & Forecasting
Sales Velocity Formula: A Worked Example and the Lever That Moves It
The sales velocity formula worked through one example, a 10% sensitivity test on each factor, and why blending two pipelines inflates the result.
Reporting & Forecasting
How to Calculate Sales Win Rate (and Why Yours Is Probably Overstated)
The win rate formula is easy; the denominator is not. Which deals count, count vs. dollar win rate, cohort vs. period, and one pipeline worked three ways.
Ready to grow with Senitix?
Connect with customers, win more deals and grow repeat business, all on one platform.
No credit card required.
