Data Analyst · Product Analyst · Junior · Theory

How would you calculate user retention for a mobile app?

~4 min by voice

How to approach it

This checks whether the candidate understands that retention is calculated by cohort as the share of the cohort that returned on a specific day, and whether they can correctly define activity, the numerator and the denominator, and compute it in SQL.

Have you seen this question in a real interview?

Answers0

Avg. score—

Strong—

Practiced0

Topics

product metrics retention

Similar questions

There's a users table with the columns user_id and signup_date, and an events table with the columns user_id and event_time. Write a SQL query that, for each weekly signup cohort, returns the cohort size and day-7 retention: the share of users who had at least one event exactly seven days after signing up. Mid-level On Monday morning you see on the dashboard that DAU has dropped fifteen percent compared to last week. How would you investigate? Mid-level At your company, five teams calculate revenue and active users differently, and the numbers never match in meetings. How would you design a unified metrics layer? Senior Which metrics would you choose to monitor the health of an online store? Junior A marketplace team is launching a new recommendations feed on the home page. What metrics would you propose to tell whether it's successful? Mid-level

Answer by voice

The interviewer will ask this question and listen. Think out loud and ask for a hint if you need one. When you're done, pause or tap “That's my answer”. In about a minute, your score and the points you covered show up here.

Best with headphones · ~4 min