We Shipped Funnel Tracking and Immediately Found a Bug Hiding in Plain Sight

We shipped funnel tracking to PageBolt last week. Basic stuff — track signup started, email verified, plan selected, trial activated. Within hours, the data was screaming at us. 64% of users who started signup made it through to plan selection. But then: a cliff. Zero users activated trials. Not 10%. Not 50%. Zero. That's not a conversion problem. That's a bug. The Query That Found It Our funnel looked like this: SELECT event , COUNT ( DISTINCT user_id ) as users , ROUND ( 100 . 0 * COUNT ( DISTINCT user_id ) / ( SELECT COUNT ( DISTINCT user_id ) FROM events WHERE event = 'signup_started' AND created_at > NOW () - INTERVAL '7 days' ) , 1 ) as conversion_pct FROM events WHERE created_at > NOW () - INTERVAL '7 days' GROUP BY event ORDER BY created_at DESC ; Results: signup_started: 856 users email_verified: 742 users (86.7%) plan_selected: 546 users (63.8%) trial_activated: 0 users (0%) That 546 → 0 drop is unnatural. Users weren't leaving. They weren't erroring out in logs. They were di