PracHub
QuestionsLearningGuidesInterview Prep

Quick Overview

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.

  • hard
  • Google
  • Data Manipulation (SQL/Python)
  • Data Scientist

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.

Last updated: May 31, 2026
Loading…
PracHub

Master your tech interviews with 9,000+ real questions from top companies.

Product

  • Questions
  • Learning Tracks
  • Interview Guides
  • Resources
  • Premium
  • For Universities

Browse

  • By Company
  • By Role
  • By Category
  • Topic Hubs
  • SQL Questions
  • AI Coding Questions
  • Compare Platforms
  • Discord Community

Support

  • support@prachub.com
  • (916) 541-4762

Legal

  • Privacy Policy
  • Terms of Service
  • About Us

© 2026 PracHub. All rights reserved.

Related Coding Questions

  • Generate binomial matrix and column-normalize - Google (medium)
  • Analyze video flags and reviews with SQL - Google (medium)
  • Write SQL/Python for messy event data - Google (medium)
  • Add a conditional column in Python - Google (medium)