Promo ROI Detail
Weekly SKU-level promotional performance metrics
Avg ASP
$52.69
Average selling price
Base Price
$52.00
List price
Avg Promo ROI
1.58x
Mean weekly ROI
Total GP
$216K
Gross profit (24 weeks)
Weekly Detail — JW Black 700ml (Johnnie Walker)
| Week | ASP ($) | ASP CY ($) | Promo ROI | ROI CY | Volume CY | Volume LY | Volume % | GP ($) | GP CY ($) | GP % | TPR % | Promo Depth % |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| W01 | $54.60 | $48.88 | 1.21x | 0.70x | 467 | 397 | +17.6% | $9,179 | $6,620 | +38.7% | 13% | 8% |
| W02 | $54.60 | $53.04 | 1.69x | 1.54x | 303 | 330 | -8.2% | $6,121 | $6,589 | -7.1% | 19% | 11% |
| W03 | $54.60 | $54.08 | 2.17x | 1.38x | 639 | 594 | +7.6% | $9,769 | $12,095 | -19.2% | 25% | 13% |
| W04 | $54.60 | $50.96 | 0.95x | 2.22x | 475 | 413 | +15% | $8,818 | $7,020 | +25.6% | 6% | 16% |
| W05 | $54.60 | $52.00 | 1.43x | 2.06x | 311 | 314 | -1% | $6,792 | $6,631 | +2.4% | 12% | 18% |
| W06 | $54.60 | $53.04 | 1.91x | 1.90x | 647 | 550 | +17.6% | $10,951 | $12,011 | -8.8% | 18% | 20% |
| W07 | $54.60 | $49.92 | 2.39x | 0.94x | 483 | 526 | -8.2% | $9,758 | $6,992 | +39.6% | 24% | 23% |
| W08 | $54.60 | $50.96 | 1.17x | 0.78x | 319 | 297 | +7.4% | $4,877 | $6,665 | -26.8% | 5% | 25% |
| W09 | $54.60 | $55.12 | 1.65x | 1.62x | 655 | 570 | +14.9% | $10,371 | $12,636 | -17.9% | 11% | 28% |
| W10 | $54.60 | $48.88 | 2.13x | 1.46x | 491 | 496 | -1% | $9,383 | $6,960 | +34.8% | 17% | 30% |
| W11 | $54.60 | $49.92 | 0.91x | 1.30x | 327 | 278 | +17.6% | $7,320 | $6,693 | +9.4% | 23% | 32% |
| W12 | $54.60 | $54.08 | 1.39x | 2.14x | 663 | 723 | -8.3% | $11,584 | $12,549 | -7.7% | 29% | 8% |
| W13 | $54.60 | $55.12 | 1.87x | 1.98x | 499 | 464 | +7.5% | $10,353 | $7,976 | +29.8% | 10% | 10% |
| W14 | $50.44 | $48.88 | 0.85x | 1.82x | 335 | 358 | -6.4% | $4,900 | $5,076 | -3.5% | — | — |
| W15 | $50.44 | $53.04 | 1.33x | 0.86x | 671 | 678 | -1% | $11,846 | $15,304 | -22.6% | — | — |
| W16 | $50.44 | $54.08 | 1.81x | 0.70x | 507 | 431 | +17.6% | $9,206 | $10,145 | -9.3% | — | — |
| W17 | $50.44 | $50.96 | 2.29x | 1.54x | 343 | 374 | -8.3% | $7,266 | $5,419 | +34.1% | — | — |
| W18 | $50.44 | $52.00 | 1.07x | 1.38x | 679 | 631 | +7.6% | $11,302 | $15,182 | -25.6% | — | — |
| W19 | $50.44 | $53.04 | 1.55x | 1.22x | 515 | 551 | -6.5% | $10,131 | $10,107 | +0.2% | — | — |
| W20 | $50.44 | $49.92 | 2.03x | 2.06x | 351 | 355 | -1.1% | $5,311 | $5,432 | -2.2% | — | — |
| W21 | $50.44 | $50.96 | 0.81x | 1.90x | 687 | 584 | +17.6% | $12,475 | $15,054 | -17.1% | — | — |
| W22 | $50.44 | $52.00 | 1.29x | 1.74x | 523 | 518 | +1% | $11,080 | $10,063 | +10.1% | — | — |
| W23 | $50.44 | $48.88 | 1.77x | 0.78x | 359 | 334 | +7.5% | $5,070 | $5,440 | -6.8% | — | — |
| W24 | $50.44 | $49.92 | 2.25x | 2.42x | 695 | 744 | -6.6% | $11,919 | $14,919 | -20.1% | — | — |
| Total / Avg | $52.69 | $51.65 | 1.58x | 1.52x | 11,944 | 11,510 | +3.8% | $215,782 | $223,578 | -3.5% | 8.8% | 10.1% |