Promotions affect the forecast twice. Looking back, there are days in the history with sales that are not normal. Looking ahead, there are promotions for which the products need to be in stock. Both have to be handled, otherwise the forecast will be too high or too low at the wrong times.
Clean promotion days out of the history
If a product normally sells 10 units a day and 35 units a day in a week with 30% off, the promotion week pulls the average up. If the forecast uses that average, you order too much for the normal weeks afterwards.
Promotion days can be found from the price: if the unit price on a day is clearly below normal, e.g. more than 20%, the day can be left out when the level is calculated. It is a simple rule that catches most sales without having to register each promotion.
Measure the uplift
The uplift shows how much more the product sells during the promotion than otherwise:
Uplift = sales per day during the promotion / sales per day in the weeks before and after − 1
The product sold 35 units a day in Black Friday week and 10 units a day in the weeks before and after:
35 / 10 − 1 = 2.5 = +250%
Use the weeks both before and after. The week before can be low because customers are waiting for the offer, and the week after can be low because they have already bought. The average of the two gives a more accurate normal level.
Plan the next promotions
If you know last year’s uplift, you can add it to the forecast for the coming promotion. If the product has not been part of a promotion before, you can use the uplift for the category or for the whole shop.
Remember the lead time. If the lead time is 56 days, products for Black Friday at the end of November have to be ordered at the end of September. If several promotions are close together, e.g. Black Friday and Christmas shopping, it is probably better to treat them as one period, so you do not order twice for the same customers.
After the promotion
Many customers buy during the promotion what they would otherwise have bought in the following weeks. Sales after a large promotion are therefore often lower than normal. Take this into account in the forecast, so a new order does not arrive right after the promotion for sales that are not there.
Promotions in lesslater
lesslater can clean out days where the unit price is more than 20% below normal, so a sale does not inflate the forecast. The Danish promotion calendar shows Black Friday, Christmas shopping, Mother’s Day and other periods with the uplift your own shop has had in previous years, measured against the weeks before and after. From there you can create a rule that raises the forecast by a percentage for selected products during the period.