What belongs in a loyalty program business case?
A loyalty program business case explains the customer problem, proposed reward, expected incremental contribution, investment required and evidence that would justify continuing. Its job is to support a launch decision, including a decision to run a smaller pilot or wait.
A strong proposal answers five questions: who will use the benefit, what behavior might change, what the program costs even without that change, how the store will test the assumptions, and who owns the decision. Start with the customer and purchase cycle, not a revenue target chosen to make the spreadsheet work.
This guide covers the investment decision. Use the loyalty strategy guide to design the program, the cost guide to research budget categories, and the loyalty RFP when you are ready to compare providers.
Download the business-case worksheet
Use the free workbook to compare a no-growth case, a pilot target and an upside case. It includes a blank scenario sheet, a fully calculated fictional example, input definitions and an approval brief. No email address is required.
Enter one currency and a defined pilot period. The model assumes a constant monthly run rate, a percentage reward on eligible product sales, and costs counted once. It does not forecast demand, model cash timing or provide accounting treatment.
Blue cells are editable inputs; lavender cells contain formulas. Enter verified zeroes rather than leaving required inputs blank. If a program combines discounts, credit, free shipping and access, translate those into separate non-overlapping cost lines or extend the workbook before approving it.
Collect the inputs before estimating the upside
On small screens, scroll the table horizontally.
| Input | Evidence to collect | Common mistake |
|---|---|---|
| Eligible audience | The actual repeat-buyer segment, purchase frequency and products the reward applies to. | Using every customer as an active member. |
| Baseline monthly sales | Expected eligible sales from the pilot audience without the new program. Keep tax and gift-card sales out of the product-sales basis. | Counting existing customer revenue as incremental revenue. |
| Additional monthly sales | A testable assumption about extra orders or order value, with no-growth and lower-response cases. | Assuming members spend more because of membership. |
| Contribution margin | Margin after product and ordinary variable fulfillment/payment costs, before the new reward. | Using gross margin while omitting delivery and payment costs. |
| Reward cost | The proposed percentage on both baseline and additional eligible sales. | Budgeting rewards only on new sales. |
| Other monthly costs | App fees, extra support time, promotion, shipping subsidies and any costs not already counted. | Omitting internal time or counting it twice. |
| Net membership fees | For a paid program, fees after refunds and collection costs, matched to the modeled period. Use zero for a free program. | Treating prepaid credit or annual cash receipts as unrestricted monthly margin. |
| Setup investment | Design, implementation, launch assets and training, with the pilot length. | Hiding initial costs outside the approval request. |
Record the source, date range and owner for each assumption in the workbook. For a fee-funded credit offer, account for the value owed to members separately; the simple percentage-reward model is not a prepaid-credit accounting model.
A worked business case with a no-growth scenario
The following is a fictional three-month pilot in USD, not a Memberply customer result or a suggested reward rate. The same audience would otherwise buy $30,000 of eligible products each month. The proposal offers 3% reward credit and budgets its full face value when earned, without assuming that unused rewards become profit.
The product contribution margin is 35% before the new reward. Ongoing program costs are $350 per month, setup costs $1,500, and membership-fee revenue is zero. Each scenario holds these assumptions constant and changes only additional eligible sales.
On small screens, scroll the table horizontally.
| Monthly line item | No growth | Pilot target | Upside |
|---|---|---|---|
| Baseline eligible sales | $30,000 | $30,000 | $30,000 |
| Additional eligible sales | $0 | $6,000 | $12,000 |
| Additional contribution at 35% | $0 | $2,100 | $4,200 |
| 3% reward budget on all eligible sales | $900 | $1,080 | $1,260 |
| Other monthly program costs | $350 | $350 | $350 |
| Net monthly result before setup | -$1,250 | $670 | $2,590 |
| Setup allocation: $1,500 ÷ 3 | $500 | $500 | $500 |
| Monthly result after setup allocation | -$1,750 | $170 | $2,090 |
| Three-month total after setup | -$5,250 | $510 | $6,270 |
The target case is positive by only $510 over the pilot. That small buffer is a reason to test assumptions, not to promise a return. A higher reward budget or lower contribution margin could reverse the decision. The no-growth case exposes the cost of subsidizing existing purchases.
Calculate the extra sales needed to break even
Monthly net contribution = additional sales × contribution margin + net membership fees − rewards on all eligible sales − other monthly costs − setup cost ÷ pilot months.
For the example: $6,000 × 35% − $36,000 × 3% − $350 − $500 = $170 per month. The baseline product contribution is excluded because it exists in both the program and no-program cases.
With a percentage reward on both baseline and additional sales, break-even additional sales are: (baseline sales × reward rate + other monthly costs + setup ÷ months − net fees) ÷ (contribution margin − reward rate).
Here that is ($30,000 × 3% + $350 + $500) ÷ (35% − 3%) = $5,468.75 of additional monthly sales. At an unchanged $60 eligible order value, that is approximately 92 extra orders each month. If margin is no higher than the reward rate, this formula has no positive marginal contribution to recover the costs.
The workbook calculates this threshold and flags that denominator condition. Use the loyalty ROI calculator for a separate purchase-behavior exploration; its inputs are not identical to this model.
Test the assumptions before expanding
Define the audience and one behavior
For example, test whether existing replenishment customers place another eligible order within their normal purchase cycle. Do not use a one-month window for a product customers buy twice a year.
Choose a credible comparison
Where practical, randomly assign otherwise eligible customers to a pilot and a comparison group. Otherwise, document differences in purchase history, promotions and seasonality. A raw member-versus-nonmember comparison does not isolate the program effect.
Track cost and benefit together
Record invitations, joins, reward earning, redemption, refunds, additional contribution and staff time. Membership count alone does not validate the investment.
Set review and stop rules before launch
Name the owner, pilot end date, maximum accepted loss and the evidence needed to expand. Treat a smaller positive result differently from evidence that the reward actually changed purchasing.
Run a heavier-use case
Increase reward or shipping usage, reduce fee collections and allow for lower response. Include outstanding rewards in the review instead of celebrating a temporarily low redemption bill.
The worksheet is a decision aid, not a substitute for an experiment. Choose the pilot length from the buying cycle and the amount of evidence needed, rather than treating the illustrative three months as a universal rule.
Write the one-page approval proposal
On small screens, scroll the table horizontally.
| Proposal line | What to write |
|---|---|
| Customer problem | Who is underserved and why the current offer does not solve it. |
| Proposed benefit | Reward, eligibility, limits and terms in one paragraph. |
| Investment and exposure | Setup budget, monthly run costs and no-growth loss over the pilot. |
| Success assumption | The additional contribution needed, with the source of each assumption. |
| Pilot plan | Audience, comparison method, measurement window and operational owner. |
| Decision rule | What evidence triggers expansion, revision or stopping. |
| Dependencies | Customer accounts, checkout, fulfillment, support, reporting and benefit configuration. |
| Approval | Decision, approver, budget cap and next review date. |
Once the economics and test plan are credible, compare the available membership benefits with the offer you described. Memberply can configure free or paid membership tiers and rewards; it does not guarantee the purchase lift in your business case. Review current app pricing separately from the fictional $350 monthly operating budget.
Turn the plan into a tested launch
Use the Shopify loyalty program implementation checklist to assign owners, test checkout and rewards, and record the evidence needed before rollout.
Measure the program after launch
Use the loyalty KPI guide and monthly worksheet to define enrollment, benefit activation, redemption and renewal consistently, then connect the results to a practical next action.
Questions merchants ask
What should a loyalty program business case include?
Include the target audience, customer problem, proposed reward, baseline purchasing, incremental contribution assumptions, reward and operating costs, setup budget, pilot plan and approval criteria.
Is the loyalty business-case worksheet free?
Yes. Download the XLSX workbook without submitting an email address. It contains blank inputs, a fictional example, formulas, definitions and an approval brief.
Should rewards on existing purchases be included?
Yes. Customers can earn rewards on purchases they would have made without the program. Include that cost when comparing the program with a no-program baseline.
Does the worksheet predict loyalty program ROI?
No. It compares assumptions using a simplified contribution model. It does not predict customer behavior, establish causal lift or model accounting and cash-flow timing.
Can the model include a paid membership?
It has a net monthly membership-fee input. Include the costs of all paid benefits separately, and extend the model for prepaid credit, annual cash collections or materially different earning rules.