Why this matters
A team that cannot agree how many customers it won cannot agree whether marketing worked. Usually each person reads a different system, counting at a different moment, and nobody has said which moment counts.
The guide to KPI trees showed how an outcome breaks into the metrics that produce it, with the arithmetic beside each node. The guide to using industry benchmarks showed why an outside figure means nothing until its definition matches yours. This exercise uses both, with the data library templates to hand.
The chain and its numbers
Glimmerway Car Wash is an invented chain of three drive-through car washes. Drivers pay per wash at the till or join a monthly membership for unlimited washes, either from an attendant or online. The owner asked four people how many members the chain gained last month and got four answers. A supplier has also sent her three published benchmarks.
Glimmerway Car Wash: last month's figures by source
| Source | What it shows | Figure |
|---|---|---|
| Agency email | "Sign-ups": online form completions plus free-wash voucher claims | 540 |
| Till system | Memberships created (190 by attendants, 120 online) | 310 |
| Payment provider | Memberships with a first successful payment (170 till, 110 online) | 280 |
| Website analytics | Online membership form completions | 220 |
| Website analytics | Sessions on the membership page | 6,000 |
| Till system | Pay-per-wash transactions by non-members; average price £9 | 9,800 |
| Payment provider | Paying members at the start of the month; members billed in the month | 2,400; 2,450 |
| Payment provider | Cancellations effective in the month | 190 |
| Payment provider | Average monthly fee across both tiers | £18 |
- Report A, from a company selling membership software to car washes: a "membership conversion rate" across its own customers, mostly in another country, defined as memberships created divided by all wash transactions.
- Report B, an online retail survey: orders divided by sessions, from self-reporting shop owners.
- Report C, a trade association blog post quoting a monthly churn figure with no definition, sample or data date.
Building the tree and the definitions
Decompose wash revenue until each leaf is something a named person can change, and check every formula against last month's numbers. Then define each metric: what is counted, at which moment, from which system. Only then judge the benchmarks.
Task
Write your answer before reading the worked answer.
- Build the KPI tree from wash revenue down to leaves a named team can move, with a formula at each node that balances with the chain's figures.
- Add the guardrails that should sit beside the tree.
- Write one definition each for "new member", in-lane and online conversion rate (CVRShare of visits or clicks that convert.), churn rate and member lifetime value (LTVTotal value a customer brings over time.), naming the source system.
- Explain each of the four sign-up figures and say which one the chain should report.
- Judge each benchmark: compare, recompute first, or decline, with the reason.
Worked answer
The tree. Wash revenue is an additive split of membership and pay-per-wash revenue. Membership revenue is members billed multiplied by the average fee; paying members move with new members in and cancellations out; new members split by where they joined, because attendants and the website are different levers.
Glimmerway's tree with last month's arithmetic
| Level | Node | Formula and check | Owner |
|---|---|---|---|
| Outcome | Wash revenue | £44,100 + £88,200 = £132,300 | Owner |
| Output | Membership revenue | Members billed × average fee: 2,450 × £18 = £44,100 | — |
| Output | Paying members at month end | 2,400 + 280 new − 190 cancelled = 2,490 | — |
| Driver | In-lane new members | Non-member washes × in-lane conversion: 9,800 × 1.73% ≈ 170 | Site managers |
| Driver | Online new members | Page sessions × form completion × payment completion: 6,000 × 3.67% × 50% = 110 | Website owner and agency |
| Driver | Cancellations | Members at start × churn: 2,400 × 7.9% ≈ 190 | Owner, through billing and service |
| Output | Pay-per-wash revenue | 9,800 × £9 = £88,200 | Site managers |
Member lifetime value on revenue is the monthly fee divided by monthly churn: £18 ÷ 7.9% ≈ £227. Finance would apply wash costs before anyone used it to set an acquisition budget.
Guardrails. First-month cancellations, which catch memberships pushed on unwilling drivers, and the first-payment failure rate, which catches billing faults. Each gets an owner and a threshold.
Definitions. A new member is a membership whose first monthly payment succeeded in the period, counted once per membership number, from the payment provider. In-lane conversion is in-lane new members divided by non-member pay-per-wash transactions, from the till and payment systems. Online conversion is online new members divided by membership page sessions, with form and payment completion as diagnostics. Churn rate is cancellations taking effect in the period divided by paying members at its start. Member lifetime value is the average fee divided by monthly churn, labelled as revenue until costs are applied.
The four figures. The agency's figure adds voucher claims, so it counts interest, not members. The website counts finished forms, some never paid for; the till includes failed cards. The payment provider's figure matches revenue, so it is reported; the others become renamed diagnostics.
Benchmarks. Report A needs recomputing: it counts memberships created over all washes, so Glimmerway recomputes on that basis, labels the result and notes that a vendor's customers abroad are a self-selected sample. Report B measures a different business; decline. Report C has no definition, sample or date; decline and say why. The first comparison is Glimmerway's own history by site and month, recorded on the new definitions from now.
Common mistakes
- Counting interest as members. Voucher claims and form completions are diagnostics, not the headline.
- One conversion rate for the whole chain. A blended rate hides whether attendants or the website moved.
- Definitions without a source. "New member" is not defined until the system and counting moment are named.
- Taking a benchmark at its label. Two figures called conversion rate can share nothing but the name.
- Treating revenue lifetime value as profit. It overstates what the chain can spend to win a member.
Next, test yourself with the metrics, KPI trees and benchmarks checkpoint, or return to the beginner marketing analytics level.
