15 Sales KPIs Every Business Should Track (With Formulas)
The 15 sales KPIs that matter most, what each one tells you, the formula to calculate it, and how to put them on one sales dashboard.
Sales teams can measure hundreds of things. These 15 KPIs are the ones that actually help you decide what to do next. We've grouped them into results, pipeline, efficiency and customers, with a formula for each.
Results KPIs: did we sell enough?
| KPI | Formula | Why it matters |
|---|---|---|
| 1. Revenue | Sum of sales value in the period | The headline number everyone asks about |
| 2. Revenue growth | (This period − Last period) ÷ Last period | Shows direction, not just size |
| 3. Quota attainment | Revenue ÷ Target | Tells you early whether the month is on track |
| 4. Gross margin on sales | (Revenue − Cost of goods) ÷ Revenue | Separates profitable sales from busy ones |
Revenue alone can hide problems. A month of high revenue with falling margin often means heavy discounting.
Pipeline KPIs: will we sell enough next month?
| KPI | Formula | Why it matters |
|---|---|---|
| 5. Pipeline value | Sum of open deal values | The raw material for future revenue |
| 6. Weighted pipeline | Sum of (Deal value × Win probability) | A more realistic forecast |
| 7. Pipeline coverage | Pipeline value ÷ Remaining target | Below 3× usually means the target is at risk |
| 8. New deals created | Count of deals opened in the period | A leading indicator of next quarter |
Efficiency KPIs: how well are we selling?
| KPI | Formula | Why it matters |
|---|---|---|
| 9. Win rate | Deals won ÷ (Deals won + Deals lost) | Measures selling skill and lead quality |
| 10. Average deal size | Revenue ÷ Deals won | Shows whether you are moving up-market |
| 11. Sales cycle length | Average of (Close date − Created date) | Longer cycles tie up the team |
| 12. Activities per rep | Calls + meetings + demos ÷ Reps | Effort, best read next to win rate |
Customer KPIs: are customers coming back?
| KPI | Formula | Why it matters |
|---|---|---|
| 13. New customers | Count of first-time buyers | Growth from outside your base |
| 14. Repeat purchase rate | Customers with 2+ orders ÷ All customers | Cheaper growth than new acquisition |
| 15. Customer acquisition cost | Sales and marketing cost ÷ New customers | Tells you what growth really costs |
Which ones should go on your dashboard?
You don't need all 15 on one screen. A practical sales dashboard shows:
- KPI cards: revenue, quota attainment, win rate, average deal size.
- Trend chart: revenue by month against target.
- Breakdown: revenue by region, product or salesperson.
- Pipeline view: weighted pipeline and coverage for the next month.
Keep the rest on a second page for the weekly review.
Tips for accurate sales KPIs
- Define "won" once. Decide whether a deal counts when the contract is signed, the invoice is raised or the payment arrives, and use it everywhere.
- Compare like with like. Compare this month with the same month last year when your business is seasonal.
- Watch the ratio, not just the count. Ten more deals means little if the win rate fell.
Use a ready-made sales dashboard
Kpiloom sales dashboards include revenue, deals won, win rate, average deal size, pipeline value, sales cycle, quota attainment and new customers, with the formulas already written. Pick your platform: Excel, Google Sheets, Power BI or Looker Studio. There are versions for retail, real estate and 51 other industries.
Frequently asked questions
What is the most important sales KPI?
Revenue against target (quota attainment) is the most watched, but win rate and pipeline coverage tell you earlier whether you will hit it.
How do I calculate win rate?
Divide deals won by all closed deals (won plus lost) in the same period. Leave out deals that are still open.
How often should sales KPIs be reviewed?
Most teams check revenue and pipeline weekly and review the full set monthly.
Skip the build. Start with a ready dashboard.
Templates for Excel, Google Sheets, Power BI and Looker Studio, with live previews.