Project Overview
Worked with JLab, a San Diego-based audio company, to address the critical challenge of
increasing customer retention and converting one-time or in-person purchasers into loyal online customers.
The project focused on leveraging consumer behavior data and brand perception insights to propose
data-driven marketing strategies that would transform JLab's customer acquisition and retention approach.
Key Problem Statement
How can JLab reduce the number of one-time and in-person purchasers and convert them into repeat,
loyal customers purchasing through their official website?
Data Analysis & Methodology
- Multi-Platform Data Integration: Consolidated purchasing records from Shopify, TikTok, in-person retail, and website data sources
- Data Cleaning & Preprocessing: Standardized customer records across platforms, handled missing values, and resolved duplicate entries
- Customer Segmentation: Developed comprehensive segmentation framework based on order price, purchase frequency, and product preferences
- Behavioral Analysis: Analyzed seasonal purchasing trends, repeat customer behaviors, and regional product preferences
- Statistical Modeling: Applied cohort analysis and RFM (Recency, Frequency, Monetary) modeling to identify high-value customer segments
Key Insights & Findings
- Customer Segmentation: Identified 5 distinct customer segments with varying lifetime values and purchase behaviors
- Seasonal Trends: Discovered significant seasonal purchasing patterns beyond traditional holidays, revealing untapped revenue opportunities
- Regional Preferences: Mapped product preferences by geography, identifying regional market opportunities
- Channel Performance: Analyzed conversion rates across different sales channels, identifying optimization opportunities
- Customer Journey Mapping: Traced customer paths from first purchase to repeat purchases, identifying drop-off points
- Product Affinity Analysis: Discovered complementary product relationships for bundling strategies
Actionable Strategy Implementation
- Personalized Product Recommendations: Developed recommendation engine based on purchase history and geographic preferences, increasing cross-sell opportunities
- Strategic Product Bundling: Created data-driven bundles (e.g., Go Air Pop with accessories) based on purchase affinity analysis, improving average order value
- Email Marketing Optimization: Redesigned Klaviyo email flows using segmentation data, resulting in 25% higher open rates and 18% better click-through rates
Technical Skills & Tools
Python
Customer Segmentation
RFM Modeling
Data Visualization
Statistical Analysis
Key Learnings & Skills Developed
This project enhanced my expertise in customer analytics and data-driven marketing strategy.
I developed advanced skills in multi-platform data integration, customer segmentation, and
predictive modeling while learning to translate complex analytical insights into actionable
business strategies.