Sales KPIs: What to Measure and How to Report It

The sales KPIs worth measuring fall into two groups: results (revenue, win rate, deal size) and pipeline health (pipeline coverage, sales cycle length, activity). Results tell you what happened; pipeline KPIs tell you what is about to happen. A good sales report shows both, briefly, every week.

Result KPIs: what closed

Win rate is best calculated only on deals that reached a decision. Leaving open deals in the denominator makes win rate look worse early in the month and better later, which is noise.

Pipeline KPIs: what is coming

Worked example: a four-person sales team

Say your B2B team has a quarterly target of R1.2 million. Halfway through the quarter, it has closed R480,000 from 12 deals and lost 18. There are 40 open opportunities worth R2.1 million, and the average won deal took 45 days.

• Revenue vs target: R480,000 ÷ R1,200,000 = 40% at the halfway mark (behind pace).
• Win rate: 12 ÷ (12 + 18) = 40%
• Average deal size: R480,000 ÷ 12 = R40,000
• Remaining target: R1,200,000 − R480,000 = R720,000
• Pipeline coverage: R2,100,000 ÷ R720,000 = 2.9×
• Sales velocity: (40 × 0.40 × R40,000) ÷ 45 = R14,222 per day

What does it mean? With about 45 days left and velocity of roughly R14,000 a day, the pipeline should produce around R640,000, which is short of the R720,000 needed. Coverage of 2.9× looks healthy, but at a 40% win rate you really need at least 2.5× just to break even on target, so there is little margin for slippage. The action is clear: either add pipeline now or improve win rate on the deals already in play.

Activity KPIs: use them carefully

Calls made, emails sent and meetings booked are leading indicators, and they are useful for coaching new reps. But they are easy to game and weakly linked to revenue once a rep is experienced. Track them to diagnose problems (a rep with a falling win rate and falling meetings has a different issue from one with plenty of meetings and a falling win rate), not as targets in themselves. If your team sells by phone, sales call analysis gives you quality signals that raw call counts miss.

How to structure a weekly sales report

1. Headline: revenue closed to date vs target, and the forecast for period end (weighted pipeline plus closed).
2. Pipeline movement: new opportunities added, deals moved forward, deals lost and why.
3. Conversion: win rate and average deal size, this period vs the last three.
4. By rep or segment: a small table, not a leaderboard. Look for outliers, not rankings.
5. Risks and actions: the three largest deals at risk and what is being done about each.

Keep it to one page. Sales managers who get a 12-tab spreadsheet on a Monday read the first tab and skim the rest. If your data lives in a CRM, see our guide to HubSpot sales reporting, or read how to find trends in sales data for spotting patterns across months.

Common mistakes in sales reporting

• Reporting unweighted pipeline as forecast. A R2 million pipeline is not R2 million of revenue.
• Letting stale deals sit in the pipeline. Anything past twice the average cycle length should be reviewed or closed as lost.
• Changing stage definitions mid-quarter. It breaks every comparison.
• Ignoring lost reasons. They are the cheapest market research you will ever get.

Summarix can pull from HubSpot, Pipedrive or a spreadsheet, calculate these KPIs with its own code and write the narrative around them, then email the report on a schedule. Whatever tool you use, the discipline is the same: consistent definitions, the same format every week, and actions at the end.

Conclusion

Good sales reporting is less about the number of metrics and more about pairing results with pipeline health. Track win rate, deal size, coverage and cycle length alongside revenue, and you will see a shortfall coming weeks before month end, while there is still time to fix it.