# A sales dashboard for a manager: six numbers on one screen and what to cut

https://salesbond.app/blog/sales-manager-dashboard-six-numbers/
Published: 2026-09-29 · Updated: 2026-10-26

A sales manager dashboard should hold about six numbers, and each should tell you what to do next: open pipeline against target, deals with no next step, deals past their close date, activity on key deals, win rate over a fixed window, and time in stage. Anything that does not change what you do on Monday belongs in a report, not on the screen.

The dashboard feeds both jobs, but they run on different rhythms: see [inspecting the pipeline versus reviewing it](https://salesbond.app/blog/pipeline-inspection-vs-review-pipedrive/).

A sales dashboard is a live screen in your CRM with a handful of numbers that update from your deal data. You look at it; you don’t send it around. That’s the difference from a report, and it’s the whole idea behind what follows: how to pick the six, what to throw out, and how to tell when the screen is lying to you.

When someone else needs to see it, pick [viewer, editor or public link](https://salesbond.app/blog/share-pipedrive-insights-dashboard/) on purpose; they give different people different powers.

## Start from the Monday questions, not from the widget list

Most sales dashboards get built backwards. Someone opens the dashboard editor in the CRM, sees a long menu of charts, and adds whatever looks useful. A month later the screen is a wall of tiles and nobody can say which one to look at first.

Flip it. Before you touch a chart, write down the questions you actually ask at the start of the the week. For a small team they tend to be the same handful:

- Is there enough in the pipeline to hit the number, or do we need to prospect this week?
- Which deals are drifting, and who owns them?
- Are reps spending time on the deals that can close?
- Are we getting better or worse at winning?

Each question gets one number. If a number doesn’t answer a question on that list, it doesn’t earn a tile.

This also gives you a test for every future request. When someone asks to add “calls made this month” to the screen, ask what they would do differently if that number went up or down. If the answer is “nothing, it’s just nice to see,” it goes in a report.

## The six KPIs, and what each one should make you do

Here is the set we’d start with. The right column matters more than the left one: a number without a trigger is decoration.

| Number | What it shows | What it should make you do |
| --- | --- | --- |
| Open pipeline vs target | Value of open deals expected to close this period, next to the target | Short of target: book prospecting time this week, not next month |
| Deals with no next step | Open deals with no scheduled activity | Call list for today. Every one of these gets an owner and a date |
| Deals past their close date | Open deals whose expected close date is already behind you | Ask the rep: new date with a reason, or close it as lost |
| Activity on key deals | Calls, meetings and emails logged on key deals | Low activity on a key deal: that’s your 1:1 topic |
| Win rate over a fixed window | Won deals divided by all closed deals, over the same rolling window every time | A drop points you to the stage where deals are dying |
| Time in stage | How long open deals have sat in their current stage | A stage where deals pile up is a process problem, not a rep problem |

A few notes on reading them.

By key deals we mean your biggest open deals plus the ones in the last stages of the pipeline. Decide the cut once, write it down, and use the same list everywhere.

Open pipeline against target is the only number here that looks forward in money. We’d put it top left. If you want the ratio behind it, we wrote about [pipeline coverage](https://salesbond.app/blog/pipeline-coverage-ratio/) separately.

The two hygiene numbers, no next step and past close date, will look boring on a good week. That’s the point. They’re the early warning that everything else on the screen is about to get worse. A director who oversees several managers needs a different cut of the same data: [five weekly CRM checks for each team](https://salesbond.app/blog/managing-sales-managers-crm-pipeline-review/), run with its manager.

Win rate needs a fixed window, and you have to keep it fixed. If one week it’s “this month” and the next it’s “this quarter,” the trend line is noise. Pick one and write it in the tile title.

Win rate is also one of the inputs to [sales velocity](https://salesbond.app/blog/sales-velocity-pipedrive/), along with deal count, deal size and cycle length.

Time in stage is the slowest to react. Look at it weekly, not daily.

If your team runs on Pipedrive, you’ll build this screen in Insights. The choice of numbers doesn’t change with the CRM, though. If the team works remotely, see [managing a remote sales team from Pipedrive](https://salesbond.app/blog/remote-sales-team-visibility-pipedrive/).

One caution before you share the dashboard: a rep who opens it can see [different totals, because of visibility and Insights permissions](https://salesbond.app/blog/pipedrive-insights-different-numbers/).

![Sales dashboard with key performance indicators](https://salesbond.app/wp-content/uploads/2026/09/sales-manager-dashboard-2.png)

## What to leave off the screen

The usual sales KPI dashboard examples you’ll find online list the same menu: deals in pipeline, win rate, average deal size, time to close, activities. Some of those made our six. The rest we’d take off the screen, and the reason is almost always the same. They describe what already happened, and they move too slowly to change a decision this week. (More on that split in [leading vs lagging sales metrics](https://salesbond.app/blog/leading-vs-lagging-sales-metrics/).)

What we’d cut:

- Revenue closed this month. Everyone already knows it, and by the time it moves the month is over.
- Average deal size. Useful for planning and pricing, useless for Monday. It barely changes week to week.
- Total activity count per rep. It rewards volume and says nothing about whether the activity landed on deals that can close. That’s why our activity tile counts key deals only.
- Leaderboards. Some reps get a push from them, others get embarrassed, and a manager rarely has anything to do about either. If you want one anyway, we wrote up [how to build a sales leaderboard that does not embarrass anyone](https://salesbond.app/blog/sales-leaderboard-small-team-pipedrive/).
- Number of deals in pipeline. A count without value or age hides the one thing you care about: whether those deals are real.

On revenue closed this month: in Pipedrive the [Won total is bookings, not revenue](https://salesbond.app/blog/bookings-vs-billings-vs-revenue-pipedrive/), so the finance number lives somewhere else anyway.

We go through [which activity metrics are signal and which are theatre](https://salesbond.app/blog/sales-activity-metrics-small-team/) in a separate piece.

None of these are bad numbers. They just answer questions you ask once a month, or once a quarter, so they don’t need a tile you see every morning.

## When the dashboard lies

The worst dashboard isn’t the cluttered one. It’s the clean one that shows green while the pipeline underneath is rotting.

This happens for a boring reason: every number on the screen is computed from fields that reps fill in by hand, and those fields go stale quietly. The expected close date is the biggest offender. A rep sets it when the deal is created, the buyer goes quiet, and nobody touches the date. The deal still counts toward this period’s open pipeline, so your first tile looks healthy. It isn’t.

Next steps go stale the same way. A deal with an activity scheduled weeks out technically has a next step. It shows up as fine. In practice nobody is working it.

So before you trust the screen on a Monday, check it against the two hygiene tiles. If deals past their close date are climbing while open pipeline against target looks fine, the pipeline number is inflated by deals that should have been moved or closed. If deals with no next step is near zero but win rate is falling, look at how far out those next steps are scheduled. You’ll often find a cluster of placeholder activities that exist only to keep the deal off the list.

We’d rather see an ugly, honest dashboard than a pretty one built on dates nobody believes. If this keeps happening, the fix is upstream: it’s a [CRM data quality](https://salesbond.app/blog/crm-data-quality-metrics/) problem, and no amount of chart design will cover it.

## The rep’s screen and the manager’s screen

A dashboard is live and tells you what to do now; a report is a weekly snapshot that explains what changed. Even the live screen, though, shouldn’t be the same for everyone. A rep and a manager need different versions.

The rep needs thier own deals, sorted by what to do today: no next step, past close date, the key deals they haven’t touched this week. They don’t need team win rate. It isn’t theirs to fix on a Tuesday afternoon.

The manager needs the team view of the same six numbers, with the option to split each one by rep. That split is where the 1:1 agenda comes from. For a monthly [rep-level view](https://salesbond.app/blog/sales-rep-scorecard-pipedrive/), a scorecard works better than another dashboard widget. If one rep owns most of the deals past their close date, you don’t need a team meeting about it, you need a short conversation with that rep. We cover how to run that conversation in our [sales 1:1 agenda](https://salesbond.app/blog/sales-1-on-1-agenda/).

And keep the manager’s screen apart from the weekly written report. When the two blur, the dashboard grows a second row of tiles nobody reads, and the report turns into screenshots of the dashboard. If your team is on Salesforce, here is [the same Monday dashboard in Salesforce](https://salesbond.app/blog/salesforce-reports-sales-manager-weekly/).

Here’s a test for this week. Open the dashboard you have now, write next to each tile the question it answers and what you’d do if it moved. Any tile left without both is a candidate for the report.