MarketCast Interview Questions
The questions to prepare for MarketCast interviews, across all roles. Questions from real interview reports rank first. Updated daily.
Identify the main pitfalls that can distort A/B test interpretation and explain how to guard against them.
Explain common online experimentation pitfalls and how to design, analyze, and decide in ways that avoid false wins.
Diagnose a below-expectations product metric drop using decomposition, guardrails, and experiment checks.
Build a systematic process to validate, decompose, and explain a sudden 10% drop in core engagement.
Calculate each user's 7-day activity average and rank users within their cohort using PostgreSQL window functions.
Explain what statistical significance means and why it matters when interpreting experimental or analytical results.
Explain how to optimize near-term product outcomes without sacrificing long-term user trust, retention, and value.
Explain how to profile, clean, and standardize missing or dirty data before analysis.
Sign up to see every question
Create a free account to unlock this list and practice real interview questions.
Calculate monthly user totals, running totals, and time-based rankings with PostgreSQL window functions.
Calculate user revenue running totals and daily rankings using PostgreSQL window functions.
CertiK