Extract insights from a multi-entry funnel scorecard
IntuitProduct Analyst · OnsiteLast updated
This question evaluates a candidate's ability to analyze multistep funnel metrics, handle highly skewed traffic across many access points, and prioritize insights from sparse or long-tail data, testing competencies in product analytics and measurement.
Scenario
You are given a scorecard for a QuickBooks-like product showing a funnel by access point (15+ entry points, highly skewed traffic).
For each access_point, you have:
visitsapplication_startapplication_completepaid(orsubscribe)- Potentially other step-level counts/rates (7–8 columns total)
Assume the funnel is: Visit → Application Start → Application Complete → Paid.
Task
- Share three insights you would report from this scorecard (prioritize by impact, not just rate extremes).
- Recommend next steps (product, experimentation, or data work) based on those insights.
Notes
- Many access points have tiny traffic; explain how you handle the long tail (e.g., 80/20).
Solution walkthrough is for members
Get the full walkthrough with reference code and complexity analysis, plus Kitty Coach at 300 messages a day. Hints, the code runner and community answers stay free.