11 min read · Business Systems · Last updated July 2026
Quick answer: A sales dashboard must show pipeline value, stage conversion rates, deal velocity, activity by rep, revenue won vs target, deals going stale, forecast vs actual, and win/loss ratio. Any dashboard missing more than two of these gives an incomplete picture of sales health.
Introduction
Most sales dashboards show too much. They are built by someone who clicked “add all available reports” and called it done. The result: a cluttered screen full of numbers that tells the reader nothing they can act on.
A great sales dashboard answers one question instantly: “What do I need to do today to hit my number?” Everything on it should serve that question.
What you’ll learn:
– The 8 metrics every sales dashboard must have
– The difference between a rep dashboard and a manager dashboard
– How to build each metric in HubSpot and Salesforce
– What to remove from your current dashboard
Table of Contents
- Dashboard Design Principles
- Metric 1 — Pipeline Value by Stage
- Metric 2 — Stage Conversion Rates
- Metric 3 — Deal Velocity
- Metric 4 — Activity by Rep
- Metric 5 — Revenue Won vs Target
- Metric 6 — Deals Going Stale
- Metric 7 — Forecast vs Actual
- Metric 8 — Win/Loss Ratio
- Rep Dashboard vs Manager Dashboard
- FAQ
- Conclusion
1. Dashboard Design Principles
One screen. Everything on the dashboard should be visible without scrolling on a standard laptop. If it requires scrolling, it is two dashboards pretending to be one.
Actionable, not informational. Every metric should prompt an action. “Pipeline value is $420,000” — so what? “3 deals are stale and at risk of being lost” — I need to call them today.
Real-time, not historical. A dashboard showing last month’s data is a history lesson. A sales dashboard needs to show the current state of the pipeline.
Separated by audience. Reps need to know what they should do. Managers need to know if the team is on track. These are different dashboards with different metrics.
2. Metric 1 — Pipeline Value by Stage
What it shows: The total value of all open deals broken down by pipeline stage.
Why it matters: Tells you where deals are concentrated. If 70% of your pipeline is in “Proposal Sent” with little in “Discovery” or “New Lead,” you have a top-of-funnel problem that will hurt you next month.
How to read it:
– Healthy pipeline: deals distributed across stages, with more at the top than the bottom
– Warning sign: large cluster in one stage with nothing feeding from above
– Warning sign: pipeline value concentrated in a small number of large deals (high risk if one falls)
In HubSpot: Reports → Create report → Pipeline Snapshot. Select: stage, deal amount, deal count.
In Salesforce: Reports → Opportunity Reports → Opportunities by Stage (pipeline funnel chart).
3. Metric 2 — Stage Conversion Rates
What it shows: What percentage of deals progress from each stage to the next.
Why it matters: Pinpoints exactly where deals are being lost. If your “Proposal Sent → Verbal Agreement” conversion rate is 25% but industry average is 40%, your proposals are not converting — that is a specific problem with a specific fix.
Formula: Deals exiting stage to next stage ÷ total deals that entered stage × 100
Benchmark ranges (professional services):
– New Lead → Discovery: 60–70%
– Discovery → Proposal: 60–70%
– Proposal → Verbal: 30–50%
– Verbal → Closed Won: 80–90%
4. Metric 3 — Deal Velocity
What it shows: How long (in days) deals are spending in each stage and the total average sales cycle length.
Why it matters: A deal spending 28 days in “Proposal Sent” when your average is 12 days is a flag. Either something is wrong with the deal, or something is wrong with the follow-up.
Formula: Total days in stage across all deals ÷ number of deals in that stage
Action trigger: Any deal spending more than 1.5x the average time in a stage gets a flag for manager review.
5. Metric 4 — Activity by Rep
What it shows: The number of calls logged, emails sent, meetings held, and tasks completed by each rep over the last 7 days.
Why it matters: Activity is a leading indicator. Revenue closed this month was determined by activity 30–90 days ago. If a rep’s activity dropped 3 weeks ago, their pipeline will show it in 4–6 weeks.
Warning sign: A rep whose activity is consistently low but whose deals appear healthy — this usually means they are not logging activity accurately, not that they are genuinely productive with fewer actions.
Sales Dashboard Completeness Score
Check which of the 8 essential metrics your current dashboard has
6. Metric 5 — Revenue Won vs Target
What it shows: Revenue closed this month (or quarter) compared to the target.
Why it matters: The most fundamental sales metric. Everything else on the dashboard explains why you are above or below this number.
Display format: A simple gauge or bar chart. Current amount vs target. Percentage complete. Days remaining.
7. Metric 6 — Deals Going Stale
What it shows: Deals in active pipeline stages with no logged activity in the last 14 days.
Why it matters: This is the most actionable metric on the dashboard. Every deal on this list needs a phone call today. Without this metric, stale deals are invisible until it is too late.
Dashboard display: A table showing: deal name, owner, stage, last activity date, deal value. Sorted by days since last activity (most stale at top).
8. Metric 7 — Forecast vs Actual
What it shows: The probability-weighted pipeline value (sum of deal value × stage probability) compared to closed revenue.
Why it matters: Forecast accuracy tells you how trustworthy your pipeline data is. If your weighted forecast consistently over-predicts by 40%, either your stage probabilities are wrong or your reps are over-optimistic about their deals.
How to read it: Target: weighted forecast within 15% of actual closed revenue at month end. Consistent over-forecasting → review stage probabilities. Consistent under-forecasting → review deal velocity.
9. Metric 8 — Win/Loss Ratio
What it shows: The percentage of deals closed as Won vs deals closed as Lost, with loss reasons.
Why it matters: Your win rate tells you if your pipeline is healthy. But the loss reasons tell you how to improve it. “Lost to competitor — price” needs a different response than “Lost — timing/budget” which needs a different response than “Lost — not a fit.”
Track loss reasons as a dropdown field on every Closed Lost deal:
– Lost to competitor (name the competitor)
– Budget / no budget
– Timing (not ready yet)
– No decision / went quiet
– Not a fit (wrong ICP)
– Proposal did not meet requirements
Manager Dashboard vs Rep Dashboard
Dashboard by Role
FAQ
Q: How often should the sales dashboard be reviewed?
Reps: daily (morning check-in, 5 minutes). Managers: daily (15 minutes). Weekly pipeline review: all reps + manager, 30–45 minutes.
Q: What tools are best for sales dashboards?
HubSpot native dashboards (excellent for SMBs). Salesforce dashboards (powerful, requires admin). Databox (third-party, aggregates from multiple CRMs). Looker Studio (free, connects to CRM data via API). Tableau (enterprise-grade analytics).
Q: Should I build one big dashboard or multiple small ones?
Multiple small ones, separated by audience and purpose. One dashboard per role (rep, manager, executive). One dashboard per time horizon (daily activity, weekly pipeline, monthly revenue).
Conclusion
The best sales dashboard is the one your team checks every morning without being told to — because it tells them exactly what to work on. Build the 8 metrics in this guide. Separate rep and manager views. Keep it to one screen. Your pipeline clarity will improve within a week.
→ Talk to Our Business Systems Team
Written by the Ignited Nepal team. ignitednepal.com