Stripe·Data Scientist·Technical Phone Screen
- Define a primary success metric for the marketing campaign that is attributable, time-bounded, and robust to activity spikes. Include two guardrail metrics and write out the precise formulas.
- Write SQL to compute, for each contact week and country, the 14-day post-contact purchase conversion rate and average revenue per contacted user. Use only the first contact per user and exclude purchases that happened before the contact time.
- Write SQL to build a matched baseline: pair each contacted user to one non-contacted user in the same signup week and country, breaking ties by smallest user_id, then compute the 14-day purchase rate for the matched group.
- On a specific date, contacted-user conversion in the US drops 20% versus the prior 7-day average. Write SQL to break this down by device and product_id, showing count contacted, 14-day conversion, and delta versus the prior period for each slice. Return the top 3 slices by approximate contribution to the drop.
- What check would you add to make sure your metrics aren't biased by users who unsubscribed immediately after being contacted?
“I went with 14-day post-contact purchase conversion using only first contacts, which felt right.”