This pack gives you 16 KPIs per dashboard β but you should report far fewer. The
hardest part of measurement isn't calculating metrics; it's choosing which ones
deserve a leader's attention. This guide helps you cut from 16 to the 5β7 that
actually drive decisions.
More metrics feel safer. They aren't. A dashboard with 40 numbers has the same effect
as a dashboard with zero: nobody knows where to look, so nobody looks. Every KPI you
add dilutes the ones that matter and adds maintenance cost. The goal is the
smallest set that lets you steer the business.
Rule of thumb: a team should be able to name its KPIs from memory. If they can't,
there are too many.
A metric earns a spot on the dashboard only if it passes all four:
1. Actionable β if it moves the wrong way, you know roughly what to *do*. A number
you can only watch is a *metric*, not a KPI.
2. Tied to an outcome β it connects to revenue, retention, cost, or risk. "Page
views" rarely does; "activation rate" does.
3. Owned β exactly one person or team is accountable for it (the Owner column).
A KPI everyone owns is a KPI no one owns.
4. Trustworthy β you can measure it consistently and people believe the number. A
precise metric from a flaky source is worse than a rough one from a solid source.
If a metric fails any of these, demote it to a secondary "diagnostic" you check only
when a real KPI moves.
Balance the two or you'll fly blind:
| Lagging | Leading | |
|---|---|---|
| Tells you | What already happened | What's about to happen |
| Examples | Revenue, churn, NRR, profit | Activation rate, pipeline coverage, lead time |
| Good for | Scorekeeping, accountability | Steering, early warning |
| Risk if over-used | You react too late | You optimize a proxy, not the goal |
A healthy dashboard pairs each lagging outcome with the leading metric that predicts
it. On the Sales dashboard, *New Bookings* (lagging) is predicted by *Pipeline
Coverage* and *SQOs* (leading). On Product, *Day-30 Retention* (lagging) is
predicted by *Activation Rate* and *Time to Value* (leading). Watch the leading ones
to change the lagging ones.
Pick one metric that best captures the value your team delivers β your North Star β
then surround it with 4β6 supporting KPIs that explain its movement.
| Function | Common North Star | Supporting KPIs |
|---|---|---|
| SaaS | Net Revenue Retention | MRR, churn, expansion, activation |
| E-commerce | Revenue per visitor | Conversion rate, AOV, cart abandonment |
| Product | DAU/MAU stickiness | Activation, feature adoption, D30 retention |
| Engineering | Lead Time for Changes | Deploy frequency, change-fail rate, MTTR |
| Sales | Quota Attainment | Win rate, pipeline coverage, sales-cycle length |
| Support | First Contact Resolution | CSAT, resolution time, ticket volume |
The North Star is the headline; the supporting KPIs are the diagnostics that tell you
*why* it moved.
| Audience | KPIs to show |
|---|---|
| Individual contributor | 2β4 (their direct levers) |
| Team lead | 5β7 (the team's North Star + supporting) |
| Executive scorecard | 1 headline per function (see formulas Β§7) |
| Board | 5β8 across the whole company |
When in doubt, fewer. You can always drill into a diagnostic when a KPI flags.
The Sales dashboard ships with 16 KPIs. For a weekly sales standup, keep:
1. Quota Attainment β the North Star; are we hitting the number?
2. Pipeline Coverage β leading indicator; do we have enough to hit next quarter?
3. Win Rate β efficiency; are we getting better at closing?
4. Sales Cycle Length β leading; are deals speeding up or stalling?
5. Average Contract Value β are we moving up-market or down?
6. Lead Response Time β the one activity metric that reliably predicts win rate.
The other ten (Forecast Accuracy, NRR, Upsell Rate, CAC, Revenue per Repβ¦) are
valuable diagnostics β review them monthly or when a top-6 KPI breaks, not in the
weekly glance.
registered users, lifetime page views). Impressive, useless.
goal (Goodhart's Law β "when a measure becomes a target, it ceases to be a good
measure"). Watch the outcome, not just the proxy.
docs/CUSTOMIZATION.md Β§2), even if it's a rough first guess.
"lower is better." The Direction column (formulas Β§0) keeps the scoring honest β
use it.
For each KPI you're considering, ask:
Get this right and guides/dashboard-design-principles.md will help you present the
survivors so people actually use them.
Get the full KPI Dashboard Template Pack and unlock everything.
Get the complete guide with every chapter unlocked, including code samples, diagrams, and best practices.
Access all interactive tools with complete data, all workload profiles, and the full scenario library.
Downloadable source code, configuration files, and working examples from every chapter.
Free updates for life. Every new chapter, tool, and improvement included.