E-commerce Funnel & Conversion Analysis Using SQL
What I did:
Cleaned & prepared 10,000+ session records with Pandas in Google Colab
Ran complex SQL queries in SQLite to uncover conversion patterns
Analyzed user behavior across funnel stages, device types, countries, and referral sources
Estimated ₹12.4 Lakhs in lost revenue due to cart abandonment
Highlighted high-performing user segments (e.g., UK market, Mobile users, Furniture category)
Key Insights:
40.86% of users dropped at the browsing stage
Mobile users had the highest conversion rate (10.5%)
Direct traffic & new users outperformed others in purchase likelihood
Huge potential in cart recovery strategies
Published:July 28, 2025
Anne Willian
Aug 8, 2025 My name is Anne Willian , I'm from the United States, I can across your profile on this site Website and I'm interested to know more about you, please contact me directly on my private email adress I have something very important to discuss with you. I can not chat with you here due to some personal issues. reasons annewillian689@gmail.com
0 likes
