Loyalty Program ROI Calculator

The calculation itself

Loyalty programme return is the incremental contribution from members less the cost of rewards and running the programme, divided by that cost.

Incremental is the difficult word: members spend more than non-members, and most of that difference is selection rather than effect. Loyal customers join loyalty programmes.

Return = (member contribution − matched non-member contribution − reward cost − programme cost) ÷ total cost.

How that looks in practice

3,600 members spending $214 a year against $96 for non-members. The naive reading is $118 of uplift per member, $424,800 a year.

Matched comparison against similar non-members spending $178 gives a real uplift of $36, $129,600.

Reward cost at 5% of member spend is $38,520; programme operation is $24,000. Total cost $62,520 against $129,600 of incremental contribution: a 107% return.

Healthy, and less than a quarter of what the unmatched comparison suggested. That gap is where most loyalty programme business cases go wrong.

Where the figure deceives

Comparing members against all non-members measures who joins rather than what the programme does. The correct comparison is against customers with similar prior behaviour who did not join.

Reward liability also accrues before it is redeemed, so a programme can look profitable while accumulating an obligation that has not yet been paid.

Acting on it

Build the comparison against a matched group, or better, hold out a random share of eligible customers from the programme for a period. Selection effects are large enough to reverse the conclusion.

Then account for the unredeemed points liability rather than only the redemptions, since the obligation exists whether or not it has been claimed.

What makes a programme work rather than merely exist

Programmes that change behaviour do so by rewarding the specific action the business wants more of: an earlier reorder, a larger basket, a second category tried, rather than by rewarding spend generally.

Rewarding spend gives money to customers who were already spending, which is the selection problem showing up as a cost.

The programmes that fail quietly are those where the reward is small enough not to change anything and large enough to matter in aggregate. Checking whether the reward is big enough to alter a decision, before launching, avoids a recurring annual cost with no corresponding behaviour change.

Running the programme as an opt-in with a randomised holdout for the first quarter produces a defensible measurement that no post-hoc comparison can match.

Most businesses launch to everyone at once and then argue about attribution for years, which the holdout would have settled before the cost was committed.

Accounting for the outstanding reward liability each period keeps the reported profitability honest, since a growing unredeemed balance is a cost that has been incurred and not yet paid.

Reviewing the programme against its original objective annually is worth doing, since most drift into a general discount over time as tactical additions accumulate.

Sunsetting a programme that does not clear its cost is difficult politically and cheaper than continuing, and the analysis is what makes the decision defensible.