Car wash membership promotion payback: follow a fixed cohort

A rising membership count does not show whether the spending used to acquire those members has been recovered. Follow one fixed group of genuinely new customers, match their earned revenue and service costs, and compare cumulative contribution with supported acquisition spending. Keep observed results separate from a downside scenario and from claims about incremental demand.

Define the acquisition cohort before dividing

Choose a campaign or acquisition window and one unit: customer, paying account or another clearly documented measure. Remove duplicates and separate reactivations, free trials, employee accounts and existing customers receiving a discount. The workbook’s cohort is genuinely new customers. Reactivations are disclosed separately and are not added to the CAC denominator.

Record how the original cohort is identified in the actual POS or membership system. No new entrants belong in later months of this cohort. An active-at-full-price endpoint is a status count, not the number of bills or visits. Use the cohort bridge for detailed status movements and reconciliation.

Allocate acquisition spending once

List media, creative, commissions and incremental acquisition labor, with evidence for the share assigned to these new customers. If one campaign also serves existing members or reactivations, document that allocation rather than put all customers into one convenient denominator. A missing cost or unsupported allocation makes complete CAC unknown.

Introductory discounts already reflected in net earned revenue are not an extra cash cost to deduct again. Distinguish a discount from separately paid acquisition costs. Continuing service labor belongs in monthly contribution if it is an incremental cost of serving the cohort; the same labor cannot also be charged to the acquisition-spend table.

Stripe’s CAC/payback explanation provides a general acquisition-cost and service-margin framework. This workbook uses entered monthly cohort observations rather than a constant monthly margin, SaaS benchmark or assumed customer lifetime.

Match earned revenue to the cost of serving the cohort

Use earned revenue net of sales tax, discounts and refunds. Collected membership cash may belong to a different service period. Reconcile visits, service resources, billing charges and additional operating costs to the same original group and month. The membership contribution tool provides the broader monthly service-cost framework.

State costs outside the model, including shared overhead not entered, financing, income tax, depreciation and capital spending. Positive cohort contribution does not by itself establish positive whole-site earnings. A promotion that changes staffing or displaces other traffic needs those effects documented separately.

CAC = supported acquisition spending ÷ unique new customers
Monthly cohort contribution = net earned revenue − service costs − billing costs − incremental operating costs
Cumulative recovery balance = contribution through the month − acquisition spending

Reproduce the fictional promotion case

An invented campaign spends $3,600 to acquire 120 new customers, giving $30 CAC. Fifteen reactivations are reported separately and excluded from that cohort. Original-cohort earned revenue for three months is $2,400, $2,520 and $2,240. Matching service, billing and incremental costs total $1,440, $1,040 and $900.

Monthly contribution is therefore $960, $1,480 and $1,340. Cumulative contribution reaches $3,780 in month three, or $180 more than acquisition spend. At the second month-end the shortfall was still $1,160. The data establish recovery by the third complete month-end, not a precise day within that month.

Eighty original customers active at full price at the third endpoint represent 66.67% of the initial cohort. A separately entered downside uses revenue 10% below those observations with the same costs; it ends $536 short of recovery. That alternative is a scenario, not an observed campaign result or a forecast of customer behavior.

Read incomplete observations and reversals honestly

Use consecutive months and identify a partial final month. A partial month can show a provisional cumulative balance but cannot establish complete-month recovery. Blank costs prevent complete contribution. Zero new customers makes CAC undefined; zero supported acquisition spending is different from missing spending.

A cohort can first recover spend and later fall below it because of refunds or additional costs. The result therefore reports both the first observed recovery month and the final balance. It does not extrapolate a lifetime value. An immature campaign should not be treated as though it has already demonstrated durable regular-price retention.

Separate attribution from incremental demand

A campaign code connects activity to a promotion; it does not prove that every attributed customer would otherwise have stayed away. Existing-customer discount leakage, channel overlap, nearby changes, weather and seasonal traffic can affect interpretation. Compare matched observation windows and retain those limitations rather than convert a coupon count into a causal growth claim.

For a sale review, compare recent promotional cohorts with the evidence available for older groups. Keep the cost needed to maintain acquisition and retention in the supported operating case. Do not automatically add back recurring marketing expense because the seller describes it as growth spending.

Use billing continuity review for plan terms, cancellations and provider acceptance, and the pre-sale improvement guide to document changes without promising a price uplift. The editor reviews this method annually and when reporting definitions change. The operator and accountant own the actual allocations and revenue-recognition evidence.

Download the blank workbook ↓

Download the fictional case v1 ↓

Continue your review

Verify the revenue · Normalize earnings · Model the cash flow