Guide
How to Track Sales Performance in a Small Business
Track sales performance without a complex BI stack — 6 metrics, reviewed weekly.
Summary
The simplest useful sales dashboard has: pipeline, new opps, win rate, avg deal, cycle time, revenue vs target. More than that becomes noise.
Metrics to track (6 is enough)
- Pipeline coverage — open pipeline value vs quota
- New opportunities per week
- Win rate — won / (won+lost)
- Average deal size
- Sales cycle time — avg days from lead to won
- Revenue vs target — MTD and YTD
Build the sheet
One tab per metric, one row per week. Link to CRM export. Formulas do the aggregation. 30 minutes of setup saves hours per month.
Weekly 15-minute review
- Revenue vs target: on track or not
- Pipeline coverage: trending up or down
- Stuck deals: any over 60 days with no activity
- Action items with owners
Monthly review
- Win rate trend
- Lost reasons — any patterns
- Top-of-funnel activity vs quota-coverage
Common mistakes
- Tracking 20 metrics, reviewing none
- Only measuring won revenue, not pipeline leading indicators
- Long monthly reviews instead of short weekly ones
Frequently asked questions
Should I use a BI tool?
Not until Sheets / CRM reports stop scaling. Looker Studio (free) is the usual next step.
Next step
Keep exploring related resources to strengthen this area of the business.
Use Pipeline Conversion CalculatorPhase 2 content slot (ads / affiliate)