How to build a sales dashboard
A good sales dashboard is not a wall of numbers; it is a decision tool for one audience. The most common failure is cramming twenty metrics onto one screen so no one knows where to look or what to do.
Start from the decision, not the data. Once you know what the viewer needs to decide, the right five to seven metrics become obvious and everything else falls away.
- 5 to 7 metrics Per dashboard
- One audience Rep, manager, or exec
- Trend + target Beside every number
Short answer
Build a sales dashboard by picking one audience and the decision it drives, choosing 5 to 7 metrics that inform that decision, wiring them to live data, and making each metric drill down to the underlying records. Show trend and target beside every number, and cut anything that does not change a decision.
Step by step
Pick one audience and decision
Decide who the dashboard is for (a rep, a manager, or an executive) and the decision it supports. A rep dashboard drives daily action; an exec dashboard drives resource allocation. Do not mix.
Choose 5 to 7 decision-driving metrics
Select only metrics that change what the viewer does. For a manager: pipeline coverage, win rate, forecast versus quota, deal aging, and activity. Cut vanity numbers.
Show trend and target with each
A number alone is not information. Put a trend line and a target or benchmark beside every metric so the viewer instantly knows whether it is good and which way it is moving.
Wire it to live data
Connect the dashboard to your CRM so it updates automatically. A dashboard someone rebuilds by hand each week is late, error-prone, and quickly abandoned.
Make every metric drill down
Each number should click through to the underlying deals or activities. A dashboard that shows a problem but not the records behind it forces a second tool and kills adoption.
Common mistakes
The biggest is metric overload: twenty tiles that impress in a demo and paralyze in practice. If a metric would not change a decision, it does not belong on the dashboard.
The second is static data. A dashboard pasted together in a spreadsheet each Monday is stale by Tuesday. Live data is what makes a dashboard a tool rather than a report.
How Ardovo handles it
Ardovo dashboards are alive with data on first load, every metric drills into the underlying records, and Rook explains what moved. Ask Rook to build a manager dashboard and it assembles the right metrics with trends and targets automatically.
Frequently asked questions
How many metrics should a sales dashboard have?
Five to seven for one audience. More than that and viewers cannot tell what matters or what to do. Every metric should change a decision; if it would not, leave it off.
What metrics belong on a sales manager dashboard?
Pipeline coverage, win rate, forecast versus quota, deal aging or stalled deals, quota attainment distribution, and key activity outputs. Each should drill into the deals behind it so the manager can act.
Should a dashboard use live or static data?
Live. A dashboard rebuilt by hand each week is stale and error-prone. Connecting it to your CRM so it updates automatically is what turns it from a periodic report into a real-time decision tool.