Product analyst interview: activation and retention
Turn usage events into account-level product metrics and explain the caveats behind each number.
Practise each question under time pressure, then explain your assumptions, data grain and edge cases aloud before comparing solutions.
Start interview practice→ 02
→ 03
Your exercises
01Return the number of distinct accounts that created a report as adopting_accounts. Count accounts, not report events.
For non-churned accounts with at least one event in September 2026, return plan and active_accounts. Sort by plan alphabetically.
Return company for non-churned accounts with no product event in September 2026, sorted by company alphabetically.
For accounts with at least one September 2026 event, return plan and average September events per active account as avg_events, rounded to two decimals, sorted by plan alphabetically.
Return company and open_tickets for accounts with at least one support ticket that has no resolved_at date, sorted by count descending and company alphabetically.