Tools · Customers & Retention
The Loyalty Math: The Punch Card Gives Your Biggest Discount to People Who'd Come Anyway.
The punch card gives your biggest discount to the people who'd come anyway.
$24 one-off
Buy — $24The-Loyalty-Math.xlsx · 4 tabs, 11 live formulas, no macros
Instant download, nothing ships. Works in Excel, no subscription. If it does not do what you needed, tell me and I will make it right.
Unless it changes behavior — and that's a math question nobody at the loyalty-app demo will run for you. The sample shop's card hands back $5,990 of margin a year if habits don't move, needs a 16.7% frequency lift just to break even, and wins a modest $1,198 at a 20% lift. A $7,188 swing rides on design, and design is free.
How it works
- The Card Math — your regulars, ticket, margin, and card structure; what the card turns a visit into ($4.55 → $3.90 in the sample); the yearly giveaway at today's habits; and the break-even lift computed for YOUR numbers
- The Two Futures — the autopilot card vs the working card, side by side, with the honest verdict: loyalty is a moat, not a gold mine — run it for the defense, the data, and the habit, priced rather than hoped
- The Rules — reward the visit, not the spend; start the card already stamped (endowed progress — the cheapest lift in retail); the gentle deadline; when the $30/month app earns its keep and when it's just a subscription; the card-as-census that builds your text list; and measure the lift or admit the discount
Built for
Coffee shops · cafés · salons · car washes · groomers · boutiques — every frequency business with a rival next door.
What you get
One .xlsx file, four tabs, instant download. Excel, Google Sheets, Apple Numbers, LibreOffice. No macros, no subscription.
A look inside
More in Customers & Retention
Customer Retention Value Calculator
You count the customers you win. Do you count the ones you quietly lose?
$32
Which Customers Actually Make You Money
Your biggest customer is not necessarily your best one. One of them might be costing you money.
$34
What Would a Maintenance Plan Be Worth?
Money that arrives on the first of the month, whether or not the phone rang.
$34