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.
Download it
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
5 sections, each listed with its own size. The first is previewed below; the remaining 4 come with the download, with blank rows ready to fill in.
| Section | Size | Previewed |
|---|---|---|
| KPI definitions | 6 columns, 8 worked example rows | Below |
| Team scorecard | 6 columns, 5 worked example rows | In the download |
| Rep view | 6 columns, 2 worked example rows | In the download |
| Dashboard design rules | 9-point checklist | In the download |
| Why most sales dashboards get ignored | Guidance notes | In the download |
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 |
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.