Subscription Churn Analysis Model

A medium Data Modeling mock interview question on DataDriven. Practice with AI-powered feedback, real code execution, and a hire/no-hire decision.

Domain

Data Modeling

Difficulty

medium

Seniority

senior

Interview Prompt

We run a music streaming service like Spotify. Our premium subscribers are churning at 8% monthly and we need to understand why. We want to analyze churn patterns by looking at how their listening habits, playlist activity, and subscription history changed before they cancelled. Design the data model.

How This Interview Works

1. Read the vague prompt (just like a real interview)
2. Ask clarifying questions to the AI interviewer
3. Write your data modeling solution with real code execution
4. Get instant feedback and a hire/no-hire decision