Q1
Walk me through how you would design a metrics framework to track user engagement for a new product feature. What KPIs would you choose and why?
Why they ask this:* They want to assess your ability to define meaningful metrics, understand product goals, and connect analytics to business outcomes—a core responsibility of product analysts.
Q2
Describe your experience with SQL. Can you write a query that identifies users who made a purchase in the last 30 days but haven't returned in the past 7 days?
Why they ask this:* SQL proficiency is essential for product analysts to independently extract and analyze data from databases without relying on engineers for basic queries.
Q3
How would you approach A/B testing a product feature? What statistical concepts would you consider, and what sample size would you need?
Why they ask this:* This tests understanding of experimental design, statistical significance, and how to validate product decisions—critical for making data-driven recommendations.
Q4
Explain the difference between cohort analysis and funnel analysis. When would you use each in your product work?