What happens if promotion planning holds the calendar flat?
The short answer
For retail promotion planning, model a flat calendar by repeating this year's sale events, depth and timing, then adjusting for how customers responded. Apply this year's promotional lift and discount cost to next year's baseline, and check whether repeat events are drawing fewer new customers and more promotion-only buyers each year.
Why it matters
A flat calendar looks safe because it repeats what worked, but customers adapt. If more of them wait for known events each year, the same calendar delivers less full-price revenue and a higher share of sales on discount. Modeling it shows the drift while the budget is still open.
The question to ask
Copy this into Lexi as written.
What the answer looks like
Illustrative output on sample data
Illustrative example: how Lexi answers this for an apparel retailer modeling next year with the same five sale events.
- This year: $62 million revenue, 38% on promotion, $31.0 million gross margin.
- Flat calendar, no change in behavior: about $63.2 million revenue, $31.6 million margin.
- Flat calendar with drift: promotion-only customers keep rising, so promotional sales reach 41%. Revenue about $63.2 million, margin about $31.0 million.
What the data shows
The same calendar grows revenue but not margin, about $600,000 below the simple flat view.
What it means
More customers wait for events they know are coming. New customers from the summer sale have fallen three years running, while its discount cost has not.
What to do
Shorten or retarget the summer sale and keep the other four events.
This projects the current trend forward, so a change in calendar would change it. Want me to show how the promotion-only share has moved over three years?
Frequently asked questions
What data do I need to model a promotional calendar scenario?
Two or three years of weekly sales split into full-price and promotional, discount dollars per event, and customer-level data showing who buys only on promotion. Add pull-forward, the dip in full-price sales in the weeks after an event, so the model counts net lift.
Why can repeating last year's calendar lose margin?
Customers learn the calendar. When events repeat at the same time and depth, more shoppers delay full-price purchases until the sale they expect. Revenue can hold while the share sold on discount rises, and margin falls even though nothing in the plan changed.
How should promotion planning in retail account for new customers?
Track how many first-time customers each event brings in and how many buy again at full price. An event that still recruits loyal customers earns its discount differently from one that mostly discounts existing buyers. Weight each event in the plan by both its margin and the repeat customers it produces.