What should a sales manager dashboard show?
Short answer: A sales manager dashboard should show the things that need a decision this week: new leads with no owner, follow-ups that are overdue, deals that haven’t moved, how much open pipeline each rep is carrying against what they need to close, and where this month’s leads come from. If a number never changes what you do, cut it.
Most dashboards I’ve seen in small teams fail the same way. They’re built to look busy. There are six charts, two of them pie charts, and the manager still opens the lead list and scrolls through it by hand on Monday morning because the dashboard doesn’t answer the question they actually have: what’s stuck, and who needs help?
This post is about the screen itself: what goes on it, in what order, and what to leave off. If you want help choosing which numbers to track in the first place, our post on sales team KPIs covers that, and the pipeline review meeting post covers how to talk through the results with your team. Here, the goal is a single view a manager can read in five minutes.
Where I’m coming from: I run Diligent Creators, a software and marketing agency, and I’m building EloSync, a CRM. I won’t quote benchmark conversion rates or “average” dashboard numbers here, because I don’t have real data behind them and neither do most of the posts that quote them. What follows is a layout I’d use, and the reasons behind each part.
Why most sales dashboards don’t get used
Because they report on the past instead of pointing at work. A chart of last quarter’s revenue is fine for a board meeting, but it doesn’t tell a manager which lead to chase today.
Three things usually go wrong:
- Too many numbers. When everything is on the screen, nothing stands out. People stop looking.
- Totals with no names. “34 open deals” doesn’t help. “Seven of one rep’s deals haven’t moved in three weeks” does.
- Data nobody trusts. If reps don’t update stages or close leads with a reason, the dashboard is wrong, and everyone knows it. Then it’s decoration.
The fix for the first two is design. The fix for the third is habit, and it comes before any dashboard. A dashboard only shows what the team actually records.
The five sections of a useful sales manager dashboard
Put the sections in the order you’d act on them: problems first, then pipeline health, then results. A manager who only has two minutes should still see the urgent part.
1. Needs attention now
This is the top of the screen, and it should be a list, not a chart. Each line is a lead or deal with a name next to it.
- New leads with no owner. Anything that arrived and hasn’t been assigned. If your lead routing rule works, this list is usually empty, and that’s the point of checking it.
- Overdue follow-up tasks. Grouped by rep, oldest first.
- Open leads with no next task at all. These are the quietest leaks, because nothing goes red when a lead simply has no next step.
If this section is long, nothing below it matters much this week. Clear it first.
2. Stalled deals
Deals that have sat in the same stage longer than your normal cycle for that stage. You pick the threshold. For a team that usually moves from proposal to decision in a week, ten days in “Proposal sent” is a flag. For a team selling six-month projects, it isn’t.
Show the deal name, owner, stage, and days since it last moved. That’s enough for a manager to ask one useful question: “What’s the next step here, and is it still a real deal?” If your stages are fuzzy, sort that out first; our guide to sales pipeline stages covers how to define exit criteria so “stalled” means something.
3. Pipeline by rep
For each rep: how many open deals, the total value at each stage, and how that compares with what they’re expected to close this month or quarter. A simple table works better than a funnel chart here, because you want to compare people side by side.
What you’re looking for is imbalance. One rep with a pipeline full of early-stage deals and nothing near closing needs a different conversation from one rep with three big deals all waiting on the same decision. Keep it a coaching tool, not a league table you read out in front of everyone.
4. Lead flow and sources
New leads this week and this month, split by source: website form, Facebook lead forms, referrals, phone, and so on. Add one column for how many of those became a qualified conversation.
This tells you whether a slow month is a sales problem or a marketing problem. If leads are flat but conversations dropped, look at follow-up. If both dropped, look at the top of the funnel. Our post on lead source tracking explains how to record the source reliably so this section isn’t guesswork, and if marketing owns the inbound side, it helps to agree on the same definitions they use in their marketing KPIs.
5. Results and reasons
At the bottom: deals won and lost this period, and the reasons for each loss. Results matter, but by the time they show up, the work that caused them is weeks old. That’s why they go last.
The loss reasons are the useful part. A pattern like “went quiet after proposal” across several deals points at something you can change. Our post on win loss analysis covers how to collect close reasons that are worth reading.
What to leave off the dashboard
Anything that doesn’t change a decision. A short list of things I’d cut from a small team’s dashboard:
- Activity counts on their own. Calls made and emails sent are easy to inflate and say little about whether deals move. If you track activity, see our post on sales activity tracking for which activities are worth counting.
- Year-to-date revenue charts. Useful for finance. Not useful on a Monday morning.
- Weighted forecast to the decimal. A small team’s forecast is a range, not a precise figure. Keep it in a separate monthly view; our sales forecasting for small teams post explains why.
- Anything nobody has looked at in a month. If you remove it and no one asks where it went, it didn’t belong there.
Daily, weekly and monthly views
One screen can’t do everything. Splitting it by how often you look keeps each view short.
| View | When | What’s on it | Question it answers |
|---|---|---|---|
| Daily | Start of day, 2 minutes | Unowned leads, overdue tasks, leads with no next task | What’s slipping right now? |
| Weekly | Before the pipeline review | Stalled deals, pipeline by rep, lead flow this week | Who needs help, and on which deals? |
| Monthly | Month end | Won and lost deals, loss reasons, leads by source, forecast range | What should we change next month? |
This table is an example layout, not a standard. Adjust the timing to your sales cycle.
Should reps see the same dashboard?
Mostly no. A rep needs their own version of the top two sections: their overdue tasks, their leads with no next step, and their stalled deals. They don’t need the team comparison.
Who can see what is a permissions question as much as a design one. A CRM with roles lets you give reps their own records and managers the whole team, which also keeps sensitive deal values limited to the people who need them. Our post on role-based access in a CRM goes through how to set that up for a small team.
How to build a sales manager dashboard without a BI tool
You don’t need a business intelligence platform for this. For a team of up to a dozen people, a spreadsheet is often enough to start, as long as the data underneath it is clean.
- Decide the fields first. Every lead needs an owner, a source, a status or stage, a “last stage change” date, a next task date, and a close reason when it’s closed. If any of these are missing in your records, the dashboard can’t show them.
- Get the data out. Export from your CRM to CSV, or, if your CRM has a REST API, pull the records on a schedule. If you’ve never connected two systems before, this API integration guide on my personal blog covers the basics.
- Build the “needs attention” list first. Filters do most of the work: owner is empty; next task date is before today; stage is open and next task date is empty.
- Add stalled deals. Today’s date minus the last stage change date, filtered to anything over your threshold.
- Add the rep table and lead sources last. These are summaries, and they’re only as good as the fields from step 1.
Our comparison of Excel vs CRM covers when a spreadsheet stops being enough. The usual signal is that updating the dashboard has become someone’s weekly chore.
Where EloSync fits
I’ll stick to what’s on our site. EloSync is a modular CRM, and Leads, Tasks and ToDos are free. Leads can come in from Meta Lead Ads (Facebook lead forms), through a webhook from your own forms, or by manual entry, which gives you one lead list to report on. Follow-ups can live as tasks on a Kanban board, so overdue work is visible, and roles control what each person sees. Marketplace add-ons extend it, and the REST API and webhooks let you send data to a spreadsheet or another reporting tool.
To be clear about limits: EloSync doesn’t claim a dedicated sales manager dashboard. The views in this post are ones you’d build from your lead and task data, in a spreadsheet or another tool connected through the API. If that setup sounds right for your team, see how EloSync works for sales teams.
FAQ
What is a sales manager dashboard?
It’s a single view of the sales team’s leads, follow-ups and pipeline, built for the person who manages the team. A good one points at work that needs a decision, such as unowned leads and stalled deals, rather than only reporting past results.
How many metrics should a sales dashboard have?
As few as you can act on. For a small team, five short sections are plenty: items needing attention, stalled deals, pipeline by rep, lead flow by source, and results with loss reasons. If a number never changes a decision, remove it.
What’s the difference between a sales dashboard and a sales report?
A dashboard is something you check often to decide what to do next. A report is a summary of a finished period, usually for planning or for people outside the team. Many teams need both, but mixing them makes the dashboard too long to read.
How often should a sales manager check the dashboard?
Check the attention list daily, the pipeline views weekly before the team review, and the results monthly. The daily check should take a couple of minutes; if it takes longer, the screen has too much on it.
Can I build a sales dashboard in Google Sheets or Excel?
Yes. Export your lead and deal data, or pull it through your CRM’s API, and use filters for the attention list and a simple table for pipeline by rep. It works well for small teams, as long as owners, stages and next task dates are kept up to date.
