E-Commerce Funnel Optimization & Cohort Analysis (In-Progress)

Introduction

Optimize conversion funnels and customer retention for an e-commerce business using Google Analytics data.

Key Components:

• SQL Queries: Built modular queries for funnel analysis, cohort retention, and customer segmentation.
• Testing: Validation scripts to ensure query accuracy.

Upcoming:

• Visualization: Jupyter notebooks with Plotly for interactive insights.
• Insights: Identified drop-off points, high-value customer segments, and A/B test opportunities.

Tech Stack: BigQuery (SQL), Python (Pandas, Plotly), Jupyter.

Outcome: Actionable recommendations to improve conversion rates and customer lifetime value.

Status: Funnel analysis complete; next steps → cohort & CLV modeling.