Seasonal promotions are a huge opportunity — and a huge risk. Too generous, and you eat margin without improving long-term value. Too stingy, and you miss sales and the chance to deepen customer relationships. Over the years I’ve found one pragmatic way to navigate that trade-off: a simple cohort-driven CLV forecasting approach that gives you an evidence-based ceiling on how much you can afford to spend on rewards or acquisition for a given promo.
Why cohort-driven CLV beats one-size-fits-all rules
Many SMEs default to blanket rules such as “give 10% off” or “offer free shipping over £50” because they’re easy to implement. But customers aren’t all the same: first-time buyers behave differently from repeat purchasers, and seasonal cohorts (e.g. holiday shoppers vs. summer buyers) can show distinct retention and spend patterns.
Cohort-driven CLV (Customer Lifetime Value) forecasting splits your customer base into groups that share a common starting point — typically their acquisition month or campaign — and projects value for each group separately. The advantage is clear: you can set promo ceilings based on realistic future revenue for the specific customers you’ll win, rather than a vague average that might under- or over-estimate value.
What I use in practice: the simple cohort CLV model
Here’s a lightweight model I use with clients when they need a rapid yet defensible estimate. It requires only basic data and gives an actionable reward ceiling.
Inputs I look for:
The basic steps:
Formula translated into a simple spreadsheet:
For each cohort month, do the following in separate columns:
Example values I commonly use:
| Cohort size | 1,000 customers |
| Initial AOV | £60 |
| Gross margin | 45% |
| Retention (month 1,2,3...) | 40%, 20%, 12%, 8%, 6% ... |
Using those numbers and projecting 12 months, you get a sum of expected revenue per acquired customer. Multiply by margin to get gross profit per customer, then decide how much of that you can allocate to rewards.
Practical tips for setting the reward ceiling
When I build ceilings with teams I always apply a few pragmatic constraints:
How to handle acquisition vs. retention promos
The cohort CLV approach works for both, but the math and acceptable ceilings differ.
Testing and iterating: the A/B playbook I recommend
Numbers are helpful, but nothing replaces an experiment.
Example: a seasonal promo for a mid-sized DTC brand
One client — a DTC homewares brand — wanted to run a winter promotion. Their data showed:
Projected 12-month gross profit per new customer came to roughly £28. If the team wanted at least £8 net contribution per customer after the promo, that left ~£20 to fund acquisition and rewards. They split that into £12 maximum paid CAC and £8 maximum reward value per customer.
They then ran two promo arms: a straight £8 off first order vs. free £8 gift with purchase that cost them £5 after fulfilment. The gift performed better for retention (higher repeat rate) and delivered stronger long-term CLV — proving the cohort forecast and the operational costs gave a useful ceiling to test.
Common pitfalls to avoid
If you want, I can sketch a ready-to-use spreadsheet template with cohort columns and the formulas shown above so you can drop in your numbers and get reward ceilings for any seasonal plan. I often share that with clients to speed up decision-making and to move from opinion to evidence within a few hours.
