Sales Rep Dashboard: Metrics, Examples, How to Build One in Salesforce

A sales rep dashboard is a single screen that shows what one rep needs to know before a pipeline review: quota attainment, deals in motion, the activity behind them. Built inside Salesforce, it pulls live report data instead of a static spreadsheet. Numbers move the moment a stage changes. Below: which metrics belong on a sales rep dashboard, three working examples, and the exact steps to build one in Salesforce Lightning.

What a Sales Rep Dashboard Actually Shows

Your CRM homepage already shows a rep their own open opportunities. A dashboard goes further. It turns those opportunities into a scorecard against quota, cycle time, and the activity that's supposed to move a deal forward. A list of deals tells you what exists. A dashboard tells you whether it's enough.

Because it's built on Salesforce reports, a rep dashboard updates the moment records change, not on a weekly export cycle. That's the point: you catch a stall while there's still time to do something about it, not in next month's business review when the deal is already gone.

It's also scoped differently from the dashboards you'd build for yourself: one person's book of business, not a whole team's. A manager or exec dashboard rolls the team up, and the metrics on each aren't interchangeable.

Which Metrics Belong on a Sales Rep Dashboard?

Keep it to numbers a rep can act on the same day they see them. These eight cover the same ground as the metrics that define sales productivity at the team level, narrowed to what one individual contributor actually owns:

• Quota attainment. Closed-won this period against the rep's quota, as a percentage and as the dollar gap. The first number a rep checks and the first one a manager asks about.
• Pipeline coverage. Open pipeline closing this period divided by the quota still to hit. Below the coverage ratio your team runs on, the quarter is already at risk, whatever the stage names say.
• Win rate. Closed-won divided by all closed deals over a trailing period. A drop here with steady activity usually means qualification slipped.
• Average deal size. Closed-won amount divided by deals won. Read it next to coverage: a book of small deals needs a bigger pipeline to hit the same number.
• Sales cycle length. Days from creation to close on won deals. Deals running past the rep's own average are the ones to inspect first.
• Stage-to-stage conversion. The share of deals that advance from each stage to the next. One stage with a low rate points at a specific skill gap or a specific missing stakeholder.
• Activity volume. Calls, emails, and meetings logged per week, by deal. Useful only when the logging is complete, which is the subject of the stale-dashboard section below.
• Forecast accuracy. The rep's committed number against what closed, over the last few quarters. It tells both of you how much to trust the next call.

Eight is the ceiling, not the target. A dashboard your reps have to scroll past is one they stop opening within a week.

3 Sales Rep Dashboard Examples

1. The Quota and Pipeline Dashboard

Quota attainment, pipeline coverage, and win rate on one row, open deals below it, grouped by stage. This is the dashboard a rep should open first each morning. It answers one question: how far off pace, and exactly where the shortfall is coming from.

2. The Activity Dashboard

Calls, emails, and meetings logged this week, plotted against the same week last quarter. Good for spotting a rep who's gone quiet on a deal. Less useful the moment the numbers reflect what got typed into Salesforce, not what actually happened on the account. That gap is worth knowing before you coach off it.

3. The Forecast Dashboard

Committed, best-case, and closed amounts for the current period, with a trend line against the last three quarters of forecast accuracy. You read this one before a forecast call. A rep reads it to see whether their calls have been holding up over time.

For the manager-level version of this same pattern, rolled up across a full team instead of one rep, see this walkthrough of BI dashboards across sales, marketing, and ops. The components look similar. The audience and the roll-up don't.

How to Build a Sales Rep Dashboard in Salesforce

Every dashboard component pulls from an underlying report, so the report comes first, not the dashboard.

1. Build the source reports. One Opportunities report per metric: closed-won this period, open pipeline by stage, won and lost deals for win rate, and so on. Filter each to the current fiscal period and to My opportunities, so one report serves every rep.
2. Create the dashboard. Dashboards tab, New Dashboard, name it, pick a folder your reps can see, and Create.
3. Add one component per metric. Click + Component, choose the report, then the display: a metric or gauge for attainment and coverage, a horizontal bar for pipeline by stage, a line for cycle length or accuracy over time. Set the measure and the grouping, then Add.
4. Set who the dashboard runs as. In the dashboard properties, set View Dashboard As to the dashboard viewer. That single setting turns one dashboard into a personal one for every rep, each seeing only their own deals. Salesforce caps how many of these dynamic dashboards an org can have, by edition, so check your limit before you build several.
5. Add dashboard filters. Click + Filter and add Close Date (this quarter, next quarter) and Stage, so a rep can slice without opening the reports. Salesforce also limits filters per dashboard and values per filter, so plan them before you start.
6. Save, then check the layout on a laptop screen. Eight components fit on one screen in a three-column layout. Anything that needs scrolling belongs on a second dashboard, not this one.
7. Subscribe the rep. A subscription emails a refreshed snapshot each morning; the dashboard itself refreshes when someone opens it or clicks Refresh.

Reps pulling their own numbers from Salesforce reports by hand get one screen that's always current instead. For visibility across a whole book of business, not a single rep's view, the nine-stage guide to managing deal pipelines in Salesforce covers the stage structure a dashboard like this one reports on.

Why Sales Rep Dashboards Go Stale

A dashboard is only as good as what feeds it, and most of what feeds it gets typed in by hand. Sales reps spend 60% of their time on non-selling tasks, and logging calls and updating stages sits squarely inside that number. When a rep falls behind on data entry, the activity metric on their dashboard doesn't drop because engagement dropped. It drops because nobody had ten minutes to log it between calls.

That's a data problem before it's a dashboard problem, and no chart type fixes it. Backstory captures every call, email, and meeting automatically and matches it to the right Salesforce record, so the activity metrics on a rep's dashboard reflect what actually happened on the account, not what a rep had time to enter. Reps don't change how they work. The dashboard just stops running on partial information.

Do You Need a Different Dashboard for Managers vs. Reps?

Yes. A rep dashboard is built around one person's quota and one person's pipeline. A manager dashboard rolls the same metrics up across a team and adds comparisons a single rep doesn't need, like attainment by rep or coverage by territory. Building both from the same underlying reports, filtered by owner, saves the work of maintaining two separate report libraries, and it keeps the numbers a rep sees consistent with the ones their manager reviews in a forecast call.

How Often Should a Sales Rep Dashboard Refresh?

As often as the data underneath it changes, within Salesforce's own limits. Salesforce enforces a one-minute wait between manual dashboard refreshes and caps automatic refresh scheduling by edition, so treat the dashboard as near-real-time, not instant. For most rep dashboards, that gap is invisible: a rep isn't checking their own attainment number every sixty seconds, they're checking it once or twice a day, and by then every update has already landed.

What to Track First When Starting From Scratch

Build the quota and pipeline dashboard before anything else. Attainment, coverage, and win rate are the three numbers that answer whether a rep is on pace, and every other dashboard here is really a deeper look at one piece of that picture. Add the activity and forecast views once the first one is live; the reports behind it are already built, so the second and third dashboards take a fraction of the time the first one did.

That first dashboard's activity numbers are only as complete as what a rep managed to log between calls. Fix that before adding a fourth view. See how Backstory keeps that data accurate without adding to a rep's workload.