Table of Content
What should a sales dashboard include?
A good sales dashboard shows revenue against target, the pipeline that will produce it, win rate, average deal size and sales cycle length, each with a trend. It adds leading signals such as new pipeline and meetings booked, so you can see problems before revenue drops. The right view differs for reps, managers and executives, so build one dashboard per audience.
The short version
- Build for one audience at a time. A rep needs today’s tasks. A manager needs coaching signals. An executive needs the forecast.
- Put leading numbers next to lagging ones. Revenue is the result. New pipeline, meetings and speed to lead are the causes you can still change.
- Define every metric once. “Win rate” can mean three different things. Write the formula on the page.
- Pipeline coverage comes from your own win rate. If you win one deal in four, you need roughly four times your remaining target in open pipeline.
- Dashboards only work on clean CRM data. Required fields, stage definitions and close-date discipline matter more than chart style.
- Need one built on your CRM? Our business intelligence dashboard services team builds sales dashboards on your own data.
What makes a sales dashboard useful
Many sales dashboards fail because they show activity instead of decisions. A page full of calls made and emails sent tells you people are busy. It does not tell you whether you will hit the quarter.
A useful dashboard answers a small number of questions: Are we on track? Where is the pipeline weak? Which deals need help? Which reps need coaching? What will we actually close? Each of the ten examples below is built around one of those questions, with the metrics, formulas and chart types that fit.
If you want to see how this fits a wider reporting set, read our guides to executive dashboard examples and financial dashboard examples.
The sales dashboard KPIs behind these examples
Define these once, in plain language, and show the formula on the dashboard. Teams argue less when everyone sees the same definition.
| Metric | Formula | Best chart | Type |
|---|---|---|---|
| Quota attainment | Closed-won revenue / quota | Bullet or progress bar | Lagging |
| Win rate | Deals won / (deals won + deals lost) | Trend line by segment | Lagging |
| Average deal size | Total won value / number of won deals | Trend line | Lagging |
| Sales cycle length | Average days from creation to close-won | Bar by segment | Lagging |
| Pipeline coverage | Open pipeline value / remaining quota | Single number with a target | Leading |
| Sales velocity | (Opportunities x win rate x average deal size) / sales cycle length | Trend line | Mixed |
| New pipeline created | Value of new opportunities in the period | Column by week | Leading |
| Speed to lead | Time from lead creation to first contact | Median with a threshold | Leading |
| Forecast accuracy | 1 – (absolute forecast error / actual) | Trend by quarter | Lagging |
| Deal push rate | Deals whose close date slipped / deals due in the period | Single number and list | Leading |
| Net revenue retention | (Starting recurring revenue + expansion – contraction – churn) / starting recurring revenue | Trend line | Lagging |
Two notes. First, pipeline coverage has no universal target. Divide 1 by your win rate to get a starting point. A 25% win rate suggests about four times your remaining quota, and a 40% win rate suggests about two and a half times. Second, show two or three leading metrics beside every lagging metric, so cause and effect sit in the same view.
10 sales dashboard examples
Use these as a sales dashboard sample to adapt. Each example lists who it is for, the question it answers, what to show and what to watch for. You can build all ten in a CRM’s built-in reports or in a BI tool such as Power BI.
1. Sales performance overview
For: Sales leaders and executives. Question: Are we on track for the period? This is the classic sales performance dashboard.
Show: Quota attainment, revenue against target by month, win rate, average deal size, sales cycle length and pipeline coverage, each with a comparison to the last period.
Layout: Six number cards on top, a revenue-versus-target line below and a short list of risks at the bottom.
Choose it if you need one weekly page for leadership. Watch for too many cards. Six is plenty.
2. Pipeline health
For: Sales managers. Question: Where is the pipeline strong, thin or stuck?
Show: Open pipeline by stage, by owner and by expected close month. Add deal age in stage, a list of stalled deals with no activity and pipeline coverage against the remaining quota.
Layout: A stage funnel, an aging bar chart and a clickable table of deals needing attention.
Choose it if deals sit in stages without moving. Watch for inflated pipeline. Remove deals with no next step or no recent contact.
3. Rep scorecard
For: Account executives. Question: How am I doing, and what should I do today?
Show: My quota attainment, my open deals with next steps, my tasks due, my pipeline coverage and my win rate against the team average.
Layout: A short page with action lists on the left and results on the right. Keep to five to seven numbers.
Choose it if you want reps to use the CRM daily. Watch for surveillance feel. Show reps their own numbers first.
4. Manager coaching dashboard
For: Sales managers. Question: Who needs help, and with what?
Show: A rep-by-rep table with conversion at each stage, average cycle length, deal push rate and activity-to-outcome ratios. Highlight outliers against the team median.
Layout: A comparison table with color flags and a drill-down to each rep’s deals.
Choose it if you run one-to-one coaching sessions. Watch for ranking by activity alone. A rep with fewer calls and more wins may be doing it right.
5. Forecast dashboard
For: Sales leaders and finance. Question: What will we actually close this period?
Show: Committed, best-case and weighted pipeline against target, forecast accuracy for past quarters, deals that slipped and the deals that decide the quarter.
Layout: A stacked bar against the target line, plus a list of the largest open deals with their stage and next step.
Choose it if finance relies on your forecast. Watch for forecasting by gut. Track accuracy each quarter and improve the method.
6. Lead generation and SDR dashboard
For: Sales development and marketing. Question: Is the top of the funnel healthy?
Show: New leads, speed to lead, lead-to-opportunity conversion, meetings booked, no-show rate and opportunities created by source.
Layout: A funnel from lead to opportunity and a trend of weekly meetings booked. Our guide to lead scoring models shows how teams prioritize leads, and our guide to AI sales agents covers automating first contact.
Choose it if leads wait too long for a reply. Watch for counting leads over quality. Track conversion, not only volume.
7. Lead source and funnel conversion
For: Marketing and sales leaders. Question: Which sources bring customers, not just leads?
Show: Opportunities, wins, revenue and cost per won customer by source and campaign, with the time each takes to close.
Layout: A table by source with a conversion bar, and a trend for the top three. Join web data using our guide to Google Analytics dashboard examples.
Choose it if you spend on several channels. Watch for last-touch bias. Choose one attribution rule and state it on the page.
8. Customer and revenue retention
For: Customer success and executives. Question: Are we keeping and growing the revenue we win?
Show: Net revenue retention, churned and expanded revenue, accounts at risk and renewal dates in the next quarter.
Layout: A retention trend, a renewal calendar and a list of accounts with falling usage or open issues. See our guide to customer retention strategies.
Choose it if you sell subscriptions or repeat contracts. Watch for ignoring expansion. Growth from existing customers is part of sales.
9. Product, region and segment analysis
For: Executives and sales operations. Question: Where does revenue come from, and where is growth?
Show: Revenue and margin by product, region and customer segment, with year-over-year change and win rate for each.
Layout: A map or ranked bar chart, plus a matrix of product by segment.
Choose it if you sell several products or serve several markets. Watch for small groups. A segment with few deals can swing wildly.
10. Bookings to cash
For: Sales, finance and operations. Question: Do the deals we win become invoices and cash on time?
Show: Bookings, orders entered, invoices issued, payments received and days from close to cash. Add a list of won deals not yet invoiced and overdue invoices by owner.
Layout: A flow from bookings to cash, with drop-off at each step. This view needs both CRM and ERP data, so see our CRM-ERP integration guide. Our guides to cash flow forecasting and payment reconciliation cover the finance side.
Choose it if sales and finance disagree about revenue. Watch for mismatched definitions. Agree on the master system for orders and invoices.
Who needs which dashboard
| Audience | Dashboards | How often to review | Keep to |
|---|---|---|---|
| Account executive | Rep scorecard, own pipeline | Daily | 5 to 7 numbers |
| SDR or lead team | Lead generation and SDR | Daily | 5 to 7 numbers |
| Sales manager | Pipeline health, coaching, forecast | Weekly | 8 to 10 numbers |
| Sales leader | Overview, forecast, product and region | Weekly and monthly | 6 to 8 numbers |
| Finance and operations | Forecast, bookings to cash | Weekly and monthly | 6 to 8 numbers |
| Customer success | Retention | Weekly | 5 to 7 numbers |
Get your CRM data ready first
A dashboard shows what is in the CRM. If the data is wrong, the dashboard will be wrong with confidence. Set these rules before you build.
- Define each stage with entry and exit criteria, so deals move for clear reasons.
- Make key fields required: amount, close date, owner, source and next step.
- Keep close dates honest. Review any deal whose date has passed.
- Merge duplicates for companies and contacts.
- Standardize names and product codes so reports group correctly.
- Assign a data owner who audits the CRM each month.
If you are still choosing a platform, our comparison of the best CRM software covers pricing and AI features. If your customer data sits in several tools, our customer data platform service can bring it into one view.
How to build a sales dashboard in 7 steps
- Choose the audience and the question. “Which deals are at risk this quarter?” for the sales manager.
- Pick the five to eight metrics that answer it, and write their formulas.
- Check the data for the required fields and the last 12 months of history.
- Sketch the layout. Put the headline numbers top left, a trend beside each one and a table of exceptions below.
- Build and test. Compare totals with a report your team already trusts.
- Set alerts and refresh. Daily for reps, weekly for managers. Alert when a threshold is crossed.
- Review usage after a month. Remove pages nobody opens and add what people ask for.
Where to build it
| Option | Best for | Watch for |
|---|---|---|
| CRM built-in dashboards | Fast start, no extra tool | Limits when you join other data |
| Power BI (for a Power BI sales dashboard) | Joining CRM, ERP and finance data | License cost per viewer |
| Looker Studio | Free dashboards over web and ad data | Less suited to deep CRM modeling |
| Spreadsheets | Very small teams, a first version | Manual refresh and version problems |
| Dedicated BI tools | Larger teams with many sources | Setup and governance effort |
Teams also add AI to dashboards, for example forecasts and alerts when a deal stalls. Our predictive analytics services and AI automation teams build these on top of your data.
6 sales dashboard mistakes to avoid
- Showing activity as success. Calls and emails are inputs, not results.
- Too many metrics. Pages with dozens of cards go unread.
- No definitions. Two people read the same number two ways.
- Stale data. Show the last refresh time on every page.
- One dashboard for everyone. Reps, managers and executives need different views.
- Ignoring the follow-up. A dashboard without a weekly review habit changes nothing.
Frequently Asked Questions
What should a sales dashboard include?
It should include revenue against target, pipeline by stage, win rate, average deal size, sales cycle length and pipeline coverage, with trends. Add leading metrics such as new pipeline and meetings booked. Tailor the page to the audience.
What is a good dashboard for sales?
A good sales dashboard answers one question for one audience. For managers it shows pipeline health, stalled deals and coaching signals. For executives it shows forecast, attainment and risks. It has clear formulas, trends and a refresh time.
What are the four main types of dashboards?
The four common types are strategic dashboards for leaders, operational dashboards for daily monitoring, analytical dashboards for deeper exploration and tactical dashboards that track a project or campaign. Sales teams use all four.
What is the 5 second rule for dashboards?
It says a viewer should understand the main message within about five seconds. Put the headline numbers at the top, use clear labels and remove anything that does not support the main question.
What does a good dashboard look like?
A good dashboard has a clear title and question, six to eight key numbers with targets, a trend for each and a way to drill into detail. It uses consistent colors, shows the refresh time and avoids clutter.
What are the top dashboard tools for sales?
Common choices are the built-in dashboards in your CRM, Power BI, Tableau and Looker Studio. Choose by where your data lives, how many people need access and who will maintain the dashboards.
Can ChatGPT make dashboards?
It can help you draft metric definitions, formulas, queries and a layout sketch. It cannot connect to your live CRM by itself, so you still need a BI tool or a connected agent, and you must check its numbers.
Are dashboards outdated?
No. Teams still need a shared view of key numbers. Good dashboards are shorter and question-led, with alerts when something changes, and many now add AI summaries on top of the data.
How do I build my own sales dashboard?
Choose an audience and a question, pick five to eight metrics, check your CRM data, sketch a layout, build it in your CRM or a BI tool, test the totals and review usage after a month.
How often should a sales dashboard refresh?
Match the refresh to how fast decisions change. Reps benefit from daily or near real-time updates, managers from daily or weekly, and executives from weekly. Always show the last refresh time.
Bottom Line
Good sales dashboards are small and specific. Define your metrics, build one view for each audience, put leading signals beside results and keep the CRM data clean. Review the dashboards in a weekly meeting, because a number nobody discusses does not change behavior.
If you want dashboards built on your CRM, ERP and store data, explore our business intelligence dashboard services.
