Given away in discount — because 92.8 % of orderlines were discounted at all.
226,904 raw orders · SQL · Python · TableauOne case worked through end to end
Five cases where a number was supposed to settle an argument. One is worked through end to end — from raw export to a pricing rule the board could adopt.
Are discounts actually good for business?
Marketing said discounts drive growth. The board saw orders rising while revenue fell. We rebuilt the true discount signal from 226,904 raw orders — cleaned to 40,985 completed ones — and classified 9,992 products into 27 categories.
The finding: discounting was not a strategy, it was the permanent default. Depth sat at ~20 % all year and barely moved for Black Friday — 23 %, while the Spanish market went to 47 %. Eniac still had its best week of the year on less than half the market's discount. The deepest cuts sat on the cheapest products, which earn the least.
The decision: stop blanket discounting, concentrate it on four events — Black Friday, Christmas, New Year, Valentine's — and cap it by price tier: low ≤ 10 %, medium ≤ 15 %, high ≤ 10 %, premium ≤ 5 %.