Contents

Chapter 1

Choosing the Right KPIs

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.

The problem with "track everything"

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.


The test: is it a real KPI?

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.


Leading vs. lagging indicators

Balance the two or you'll fly blind:

LaggingLeading
Tells youWhat already happenedWhat's about to happen
ExamplesRevenue, churn, NRR, profitActivation rate, pipeline coverage, lead time
Good forScorekeeping, accountabilitySteering, early warning
Risk if over-usedYou react too lateYou 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.


The "North Star" approach

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.

FunctionCommon North StarSupporting KPIs
SaaSNet Revenue RetentionMRR, churn, expansion, activation
E-commerceRevenue per visitorConversion rate, AOV, cart abandonment
ProductDAU/MAU stickinessActivation, feature adoption, D30 retention
EngineeringLead Time for ChangesDeploy frequency, change-fail rate, MTTR
SalesQuota AttainmentWin rate, pipeline coverage, sales-cycle length
SupportFirst Contact ResolutionCSAT, resolution time, ticket volume

The North Star is the headline; the supporting KPIs are the diagnostics that tell you

*why* it moved.


How many is right?

AudienceKPIs to show
Individual contributor2–4 (their direct levers)
Team lead5–7 (the team's North Star + supporting)
Executive scorecard1 headline per function (see formulas Β§7)
Board5–8 across the whole company

When in doubt, fewer. You can always drill into a diagnostic when a KPI flags.


A worked example: cutting the Sales dashboard to 6

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.


Common KPI mistakes

  • Vanity metrics: big numbers that only go up and don't inform a decision (total

registered users, lifetime page views). Impressive, useless.

  • Proxy obsession: optimizing the measurable stand-in until it stops reflecting the

goal (Goodhart's Law β€” "when a measure becomes a target, it ceases to be a good

measure"). Watch the outcome, not just the proxy.

  • Unowned metrics: a KPI with no name next to it never improves.
  • No target: a number without a target is trivia. Set one (see

docs/CUSTOMIZATION.md Β§2), even if it's a rough first guess.

  • Mixing directions silently: half your KPIs are "higher is better" and half

"lower is better." The Direction column (formulas Β§0) keeps the scoring honest β€”

use it.


Your selection checklist

For each KPI you're considering, ask:

  • [ ] If this moves the wrong way, do I know what to do?
  • [ ] Does it connect to revenue, retention, cost, or risk?
  • [ ] Is there exactly one owner?
  • [ ] Do I trust the number enough to act on it?
  • [ ] Is it leading (steer) or lagging (score) β€” and do I have a balance of both?
  • [ ] Could I remove it and lose nothing? (If yes β€” remove it.)

Get this right and guides/dashboard-design-principles.md will help you present the

survivors so people actually use them.

Chapter 2
πŸ”’ Available in full product

Dashboard Design Principles

Chapter 3
πŸ”’ Available in full product

Customization Guide

Chapter 4
πŸ”’ Available in full product

Getting Started

Chapter 5
πŸ”’ Available in full product

Import Guide

Chapter 6
πŸ”’ Available in full product

Formulas Reference β€” KPI Dashboard Template Pack

Chapter 7
πŸ”’ Available in full product

Choosing the Right KPIs

Chapter 8
πŸ”’ Available in full product

Dashboard Design Principles

You’ve reached the end of the free preview

Get the full KPI Dashboard Template Pack and unlock everything.

All Chapters

Get the complete guide with every chapter unlocked, including code samples, diagrams, and best practices.

Full Tool Suite

Access all interactive tools with complete data, all workload profiles, and the full scenario library.

Source Files

Downloadable source code, configuration files, and working examples from every chapter.

Lifetime Updates

Free updates for life. Every new chapter, tool, and improvement included.

Buy Now — $39 →
πŸ“¦ Free sample included — download another copy or visit the store for the full product.
KPI Dashboard Template Pack v1.0.0 β€” Free Preview