Promo Calendar & Campaign Uplift Planner
Plan annual promotional calendar, forecast campaign uplift and ROI to maximize revenue without over-promotion.
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):\n- Revenue: $100,000\n- Orders: 1,000 ($100 each)\n- Assumed margin: 40%\n- Profit: $40,000\n\nBlack Friday Promotion:\n- Discount: 30%\n- Discounted price: $100 × 0.7 = $70\n- Expected uplift: 300%\n- Uplift orders: 1,000 × 3 = 3,000\n- Total orders: 1,000 + 3,000 = 4,000\n\nRevenue Calculation:\n- Baseline orders (full price): 1,000 × $100 = $100,000\n- Uplift orders (discount): 3,000 × $70 = $210,000\n- Total revenue: $310,000\n\nCost & Profit:\n- Assume 40% margin → 60% COGS\n- COGS: $310K × 0.6 = $186,000\n- Gross profit: $124,000\n- Campaign cost: $5,000\n- Net profit: $119,000\n- Baseline profit: $40,000\n- Incremental profit: $79,000\n\nROI Calculation:\n- Incremental profit: $79,000\n- Promo cost: $5,000 (campaign) + $30,000 (discount on baseline 1,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).
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.
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 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.
Why might my result differ from another tool or reference?
Differences typically arise from rounding conventions, the specific version of a formula (for example, simple vs compound interest), or unit inconsistencies between inputs. Check that both tools are using the same formula variant and the same units. The References section links to the authoritative source behind the formula used here.