Katkat

real interview stories, told over a cup of tea ♡

Mixpanel Interview Experiences

3935 interview stories from candidates at 857 companies: how each round went, what was asked and how it ended. Every company page links to practice questions in the same style.

3935
Experiences
857
Companies
532
Offers

2 results

  • Four Retention SQL Questions in a 45-Minute ScreenMixpanel · Data Scientist · Technical Screen · Sep 2026
    In progress

    Straight to the useful stuff. My Mixpanel Data Scientist phone interview was a SQL screen, around 45 minutes, with someone from the DS team. Table structures, restated as I understood them, roughly like this: users: user_id, signup_date, plan_type, ... events: user_id, event_ts, ... There were four questions, each building on the previous one, all about retention analysis. Q1: How many users had…

  • Pandas Tasks and Open-Ended Retention PredictionMixpanel · Data Scientist · Technical Screen · Sep 2026
    In progress

    Following up on my previous SQL post: This was the Python screen in the same Mixpanel DS phone-interview round, about 45 minutes. There were four questions: two hands-on pandas tasks and two open-ended questions. Aggregate the users and events dataframes separately. Merge the two dataframes and check for duplicates. An easy one. Open-ended: Which features might predict retention? Explore the data…