Tabellab
Marketing Analytics Intermediate

Promotion & Markdown Analytics: Lift, Cannibalisation & Profit

Build clean baselines, measure lift and subsidised units, compare discount depths, find the break-even lift, track cannibalisation, halo and pull-forward, optimise a markdown and rank a promo calendar by ROI, with every cell checked as you go.

8 lessons 8 labs 1.9 h Certificate

The first lesson is free โ€” no account needed.

About this course

A promotion and markdown analytics course that measures one fictional grocery retailer's promotions in a spreadsheet, for category managers, revenue and pricing analysts, trade marketing teams and suppliers. You build a clean baseline from the pre-period without stock-out weeks and adjusted for season, measure incremental units, lift % and the units you would have sold anyway, compare promo profit with baseline profit at three discount depths, build the break-even lift table for margin and discount and test a supplier's forecast against it, track cannibalisation of substitutes and the halo on complementary products, measure the post-promo dip and pull-forward, choose a markdown level by sell-through and margin of the whole stock and rank a year's promo calendar by ROI. The first lab is free.

Lessons

  1. Baseline Sales from the Pre-PeriodLab12 minFree
  2. Incremental Units, Lift and Lift %Lab13 min Pro
  3. Promo Profit vs Baseline Profit: Discount Depth vs VolumeLab15 min Pro
  4. Break-Even Lift for a DiscountLab14 min Pro
  5. Cannibalisation and Halo EffectsLab15 min Pro
  6. Pull-Forward: The Post-Promo DipLab15 min Pro
  7. Markdown Optimisation: Sell-Through vs MarginLab16 min Pro
  8. Promo Calendar ROI RankingLab15 min Pro