Conversion Funnel Audit
Finds where e-commerce revenue leaks across the funnel, with data-driven fixes for user journeys.
Challenge
132K sessions and $1.78M in revenue — but product views weren’t converting, and nobody could point to the exact stage where the funnel was breaking.
Solution
Built the session-level funnel in BigQuery SQL (validation → construction → leakage → segmentation) with Python validation: View→Cart bled 73,961 sessions worth $1.14M — roughly 65—70% of all leakage — with desktop alone leaking $835K. Fixes ordered by ROI: above-the-fold Add-to-Cart on desktop, trust signals against hesitation, and landing pages matched to the Direct and Google intent behind $1M+ of leakage.
View GitHub Repo
