KPI Tracker Design Skill
KPI trackers fail by addition: every meeting adds a metric, none subtracts, and within two quarters the tracker is a wall of numbers nobody reads — motion without instrumentation. The working tracker is small (5–9 metrics, each with an owner and a written so-what), trend-first (a number without its history is a Rorschach test), honestly baselined before targets exist, and — the part that decides everything — attached to a ritual where someone reads it aloud and decisions reference it. The tracker is the artifact; the ritual is the product.
What This Skill Produces
- The metric selection — 5–9 survivors of the so-what test, each: definition, source, owner, cadence — plus the kill-list of metrics deliberately not tracked, with reasons
- The tracker structure — metric × period grid, trend columns/sparklines, target and threshold lines
- The target notes — baseline-first discipline: track before targeting; targets with owners and reasons, not round numbers
- The review ritual — where, when, who reads it, and the metric-in-every-decision norm
Required Inputs
Ask for these if not provided:
- The decisions the tracker should feed — metrics follow decisions; "what would we do differently if this number moved?" is the selection filter, and it needs the team's real decision list
- The candidate metrics and their sources — what's measurable today vs. requiring new instrumentation (day-one tracker uses today's sources; the wishlist is a separate roadmap)
- The audience and cadence — team-weekly vs. leadership-monthly are different trackers (grain, commentary, tone) — pick one; hybrids serve neither
- Existing baselines — history where it exists; where it doesn't, the no-targets-for-a-month rule applies
Framework: The Design Rules
- The so-what test selects: every candidate metric answers "if this moved 20%, what would we do?" — no answer, no slot. The kill-list (tracked-nowhere metrics with their reasons) is half the design's value: it's the documented defense against the wall-of-numbers drift.
- 5–9, owned, defined: each metric has one owner (who explains its movement, not who's blamed), a written definition (the numerator/denominator argument happens once, at design time — not monthly), and a stated source. Undefined metrics generate the two-truths meeting.
- Trend-first layout: every metric shows its last 6–12 periods (sparkline or mini-column), not just current-vs-target — direction and volatility are the actual information; a red 87% that's been climbing for four months is a different fact than a red 87% in freefall.
- Baseline before target: new metrics run target-less for 3–4 periods (you can't set honest targets on unmeasured behavior); then targets get set with a reason and an owner, at attention-worthy thresholds — the budget-tracker-design signal discipline applies: red must mean something.
- The ritual is the product: a standing slot (the weekly's first ten minutes) where the owner-of-the-moment reads the tracker aloud — one sentence per moved metric — and any proposal in the meeting gets the "which metric does this move?" question. Trackers without rituals decay into decoration in six weeks, on schedule.
Output Format
KPI Tracker: [team] — feeds: [the decisions]
The Metrics (5–9)
| Metric |
Definition (num/denom) |
Source |
Owner |
Cadence |
The Kill-List
[Deliberately untracked: metric → reason — the wall-of-numbers defense]
Structure & Targets
[Grid + trend columns · baseline-first schedule for new metrics · targets with owner + reason + threshold]
The Ritual
[The slot · the read-aloud norm (one sentence per mover) · the which-metric-does-this-move question · quarterly metric review: add/kill with the so-what test]
Quality Checks
Anti-Patterns
1---2name: kpi-tracker-design3description: Design a KPI tracker that drives decisions instead of decorating them — the few-metrics discipline (5–9, each with an owner and a so-what), targets with honest baselines, the trend-first layout, and the review ritual where the tracker actually gets used. Use when asked set up KPI tracking for the team, build a metrics dashboard in sheets, which numbers should we track, or our dashboard exists but nobody acts on it. Produces the metric selection with kill-list, the tracker structure, the target-setting notes, and the review ritual.4---5
6# KPI Tracker Design Skill
7
8KPI trackers fail by addition: every meeting adds a metric, none subtracts, and within two quarters the tracker is a wall of numbers nobody reads — motion without instrumentation. The working tracker is small (5–9 metrics, each with an owner and a written so-what), trend-first (a number without its history is a Rorschach test), honestly baselined before targets exist, and — the part that decides everything — *attached to a ritual* where someone reads it aloud and decisions reference it. The tracker is the artifact; the ritual is the product.
9
10## What This Skill Produces
11
12- **The metric selection** — 5–9 survivors of the so-what test, each: definition, source, owner, cadence — plus the kill-list of metrics deliberately not tracked, with reasons
13- **The tracker structure** — metric × period grid, trend columns/sparklines, target and threshold lines
14- **The target notes** — baseline-first discipline: track before targeting; targets with owners and reasons, not round numbers
15- **The review ritual** — where, when, who reads it, and the metric-in-every-decision norm
16
17## Required Inputs
18
19Ask for these if not provided:
20- **The decisions the tracker should feed** — metrics follow decisions; "what would we do differently if this number moved?" is the selection filter, and it needs the team's real decision list
21- **The candidate metrics and their sources** — what's measurable today vs. requiring new instrumentation (day-one tracker uses today's sources; the wishlist is a separate roadmap)
22- **The audience and cadence** — team-weekly vs. leadership-monthly are different trackers (grain, commentary, tone) — pick one; hybrids serve neither
23- **Existing baselines** — history where it exists; where it doesn't, the no-targets-for-a-month rule applies
24
25## Framework: The Design Rules
26
271. **The so-what test selects:** every candidate metric answers "if this moved 20%, what would we do?" — no answer, no slot. The kill-list (tracked-nowhere metrics with their reasons) is half the design's value: it's the documented defense against the wall-of-numbers drift.
282. **5–9, owned, defined:** each metric has one owner (who explains its movement, not who's blamed), a written definition (the numerator/denominator argument happens once, at design time — not monthly), and a stated source. Undefined metrics generate the two-truths meeting.
293. **Trend-first layout:** every metric shows its last 6–12 periods (sparkline or mini-column), not just current-vs-target — direction and volatility are the actual information; a red 87% that's been climbing for four months is a different fact than a red 87% in freefall.
304. **Baseline before target:** new metrics run target-less for 3–4 periods (you can't set honest targets on unmeasured behavior); then targets get set with a reason and an owner, at attention-worthy thresholds — the [budget-tracker-design](../budget-tracker-design/SKILL.md) signal discipline applies: red must mean something.
315. **The ritual is the product:** a standing slot (the weekly's first ten minutes) where the owner-of-the-moment reads the tracker aloud — one sentence per moved metric — and any proposal in the meeting gets the "which metric does this move?" question. Trackers without rituals decay into decoration in six weeks, on schedule.
32
33## Output Format
34
35# KPI Tracker: [team] — feeds: [the decisions]
36
37## The Metrics (5–9)
38| Metric | Definition (num/denom) | Source | Owner | Cadence |
39|---|---|---|---|---|
40
41## The Kill-List
42[Deliberately untracked: metric → reason — the wall-of-numbers defense]
43
44## Structure & Targets
45[Grid + trend columns · baseline-first schedule for new metrics · targets with owner + reason + threshold]
46
47## The Ritual
48[The slot · the read-aloud norm (one sentence per mover) · the which-metric-does-this-move question · quarterly metric review: add/kill with the so-what test]
49
50## Quality Checks
51
52- [ ] Every metric passed the so-what test against a real decision
53- [ ] Count is 5–9; the kill-list exists with reasons
54- [ ] Definitions settle the numerator/denominator argument in writing
55- [ ] Trends are visible per metric — no naked current-values
56- [ ] The ritual has a slot, a reader, and the decision-linkage norm
57
58## Anti-Patterns
59
60- [ ] Do not track what you can't act on — interesting is not a criterion; decidable is
61- [ ] Do not exceed nine — the tenth metric costs attention from the first nine
62- [ ] Do not set targets on unbaselined metrics — round-number targets on unknown behavior are theater
63- [ ] Do not show numbers without trends — a value with no history is a mood
64- [ ] Do not build the tracker without booking the ritual — undecorated walls beat decorated ones
Mohit Aggarwal