How to build a sales pipeline dashboard
A pipeline dashboard should answer one question fast: are we going to hit the number, and if not, where is the gap. Everything on it should serve that question.
The common failure is a dashboard full of pretty charts that nobody acts on. A good one is a small set of tiles that each trigger a decision.
Short answer
Build a pipeline dashboard around a handful of decision-driving metrics: coverage versus target, pipeline by stage, sales velocity, deal aging, and week-over-week movement. Add win rate and forecast versus goal. Skip vanity charts that look busy but change no decisions, and make every tile drill down to the underlying deals.
Step by step
Lead with coverage versus target
The top tile should show qualified pipeline against the coverage you need. This is the earliest indicator of whether the period is on track.
Show pipeline by stage
Display deal count and value by stage so you can see whether the pipeline is top-heavy with early deals or healthy through to close.
Add velocity and aging
Include sales velocity and a view of deals aging past their stage average. Together they show whether pipeline is converting fast enough and where deals stall.
- Velocity: dollars generated per day
- Aging: deals stuck past stage norms
- Time-in-stage by stage
Track week-over-week movement
Show what changed since last week: new pipeline, deals advanced, deals slipped. Movement, not a static snapshot, reveals health.
Make every tile drill to deals
A metric you cannot click into is a dead end. Each tile should open the list of deals behind it so the dashboard drives action, not just awareness.
Decisions, not decoration
Every tile should answer "so what do I do." Coverage low means generate pipeline; aging high means work stalls; velocity down means find the dragging lever. If a chart triggers no action, cut it.
Resist the urge to add everything. A crowded dashboard hides the few numbers that matter. Ruthless editing is what makes it usable in a weekly review.
How Ardovo helps
Ardovo ships pipeline and forecast dashboards alive with real data on day one, every tile drills straight to the underlying deals, and Rook can answer plain-language questions about the pipeline so you do not have to build a custom report for every question.
Frequently asked questions
What metrics belong on a pipeline dashboard?
Coverage versus target, pipeline by stage, sales velocity, deal aging, week-over-week movement, win rate, and forecast versus goal. Each should drive a decision and drill down to the deals behind it. Leave off vanity charts that change no action.
What makes a pipeline dashboard actually useful?
Every tile answers "so what do I do next," and every metric clicks through to the underlying deals. A useful dashboard is small, decision-oriented, and drillable, not a wall of charts nobody acts on.
How often should a pipeline dashboard update?
Live or at least daily. Pipeline changes constantly as deals move, so a stale dashboard leads to stale decisions. Real-time data is what lets a weekly review react to what actually happened this week.