Finance
use case
Grow margin

How deep did holiday discounts run by department?

Last updated
October 14, 2026
What was the average discount depth by department during Boxing Day compared with the rest of the quarter?
Copy question

What the answer looks like

Illustrative output on sample data

Illustrative example: how Lexi answers this for a furniture retailer. It compares discount depth in the Black Friday and Cyber Monday window with the rest of the quarter by department.

  • Sofas: 30% in the event, 12% the rest of the quarter
  • Mattresses: 38%, against 15%
  • Lighting: 20%, against 14%

What the data shows

Mattresses ran more than twice their usual depth, the biggest jump. Lighting barely changed.

What it means

40% of event mattress buyers were existing customers who viewed mattresses in the month before, which suggests many waited for the sale.

What to do

Reduce mattress depth next event and send recent mattress browsers an earlier, smaller offer.

Would you like to see who bought at each discount depth?

Holiday discount depth, department by department

Average discount depth = total discount dollars ÷ pre-discount value of sales × 100

Why it matters

Holiday events can deliver a large share of quarterly revenue, and the discount set for that week shapes the quarter's margin. Knowing which departments discounted far deeper during the event than the rest of the quarter shows where next year's plan can hold more margin.

Frequently asked questions

Should discount depth use list price or the price before the event?

Use the regular selling price before the event, so depth shows the cut customers actually saw. If items were already on markdown, measure from the markdown price and track the markdown separately. Mixing the two makes holiday depth look deeper or shallower than it was.

Why compare the event with the rest of the quarter?

Holiday depth on its own says little. A 30% discount is modest for a department that runs 25% all quarter and deep for one that usually sells near full price. Comparing the event with the surrounding weeks shows where the holiday plan changed behavior and margin most.

Does a deeper holiday discount always bring in more revenue?

Not always. Beyond a point, extra depth mostly lowers the price for customers who would have bought at a smaller discount. Compare units and margin for departments at different depths, and test a shallower discount in one department to see how much volume it really costs.

Bring your own question to a demo

Book a demo