A sales manager needs to know one thing at a glance: "Are we going to hit quota this month?"
Everything else on the dashboard should answer that one question.
This guide covers the sales dashboard: what to track, how to visualize it, and how to make it actionable.
The Sales Dashboard Stack
Top: Quota and Attainment (the business outcome) Middle: Pipeline and Conversion (the drivers) Bottom: Team performance and Activity (the details)
Level 1: Revenue Attainment
Revenue YTD: $1.2M
Target: $1.5M
Attainment: 80% ████████░░
On track for: $1.4M (below target)
This should be largest. If you're off track, the whole team sees it.
Level 2: Pipeline Analysis
Pipeline funnel (by stage):
- Stage 1 (Leads): 50 deals, $500K value
- Stage 2 (Qualified): 30 deals, $350K value
- Stage 3 (Proposal): 15 deals, $200K value
- Stage 4 (Negotiation): 8 deals, $150K value
What it shows: Is the pipeline healthy? Are deals flowing? Are deals stalling in one stage?
Key metric: Pipeline Coverage (Total pipeline ÷ Quarterly quota)
- Healthy: 3-4x quarterly quota
- At-risk: Below 2x
Level 3: Conversion Rates
Track the percentage of deals advancing at each stage:
- Lead to Qualified: 60% (50 leads → 30 qualified)
- Qualified to Proposal: 50% (30 qualified → 15 proposals)
- Proposal to Close: 53% (15 proposals → 8 closes)
- Overall: 20% (leads to close)
Use benchmarks by your sales model. SaaS typically has 10-25% lead-to-close rates.
Level 4: Individual Rep Attainment
| Rep | YTD Revenue | Target | % Attainment | On Track? | |-----|-------------|--------|-------------|-----------| | Alice | $280K | $300K | 93% | ✓ | | Bob | $200K | $300K | 67% | ⚠️ | | Carol | $320K | $300K | 107% | ✓ |
Rank by performance. This drives healthy competition.
Level 5: Sales Velocity (Optional Detail)
Average days to close from Stage 1 to Stage 4. Trends show if deals are moving faster or slower.
Example:
- Q1 average: 45 days
- Q2 average: 52 days (slowing down)
This is a warning flag for forecasting.
Key Metrics to Include
| Metric | Why | Target | |--------|-----|--------| | Pipeline Value | Shows revenue potential | 3-4x quarterly quota | | Pipeline Coverage | Ensures you can hit quota | 3-4x quarterly quota | | Conversion Rate by Stage | Identifies bottlenecks | Varies by model, track trends | | Sales Cycle Length | Affects forecasting and cash | Shorter = better | | Win Rate | Quality of pipeline | 20-50% depending on model | | Average Deal Size | Revenue per opportunity | Trends matter more than absolute | | Quota Attainment | Are we winning? | 90%+ on track for goal | | Activity Metrics (optional) | Leads effort to outcomes | 5-10 calls/meetings per day | | Forecast Accuracy | Are our predictions right? | ±10% of actual | | Deal Slippage | Deals moving to next period | Track and alert |
The Dashboard Layout
Sales Team Daily Dashboard (what it looks like):
┌────────────────────────────────────────────────────┐
│ MONTHLY QUOTA │
│ Attainment: $1.2M of $1.5M (80%) │
│ ████████░░ On track for: $1.4M │
└────────────────────────────────────────────────────┘
┌─────────────────────┬──────────────────────────────┐
│ PIPELINE FUNNEL │ PIPELINE COVERAGE │
│ Leads: 50 ($500K) │ Total: $1.2M │
│ Qualified: 30 │ Quarterly Quota: $375K │
│ Proposal: 15 │ Coverage: 3.2x ✓ │
│ Negotiation: 8 │ │
│ ($1.2M total) │ │
└─────────────────────┴──────────────────────────────┘
┌──────────────────────────────────────────────────┐
│ TEAM ATTAINMENT │
│ Alice $280K / $300K 93% ✓ [████████░] │
│ Bob $200K / $300K 67% ⚠️ [██████░░░] │
│ Carol $320K / $300K 107% ✓ [██████████] │
│ [Alert: Bob is below pace] │
└──────────────────────────────────────────────────┘
┌──────────────────┬────────────────────────────────┐
│ CONVERSION RATE │ SALES CYCLE LENGTH │
│ Lead→Close: 20% │ Avg: 45 days (⚠️ up from 38) │
│ Q2 vs Q1: same │ Median: 42 days │
└──────────────────┴────────────────────────────────┘
[Filters: Team | Region | Product]
What NOT to Include
❌ Activity vanity metrics. "200 calls made" doesn't matter. Only care if it correlates to closes.
❌ Historical data. Yesterday's won deals are done. Today's matters.
❌ Metrics you can't act on. Interesting data, wrong place.
❌ Granular details. Those go in CRM. Dashboard shows summaries.
Red Flags to Alert On
Set up automatic alerts for:
- Deal slippage – A deal that was supposed to close this month just moved to next month
- Pipeline coverage below 2x – You won't hit quota
- Rep below 50% of quarterly target – With 3 months left, they need intervention
- Win rate trending down – Sales cycle might be broken
- Forecast accuracy off by >20% – Your predictions are unreliable
Sales Dashboard for Managers vs. Reps
Sales Manager Dashboard (weekly):
- Team attainment vs. quota
- Pipeline by stage
- Top/bottom performers
- Pipeline coverage
- Forecast accuracy
Sales Rep Dashboard (daily):
- Personal quota attainment
- Personal pipeline by stage
- Next actions (followups, proposals to send)
- Win/loss tracker
- Activity metrics (if your org tracks these)
Don't show the same dashboard to everyone. Customize.
The Weekly Sales Huddle
Use the dashboard to drive a 15-minute team standup:
- Status (5 min): Read the dashboard. Are we on track? (Green = move on. Red = dig in.)
- Issues (5 min): What's blocking deals? (Slippage, competitor loss, pricing objections?)
- Actions (5 min): What are we doing this week to fix it?
This turns data into action.
Checklist
- ✓ Quota/attainment is visible at top (largest)
- ✓ Pipeline funnel visualized (shows flow and bottlenecks)
- ✓ Coverage ratio shown (3-4x healthy)
- ✓ Individual rep performance ranked
- ✓ Conversion rates by stage tracked
- ✓ Sales cycle length trending
- ✓ Win rate visible
- ✓ Red flags for slippage or underperformance
- ✓ Updated in real-time (or daily at minimum)
- ✓ Customizable by team/region/product
The Bottom Line
A sales dashboard is only useful if it drives action. Every day, sales managers should look at it and ask: "What changed since yesterday? Do we need to act?"
Keep it simple. Leads to close. Pipeline to quota. Team to target.
Everything else is noise.