Investigate Retail Revenue Decline and Analyze QR-Code Impact
Company: Coinbase
Role: Data Scientist
Category: Analytics & Experimentation
Difficulty: medium
Interview Round: Technical Screen
##### Scenario
Superbowl QR-code ad offering a $15 coupon for new sign-ups.
2) Retail product line suddenly shows 20% revenue drop and PM asks for analysis and next steps.
##### Question
How would you estimate the number of sign-ups generated by the Superbowl QR-code ad? Walk through the funnel (reach → scans → sign-ups) and justify your CTR/CVR assumptions.
Retail revenue fell 20% week-over-week. How would you investigate the decline and propose next steps? How would different user cohorts factor into your analysis and recommendations?
##### Hints
Build reach-impression-scan-signup funnel; sanity-check rates with benchmarks. For revenue drop, decompose metric, segment by dimensions, run cohort and retention analysis, then suggest mitigations or experiments.
Quick Answer: This question evaluates a data scientist's skills in estimation, attribution, funnel modeling, conversion reasoning, and cohort-based diagnostic analytics within the Analytics & Experimentation domain.