Metrics question
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
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
Tests hypothesis generation and testing for a sudden content-supply spike, connecting cause diagnosis to a concrete verification plan.
How to approach it
- Clarify scope: confirm whether the spike is in upload count, total minutes uploaded, or both, and how large the spike is.
- Generate seasonal hypotheses: June often includes graduations, the start of summer break, and Pride Month content, all plausible drivers.
- Generate product hypotheses: a recent feature launch, an easier upload flow, a new editing tool, or a raised upload size limit shipped around that time.
- Generate external hypotheses: a viral trend or challenge format specific to June driving a wave of similar videos.
- Propose tests: compare the spike against the same month in prior years to isolate a recurring pattern, and segment new uploads by category or hashtag to see if one theme dominates.
- Define the follow-up action: if seasonal, prepare capacity and moderation for a recurring pattern; if feature-driven, consider promoting that upload flow further.
What a strong answer includes
- Generates hypotheses across three distinct categories, seasonal, product, and external trend, rather than guessing one cause.
- Proposes a concrete year-over-year comparison to separate a recurring seasonal pattern from a genuine anomaly.
- Names specific, plausible June events, graduations, Pride Month, summer break, rather than vague seasonality.
- Ties the diagnosis to an actionable next step depending on which cause is confirmed.
Common mistakes
- Treating seasonality as a black-box explanation without checking it against prior years' data.
- Not segmenting the spike by content category, missing that one theme could be driving most of it.
Likely follow-up questions
- How would you distinguish a genuine trend from bot or spam-driven uploads?
- What would you do differently if the spike were concentrated in one geography?
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
- 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
- How would you measure the success of Messenger Rooms?Microsoft · Metrics · Medium
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