Funnel Drop-Off Diagnosis
Root cause by morning.
- Trigger
- Daily at 7:30 a.m., plus on-demand via Slack
- Data sources
- Mixpanel events, Branch attribution, internal booking DB, payment processor
- How it runs
- Pulls the last 24 hours of funnel and compares to 7-day and 30-day baselines. Flags drop-offs >3σ from baseline. Traces flagged steps to source: channel, creative ID, device, city, time-of-day. Writes a 4-sentence root-cause summary.
- Human in the loop
- Growth lead reviews in the 9 a.m. standup. One click expands the underlying SQL trace.
- Output
- Slack #growth-daily by 7:45 a.m., plus a saved analysis link.
Three-to-five day analyst cycle, often arriving after the next dip had started.
Same-morning answer with a named root cause. Standups now lead with action, not investigation.