Promo Calendar & Campaign Uplift Planner
Plan annual promotional calendar, forecast campaign uplift and ROI to maximize revenue without over-promotion.
Formula
Net Uplift = (Promo Sales - Baseline Sales - Cannibalized Sales); ROI = (Incremental Profit - Promo Cost) / Promo Cost × 100
Net promotional uplift subtracts baseline sales (would've sold anyway) and cannibalized future sales from gross promo sales to reveal true incremental volume. Promotional ROI calculates return by dividing incremental profit (net uplift × margin - discount cost) minus campaign cost, divided by total promotional investment (campaign + discounts). Example: Gross uplift 3,000 orders at $70 = $210K. Baseline 1,000 orders at $100 = $100K. Net uplift revenue: $210K. Margin 40% = $84K profit. Discount cost on baseline (1,000 × $30) = $30K. Campaign cost $5K. Incremental profit: $84K - $30K = $54K. ROI: ($54K - $5K) / $35K = 140%. The formula works because it isolates the true marginal value of the promotion: not total sales, but sales you wouldn't have gotten otherwise, net of costs you incurred (discounts, marketing). Many companies miscalculate by using gross uplift (overstating impact) or ignoring discount cost on baseline sales (understating cost).
Worked Examples
Example 1: Black Friday Promotion Planning
Problem:E-commerce site: $100K baseline monthly revenue, $100 avg order value. Planning Black Friday: 30% discount, expect 300% uplift, campaign cost $5K. Calculate ROI.
Solution:Baseline (Normal November): - Revenue: $100,000 - Orders: 1,000 ($100 each) - Assumed margin: 40% - Profit: $40,000 Black Friday Promotion: - Discount: 30% - Discounted price: $100 × 0.7 = $70 - Expected uplift: 300% - Uplift orders: 1,000 × 3 = 3,000 - Total orders: 1,000 + 3,000 = 4,000 Revenue Calculation: - Baseline orders (full price): 1,000 × $100 = $100,000 - Uplift orders (discount): 3,000 × $70 = $210,000 - Total revenue: $310,000 Cost & Profit: - Assume 40% margin → 60% COGS - COGS: $310K × 0.6 = $186,000 - Gross profit: $124,000 - Campaign cost: $5,000 - Net profit: $119,000 - Baseline profit: $40,000 - Incremental profit: $79,000 ROI Calculation: - Incremental profit: $79,000 - Promo cost: $5,000 (campaign) + $30,000 (discount on baseline 1,000 orders) - Total cost: $35,000
Result:Revenue: $310K (+210%) | Incremental profit: $79K | ROI: 126% (conservative) to 1,580% (campaign-only)
Frequently Asked Questions
What is promotional uplift?
Uplift is the incremental sales increase from a promotion vs. baseline (no promotion). Formula: (Sales during promo - Expected sales without promo) / Expected sales × 100. Example: Normally sell 1,000 units/month. Black Friday promotion: sell 4,000 units. Uplift = (4,000 - 1,000) / 1,000 = 300%. Uplift can be positive (promo worked) or negative (promo cannibalized future sales—customers waited for discount).
How do I measure promotional ROI?
Promo ROI = (Incremental Profit - Promo Cost) / Promo Cost × 100. Incremental profit = (Uplift revenue × Margin %) - Discount cost - Campaign cost. Example: Uplift $50K revenue, 40% margin = $20K profit. 20% discount on $50K = $10K. Campaign cost $3K. Incremental profit: $20K - $10K - $3K = $7K. ROI = $7K / $3K = 233%. Target: >200% for promotions. <100% means losing money.
What promotional calendar should I follow?
Retail calendar: Black Friday (Nov), Cyber Monday (Nov), Christmas/Holiday (Dec), New Year (Jan), Valentine's (Feb), Spring (Mar-Apr), Back-to-School (Aug), Prime Day (Jul, if Amazon). B2B: End-of-quarter (Mar, Jun, Sep, Dec) when buyers have budget to spend. Balance: Don't over-promote (trains customers to wait for sales). Mix: 4-6 major promos/year + flash sales. Test: What works for your audience may differ from calendar.
Can promotions hurt long-term profitability?
Yes, risks: (1) Training customers to wait (if always on sale, full price seems unfair), (2) Brand damage (excessive discounts signal desperation or low quality), (3) Margin erosion (constant promotions reduce average selling price), (4) Pull-forward effect (stealing future sales—customers who'd buy next month buy now at discount). Mitigation: Strategic timing (seasonal, competitive response), limited frequency (4-6/year), new customer focus (acquire, not just discount existing).
What's the difference between discount and uplift?
Discount = price reduction (20% off means $100 → $80). Uplift = volume increase (300% means 1,000 → 4,000 units). Often correlated but not 1:1. 10% discount may drive 50% uplift (elastic demand). Or 30% discount drives only 10% uplift (inelastic). ROI depends on both: small discount with large uplift = highly profitable. Large discount with small uplift = unprofitable. Test to find optimal discount-to-uplift ratio.
How do I forecast promotional uplift?
Historical data: Average past Black Friday uplifts (2021: 280%, 2022: 320%, 2023: 300% → forecast 300%). A/B testing: Test 20% discount on 10% of traffic, measure uplift, extrapolate. Industry benchmarks: Black Friday avg 200-400%, flash sales 50-150%. Conservative: Use lowest historical uplift. Optimistic: Use highest. Realistic: Use median or weighted average. Always have pessimistic scenario (50% of expected uplift) in planning.
What is promotional cannibalization?
Cannibalization = promotion steals sales from: (1) Future periods (customers who'd buy next month buy now), (2) Full-price sales (customers who'd pay full price wait for discount), (3) Other products (promote A, sales of B drop). Example: 40% off promotion drives $100K uplift. But next month sales drop $40K (pull-forward). Net uplift: $60K. Measure: Compare 30-60 days post-promo to baseline. If below baseline, promo cannibalized future.
How often should I run promotions?
Depends on brand positioning. Discount retailers (Kohl's, Old Navy): Constant promotions (culture expects it). Premium brands (Apple, Tesla): Rare or never (devalues brand). Most businesses: 4-8 per year (major holidays, seasonal, competitive). Too frequent (monthly): Trains customers to wait, erodes margin. Too rare (annual): Misses revenue opportunities. Sweet spot: Quarterly major promo + occasional flash sales.
What metrics should I track for promotions?
Pre-promo: Baseline sales, inventory. During: Sales uplift %, traffic increase, conversion rate, AOV (average order value), margin impact. Post: ROI, cannibalization (next 30 days sales), customer retention (did discounted customers return?), inventory clearance (if goal). Leading indicators: Email open rate, landing page traffic (predict promo success before it starts). Lagging: Total revenue, profit, new customer acquisition cost.
What is the difference between business days and calendar days?
Calendar days include every day. Business days (or working days) exclude weekends (Saturday and Sunday) and public holidays. A 10-business-day deadline is typically 14 calendar days. Legal and financial deadlines often specify which type applies.