Instacart·Data Scientist·Take-home Assignment
- Using findings from a SQL analysis on advertiser spend and program profitability, propose a concrete budget allocation for next quarter that maximizes net profit while managing risk. Your answer should cover recommended program-level budget shares, advertiser-level allocation rules, and a back-of-the-envelope incremental profit estimate with stated assumptions.
- Design an experiment to validate the proposed budget allocation strategy. Specify your randomization unit, power and sample size considerations, primary KPI, and guardrails. Define what success looks like and how you would make a go/no-go decision.
- Walk through your analysis plan: what segmentations would you run, how would you handle seasonality and regression to the mean, what additional data would you request, and what confounders are you worried about and how would you address them?
“This part took me way longer than I expected.”