Mekky Mart Ecommerce
Category:
Data Analytics, E-Commerce Strategy, Business Intelligence (BI)
Client:
Mekky Mart (Fictional Client)
The Challenge
Mekky scaled rapidly, leading to major blind spots in critical operational and customer areas. Leadership lacked data-driven answers to core questions:
Who are our most valuable customers?
Which regions are causing delivery delays?
And are we getting a return on our marketing spend?
The Solution
A complete data integrity and analytical pipeline was built using Python. The solution involved:
1) Customer Segmentation to determine Lifetime Value (CLV);
2) Root Cause Analysis to pinpoint the exact regions responsible for poor delivery efficiency.
etc.
The Result
Delivered three high-impact, actionable strategies to the executive team:
1) Implement a 48-Hour Churn Recovery Funnel to save at-risk revenue.
2) Launch Targeted Audits on the worst-performing delivery regions to reduce latency.
etc.
Want to see the data cleaning, the complex joins, and the precise code used to calculate customer churn and marketing ROAS? The full Jupyter Notebook and raw data are available on GitHub.
Click Here To View Project Code, Dashoard Report, Presentation & Raw Data on GitHub
