Analysis
Optimize Ad Spend for Munich D2C Cosmetics Brand
Overview
What this challenge is about.
You are given a CSV dataset with 10,000 rows of ad performance data including date, campaign, audience segment, creative type, impressions, clicks, conversions, and spend. Your task is to clean the data, perform exploratory analysis, run A/B tests to compare creative performance, and build a simple regression model to predict conversions. Deliver a presentation with your findings and a recommended budget allocation across segments. Success is defined by a clear, justified proposal that increases ROI by at least 15% based on your analysis.
The Brief
What you'll do, and what you'll demonstrate.
How should GlowBerlin reallocate its monthly €50,000 ad budget across audience segments and creative types to maximize ROI?
Earning criteria — what you'll demonstrate
- Apply A/B testing methodology to compare ad creative performance
- Build and interpret a linear regression model for conversion prediction
- Use data-driven insights to inform marketing budget allocation
- Communicate analytical findings to a non-technical audience
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.