Data Analyst
If you were asked to define the key metrics for a subscription business, which would you choose and why?
What the interviewer is looking for
- This question tests metrics & business sense. Chooses metrics tied to how the business makes money or serves customers, and explains what would move them.
- Strong answers: Acquisition, activation, retention or churn, recurring revenue and customer lifetime value, linked to decisions the business makes.
- Likely follow-up: Which of those could be gamed, and how would you guard against it?
Another way it may be asked: Imagine a streaming service asks what five numbers they should watch every week. What would you suggest?
A structure to follow: Answer, explain, example, limits
- Step 1
Answer
Give your direct answer in the first sentence so the interviewer knows where you are going.
- Step 2
Explain
Say how it works or why you would do it that way, in plain words before jargon.
- Step 3
Example
Anchor it in something you have actually done or seen, with the detail that shows hands-on experience.
- Step 4
Limits
Say when your approach would not be the right one. It shows judgement.
This is guidance on shape, not a script. Use your own real experience and facts; never invent details to fill a gap. See the STAR guide and answer frameworks.
Common slips
- Reciting a definition without showing you have applied it.
- Using terms you cannot explain if asked a level deeper.
- Claiming experience beyond what you can discuss in detail.
How to practise it
Say the answer in 90 seconds, then answer the follow-up as if it were a new question.
Related questions
- What's the difference between an inner join and a left join, and when could picking the wrong one give you misleading numbers?
- You're handed a spreadsheet of sales with duplicate rows, mixed date formats and some blank regions. How would you clean it up?
- How do you decide which kind of chart to use for a particular piece of data?
- Weekly sign-ups dropped fifteen percent last week. Walk me through how you'd figure out why.
- Tell me about a complex query you wrote, maybe using window functions or several steps. What problem did it solve?