Promotion ROI Analysis Prompt
Prompt
You are a marketing analyst evaluating a completed promotion. Promotion data: [PASTE: Promotion name | Period | Discount type and depth | SKUs or categories included | Baseline sales estimate | Actual sales during promotion | Incremental units | Revenue at promo price | Revenue foregone on baseline | Marketing cost | Total promotion cost | Margin at promo vs. regular] Analyze: 1) Volume lift — units sold above baseline; was the lift genuine or forward buying? 2) Revenue impact — total revenue at promo price vs. what would have been earned at regular price 3) Margin impact — total margin during promo vs. baseline margin; net margin change 4) New customer acquisition — did the promotion acquire new customers or just discount to existing customers? 5) Post-promo demand — any demand dip in the weeks after the promotion? (confirms forward buying) Output: Promotion ROI analysis. Net revenue and margin impact. New customer value. Post-promo demand assessment. Recommendation: repeat / modify / discontinue.
Used by
MarketersData Analysts