Compute Company Suggestion Funnels
Company: Google
Role: Data Scientist
Category: Data Manipulation (SQL/Python)
Difficulty: hard
Interview Round: Technical Screen
Quick Answer: This question evaluates a candidate's ability to perform event-level funnel analysis including distinct aggregation, joins to a dimension table, time-windowed filtering, handling missing events (such as completions without prior clicks), and computing safe conversion rates using SQL or Python.