The short answer
Loyalty program ROI for each tier compares the margin a tier's members add with what their member discount costs. Total the discount dollars given to each tier, estimate the extra gross margin members generate against comparable non-members, then divide the net gain by the discount cost. Tiers below zero are not earning back their discount.
Loyalty program profitability by tier, worked through
Why it matters
Member discounts are often a program's biggest cost, and they apply to purchases members would have made anyway. Without a tier-level ROI, a program can look healthy overall while one tier gives away more margin than it brings in.
The question to ask
Copy this into Lexi as written.
How to work it out
1. Cost the discount. Total the discount dollars each tier received over a year, from member pricing, birthday offers and tier perks.
2. Estimate incremental margin. Compare each tier's gross margin per member with similar non-members, matched on spend before joining, and multiply the gap by members in the tier.
3. Calculate ROI per tier. Subtract discount cost from incremental margin and divide by discount cost.
What the answer looks like
Illustrative output on sample data
Illustrative example: how Lexi answers this for an apparel retailer with three loyalty tiers. It compares member discount cost with incremental margin against matched non-members over a year.
- Silver: 60,000 members, $1.2 million discounts, $0.9 million incremental margin. ROI -25%.
- Gold: 18,000 members, $1.0 million discounts, $1.6 million margin. ROI 60%.
- Platinum: 4,000 members, $0.6 million discounts, $1.5 million margin. ROI 150%.
What the data shows
The program returns a 43% return on investment (ROI) overall, but Silver loses $300,000.
What it means
Silver's flat 10% discount goes to entry-level members whose spend barely changes after joining. Half of them joined at checkout for the instant discount and never bought again.
What to do
Replace Silver's flat discount with points toward a reward, and keep Gold and Platinum as they are.
Matched non-members are an estimate of what members would have spent anyway. Want me to show Silver members' spend before and after joining?
Frequently asked questions
How do I calculate loyalty program profitability?
Start with the extra gross margin members generate compared with similar non-members, then subtract every program cost: discounts, points redeemed, partner fees, technology and staff time. Divide by total program cost for ROI. Use matched non-members, because comparing members with everyone else credits the program for customers who were already your best.
Why does a member discount cost more than it looks?
The discount applies to every qualifying purchase, including the ones members would have made at full price without the program. Only the extra purchases it prompts earn the discount back. Counting all member revenue as program revenue hides how much margin goes to customers who needed no incentive.
Should every loyalty tier earn a positive ROI?
Not necessarily on its own. An entry tier can run at a small loss if it moves members up to tiers that earn well. Check how many entry members reach the next tier within a year. If few do, the entry tier is acting as a discount program, and its cost needs to come down.