Root-Cause Analysis for Falling Engagement in Microsoft OneDrive

Quick Overview

A product analytics interview question about Microsoft OneDrive: engagement has fallen and the candidate must find out why. It tests defining the engagement metric, ruling out data problems, segmenting by account type, client and region, and separating internal from external causes before recommending a fix.

Root-Cause Analysis for Falling Engagement in Microsoft OneDrive

Company: Microsoft

Role: Product Manager

Category: Analytics & Experimentation

Difficulty: medium

Interview Round: Other

You are a product manager for Microsoft OneDrive, Microsoft's cloud service for storing, syncing and sharing files. The team has noticed that OneDrive engagement has gone down. How would you work out what caused the decline, and what would you do once you have found the cause? The prompt does not say which engagement metric fell, by how much, since when, or for which users. Establishing those facts is part of the exercise. ```hint Locate the drop before explaining it Before listing possible causes, pin down which part of the engagement number moved: fewer active people, fewer sessions per person, or fewer specific file actions such as uploads, opens or shares. Where the drop sits narrows the plausible causes sharply. ``` ### Clarifying Questions - Which metric is the team calling engagement: daily or monthly active users, sessions, files uploaded or synced, files opened, or sharing and co-editing activity? - How large is the decline, did it appear suddenly or build over weeks, and how does it compare with normal seasonal swings such as school holidays? - Is the drop concentrated in personal accounts or in work and school accounts, or in one client: the desktop sync app, the web, the mobile apps, or OneDrive inside other Microsoft apps? - What changed recently: app releases, storage or pricing plans, default settings in Windows or Office, or the way activity events are logged? ### What a Strong Answer Covers - A precise engagement definition, decomposed into users, frequency and OneDrive-specific actions (upload, sync, open, share, co-edit) - Checking instrumentation and data pipelines before treating the drop as a real change in behavior - Segmentation by account type, client, operating system, region and app version to localize the drop - Internal and external hypotheses tested in order of likelihood, with the evidence that would confirm or rule out each - A remedy matched to the confirmed cause, plus how the recovery would be monitored ### Follow-up Questions - The drop is limited to Windows desktop sync and began the week of an operating-system update. How do you decide whether the OneDrive team or the Windows team must fix it? - Engagement fell among free personal users right after a change to their storage allowance, while paid subscriptions rose. Is that a problem, and what would you recommend? - How would you prove the decline is not an artifact of a change in how sync events are counted?

Overview: A product analytics interview question about Microsoft OneDrive: engagement has fallen and the candidate must find out why. It tests defining the engagement metric, ruling out data problems, segmenting by account type, client and region, and separating internal from external causes before recommending a fix.

Microsoft logo
Microsoft
Aug 16, 2026
mediumProduct ManagerOtherAnalytics & Experimentation
0
0

You are a product manager for Microsoft OneDrive, Microsoft's cloud service for storing, syncing and sharing files. The team has noticed that OneDrive engagement has gone down. How would you work out what caused the decline, and what would you do once you have found the cause?

The prompt does not say which engagement metric fell, by how much, since when, or for which users. Establishing those facts is part of the exercise.

Clarifying Questions Guidance

  • Which metric is the team calling engagement: daily or monthly active users, sessions, files uploaded or synced, files opened, or sharing and co-editing activity?
  • How large is the decline, did it appear suddenly or build over weeks, and how does it compare with normal seasonal swings such as school holidays?
  • Is the drop concentrated in personal accounts or in work and school accounts, or in one client: the desktop sync app, the web, the mobile apps, or OneDrive inside other Microsoft apps?
  • What changed recently: app releases, storage or pricing plans, default settings in Windows or Office, or the way activity events are logged?

What a Strong Answer Covers Guidance

  • A precise engagement definition, decomposed into users, frequency and OneDrive-specific actions (upload, sync, open, share, co-edit)
  • Checking instrumentation and data pipelines before treating the drop as a real change in behavior
  • Segmentation by account type, client, operating system, region and app version to localize the drop
  • Internal and external hypotheses tested in order of likelihood, with the evidence that would confirm or rule out each
  • A remedy matched to the confirmed cause, plus how the recovery would be monitored

Follow-up Questions Guidance

  • The drop is limited to Windows desktop sync and began the week of an operating-system update. How do you decide whether the OneDrive team or the Windows team must fix it?
  • Engagement fell among free personal users right after a change to their storage allowance, while paid subscriptions rose. Is that a problem, and what would you recommend?
  • How would you prove the decline is not an artifact of a change in how sync events are counted?