Analysis
Optimizing Ad Spend for a D2C Cosmetics Brand
Overview
What this challenge is about.
You are a data analyst at Glow & Grow. Using the provided dataset (simulated), perform an exploratory data analysis to understand trends in ad performance. Build a regression model to predict conversions based on spend per channel. Then, create a dashboard in Tableau or Power BI that visualizes the key metrics and your recommended budget allocation. Success is defined by a clear, data-driven recommendation that reduces CAC by at least 15% without sacrificing volume.
The Brief
What you'll do, and what you'll demonstrate.
How should Glow & Grow reallocate its advertising budget across channels to reduce customer acquisition costs while maintaining or increasing conversion volume?
Earning criteria — what you'll demonstrate
- Apply inferential statistics to interpret marketing data
- Build and interpret a multiple regression model for prediction
- Create effective data visualizations to communicate insights
- Translate analytical findings into actionable business recommendations
Program Fit
Where this fits in your program.
Sharpens the same skills your degree expects you to demonstrate.
Skills
Skills you'll demonstrate.
Each one shows up on your verified credential.
Careers
Roles this prepares you for.
Real titles. Real skill bridges. Pick the one closest to your trajectory.
Career mappings coming soon.