Skip to content
Faisal Mahmud TusherDigital marketing, SEO & analytics
with Faisal Tusher

Marketing Analytics and Reporting › Beginner

Defining Metrics for a Car Wash Chain

A practice run at settling an argument about numbers. For an invented car wash chain whose sign-up figure changes depending on who reports it, you build a KPI tree from revenue down to the levers each team owns, write one definition per metric and decide which published benchmarks deserve a place in the conversation.
ExerciseBeginner levelModule 1: From data to decisions5 minUpdated

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.

Illustrative example — not a real result

Glimmerway Car Wash: last month's figures by source

SourceWhat it showsFigure
Agency email"Sign-ups": online form completions plus free-wash voucher claims540
Till systemMemberships created (190 by attendants, 120 online)310
Payment providerMemberships with a first successful payment (170 till, 110 online)280
Website analyticsOnline membership form completions220
Website analyticsSessions on the membership page6,000
Till systemPay-per-wash transactions by non-members; average price £99,800
Payment providerPaying members at the start of the month; members billed in the month2,400; 2,450
Payment providerCancellations effective in the month190
Payment providerAverage 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.

  1. 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.
  2. Add the guardrails that should sit beside the tree.
  3. Write one definition each for "new member", in-lane and online conversion rate (CVR), churn rate and member lifetime value (LTV), naming the source system.
  4. Explain each of the four sign-up figures and say which one the chain should report.
  5. 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.

Illustrative example — not a real result

Glimmerway's tree with last month's arithmetic

LevelNodeFormula and checkOwner
OutcomeWash revenue£44,100 + £88,200 = £132,300Owner
OutputMembership revenueMembers billed × average fee: 2,450 × £18 = £44,100—
OutputPaying members at month end2,400 + 280 new − 190 cancelled = 2,490—
DriverIn-lane new membersNon-member washes × in-lane conversion: 9,800 × 1.73% ≈ 170Site managers
DriverOnline new membersPage sessions × form completion × payment completion: 6,000 × 3.67% × 50% = 110Website owner and agency
DriverCancellationsMembers at start × churn: 2,400 × 7.9% ≈ 190Owner, through billing and service
OutputPay-per-wash revenue9,800 × £9 = £88,200Site 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.

Pages this lesson applies

Terms used on this page

Also related

Related