Learn · Technology and vendors
Do you need a platform yet?
You probably do not need a platform yet. Start with a spreadsheet ledger and manual enrolment. Move to a platform when manual tracking costs more in staff time than a platform fee, when redemptions happen weekly, or when you need automatic point expiry and reporting. Until then, a platform adds setup cost and complexity without improving the member experience.
How it works
A loyalty platform automates point accrual, redemption, balance lookup, expiry, and reporting. A manual system uses a spreadsheet or simple database where you record each transaction by hand. The manual approach works when member counts are low and redemptions are rare. It fails when you cannot reconcile balances quickly or when staff cannot answer a member's balance question without digging through rows. The switch point is not a fixed member count. It is the moment when manual administration costs more in staff time than a platform costs in fees. Platforms also take over consent tracking and data storage, but those become urgent only after you have member data worth protecting.
Worked example
This worked example uses illustrative arithmetic for a coffee shop with a points programme. Each member earns one point per dollar and spends eight dollars per visit, visiting twice a month. With 150 active members, total monthly spend is 2,400 dollars, which at one point per dollar creates 2,400 points. At 100 points per free coffee, that creates 24 redemptions per month. If each redemption takes five minutes of staff time, the monthly workload is 120 minutes, or two hours. At 20 dollars per hour, manual administration costs 40 dollars per month, less than a platform at 200 dollars per month. When active members reach 1,000, total monthly spend is 16,000 dollars, which creates 16,000 points and 160 redemptions. The workload is 800 minutes, about 13.3 hours. At the same pay rate, that costs about 267 dollars per month, which exceeds a platform fee of 200 dollars per month.
What to do
Start with a manual ledger and name one owner for it. Record every point issue and redemption within one business day. Track the time that owner spends on loyalty administration each week. If the time exceeds two hours per week for two consecutive weeks, or if you find two balance errors in a month, start evaluating platforms. Before contacting vendors, write a one page list of required features. Include automated point expiry, member self-service balance checks, and a report showing total points outstanding. Get three quotes and compare them against that list. Run a 90 day pilot with one location or one segment before signing a full contract.
Common mistakes
- Buying a platform before running a manual programme, because the expected growth may not arrive.
- Choosing a platform for advanced features like segmentation when your member list is under one hundred names.
- Ignoring staff time as a real cost and comparing only the platform fee to zero dollars.
- Importing messy spreadsheet data into a new platform, which then creates duplicate records and wrong point balances.