Note: This app can make mistakes in calculating Promo Depth, please perform QA before using it.
Promo Depth Calculator
Upload your Price & Promo file to calculate depths automatically.
How to Prepare Your Data
- Download the Latest Wave Data.
- Combine the Local Price and PromotionDetails using Concatenation Function Seperated by ( - ).
- Rename the new Column as Price & Promo Details.
- Take the Price & Promo Details column to a separate sheet, go to Data tab and remove duplicates.
- Save the Price & Promo Details in a separate Excel file.
- Upload the Excel file below.
Calculation Logic Examples
- Direct %: "Save 33%" → 33%
- Buy X Get Y: "Buy 2 Get 1 Free" → 33.33% (1/3)
- Was/Now: "Was $100 Now $80" → 20%
- Money Off: "$10 Off" (Base $50) → 20%
- Multi-Buy: "2 For $15" (Base $10 each) → 25%