Data Analytics · Business Intelligence · Predictive Analytics

E-commerce Conversion Funnel Analysis

An end-to-end analytics project focused on understanding e-commerce conversion behavior, funnel drop-offs, revenue efficiency, and purchase likelihood.

Problem Statement

E-commerce businesses lose revenue at multiple points of the customer journey — from initial visit to final purchase. Without clear funnel visibility, it's hard to identify where drop-offs happen, which channels and campaigns underperform, and how to prioritize revenue optimization efforts.

The dataset contains 120,000 sessions with 17 columns, covering July 2025 to December 2025 at session-level granularity.

Customer Journey — 5 Funnel Stages

Website Visit→ Product View→ Add to Cart→ Checkout→ Purchase

Business Objectives

  • Analyze conversion funnel stages and identify customer drop-offs
  • Compare channels, campaigns, devices, and user types
  • Analyze order value and realized revenue
  • Study revenue leakage and discount impact
  • Track purchase and conversion trends
  • Develop a purchase prediction model
  • Build Power BI dashboards
  • Develop a Streamlit prediction application

Analytical & ML Workflow

Python Cleaning→ SQL Analysis→ Power BI→ Machine Learning→ Streamlit

Technologies Used

PythonPandasNumPyMySQLSQL Power BIDAXScikit-learnRandom Forest XGBoostStreamlitJoblib

Machine Learning Details

Models tested during development:

  • Logistic Regression
  • Random Forest
  • XGBoost

The final Streamlit application uses a Random Forest classifier with a 92% decision threshold.

Note: The live Streamlit application URL has not yet been deployed publicly. The GitHub repository and reports are linked below.

Dashboard Gallery

Business Value

Combines SQL-based funnel analysis, business intelligence dashboards, and a deployed prediction model to help stakeholders understand where customers drop off, why revenue leaks, and how to prioritize optimization. The Streamlit app supports what-if purchase likelihood prediction for new sessions.

Note: Stage-wise conversion percentages and revenue leakage amounts were not part of the verified brief and are not included here.

Project Resources