Sales Dashboard: What to Put on It, and How to Make Your Team Actually Use It
A sales dashboard earns its place only if someone opens it on Monday morning. Here is what to put on one for founders, sales heads and reps, how to lay it out, and a weekly routine that keeps it in use.
By DigiPix Flow team
In this guide
Most growing businesses have one. Someone spent a week building it, with a dozen charts, a colour scheme and a row of filters. It was shown proudly in a team meeting. Six weeks later, when the founder wants to know how sales are going, they don't open it. They send the sales head a WhatsApp message, the sales head asks the team, and someone opens a spreadsheet.
The problem is rarely a lack of numbers. It is that the sales dashboard answers questions nobody is asking, shows figures nobody trusts, or gives everyone the same view when each person needs a different one. This guide covers what a dashboard is for, what to put on it for each role, how to lay it out and the weekly habit that keeps people coming back to it.
What a sales dashboard is for
A sales dashboard is a single screen that shows the current state of your sales effort: how many enquiries are coming in, what the open pipeline is worth, what is due today and how many deals the team is winning. Its job is to tell you, in under a minute, whether things are on track and where to look if they are not.
That makes it different from a report. A report answers a specific question in depth, such as which lead sources grew this quarter. A dashboard is a summary you glance at often. Mixing the two is where most dashboards go wrong: they try to hold every report the business has ever needed, and the important numbers get buried.
| Aspect | Dashboard | Report | Spreadsheet |
|---|---|---|---|
| Purpose | A quick check on the state of sales | A detailed answer to one question | Ad hoc analysis and one-off workings |
| How often it's opened | Daily or weekly | Weekly, monthly or on demand | When someone has time |
| Where numbers come from | The CRM's own records | The CRM's own records | Exports pasted in by hand |
| Typical size | Four to six numbers and one or two charts | One chart and a breakdown table | As many tabs as it takes |
Why most sales dashboards stop being opened
When a dashboard falls out of use, the cause is usually one of three things.
- The numbers go stale. If the dashboard depends on someone exporting data and updating a sheet, it is only as fresh as the last time they remembered. The first time a manager spots a deal they closed yesterday missing from the total, trust drops and never quite recovers.
- It answers the wrong questions. Total leads this year is interesting once. A sales head on Monday morning wants to know which leads are waiting for a reply, which deals are stuck and what is due today.
- Everyone gets the same view. The founder cares about the size and health of the pipeline. A rep cares about their own follow-ups. One screen for all of them ends up useful to none.
The instinctive fix, adding more charts, makes it worse. Every extra tile makes the one number that matters harder to find. Fewer, better-chosen numbers are almost always the answer.
The questions your dashboard should answer
Start from questions, not from charts. Write down the questions people actually ask in your sales meetings and on WhatsApp. For a typical enquiry-led business, the list looks something like this:
- How many new enquiries came in this week, and is that more or fewer than last week?
- Which leads are still waiting for a first reply? The idea of speed to lead explains why this one matters so much.
- What is the open pipeline worth, and in which stages is it sitting?
- Of the deals we closed recently, how many did we win?
- What does the team have to do today, and what is already overdue?
- Which sources are bringing the enquiries, and has any of them gone quiet?
Each question becomes one number or one chart. If a tile on your current dashboard doesn't answer a question on the list, it is a candidate for removal.
What to put on a sales dashboard, by role
Build one set of records and several views of it. The table below is a starting point; adjust it to how your team sells.
| Role | The question they ask | What belongs on their view |
|---|---|---|
| Founder or director | Are we on track, and is the pipeline healthy? | New leads vs last period, open pipeline value, win rate, pipeline by stage |
| Sales head | Where is the team stuck, and who needs help? | Leads waiting for first contact, overdue follow-ups, deals per stage, recent wins and losses with reasons |
| Sales rep | What do I need to do today? | Their own tasks due today, their open leads and deals, their overdue follow-ups |
| Marketing | Which channels bring enquiries worth having? | Leads by source over 30 days or a quarter, each source's share, qualified leads by source |
The key is that these views share one set of records. When the founder and the sales head look at the pipeline, they should see the same total, cut to what each is allowed to see. Separate spreadsheets per person bring back the old argument about whose number is right.
Layout rules for a dashboard people trust
- Four to six headline numbers at the top. Put the answers to your most frequent questions first, in large type.
- Compare every number with something. Forty new leads means little on its own. Forty against fifty-five last week tells a story.
- Use one date range across the screen. Mixing a 7-day lead count with a 90-day win rate invites wrong conclusions.
- Show counts beside values. A pipeline of ₹45,00,000 could be three big deals or forty small ones, and those need different actions.
- Write definitions down. Agree what counts as a lead, a qualified lead and a win. The win rate should mean deals won out of deals closed, not out of every lead.
- Attach an action to each number. If leads waiting for a reply go above ten, the sales head reassigns. If a stage is swelling, the team reviews those deals.
A worked example
Example, with invented names and figures. Kaveri Interiors in Pune gets enquiries from Meta ads, Google Ads and its website. On Monday at 10:00, the sales head opens the dashboard and sees four numbers: 62 new leads in the last seven days against 48 the week before, an open pipeline of ₹38,50,000, 17 tasks due today and a 30-day win rate of 28%. The pipeline by stage chart beneath shows ₹21,00,000 sitting in Site visit done, more than double any other stage.
That is enough to set the week. Lead volume is up, so she checks that new enquiries are being contacted quickly. The swollen Site visit done stage tells her quotes are not going out fast enough, so the Monday meeting focuses on those deals. Our guide to sales pipeline stages covers how to define stages so this kind of pile-up shows clearly.
A weekly routine that keeps the dashboard in use
A dashboard becomes a habit only when it is built into the week. A simple rhythm for a small team:
- Every morning, reps check their own view. Tasks due today and overdue follow-ups first, before opening WhatsApp.
- Monday, the sales head runs a 15-minute review from the dashboard. New leads against last week, leads waiting for a reply, stage totals and any big change in win rate. Decisions are noted, not just numbers.
- Monthly, marketing and sales look at leads by source together. Which channels grew, which went quiet, and which brought enquiries the team could actually qualify. Pair this with a lead conversion rate calculator to compare sources on the same footing.
- Quarterly, prune the dashboard. Remove any tile nobody referred to in three months, and add one only if it answers a question that keeps coming up.
The rule that makes this work: in the Monday meeting, nobody quotes a number that isn't on the dashboard. If someone needs a figure that isn't there, that is a signal to add it, not to open a side spreadsheet.
Common sales dashboard mistakes
- Putting every metric on one screen, so nothing stands out
- Showing totals without a comparison to the previous period
- Counting leads but never showing how many became customers
- Letting reps see a company-wide view instead of their own work
- Relying on figures that someone updates by hand each Friday
- Building the dashboard once and never reviewing what is on it
Where DigiPix Flow fits
In DigiPix Flow, the home screen opens on four numbers: new leads over the last seven days compared with the seven before, the value of the open pipeline, tasks due today and the win rate over the last 30 days, with a pipeline snapshot beneath. Each figure is worked out from the records the person signing in is allowed to see, so a rep sees their own work and a manager sees wider totals.
For the deeper questions, CRM reports cover leads by source and open pipeline by stage over 7 days, 30 days, a quarter or a year. You can save a report, put it on a daily, weekly or monthly schedule with a notification when it is ready, and export it as a CSV. Overdue work shows up in the follow-up queues rather than on a chart. The product holds no ad spend, so cost per lead still means combining your ad platform's spend with the lead counts.
Make it the first place people look
A good sales dashboard is short, trusted and opened every week. Start from the questions your team asks, give each role its own view of the same records, and run the Monday review from the screen rather than from memory. If you are still unsure your numbers capture where leads came from, our guide to lead source tracking is the place to start.
Want a dashboard your team opens without being asked? Talk to an expert and we'll walk through the numbers your founder, sales head and reps would see.
Frequently asked questions
What should be on a sales dashboard?
Four to six numbers that answer your most frequent questions: new leads compared with the previous period, leads waiting for a first reply, open pipeline value, pipeline by stage, win rate and tasks due today. Add leads by source for marketing. Anything that doesn't answer a recurring question belongs in a report instead.
What is the difference between a sales dashboard and a sales report?
A dashboard is a quick summary of the current state of sales, opened daily or weekly. A report answers one specific question in more depth, such as which lead sources grew this quarter. Most teams need one dashboard per role and a small set of saved reports.
How many metrics should a sales dashboard show?
For most small teams, four to six headline numbers and one or two charts are enough. More than that and the important figures get lost. If people keep asking for a number that isn't there, add it, and remove anything nobody has referred to for a few months.
Should sales reps see the same dashboard as managers?
No. Reps need their own tasks, leads, deals and overdue follow-ups. Managers need team-wide totals, stuck deals and response times. Both views should come from the same records, so the numbers agree, but each person should see only what their role allows.
Why does nobody use our sales dashboard?
Usually because the numbers are out of date, it answers questions nobody asks, or everyone gets the same view. Rebuild it from the questions asked in your sales meetings, make sure figures come from the CRM rather than hand-updated sheets, and run a weekly review from it.
Put this guide into practice
See qualification questions, lead scoring and follow-up built into one workspace, using your own lead sources.
