Learn · Calculators
Tier threshold modeller
A tier threshold modeller calculates where to set spend or point cutoffs between loyalty tiers so that each tier has a viable number of members and the programme's rewards cost stays within budget. It lets you adjust thresholds and immediately see the member mix and liability change.
How it works
A tier threshold modeller sorts members by a trailing twelve-month spend or point total, then tests each possible cutoff from low to high. For every candidate threshold, the modeller counts how many members sit at or above that line and assigns each of those members to the tier that begins at that threshold. It then multiplies the member count in a tier by a tier benefit cost per member to produce that tier's estimated annual reward cost. Moving a threshold changes the qualifying count and the cost together. A useful modeller shows the member count, the share of all members, and the reward cost for each tier so you can compare breakpoints before committing to them. The main levers are the threshold value, the number of tiers, and the benefit cost assigned to each tier.
Worked example
This worked example is illustrative and uses simple rounded member counts. Suppose a programme has 1,000 members, and the silver tier covers annual spend from 500 dollars to 1,999 dollars while gold starts at 2,000 dollars. From the member list, 400 members have spent at least 500 dollars, and 80 of those have spent at least 2,000 dollars. That leaves 320 silver members and 80 gold members. If silver benefits cost 15 dollars per member per year and gold benefits cost 60 dollars per member per year, silver costs 320 times 15, which equals 4,800 dollars, and gold costs 80 times 60, which equals 4,800 dollars. Total tier benefit cost is 9,600 dollars. If you lower the silver threshold from 500 dollars to 400 dollars and this adds 120 members to silver, silver membership becomes 440. Silver cost rises to 440 times 15, which equals 6,600 dollars. Total cost moves from 9,600 dollars to 11,400 dollars, an increase of 1,800 dollars, while the share of members in a paid tier rises from 40 percent to 52 percent.
What to do
- Collect each member's trailing twelve-month spend or points and sort the list from highest to lowest.
- Decide how many tiers you want and assign a first-pass annual benefit cost per member to each tier.
- Choose a starting threshold for the lowest paid tier by testing a value that captures roughly the top half of spenders.
- Set the next tier threshold by looking for a natural break in the sorted list, often where spend drops sharply.
- Run each candidate threshold through the modeller and record the member count and tier reward cost.
- Adjust thresholds until the share of members in each tier matches your desired mix and the total cost sits within budget.
Common mistakes
- Setting a threshold without checking how many members fall just below it, so a small change can suddenly add a large cost.
- Using only average spend to set thresholds and ignoring members who spend heavily in one month but little across the year.
- Forgetting to cost the tier benefits as a recurring annual amount, which makes the modeller understate the programme liability.
- Changing one threshold and not rechecking the member counts for the tiers above and below it.