Sales dashboards have a unique problem: they serve two masters. The sales rep needs "what should I do next?" The sales manager needs "are we going to hit target?" Same data, different questions. Design for one and you alienate the other. Design for both on the same screen and you satisfy neither. The answer is two views from one source.
The underlying data is identical: deals, stages, values, dates, activities. But the lens is different. The manager looks down across the team. The rep looks forward at their own pipeline. Building both views from a single data model keeps them consistent while letting each audience get what they actually need.
Most CRMs ship with a default dashboard that attempts to serve everyone. It shows pipeline value, a funnel chart, some activity numbers, and a league table. This is the compromise that satisfies no one. It is too detailed for the manager who wants a quick read on target, and too high-level for the rep who needs to know what to do before lunch. The best sales dashboard examples share a common trait: they are built around specific workflows, not generic layouts.
Two Views, One Data Source
The manager and the rep ask fundamentally different questions of the same pipeline. A single dashboard trying to answer both becomes cluttered and unfocused. The better pattern is two purpose-built views that share a common data layer, each designed around the decisions its audience actually makes.
The manager's view is diagnostic: where is the team against target, which sales pipeline stages are stalling, where should coaching time go? The rep's view is operational: what should I work on right now, which deals are going stale, am I on pace to hit my number? Both views are valid. Both are necessary. They simply cannot share the same screen without one compromising the other.
Below is what belongs on each view. The specifics will vary by sales process and CRM, but the categories are consistent across almost every B2B sales organisation. The manager's metrics are amber (diagnostic, attention-seeking). The rep's metrics are blue (operational, action-oriented).
The Manager's View
Target tracking: This month's closed revenue vs target, with trend projection and pace indicator.
Pipeline health: Total value by stage, weighted and unweighted, with the gap to target clearly visible.
Velocity: Average days in each stage and conversion rates between stages. Where deals stall reveals where coaching is needed.
At-risk deals: Stalled, past expected close date, or no recent activity. These are the one-to-one conversations waiting to happen.
Team performance: Individual contribution to pipeline and closed revenue. A coaching tool, not a leaderboard.
The Rep's View
My number: Personal target, current closed revenue, gap to close, days remaining. Impossible to miss.
Today's priorities: Follow-ups due, meetings scheduled, proposals to send. The day's plan at a glance.
Stale deals: Opportunities not touched in 7+ days. A nudge, not a punishment.
Recent wins and losses: Pattern recognition over time. What is closing, what is not, and why.
Activity feed: This week's calls, emails, meetings, and proposals. Context for self-assessment.
The Rep's Day at a Glance
A sales rep's dashboard should answer "what do I do next?" within five seconds of opening it. That means surfacing the most time-sensitive actions first, then providing context for planning the rest of the day. Three categories cover it.
These priority buckets pull directly from CRM task data and calendar integration. Nothing is manually curated. The dashboard assembles the day from existing commitments and overdue items, giving the rep a single place to start their morning.
The order matters. Follow-ups first (keep promises), meetings second (be prepared), proposals third (move deals forward). This is not arbitrary. It reflects the sequence that maintains trust and momentum across the pipeline.
A stale deals section sits below the priorities. Opportunities not touched in seven or more days surface here automatically, calculated from the most recent CRM activity. The threshold for "stale" should be configurable: a complex enterprise deal and a transactional sale have very different expected cadences. The tone is encouragement, not surveillance. "This deal has been quiet for 9 days" is a prompt, not an accusation.
Pipeline Visualisation
Pipeline is the metric sales teams live and die by, so how you visualise sales pipeline stages matters enormously. The wrong chart can mislead as effectively as the wrong data.
Most teams default to the funnel chart without considering whether it actually fits their pipeline shape. The choice of visualisation should follow the shape of the data, not the conventions of the CRM vendor.
Funnel warning: Funnel charts imply a smooth, consistent narrowing from many leads to few closed deals. In practice, most sales pipelines are lumpy: stages have similar volumes, deals skip stages, and re-entries distort the shape. If your funnel looks like a cylinder, the chart is misleading you.
Each visualisation approach has strengths and weaknesses. The right choice depends on what question you are trying to answer and how your pipeline actually behaves.
| Approach | Strength | Weakness |
|---|---|---|
| Funnel chart | Intuitive shape, immediately recognisable to sales teams | Misleading when stage volumes are similar or deals re-enter stages |
| Horizontal bar by stage | Honest comparison of value at each stage, handles uneven distributions | Less visually dramatic, requires labels to show progression |
| Pipeline gap analysis | Shows whether enough pipeline exists to hit target, broken by close date | Depends on accurate close date estimates, which are often unreliable |
Always show both count and value. Ten deals worth £5,000 each behave very differently from one deal worth £50,000. Count reveals volume and pattern. Value reveals exposure and risk. The strongest sales dashboard examples display both to give a complete picture of pipeline health.
Deal-level drill-down connects the aggregate view to specific actions. Click a stage to see individual deals, owners, expected close dates, last activity, and next steps. The aggregate view tells you where attention is needed. The deal view tells you what to do about it. For more on choosing the right chart types for dashboard data, see our guide to data visualisation for dashboards.
Activity Metrics: Handle with Care
Calls made, emails sent, meetings booked. These metrics are easy to track, easy to display, and surprisingly easy to get wrong.
The instinct to measure activity is understandable: if you cannot see the work happening, how do you know it is happening? But the execution matters more than the intent.
Gaming risk: When activity metrics become targets, experienced reps optimise for the metric rather than the outcome. Drive-by calls get logged. Template emails get sent to unqualified contacts. Meetings get booked with no real prospect. The dashboard shows healthy activity while the pipeline quietly deteriorates.
The question is not whether to track activity, but when activity data helps and when it harms. The distinction is context-dependent and worth thinking through carefully.
The better pattern: display activity as a small contextual panel alongside pipeline movement. Show what happened this week alongside what it produced. Not a scoreboard. Not a leaderboard. Context for coaching conversations.
The goal is to connect effort to outcome. A rep who made 12 calls and generated 3 qualified meetings is doing something right. A rep who made 50 calls and generated none needs a different kind of support. The dashboard should make both patterns visible without reducing either rep to a number.
Forecast Confidence
Sales forecasts drive hiring plans, marketing budgets, cash flow projections, and board reporting. When forecasts are consistently wrong, every downstream decision is built on fiction. A forecast accuracy panel tracks what was predicted against what actually closed, revealing whether the team is chronically optimistic, consistently sandbagging, or genuinely uncertain.
Forecast confidence works in layers. Each layer adds more risk and less certainty, and the visualisation should make that gradient obvious to anyone reviewing the numbers.
Committed
Deals the rep believes will close this period with high confidence. Contracts in negotiation, verbal agreements, purchase orders expected. This is the floor.
Best Case
Committed deals plus those that are likely but not certain. Strong engagement, positive signals, but dependencies remain. A reasonable expectation if things go well.
Upside
Best case plus deals that could close if everything aligns. Earlier-stage opportunities with momentum. Possible but not probable within the period.
Stretch
The theoretical maximum. Includes long-shot deals and optimistic timing assumptions. Useful for capacity planning, not for setting expectations with leadership.
The weekly forecast review is where this visualisation earns its keep. Reps walk through their committed deals, managers challenge assumptions, and the team agrees on a number. Tracking forecast accuracy over multiple periods reveals systematic bias: teams that consistently forecast 20% above actual need a different conversation than teams whose forecasts are volatile but unbiased.
Visualising these layers as stacked or layered bars (committed as solid colour, best case as lighter, upside as lighter still) gives leadership a clear picture of risk at a glance. The shape of the stack tells the story: a tall committed bar with thin upside layers signals a healthy, predictable pipeline. A thin committed bar with towering upside layers signals hope, not certainty. For guidance on how executive dashboards use forecast data, see our dedicated guide.
CRM Integration and Data Quality
Every sales dashboard pulls from a CRM: Salesforce, HubSpot, Pipedrive, or a custom system. The dashboard is only as good as the data feeding it. And the most common failure mode for sales dashboards is not design or layout. It is data quality.
The dashboard acts as a mirror. It reveals CRM hygiene issues immediately and visibly. When a manager sees a deal with no activity logged in 30 days sitting in "negotiation," the conversation about data discipline happens naturally. The dashboard does not fix CRM habits, but it makes poor habits impossible to ignore.
Automating "last touched" calculations helps surface neglected deals without relying on reps to self-report. Pull the most recent email, call, meeting, or note from the CRM and calculate the gap. Deals going cold appear on the stale deals list automatically, creating a gentle accountability loop that improves data quality over time.
The good news: data quality tends to improve once the dashboard is live. When reps see that missing close dates or stale stages make their pipeline look worse than it is, they update the CRM to correct the picture. The dashboard creates the incentive that no amount of managerial nagging achieves.
What a Good Sales Dashboard Delivers
A sales dashboard that works does not just report on what happened. It changes what happens next. The real measure is behavioural: does the team work differently because the dashboard exists?
-
Reps plan their day from it Open the dashboard, see priorities, start working. No digging through CRM screens to figure out what needs attention.
-
Managers coach from it Pipeline problems, stalled deals, and velocity trends are visible before the one-to-one. The conversation starts with evidence, not guesswork.
-
Stale deals get attention Deals no longer go cold unnoticed. Automatic surfacing creates a gentle nudge that prevents neglect before it becomes a lost opportunity.
-
Forecasts improve over time Tracking predicted vs actual creates accountability. Teams learn to forecast honestly when the record is visible and persistent.
-
CRM discipline improves When the dashboard visibly reflects data quality, teams maintain their CRM because the cost of not doing so is obvious every morning.
-
The forecast review runs faster Everyone arrives looking at the same data. Less time debating numbers, more time discussing strategy and removing blockers.
The test is straightforward. Does the rep open it first thing? Does the manager reference it in every one-to-one? Does the forecast review produce better numbers because everyone shares the same view? If the answer to all three is yes, the dashboard is working.
The behavioural shift is the real return on investment. Pipeline coverage improves because stale deals get attention earlier. Forecast accuracy improves because the record is visible and persistent. CRM discipline improves because the dashboard makes poor data quality obvious every morning. For broader principles on building dashboards that earn habitual use, see our guide to dashboard UX and interaction design.
Build a Sales Dashboard That Drives Pipeline
We design sales dashboards around your pipeline stages, your CRM, and how your team actually works. Manager views for coaching and forecasting. Rep views for daily priorities. Connected to Salesforce, HubSpot, Pipedrive, or your custom system.
Let's talk about your sales dashboard →