E-Commerce Omnichannel & Retention Analytics

This analysis evaluates the end-to-end customer journey focusing on acquisition efficiency, marketing ROI, and Customer Lifetime Value (LTV). By integrating Cohort and RFM (Recency, Frequency, Monetary) analyses, this project uncovers the true health of the customer base and identifies high-ROI strategies for sustainable growth.

Key Findings:

The 80/20 Retention Crisis: The business relies heavily on a core 18% of the customer base (VIP & Loyal segments) to drive sustainable profitability. Conversely, 53% of customers are currently At-Risk or Lost.

The Month-1 Cliff: There is a severe immediate retention leak. An alarming 86% of customers churn immediately following their first purchase, highlighting major post-purchase onboarding flaws.

The Paid Acquisition Trap: Paid Marketing Campaigns create a conversion illusion. They yield quick initial sales but fail to generate long-term value, bringing in the highest percentage of one-time buyers (Lost segment).

The Hidden Treasure: In contrast to paid ads, Organic Search and Direct traffic are the true LTV drivers, generating over 50% of all VIP customers.

Actionable Recommendations:

Deploy a Month-1 Retention Sequence: Combat the massive 86% initial drop-off by launching an automated post-purchase "Welcome Series" (email/SMS). This should focus on product education and brand value to build trust before the next buying cycle begins.

Reallocate CAC to 'At-Risk' Retargeting: Halt budget increases for generic, discount-driven campaigns that fuel the Month-1 churn. Instead, reallocate this ad spend toward retargeting the 'At-Risk' segment, as their acquisition DNA perfectly mirrors the highly profitable VIP segment.

Launch a VIP Referral Program: Capitalize on the robust 70% repeat purchase rate by turning satisfied customers into brand advocates. Implementing a referral program will organically scale Direct and Organic traffic, which are the absolute best sources for acquiring VIPs.