Metrics question
A drop in engagement is observed in Microsoft OneDrive. How would you investigate the issue?
- Microsoft
- Metrics
- Hard
Practice this question out loud. An AI interviewer asks it, follows up like a real interviewer would, and scores your answer. Type or speak.
Start a mock interview on this question · Mock interview from a job description
What this question tests
Structured investigation of an engagement drop in an enterprise productivity product.
How to approach it
- Confirm the drop is real: check the metric definition and rule out a reporting or tracking bug first.
- Segment by user type: individual consumers versus enterprise IT-managed accounts, since OneDrive serves both differently.
- Segment by action: file uploads, shares, and syncs, to see which specific behavior dropped.
- Check for a recent change: a OneDrive UI update, a Windows update affecting sync, or a competing tool like Google Drive gaining share.
- Check seasonality: enterprise tools often see engagement dips around holidays or fiscal year-end freezes.
- Propose the top hypothesis and the specific data pull needed to confirm before recommending a fix.
What a strong answer includes
- Separates individual consumer accounts from enterprise IT-managed accounts, since drop causes and fixes differ sharply between them.
- Breaks engagement into specific actions, uploads, shares, syncs, rather than one blended engagement score.
- Names a concrete external hypothesis, competing tools like Google Drive or Dropbox gaining share in some accounts.
- Considers seasonality, like fiscal year-end IT freezes, as a plausible explanation worth ruling out first.
Common mistakes
- Treating OneDrive's user base as one uniform group instead of consumer versus enterprise.
- Jumping to a product fix before confirming the drop is not seasonal or a tracking issue.
Likely follow-up questions
- How would you tell if this drop is seasonal versus a real structural decline?
- What would you check first if the drop was concentrated in enterprise accounts?
More metrics questions
- How would you measure the performance and health of a Netflix Original?Microsoft · Metrics · Hard
- You are a PM for LinkedIn Trust Team. A number of senior influencers at LinkedIn have complained that they receive innumerable spam connection requests and they threaten to leave the platform or launch a tirade against LinkedIn. What do you do?Amazon · Metrics · Hard
- You notice a spike in the number of user-uploaded videos on your platform in June. What do you think is the cause, and how would you test it?Microsoft · Metrics · Medium
- Pick any favorite product of your choice . Find any one functionality you find missing in the same product which would make life simpler.Microsoft · Metrics · Easy
- How would you measure the success of Zoom?Google · Metrics · Medium
- How will you deliver a project during the unseen pandemic situation with a contract already signed?Microsoft · Metrics · Hard
More questions from Microsoft
Learn the skill behind it
Chapters of the AI PM course that teach what this question tests.
- Chapter 9: Prove it paid off: outcomes, economics, and pricing
- Chapter 2: Data fluency: SQL, logs, and reading the truth yourself
- Chapter 14: Get the job: the AI PM interview loop