43. A funnel report counts users who viewed, started and completed a task, but does not check event order. What would you change?
MediumSQL
Technical
Show model answer
Define the allowed sequence, observation window and unit of analysis before counting. A user who completed a task before the recorded start should not automatically qualify for a later start-to-completion step.
Build qualifying paths using event timestamps and an explicit rule for repeated attempts. Keep the eligible population consistent at each stage, and test out-of-order events, duplicate events and users with several attempts.
What interviewers listen for
- Require the intended event sequence
- Define repeated-attempt attribution
- Keep funnel populations consistent