🏀Zerve chosen as NCAA's Agentic Data Platform for 2026 Hackathon·📍Zerve exhibiting at Neudata London Summit · 2 July·📈We're hiring — awesome new roles just gone live!
Back

Production-Grade E-Commerce ETL & RFM Customer Segmentation Pipeline

purnanelluri27
July 8, 2026

About

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.

Related Topics

Decision-grade data work

Explore, analyze and deploy your first project in minutes