Tools · Customers & Retention

The Loyalty Math: The Punch Card Gives Your Biggest Discount to People Who'd Come Anyway.

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 — $24

The-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