E-commerce & Retail Analytics Path · Mission 21 of 30Expert

RFM segmentation — customer scoring

Compute Recency (days since last paid order), Frequency (paid order count), and Monetary (sum total_price) per customer, score each into NTILE(5) buckets, sum to a 3-15 RFM score. The canonical retention-segmentation framework.

The Brief

You'll practice

NTILEMulti-CTECapstone