Skip to interview prep
Apexed

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
A funnel report counts users who viewed, started and completed a task, but does not check event order. What would you change — Data & analytics interview questi