Diagnose a drop in revenue
Last updated: November 26, 2025
Quick Overview
The activation rate dropped by 15% this week. Walk through your investigation process.
Shopify
November 26, 202535
5
1,107 solved
The activation rate dropped by 15% this week. Walk through your investigation process.
Product questions at Shopify test your ability to think like a product leader. This Take-home Project question evaluates how you balance user needs, business goals, and technical constraints when making product decisions.
What the Interviewer Expects
- Identify the target user and their core problem
- Propose reasonable solutions with basic prioritization
- Define 2-3 key success metrics
- Consider basic trade-offs and risks
Key Topics to Cover
How to Approach This
- Start with the user. Who are they, what problem do they have, and what is their current workaround?
- Use a prioritization framework: impact vs effort, RICE scoring, or ICE scoring.
- Define success metrics using the AARRR framework: Acquisition, Activation, Retention, Revenue, Referral.
- Consider second-order effects. A feature might boost short-term engagement but hurt long-term retention.
Possible Follow-up Questions
- How would you handle pushback from engineering on feasibility?
- What competitive response would you expect and how would you prepare?
- How would you decide to kill this feature if it's not working?
Sharpen Your Skills on Codemia
Practice similar problems with our interactive workspace, get AI feedback, and track your progress.
Browse Product QuestionsSample Answer
Problem Framing
The drop in activation rate by 15% indicates that fewer new merchants are successfully setting up and using their Shopify stores. To scope this problem, we should analyze the activation funnel, which ...
User & Market Context
The primary users affected by this drop in activation are new merchants, including small business owners and entrepreneurs looking to establish an online presence. What matters most for these users is...
Submit Your Answer
