Production-Grade E-Commerce ETL & RFM Customer Segmentation Pipeline
purnanelluri27
July 8, 2026About
This canvas implements a comprehensive RFM (Recency, Frequency, Monetary) customer segmentation and CLV analysis workflow for an e-commerce retailer, processing raw Online Retail data into six customer segments with actionable CRM strategies, visualizations, and projected lifetime value metrics. Starting from data ingestion with quality checks, it calculates RFM metrics per customer, assigns segment labels (Champions through Lost/At Risk), and outputs multiple visualizations including segment counts, spend distributions, revenue trends, and CLV projections alongside a detailed CRM action recommendation table.



