Start here: what these KPIs are for
Sales KPIs show how efficiently the team turns leads and opportunities into revenue.
Use these pages when you need to explain a KPI to a beginner, build it in Excel, validate the inputs, or recreate the same logic in Power BI. Each page includes a plain-English definition, real-life example, Excel formula, DAX measure, interpretation notes, and common mistakes.
Sales KPI list
Average Deal Size
Revenue / Number of Deals
🤝Average Sales Price
Total Sales Revenue / Units Sold
🤝Demo-to-Close Rate
Closed Deals / Demos Completed
🤝Lead Response Time
Total Response Time / Number of Leads
🤝Opportunity-to-Win Ratio
Won Opportunities / Opportunities Created
🤝Outbound Call Conversion
Qualified Leads / Outbound Calls
🤝Proposal Acceptance Rate
Accepted Proposals / Sent Proposals
🤝Quota Attainment
Actual Sales / Sales Quota
🤝Revenue per Sales Rep
Revenue / Sales Rep Count
🤝Sales Conversion Rate
Closed Deals / Leads
🤝Sales Cycle Length
Total Days to Close / Number of Deals
🤝Sales Pipeline Value
Sum of Opportunity Value
🤝Sales Productivity
Revenue / Sales Rep Count
🤝Weighted Pipeline Value
Opportunity Value × Probability
🤝Win Rate
Won Opportunities / Total Opportunities
How to use these KPI formulas
- Pick one KPI and confirm the business definition.
- Add the inputs to a clean Excel table, one row per period or segment.
- Paste the formula from the KPI page and format the result correctly.
- Add a target or benchmark column so the number has context.
- Link related KPIs together instead of judging one metric alone.