The data is output of a marketing mix modeling for say hair care category. There are fur brands. Models are built for each of the four brands
1. Consider any one brand to build your strategy
2. Calculate ROMI for each Marketing Channel
3. Compare across years, quarters and against other competition
4. Comment on the effectiveness, efficiency of each marketing channel
5. Identify opportunities to improve, if any (across markets, channels)
6. Consider you have INR 1 Cr. Create a plan to allocate the same across different markets and channels - so that your volume is maximized
Take cure from ROMI analyses you have done as above
Assumption: Consider media and promotion prices as well as product prices remain constant over years (inflation adjusted)
Attachment:- Data is Output of a Marketing Mix Modeling.xlsx