✏️Prompts

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