Sales KPI dashboard template
Most sales dashboards fail because they show forty metrics nobody owns, calculated in ways nobody wrote down. Sales and finance then spend the QBR arguing about whose win rate is right. This template starts with fewer KPIs, each with a formula, an owner, a source, and a cadence, and it separates leading indicators you can still act on from lagging ones that only report the result.
- Category:
- RevOps Metrics & Reporting
- Formats:
- PDF + CSV + web view
- Sections:
- 5
- Updated:
What you get
- A KPI definitions table with formula, owner, source system, and review cadence
- A leading vs lagging split so the weekly review focuses on numbers you can still change
- A team scorecard layout with target, quarter to date, last quarter, and status
- A rep-level view for the same KPIs, so team numbers can be traced to people
- Design rules for keeping the dashboard short enough that people read it
Who it's for
- RevOps leads building or rebuilding the sales dashboard
- VPs of Sales who need one agreed set of numbers with finance
- Sales managers who want team numbers traceable to reps
What's inside
- 1
KPI definitions
6 columns, 8 worked example rows
- 2
Team scorecard
6 columns, 5 worked example rows
- 3
Rep view
6 columns, 2 worked example rows
- 4
Dashboard design rules
9-point checklist
- 5
Why most sales dashboards get ignored
Guidance notes
Preview of section 1
KPI definitions
Every KPI on the dashboard needs a row here. If you cannot write the formula, the KPI is not ready.
| KPI | Type | Formula | Owner | Source | Review cadence |
|---|---|---|---|---|---|
| Pipeline created | Leading | Sum of amount on opportunities created in the period that passed qualification | VP Sales (outbound), Marketing lead (inbound) | CRM | Weekly |
| Pipeline coverage | Leading | Open in-period pipeline / (Quarter target - Closed won to date) | RevOps | CRM | Weekly |
The preview shows part of section 1. The full template has all 5 sections (4 not previewed here), with blank rows ready to fill in. Download the full template
How to use it
- 1
Agree the formulas before building anything
Write every KPI's formula in the definitions table and get sales and finance to sign off. Win rate by count and win rate by value can differ by ten points; pick one and label it.
- 2
Cap the dashboard at eight KPIs
If a metric does not have an owner who would change something when it moves, it does not belong on the main dashboard. Put it in a drill-down or drop it.
- 3
Review leading KPIs weekly, lagging monthly
Pipeline created, coverage, and stage conversion can still change this quarter's outcome, so they get weekly attention. Win rate and cycle length move slowly and are noisy week to week; review them monthly.
- 4
Give every KPI one owner
An owner is the person who explains the number when it misses. Shared ownership between sales and marketing means nobody explains it. Split the metric (for example, pipeline created by source) if you must.
Frequently asked questions
What KPIs should be on a sales dashboard?
A short set covering both leading and lagging indicators: pipeline created, pipeline coverage, stage conversion, win rate, average deal size, sales cycle length, bookings vs target, and forecast accuracy. Add others only if someone owns them and would act on a change.
What is the difference between leading and lagging sales KPIs?
Leading KPIs, like pipeline created and coverage, predict future results and can still be changed this quarter. Lagging KPIs, like win rate and bookings, report outcomes after the fact. Review leading KPIs weekly and lagging ones monthly.
Should win rate be calculated by count or by value?
Either can be right, but pick one and label it. By value is better for pipeline coverage and forecasting because it matches how pipeline is measured. By count is better for coaching rep behavior. Many teams track both and name them differently.
How many KPIs should a sales dashboard have?
Around six to eight on the main view. More than that and people stop reading it. Keep additional metrics in drill-downs for the people who own them.
Related templates
All sales ops templatesWeekly sales report template
RevOps Metrics & Reporting
A one-page weekly sales report template covering bookings, a pipeline movement bridge, forecast change by manager, and top risks. Free PDF and CSV.
SaaS metrics definitions sheet
RevOps Metrics & Reporting
SaaS metrics definitions for ARR, NRR, GRR, CAC, win rate, and more, with formulas, inclusions, owners, and worked examples. Free PDF and CSV.
Sales rep scorecard
RevOps Metrics & Reporting
A monthly sales rep scorecard that weights outcome and input metrics, caps overachievement, and turns the score into a coaching focus. Free PDF and CSV.