Promotion Management
HealthMax had three different promotions for the Shinez brand in 2022. To build the strategy for 2024, you'd like to come with clear recommendation of which promotions are the most effective ones.
Let's complete the table and calculate the ROI for the three different promotions.
Este exercicio faz parte do curso
Estudo de Caso: Net Revenue Management no Google Sheets
Instruções do exercicio
- Fill in the
Value Salesby using the 2022 monthly sales values from Shinez using aVLOOKUP()function. - Calculate the
Baseline salesby taking the average values of all months in the year where no promotion was active. - Uplift can be calculated as the absolute increase (not %) in sales compared to baseline.
- The ROI is the increase in monetary value divided by the campaign cost.
exercicio interativo prático
Transforme teoria em prática com um dos nossos exercicio interativos
Iniciar exercicio