Kpiloom
KPIs

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.

By the Kpiloom team · · 3 min read


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?

KPIFormulaWhy it matters
1. RevenueSum of sales value in the periodThe headline number everyone asks about
2. Revenue growth(This period − Last period) ÷ Last periodShows direction, not just size
3. Quota attainmentRevenue ÷ TargetTells you early whether the month is on track
4. Gross margin on sales(Revenue − Cost of goods) ÷ RevenueSeparates 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?

KPIFormulaWhy it matters
5. Pipeline valueSum of open deal valuesThe raw material for future revenue
6. Weighted pipelineSum of (Deal value × Win probability)A more realistic forecast
7. Pipeline coveragePipeline value ÷ Remaining targetBelow 3× usually means the target is at risk
8. New deals createdCount of deals opened in the periodA leading indicator of next quarter

Efficiency KPIs: how well are we selling?

KPIFormulaWhy it matters
9. Win rateDeals won ÷ (Deals won + Deals lost)Measures selling skill and lead quality
10. Average deal sizeRevenue ÷ Deals wonShows whether you are moving up-market
11. Sales cycle lengthAverage of (Close date − Created date)Longer cycles tie up the team
12. Activities per repCalls + meetings + demos ÷ RepsEffort, best read next to win rate

Customer KPIs: are customers coming back?

KPIFormulaWhy it matters
13. New customersCount of first-time buyersGrowth from outside your base
14. Repeat purchase rateCustomers with 2+ orders ÷ All customersCheaper growth than new acquisition
15. Customer acquisition costSales and marketing cost ÷ New customersTells 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.

Browse dashboards

Dashboards related to this article

Keep reading