Estimate Super Bowl QR Code Scan Rate Using Historical Data
CoinbaseData Scientist · Technical Screen
Last updated
This interview question evaluates metric design, causal reasoning, experiment setup, diagnostics, SQL/statistical checks, and recommendations in a realistic interview setting. A strong answer for Estimate Super Bowl QR Code Scan Rate Using Historical Data states assumptions, handles edge cases, explains trade-offs, and shows how to validate the result clearly.
Scenario
Super Bowl TV ad featuring a QR code; company wants to project funnel performance from view to sign-up.
Question
Estimate what percentage of viewers will scan the on-screen QR code during the Super Bowl broadcast. Describe how you would leverage historical data to build that estimate. If conversion-rate data from past QR campaigns is owned by the ad agency and only TV-company data are available, how would you still approximate the scan rate? After a user scans the code, how would you estimate the conversion rate from landing-page visit to sign-up?
Hints
Lay out a funnel, justify priors with comparable events, adjust for audience size and engagement, and state key assumptions.
Solution walkthrough is for members
Get the full walkthrough with reference code and complexity analysis, plus Kitty Coach at 300 messages a day. Hints, the code runner and community answers stay free.