A sales dashboard is one screen that shows the few numbers a person needs to make their next sales decision: revenue against target, pipeline by stage, win rate, deal size, cycle length and the activity that feeds them. It works when every tile has an owner, comes from clean CRM data and is opened in a fixed meeting.
- Build one dashboard per role, not one dashboard for everyone
- Five to nine tiles, each tied to a decision
- Fix CRM data entry before you design a single chart
Most small sales teams do not lack data. They lack a view of it that someone opens every Monday. So the weekly pipeline review starts with a rep scrolling a deal list and guessing what will close. A sales dashboard replaces that guesswork with a handful of numbers everyone agrees on.
For a team on one CRM, the built-in reports usually cover the first version. The picture changes when revenue lives in a billing system, leads come from three marketing tools and the forecast is a spreadsheet on the sales manager's laptop. Joining those sources into one trustworthy model is real data work: some teams give it to an operations hire, others bring in a data analytics consulting company to build the pipeline and the definitions once, so the dashboard stops depending on one person's copy and paste.
Below: KPIs with formulas, nine dashboards by role, a meeting map, a five-step build and a checklist. If your CRM data is still scattered across spreadsheets, start with what a CRM database is.
What is a sales dashboard?
A sales dashboard is a visual summary of sales performance that pulls live or regularly refreshed data from a CRM and related systems and shows it as a small set of charts, numbers and tables on one screen. Its job is to answer "where do we stand and what should we do next?" in under a minute.
It differs from the things it is often confused with:
- A sales report answers one question in depth, for example "all deals lost in Q3 with the loss reason". A dashboard combines several reports so you see the overall state and know which report to open.
- A sales forecast is a prediction of future revenue. A dashboard can display the forecast, but it also shows what already happened and what is happening now.
- A leaderboard is one type of dashboard that ranks reps. Useful for motivation, but on its own it says nothing about pipeline health.
Good dashboards share three traits: they are built for a specific person and decision, every number has one agreed definition, and the data refreshes without anyone touching a spreadsheet.
Why do most sales dashboards fail?
Sales dashboards fail for four reasons: the data under them is incomplete, they try to show everything, nobody owns the numbers, and no meeting depends on them. The software is rarely the problem.
- Dirty or missing CRM data. If reps log calls on Friday afternoon from memory, or close dates are never updated, the dashboard shows a pipeline that does not exist. Managers notice, stop trusting it and go back to asking reps directly. Gartner has repeatedly pointed to poor data quality as a major cost for organisations (Gartner on data quality); in sales it shows up first as a forecast nobody believes.
- Too many tiles. Twenty charts on one screen look impressive in a demo. In practice nobody reads past the top row, and the metric that matters is buried.
- No owner and no definitions. "Revenue" means booked contract value to the sales manager, invoiced amount to finance and collected cash to the founder. Without one written definition, every meeting turns into an argument about the number instead of the action.
- No ritual. A dashboard that is not opened in a recurring meeting is a screensaver. The teams that use dashboards well start every pipeline review by putting one on the screen.
Which KPIs should a sales dashboard track?
A sales dashboard should track a mix of lagging metrics (results already achieved), pipeline metrics (what is likely to happen) and leading metrics (activity that predicts future results). The table lists the KPIs that appear on almost every effective dashboard, with formulas you can recreate in any CRM.
| KPI | Formula | Type | Question it answers |
|---|---|---|---|
| Revenue vs target | Closed-won value in period / target for period | Lagging | Are we on track this month or quarter? |
| Quota attainment | Rep's closed-won value / rep's quota | Lagging | Which reps need help or more pipeline? |
| Win rate | Deals won / (deals won + deals lost) in period | Lagging | How good are we at closing what we work? |
| Average deal size | Closed-won value / number of deals won | Lagging | Are we moving up or down market? |
| Sales cycle length | Average days from deal created to closed-won | Lagging | How long does cash take to arrive? |
| Pipeline value by stage | Sum of open deal value, grouped by stage | Pipeline | Where are deals piling up or stalling? |
| Pipeline coverage | Open pipeline value / remaining target | Pipeline | Do we have enough deals to hit the number? |
| Stage conversion rate | Deals moved to next stage / deals that entered the stage | Pipeline | Which step of the process leaks the most? |
| Sales velocity | (Open deals multiplied by win rate multiplied by average deal size) / cycle length in days | Pipeline | How much revenue does the pipeline produce per day? |
| Activities per rep | Calls, emails and meetings logged per rep per week | Leading | Is the team doing enough prospecting? |
| Meetings booked | First meetings scheduled in period | Leading | Will next month's pipeline be full? |
| Lead response time | Average time from new lead to first contact | Leading | Are we losing inbound leads to slow follow-up? |
Not every team needs all twelve. A two-rep startup can run on revenue vs target, pipeline by stage, win rate and meetings booked. A team with a dedicated SDR function adds lead response time and stage conversion. Pick the KPIs your recurring meetings actually discuss, then stop.
What are the most useful sales dashboard examples?
The nine dashboards below cover the views most small and mid-size teams need. Each one is built for a specific audience and a specific decision; the summary table comes first, details follow.
| Dashboard | Main audience | Core decision | Key metrics |
|---|---|---|---|
| State of sales | Founder, sales leader | Are we on track for the period? | Revenue vs target, pipeline coverage, forecast |
| Pipeline | Sales manager | Which deals need attention this week? | Value by stage, days in stage, stalled deals |
| Rep performance | Each rep, manager | Where should I spend my time today? | Quota attainment, activities, open deals |
| Forecast | Sales leader, finance | What revenue can we commit to? | Weighted pipeline, commit vs best case, accuracy |
| Win/loss | Sales manager, product | Why do we win and lose? | Win rate by segment, loss reasons, competitors |
| Lead and SDR | SDR lead, marketing | Are leads followed up and qualified? | Response time, meetings booked, lead-to-opportunity rate |
| Activity | Sales manager | Is effort at the level the pipeline needs? | Calls, emails, meetings per rep |
| Leaderboard | Whole team | Who is ahead this month? | Closed-won, deals won, meetings booked |
| Sales and marketing funnel | Marketing and sales leads | Which channels produce revenue, not just leads? | Leads by source, conversion by source, revenue by source |
1. State of sales dashboard
The top-level view for the founder or head of sales. It shows revenue closed so far against the period target, the gap still to close, open pipeline coverage for that gap and the current forecast. Add a simple trend of monthly revenue for the last twelve months so seasonality is visible. This is the dashboard you open at the start of a monthly leadership meeting.
2. Pipeline dashboard
The workhorse of the weekly pipeline review. A funnel or bar chart of open deal value by stage, a table of deals that have sat in one stage longer than your normal cycle, deals with a close date in the past and deals without a next step. The goal is a short list of deals to discuss, not a tour of the whole pipeline.
3. Sales rep performance dashboard
A personal view each rep sees when they open the CRM: quota attainment for the month, their open deals sorted by close date, tasks due today and their activity count for the week. Managers see the same view filtered by rep during one-to-ones. Keep it about the rep's own work; comparisons belong on the leaderboard.
4. Forecast dashboard
Shows what revenue the team expects to close, split into categories such as commit, best case and pipeline. Add weighted pipeline (deal value multiplied by stage probability) as a sanity check against reps' own calls, and track forecast accuracy over past periods so you can see whether the team habitually over- or under-promises. Finance usually wants this one.
5. Win/loss dashboard
Win rate by segment, deal size, lead source and competitor, plus a breakdown of loss reasons. It only works if reps must pick a loss reason from a short, fixed list when they close a deal as lost. Review it monthly with whoever owns pricing and product; patterns here often explain more than any activity metric.
6. Lead and SDR dashboard
For teams where someone qualifies inbound leads or books meetings for account executives. Track average lead response time, the share of leads contacted within your target window, meetings booked and the lead-to-opportunity rate. If you score leads, show conversion by score band; our AI lead scoring guide explains how to set those bands up.
7. Activity dashboard
Calls, emails and meetings per rep per week, ideally next to pipeline created. On its own, activity is a vanity metric: a rep can send a hundred emails that go nowhere. Paired with meetings booked and pipeline created, it shows whether effort is converting, which is what a manager needs to know before coaching.
8. Sales leaderboard
A ranking of reps by closed-won value, deals won or meetings booked for the current month, often shown on a TV in the office or pinned in the team chat. It drives friendly competition, but rank by more than one metric so new reps building pipeline are not always at the bottom.
9. Sales and marketing funnel dashboard
Leads, opportunities and closed revenue grouped by source or campaign. It answers the question marketing and sales argue about most: which channels produce revenue, not just form fills. It needs source tracking that survives from the first form submission to the closed deal, which is where many CRMs lose the thread.
Which dashboard belongs in which meeting?
The fastest way to make dashboards stick is to assign each one to a recurring meeting. If a dashboard has no meeting, ask whether it needs to exist.
| Meeting | Frequency | Dashboard on screen | Output |
|---|---|---|---|
| Rep daily planning | Daily, 10 minutes | Rep performance | Today's priority deals and tasks |
| Team stand-up | Daily or 2–3 times a week | Activity, leaderboard | Blockers, meetings booked |
| Pipeline review | Weekly | Pipeline, lead and SDR | Next steps on stalled and at-risk deals |
| Forecast call | Weekly or bi-weekly | Forecast | Committed number for the period |
| Leadership review | Monthly | State of sales, sales and marketing funnel | Hiring, budget and channel decisions |
| Win/loss review | Monthly or quarterly | Win/loss | Changes to pricing, messaging or qualification |
For a team of under ten people, three of these are enough to start: rep daily planning, the weekly pipeline review and the monthly leadership review.
How do you build a sales dashboard step by step?
Building a sales dashboard takes five steps: define the audience and decision, choose the KPIs, fix the data, build the first version and review it after a month. For a small team on one CRM, a first version usually takes days, not months.
- Define the audience and the decision. Write one line per dashboard: "The sales manager uses this in Monday's pipeline review to decide which five deals to discuss." If you cannot write that line, you do not need the dashboard yet.
- Choose five to nine KPIs. Start from the decision and work backwards. For each candidate metric ask: if this number moved sharply, would someone do something different? If not, leave it out. Write the definition of each KPI, including which date field and which deals it uses.
- Audit and fix the data. Check that the fields your KPIs depend on are actually filled: deal amount, close date, stage, owner, lead source, loss reason. Make the critical ones required in the CRM, merge duplicates and set a rule for updating close dates. If you are moving systems first, our guide to CRM data migration covers the cleanup in detail.
- Build version one. Use the reports already in your CRM wherever possible. Put the most important number top left, group related tiles, and add filters for period and owner. Share it with two or three of the people who will use it and watch them try to answer a real question with it.
- Review after a month. Look at which tiles were discussed in meetings and which were ignored. Remove the ignored ones, fix any number people disputed and only then add what was missing. Repeat each quarter.
Where should you build your sales dashboard?
There are four places to build a sales dashboard: the CRM's own reporting, a spreadsheet, a business intelligence (BI) tool connected to the CRM, or a custom data model and dashboard. The right choice depends on how many data sources you combine and how much the numbers need to be trusted outside the sales team.
| Option | Best for | Strength | Watch out for |
|---|---|---|---|
| CRM built-in dashboards | Teams whose sales data lives in one CRM | Real-time, no extra cost, reps already work there | Weak at combining billing, product or ad data |
| Spreadsheet | One to three reps, one pipeline | Flexible, familiar, free | Manual exports go stale; formulas break silently |
| BI tool on top of the CRM | Teams that need CRM plus billing or marketing data | Joins sources, richer charts, shareable with finance | Needs someone to own the data model and definitions |
| Custom data model and dashboard | Several systems, in-house tools, strict definitions | One source of truth for revenue across the company | Upfront build effort; needs ongoing maintenance |
Most teams should start inside the CRM and move only when a real question cannot be answered there, typically "how much revenue did each marketing channel produce?" or "what is our net revenue after refunds?". When you outgrow the CRM, the hard part is not the charting tool. It is agreeing on definitions and building a reliable sync between systems; our CRM integration guide explains sync direction and field ownership.
What makes a sales dashboard easy to read?
A sales dashboard is easy to read when the most important number is the first thing the eye lands on, each chart type matches the question, and colour is used only to signal something that needs attention. Usability research from Nielsen Norman Group shows that people spot differences in position, length and colour almost instantly, which is why simple bars and big numbers beat decorative charts (NN/g on dashboards and preattentive attributes).
- Top-left first. Put the headline number, usually revenue against target, in the top-left corner. People scan a screen from there.
- Big numbers for single values. Revenue to date, win rate and pipeline coverage read best as one large figure with a comparison to target or last period.
- Bars for comparisons, lines for trends. Pipeline by stage and revenue by rep are bars. Revenue by month is a line. Avoid pie charts with more than three slices and avoid 3D effects entirely.
- Colour means action. Keep everything neutral and use one warning colour for numbers below target or deals that have stalled. If everything is coloured, nothing stands out.
- Always show context. A number without a target, a previous period or a trend arrow cannot be judged. "42 meetings" means nothing; "42 meetings, target 50, last month 38" drives a conversation.
- Make it work on a phone. Reps and founders check numbers between meetings. A single column of key tiles on mobile beats a full desktop layout squeezed onto a small screen.
What are the most common sales dashboard mistakes?
- One dashboard for everyone. Reps, managers and the founder need different views. A shared mega-dashboard serves none of them well.
- Vanity metrics on top. Total emails sent or total contacts in the CRM look good and drive no decisions. Lead with outcomes and pipeline.
- Building before cleaning. A beautiful dashboard on top of incomplete close dates and missing deal values destroys trust in the first week.
- Manual data refresh. If the dashboard depends on someone exporting a CSV every Monday, it will be out of date by Wednesday.
- Never pruning. Dashboards grow as people ask for "one more chart". Remove a tile for every one you add.
- No link to action. A stalled-deals tile should click through to the list of deals, so the manager can assign next steps straight from the dashboard.
Dashboards also go wrong when they are treated as the sales process itself. They show where the process is weak; fixing it still takes coaching, better qualification and the right tools around the CRM, which our overview of sales enablement tools covers.
What should a sales dashboard checklist include?
Use this list before you share a new dashboard with the team.
- One sentence describing the audience and the decision the dashboard supports
- Five to nine tiles, each tied to that decision
- Written definition for every KPI, including date field and exclusions
- Critical CRM fields made required: amount, close date, stage, owner, source, loss reason
- Duplicates merged and stale deals closed or updated
- Headline number top left, with target and previous period shown
- Charts matched to questions: big numbers, bars, lines, no 3D
- One warning colour, used only for numbers below target
- Filters for period and owner; drill-down from tiles to underlying records
- Automatic refresh, no manual exports
- Assigned to a recurring meeting with a named owner
- Review date set one month after launch
A dashboard is one of the last steps of a CRM rollout, not the first. If you are still setting the system up, our CRM implementation plan shows where reporting fits into a 90-day schedule.
Sales dashboards: frequently asked questions
What should be on a sales dashboard?
Only the numbers that drive a decision for the person looking at it. For most small teams that means revenue against target, open pipeline value by stage, win rate, average deal size, sales cycle length and one or two activity metrics. Five to nine tiles per dashboard is a sensible limit.
What is the difference between a sales dashboard and a sales report?
A report answers one question in detail, usually as a table or a single chart. A dashboard puts several reports side by side on one screen so you can see the state of sales at a glance and spot where to dig deeper.
How often should a sales dashboard update?
Activity and pipeline dashboards built inside the CRM should refresh in near real time or at least hourly. Revenue and forecast dashboards that combine CRM data with billing or finance data can refresh daily, because those numbers do not change minute by minute.
Can I build a sales dashboard in Excel or Google Sheets?
Yes, for a team of two or three reps with one pipeline. Once data has to be copied by hand every week, or several people edit the same sheet, the dashboard goes stale. At that point the reports built into your CRM, or a BI tool connected to it, are more reliable.
How many dashboards does a small sales team need?
Usually three: a rep dashboard for daily work, a manager dashboard for the weekly pipeline review and a leadership dashboard for the monthly revenue and forecast review. Add more only when a recurring meeting needs a view the three do not provide.
Why do sales dashboards stop being used?
The most common reasons are numbers nobody trusts because CRM data is incomplete, too many metrics with no clear owner, and no meeting where the dashboard is actually opened. Fix data entry first, cut tiles that nobody acts on and tie each dashboard to a fixed meeting.



