Context and Data Preparation

Analysis Overview and Data Quality

OV

RFM Analysis Overview

Customer Segmentation Configuration

Analysis overview and configuration

Rfm Analysis
Online Retail Demo
Which customers are most valuable and how should we prioritize them?
Module Configuration
min_transactions 1
scoring_method quintile
segment_labels TRUE
Processing ID
test_1771262835
analysis type: Rfm Analysis
company: Online Retail Demo
objective: Which customers are most valuable and how should we prioritize them?
IN

Key Insights

RFM Analysis Overview

RFM Analysis: Overall Setup & Data Characteristics

Purpose

This RFM (Recency, Frequency, Monetary) analysis segments 950 customers into five distinct groups to identify the most valuable customers and guide prioritization strategies. The analysis directly addresses the business objective of determining which customers are most valuable and how to allocate resources effectively across the customer base.

Key Findings

  • Champions Segment: 396 customers (41.7%) generating $83,766 (68.7% of total revenue) at $211.53 per customer—representing the highest-value tier
  • Revenue Concentration: Top 20% of customers account for 40.2% of revenue, indicating moderate concentration with significant value distributed across multiple segments
  • Frequency Distribution: 908 customers (95.6%) classified as high-frequency buyers (10+ transactions), with maximum order count reaching 130 transactions
  • Geographic Concentration: United Kingdom dominates with 836 customers and $110,215 revenue (90.4% of total), while 6 other countries contribute minimally
  • Recency Anomaly: All customers show 0 days recency, suggesting snapshot analysis or data collection timing issue

Interpretation

The analysis reveals a highly engaged customer base with strong purchase frequency but concentrated value. Champions and Loyal Customers together represent 64.4

IN

Key Insights

RFM Analysis Overview

RFM Analysis: Overall Setup & Data Characteristics

Purpose

This RFM (Recency, Frequency, Monetary) analysis segments 950 customers into five distinct groups to identify the most valuable customers and guide prioritization strategies. The analysis directly addresses the business objective of determining which customers are most valuable and how to allocate resources effectively across the customer base.

Key Findings

  • Champions Segment: 396 customers (41.7%) generating $83,766 (68.7% of total revenue) at $211.53 per customer—representing the highest-value tier
  • Revenue Concentration: Top 20% of customers account for 40.2% of revenue, indicating moderate concentration with significant value distributed across multiple segments
  • Frequency Distribution: 908 customers (95.6%) classified as high-frequency buyers (10+ transactions), with maximum order count reaching 130 transactions
  • Geographic Concentration: United Kingdom dominates with 836 customers and $110,215 revenue (90.4% of total), while 6 other countries contribute minimally
  • Recency Anomaly: All customers show 0 days recency, suggesting snapshot analysis or data collection timing issue

Interpretation

The analysis reveals a highly engaged customer base with strong purchase frequency but concentrated value. Champions and Loyal Customers together represent 64.4

PP

Data Preprocessing

Data Quality & Completeness

994
Final Observations

Data preprocessing and column mapping

Data Pipeline
1,000
Initial Records
994
Clean Records
Column Mapping
customer_id
→
Customer.ID
invoice_date
→
InvoiceDate
invoice
→
Invoice
revenue
→
Price
country
→
Country
product_id
→
StockCode
994 Records
MCP Analytics
994 Records
IN

Key Insights

Data Preprocessing

Purpose

This section documents the data cleaning process applied before RFM segmentation analysis. The minimal data loss (0.6%) indicates a high-quality dataset with few anomalies or missing values, which is critical for reliable customer segmentation and revenue concentration insights.

Key Findings

  • Retention Rate: 99.4% - Only 6 rows removed from 1,000 initial observations, suggesting minimal data quality issues
  • Rows Removed: 6 observations - Likely duplicates, null values, or invalid transaction records that would skew RFM calculations
  • Final Dataset: 994 rows analyzed across 950 unique customers, providing a robust foundation for segmentation

Interpretation

The near-complete retention rate demonstrates that the source data was already well-structured and validated. The removal of just 6 rows represents negligible data loss, meaning the downstream RFM analysis (quintile-based scoring, segment profiling, and revenue concentration metrics) operates on a representative and reliable dataset. This high data quality supports the credibility of findings showing 41.7% of customers as Champions generating 68.7% of revenue.

Context

No train/test split is documented, indicating this is a descriptive analysis rather than a predictive modeling exercise. The analysis treats all 994 cleaned records as a complete population snapshot for December 2009, which is appropriate

IN

Key Insights

Data Preprocessing

Purpose

This section documents the data cleaning process applied before RFM segmentation analysis. The minimal data loss (0.6%) indicates a high-quality dataset with few anomalies or missing values, which is critical for reliable customer segmentation and revenue concentration insights.

Key Findings

  • Retention Rate: 99.4% - Only 6 rows removed from 1,000 initial observations, suggesting minimal data quality issues
  • Rows Removed: 6 observations - Likely duplicates, null values, or invalid transaction records that would skew RFM calculations
  • Final Dataset: 994 rows analyzed across 950 unique customers, providing a robust foundation for segmentation

Interpretation

The near-complete retention rate demonstrates that the source data was already well-structured and validated. The removal of just 6 rows represents negligible data loss, meaning the downstream RFM analysis (quintile-based scoring, segment profiling, and revenue concentration metrics) operates on a representative and reliable dataset. This high data quality supports the credibility of findings showing 41.7% of customers as Champions generating 68.7% of revenue.

Context

No train/test split is documented, indicating this is a descriptive analysis rather than a predictive modeling exercise. The analysis treats all 994 cleaned records as a complete population snapshot for December 2009, which is appropriate

Executive Summary

Key Findings and Pareto Validation

TLDR

Executive Summary

Key Findings & Pareto Validation

950
Total Customers

Key Performance Indicators

Total customers
950
Total revenue
121,876.4
Champions count
396
At risk count
0
Lost count
0
Top 20 pct revenue
40.2
Champions revenue per customer
211.53

Key Findings

Key findings

Metric Value
Total Customers 950
Champions 396 ($212/customer)
At Risk (Value at Risk) 0
Lost 0
One-Time Buyers 11 (1.2%)
Top 20% Revenue Share 40.2%
Unique Segments 5
Countries Analyzed 7
Cohorts Tracked 1

Executive Summary

Bottom Line: Segmented 950 customers into 5 behavioral segments using RFM analysis. Top 20% of customers drive 40.2% of revenue.

Key Findings:
• Champions (396 customers, 41.7%): Highest value at $212 per customer - VIP treatment required
• Loyal Customers (216 customers): Stable revenue - maintain with retention programs
• At Risk (0 customers, 0%): High historical value but declining - URGENT win-back needed
• Lost (0 customers): Inactive - remove from marketing for cost savings
Additional Insights:
• Geographic: Analyzed 7 countries with top market at $110,215 revenue
• Cohorts: Tracked 1 customer cohort(s) for retention analysis


Pareto Validation: Top 20% = 40.2% revenue (LOW concentration - needs loyalty building)

Recommendations:
1. HIGH Priority: Champions retention + At Risk win-back campaigns
2. MEDIUM Priority: Loyal customer maintenance + About to Sleep intervention
3. LOW Priority: Remove Lost customers from active marketing lists

Executive Summary
Action Plan
Pareto Validation
IN

Key Insights

Executive Summary

EXECUTIVE SUMMARY: RFM CUSTOMER SEGMENTATION ANALYSIS

Purpose

This analysis segments 950 customers into five behavioral groups using Recency, Frequency, and Monetary (RFM) metrics to identify high-value customers and optimize marketing resource allocation. Understanding customer value distribution is critical for maximizing lifetime value and retention efficiency.

Key Findings

  • Champions Segment: 396 customers (41.7% of base) generating $211.53 per customer—representing the highest-value behavioral tier requiring VIP-level engagement
  • Revenue Concentration: Top 20% of customers drive only 40.2% of total revenue, indicating relatively distributed value across the customer base rather than extreme concentration
  • Loyal Customers: 216 customers (22.7%) with $96.72 average value—stable, retention-focused segment
  • At-Risk & Lost Customers: Zero customers in both categories, suggesting either excellent current retention or data collection limitations
  • One-Time Buyers: Only 11 customers (1.2%), indicating strong repeat purchase behavior across the base
  • Geographic Diversity: Seven countries analyzed with United Kingdom dominating at $110,215 revenue (90.4% of total)

Interpretation

The customer base demonstrates healthy engagement patterns with 88.1% retention and predominantly high-frequency purchasing behavior (95

IN

Key Insights

Executive Summary

EXECUTIVE SUMMARY: RFM CUSTOMER SEGMENTATION ANALYSIS

Purpose

This analysis segments 950 customers into five behavioral groups using Recency, Frequency, and Monetary (RFM) metrics to identify high-value customers and optimize marketing resource allocation. Understanding customer value distribution is critical for maximizing lifetime value and retention efficiency.

Key Findings

  • Champions Segment: 396 customers (41.7% of base) generating $211.53 per customer—representing the highest-value behavioral tier requiring VIP-level engagement
  • Revenue Concentration: Top 20% of customers drive only 40.2% of total revenue, indicating relatively distributed value across the customer base rather than extreme concentration
  • Loyal Customers: 216 customers (22.7%) with $96.72 average value—stable, retention-focused segment
  • At-Risk & Lost Customers: Zero customers in both categories, suggesting either excellent current retention or data collection limitations
  • One-Time Buyers: Only 11 customers (1.2%), indicating strong repeat purchase behavior across the base
  • Geographic Diversity: Seven countries analyzed with United Kingdom dominating at $110,215 revenue (90.4% of total)

Interpretation

The customer base demonstrates healthy engagement patterns with 88.1% retention and predominantly high-frequency purchasing behavior (95

Segment Profile - THE KEY INSIGHT

Complete characteristics showing who they are, how valuable they are, and what to do

SP

Segment Profile

Complete Characteristics - THE KEY INSIGHT

5
Total Customers

Complete segment characteristics showing who they are, how valuable they are, and what to do with them

segment customer_count pct_total avg_recency_days avg_frequency avg_monetary total_revenue revenue_per_customer recommended_action priority
Champions 396.000 41.700 0.000 85.300 211.530 83766.040 211.530 VIP program, exclusive offers, early access HIGH
Loyal Customers 216.000 22.700 0.000 29.100 96.720 20891.500 96.720 Retention program, loyalty rewards MEDIUM
Potential Loyalists 225.000 23.700 0.000 21.600 59.890 13474.630 59.890 Upsell campaigns, personalized offers LOW
Promising 61.000 6.400 0.000 15.600 40.680 2481.330 40.680 Engagement campaigns, product recommendations LOW
New Customers 52.000 5.500 0.000 5.000 24.290 1262.880 24.290 Onboarding program, welcome series LOW
950
total customers
5
unique segments
total customers: 950
unique segments: 5
champions revenue per customer: 212
IN

Key Insights

Segment Profile

Purpose

This section profiles five distinct customer segments based on RFM (Recency, Frequency, Monetary) analysis, revealing how customers cluster by value and engagement patterns. Understanding segment composition is essential for allocating marketing resources efficiently and tailoring strategies to customer lifecycle stage.

Key Findings

  • Champions Dominance: 396 customers (41.7%) generate $83.8K revenue at $211.53 per customer—nearly 3x the overall average of $128.29, representing 68.7% of total revenue
  • Frequency Concentration: Champions average 85.3 transactions versus 5 for New Customers, showing extreme behavioral polarization across segments
  • Segment Size Distribution: Five segments range from 52 to 396 customers, with top two segments (Champions + Loyal) comprising 64.4% of the base but generating 85.8% of revenue
  • Value Gradient: Revenue per customer decreases consistently from Champions ($211.53) through New Customers ($24.29), indicating clear value stratification

Interpretation

The customer base exhibits highly skewed value distribution—a small proportion of engaged, frequent buyers drives disproportionate revenue. The 41.7% Champions segment represents the core business engine, while the remaining 58.3% spans varying maturity stages from established Loyal Customers to newly acquired prospects

IN

Key Insights

Segment Profile

Purpose

This section profiles five distinct customer segments based on RFM (Recency, Frequency, Monetary) analysis, revealing how customers cluster by value and engagement patterns. Understanding segment composition is essential for allocating marketing resources efficiently and tailoring strategies to customer lifecycle stage.

Key Findings

  • Champions Dominance: 396 customers (41.7%) generate $83.8K revenue at $211.53 per customer—nearly 3x the overall average of $128.29, representing 68.7% of total revenue
  • Frequency Concentration: Champions average 85.3 transactions versus 5 for New Customers, showing extreme behavioral polarization across segments
  • Segment Size Distribution: Five segments range from 52 to 396 customers, with top two segments (Champions + Loyal) comprising 64.4% of the base but generating 85.8% of revenue
  • Value Gradient: Revenue per customer decreases consistently from Champions ($211.53) through New Customers ($24.29), indicating clear value stratification

Interpretation

The customer base exhibits highly skewed value distribution—a small proportion of engaged, frequent buyers drives disproportionate revenue. The 41.7% Champions segment represents the core business engine, while the remaining 58.3% spans varying maturity stages from established Loyal Customers to newly acquired prospects

Segment Treemap - VISUAL IMPACT

Visual comparison of segment size (customer count) vs value (revenue per customer)

TM

Segment Treemap

Size vs Value Comparison

Visual comparison of segment size (customer count) vs segment value (revenue per customer)

Visual Impact
Size vs Value
IN

Key Insights

Segment Treemap

Purpose

This section visualizes the relationship between segment size and profitability, revealing which customer groups represent the largest populations versus which generate the most value per customer. This dual perspective is critical for resource allocation decisions—understanding whether to focus on scaling volume or maximizing value extraction from existing customers.

Key Findings

  • Champions: 396 customers (41.7% of base) generating $211.53 per customer—the smallest segment by count but darkest by value intensity, representing 68.7% of total revenue
  • Loyal Customers: 216 customers (22.7%) with $96.72 per customer, contributing 17.1% of revenue
  • Potential Loyalists: 225 customers (23.7%)—largest segment by near-equal count to Loyal—but only $59.89 per customer, yielding 11.1% of revenue
  • Revenue Concentration Disparity: Top 41.7% of customers (Champions) capture 68.7% of revenue, while bottom 5.5% (New Customers) generate only 1%

Interpretation

The treemap reveals extreme value concentration: Champions are a compact, high-value segment despite representing less than half the customer base. Conversely, Potential Loyalists represent nearly equal customer volume to Loyal Customers but generate less than two-thirds the

IN

Key Insights

Segment Treemap

Purpose

This section visualizes the relationship between segment size and profitability, revealing which customer groups represent the largest populations versus which generate the most value per customer. This dual perspective is critical for resource allocation decisions—understanding whether to focus on scaling volume or maximizing value extraction from existing customers.

Key Findings

  • Champions: 396 customers (41.7% of base) generating $211.53 per customer—the smallest segment by count but darkest by value intensity, representing 68.7% of total revenue
  • Loyal Customers: 216 customers (22.7%) with $96.72 per customer, contributing 17.1% of revenue
  • Potential Loyalists: 225 customers (23.7%)—largest segment by near-equal count to Loyal—but only $59.89 per customer, yielding 11.1% of revenue
  • Revenue Concentration Disparity: Top 41.7% of customers (Champions) capture 68.7% of revenue, while bottom 5.5% (New Customers) generate only 1%

Interpretation

The treemap reveals extreme value concentration: Champions are a compact, high-value segment despite representing less than half the customer base. Conversely, Potential Loyalists represent nearly equal customer volume to Loyal Customers but generate less than two-thirds the

R×F Heatmap - BEHAVIORAL VALUE MAP

Average monetary value by recency and frequency score combinations

HM

R×F Heatmap

Average Monetary Value by Behavior

5
R×F Combinations

Average monetary value by recency and frequency score combinations - shows which behaviors drive revenue

5
rf combinations
R=5, F=5
highest value behavior
rf combinations: 5
highest value behavior: R=5, F=5
IN

Key Insights

R×F Heatmap

Purpose

This heatmap reveals the relationship between customer purchase behavior (recency and frequency) and spending value. It identifies which behavior patterns generate the highest revenue and highlights segments with different engagement trajectories—critical for understanding where value concentrates and where growth opportunities exist.

Key Findings

  • Highest Value Behavior (R=5, F=5): $187.17 average monetary value with 488 customers generating $91,337 total revenue—the dominant value driver
  • Frequency Gradient Effect: Average spending increases consistently with frequency score (from $23–$29 at F=1 to $187 at F=5), showing strong correlation between purchase repetition and customer value
  • Customer Distribution: High-frequency segments (F=4–5) contain 713 customers (75% of analyzed cohort) but represent concentrated value concentration
  • Recency Uniformity: All customers scored R=5 (perfect recency), indicating the entire analyzed base made recent purchases—no declining engagement risk visible in this snapshot

Interpretation

The data shows a clean, linear relationship between purchase frequency and monetary value. The absence of recency variation (all R=5) suggests this analysis captures a recent, active customer window where engagement decay hasn’t yet occurred. The concentration of revenue in the F=5 segment (51.4% of total) reflects the 80/

IN

Key Insights

R×F Heatmap

Purpose

This heatmap reveals the relationship between customer purchase behavior (recency and frequency) and spending value. It identifies which behavior patterns generate the highest revenue and highlights segments with different engagement trajectories—critical for understanding where value concentrates and where growth opportunities exist.

Key Findings

  • Highest Value Behavior (R=5, F=5): $187.17 average monetary value with 488 customers generating $91,337 total revenue—the dominant value driver
  • Frequency Gradient Effect: Average spending increases consistently with frequency score (from $23–$29 at F=1 to $187 at F=5), showing strong correlation between purchase repetition and customer value
  • Customer Distribution: High-frequency segments (F=4–5) contain 713 customers (75% of analyzed cohort) but represent concentrated value concentration
  • Recency Uniformity: All customers scored R=5 (perfect recency), indicating the entire analyzed base made recent purchases—no declining engagement risk visible in this snapshot

Interpretation

The data shows a clean, linear relationship between purchase frequency and monetary value. The absence of recency variation (all R=5) suggests this analysis captures a recent, active customer window where engagement decay hasn’t yet occurred. The concentration of revenue in the F=5 segment (51.4% of total) reflects the 80/

3D Customer Distribution - CLUSTER ANALYSIS

Customer distribution in 3D RFM space showing natural clusters and outliers

3D

3D Customer Distribution

Customers in RFM Space

950
Total Customers

Customer distribution in 3D RFM space showing natural clusters and outliers

950
total customers
5
unique segments
total customers: 950
unique segments: 5
IN

Key Insights

3D Customer Distribution

Purpose

This 3D scatter plot maps all 950 customers across Recency, Frequency, and Monetary dimensions to reveal natural clustering patterns and segment separation. It visualizes whether RFM-based segments are truly distinct in behavioral space and identifies outlier customers with extreme value profiles—critical for validating segmentation quality and spotting high-value anomalies.

Key Findings

  • Recency Uniformity: All customers show recency = 0 days (standard deviation = 0), meaning the analysis captures a single snapshot with no temporal variation—all customers are equally “recent.”
  • Frequency Distribution: Ranges 1–130 orders (mean = 48.6, median = 32), showing right-skewed concentration with high variance (SD = 39.3), indicating most customers cluster at lower frequencies with distinct high-frequency outliers.
  • Monetary Spread: Ranges $1.45–$271.84 (mean = $128.29, median = $106.55), similarly right-skewed with moderate variance, revealing concentration around mid-range spenders with whale customers at the tail.
  • Segment Dominance: Champions comprise 41.7% (396 customers), with 13 distinct RFM score combinations, suggesting moderate overlap between segments rather than clean separation.

Interpretation

The absence of rec

IN

Key Insights

3D Customer Distribution

Purpose

This 3D scatter plot maps all 950 customers across Recency, Frequency, and Monetary dimensions to reveal natural clustering patterns and segment separation. It visualizes whether RFM-based segments are truly distinct in behavioral space and identifies outlier customers with extreme value profiles—critical for validating segmentation quality and spotting high-value anomalies.

Key Findings

  • Recency Uniformity: All customers show recency = 0 days (standard deviation = 0), meaning the analysis captures a single snapshot with no temporal variation—all customers are equally “recent.”
  • Frequency Distribution: Ranges 1–130 orders (mean = 48.6, median = 32), showing right-skewed concentration with high variance (SD = 39.3), indicating most customers cluster at lower frequencies with distinct high-frequency outliers.
  • Monetary Spread: Ranges $1.45–$271.84 (mean = $128.29, median = $106.55), similarly right-skewed with moderate variance, revealing concentration around mid-range spenders with whale customers at the tail.
  • Segment Dominance: Champions comprise 41.7% (396 customers), with 13 distinct RFM score combinations, suggesting moderate overlap between segments rather than clean separation.

Interpretation

The absence of rec

Revenue Concentration - PARETO PRINCIPLE

Cumulative revenue curve showing which customer percentiles drive business value

PC

Revenue Concentration

Pareto Principle Validation

40.2
Top 20% Revenue Share

Cumulative revenue curve showing which customer percentiles drive business value (80/20 rule)

40.2
top 20 pct revenue
121876.38
total revenue
top 20 pct revenue: 40.2
total revenue: 121876
IN

Key Insights

Revenue Concentration

Purpose

This section measures revenue concentration—how evenly (or unevenly) revenue is distributed across your customer base. It reveals whether your business depends on a small group of high-value customers or benefits from broad-based purchasing. Understanding this distribution is critical for assessing customer loyalty, retention risk, and growth stability.

Key Findings

  • Top 20% Revenue Contribution: 40.2% - Below the classic 80/20 rule, indicating revenue is relatively dispersed rather than concentrated in elite customers
  • Top 10% Contribution: 21.2% - Champions alone drive only one-fifth of total revenue, suggesting limited dependency on a single segment
  • Revenue Distribution Pattern: Gradual curve (not steep) shows revenue spreads across multiple customer tiers; top 60% of customers generate 83.1% of revenue

Interpretation

The 40.2% figure indicates low concentration—your revenue base is healthier and less vulnerable than businesses where top 20% drive 60%+ of sales. However, this also suggests Champions and Loyal Customers (612 customers, 64.4% of base) are undermonetized relative to their frequency. The gradual cumulative curve reflects a broad customer foundation, but with untapped upsell potential in mid-tier segments.

Context

This analysis assumes all customers are equally active (rec

IN

Key Insights

Revenue Concentration

Purpose

This section measures revenue concentration—how evenly (or unevenly) revenue is distributed across your customer base. It reveals whether your business depends on a small group of high-value customers or benefits from broad-based purchasing. Understanding this distribution is critical for assessing customer loyalty, retention risk, and growth stability.

Key Findings

  • Top 20% Revenue Contribution: 40.2% - Below the classic 80/20 rule, indicating revenue is relatively dispersed rather than concentrated in elite customers
  • Top 10% Contribution: 21.2% - Champions alone drive only one-fifth of total revenue, suggesting limited dependency on a single segment
  • Revenue Distribution Pattern: Gradual curve (not steep) shows revenue spreads across multiple customer tiers; top 60% of customers generate 83.1% of revenue

Interpretation

The 40.2% figure indicates low concentration—your revenue base is healthier and less vulnerable than businesses where top 20% drive 60%+ of sales. However, this also suggests Champions and Loyal Customers (612 customers, 64.4% of base) are undermonetized relative to their frequency. The gradual cumulative curve reflects a broad customer foundation, but with untapped upsell potential in mid-tier segments.

Context

This analysis assumes all customers are equally active (rec

RFM Score Distributions - DIAGNOSTIC

Distribution of R, F, M scores to validate quintile binning

RD

RFM Score Distributions

Quintile Binning Validation

quintile
Scoring Method

Distribution of Recency, Frequency, and Monetary scores to validate quintile binning

quintile
scoring method
scoring method: quintile
IN

Key Insights

RFM Score Distributions

Purpose

This section validates the quintile binning methodology used to segment customers by Recency, Frequency, and Monetary value. Balanced distributions (approximately 20% per quintile) confirm that RFM thresholds are appropriately calibrated. Skewed distributions would indicate that bin boundaries need adjustment to ensure fair customer segmentation across all five tiers.

Key Findings

  • Recency Distribution: Severely skewed—100% of customers score 5 (most recent), 0% in scores 1-4. This indicates all customers have identical recency values (0 days), making recency non-discriminative for segmentation.
  • Frequency Distribution: Well-balanced across quintiles (1.2% to 51.4%), with score 5 capturing 51.4% of customers, indicating a right-skewed but functional distribution.
  • Monetary Distribution: Reasonably balanced (1.7% to 45.1%), with score 5 containing 45.1% of customers, showing natural concentration of high-value spenders.

Interpretation

The recency metric fails to differentiate customers because all transactions occurred on the same analysis date (2009-12-01), collapsing all recency scores to the maximum value. Frequency and monetary distributions are functional, though both show concentration in the highest quintile—reflecting genuine

IN

Key Insights

RFM Score Distributions

Purpose

This section validates the quintile binning methodology used to segment customers by Recency, Frequency, and Monetary value. Balanced distributions (approximately 20% per quintile) confirm that RFM thresholds are appropriately calibrated. Skewed distributions would indicate that bin boundaries need adjustment to ensure fair customer segmentation across all five tiers.

Key Findings

  • Recency Distribution: Severely skewed—100% of customers score 5 (most recent), 0% in scores 1-4. This indicates all customers have identical recency values (0 days), making recency non-discriminative for segmentation.
  • Frequency Distribution: Well-balanced across quintiles (1.2% to 51.4%), with score 5 capturing 51.4% of customers, indicating a right-skewed but functional distribution.
  • Monetary Distribution: Reasonably balanced (1.7% to 45.1%), with score 5 containing 45.1% of customers, showing natural concentration of high-value spenders.

Interpretation

The recency metric fails to differentiate customers because all transactions occurred on the same analysis date (2009-12-01), collapsing all recency scores to the maximum value. Frequency and monetary distributions are functional, though both show concentration in the highest quintile—reflecting genuine

Order Distribution - RETENTION PROBLEM

Customer count by order frequency - reveals one-time buyer problem magnitude

OD

Order Distribution

Customer Count by Order Frequency

11
One-Time Buyers %

Customer count by number of orders - reveals one-time buyer problem and identifies loyalists

11
one time buyers count
1.2
one time buyers pct
908
high frequency count
one time buyers count: 11
one time buyers pct: 1.2
high frequency count: 908
IN

Key Insights

Order Distribution

Purpose

This section quantifies customer retention health by examining the distribution of purchase frequency. It reveals the magnitude of the one-time buyer problem and identifies the size of the loyal customer base, directly indicating whether acquisition efforts convert to repeat purchases or leak through churn.

Key Findings

  • One-time Buyers: 11 customers (1.2%) - Exceptionally low rate signals strong retention mechanics are functioning effectively across the customer base
  • High-Frequency Loyalists: 908 customers (95.6%) with 10+ orders - Dominant segment representing the core revenue engine and primary protection target
  • Maximum Order Count: 130 transactions - Demonstrates extreme loyalty potential and validates the viability of VIP/champion programs
  • Distribution Skew: Right-skewed pattern (skew=0.84) shows most customers cluster at higher frequencies rather than concentrating at 1-2 orders

Interpretation

The 1.2% one-time buyer rate is substantially below typical e-commerce benchmarks (20-40%), indicating existing retention programs successfully convert initial purchases into repeat behavior. The concentration of 908 customers in the 10+ order range aligns with the RFM segmentation showing 396 Champions and 216 Loyal Customers. This healthy funnel progression—where customers advance beyond single transactions—validates that the business has established effective repeat-

IN

Key Insights

Order Distribution

Purpose

This section quantifies customer retention health by examining the distribution of purchase frequency. It reveals the magnitude of the one-time buyer problem and identifies the size of the loyal customer base, directly indicating whether acquisition efforts convert to repeat purchases or leak through churn.

Key Findings

  • One-time Buyers: 11 customers (1.2%) - Exceptionally low rate signals strong retention mechanics are functioning effectively across the customer base
  • High-Frequency Loyalists: 908 customers (95.6%) with 10+ orders - Dominant segment representing the core revenue engine and primary protection target
  • Maximum Order Count: 130 transactions - Demonstrates extreme loyalty potential and validates the viability of VIP/champion programs
  • Distribution Skew: Right-skewed pattern (skew=0.84) shows most customers cluster at higher frequencies rather than concentrating at 1-2 orders

Interpretation

The 1.2% one-time buyer rate is substantially below typical e-commerce benchmarks (20-40%), indicating existing retention programs successfully convert initial purchases into repeat behavior. The concentration of 908 customers in the 10+ order range aligns with the RFM segmentation showing 396 Champions and 216 Loyal Customers. This healthy funnel progression—where customers advance beyond single transactions—validates that the business has established effective repeat-

Marketing Action Matrix - ACTIONABILITY

Prioritized marketing recommendations with expected outcomes

MA

Marketing Action Matrix

Prioritized Recommendations

5
Action Priorities

Prioritized marketing recommendations for each segment with expected outcomes

segment priority recommended_action expected_outcome estimated_value_at_risk
Loyal Customers MEDIUM Retention program, loyalty rewards Maintain engagement, prevent churn 0.000
Potential Loyalists LOW Upsell campaigns, personalized offers Convert 40-50% to Loyal 0.000
Promising LOW Engagement campaigns, product recommendations Default outcome for other segments 0.000
New Customers LOW Onboarding program, welcome series Default outcome for other segments 0.000
Champions HIGH VIP program, exclusive offers, early access Retain 95%+ customers, increase spend 10-20% 0.000
HIGH Priority
MEDIUM Priority
LOW Priority
IN

Key Insights

Marketing Action Matrix

Purpose

This section maps each customer segment to prioritized marketing interventions based on their lifecycle stage and revenue contribution. It translates RFM segmentation into actionable strategies, enabling resource allocation toward high-impact retention and growth opportunities while minimizing churn risk across the customer base.

Key Findings

  • Priority Distribution: One HIGH priority segment (Champions), one MEDIUM (Loyal Customers), three LOW priority segments (Potential Loyalists, Promising, New Customers)
  • Champions Expected Outcome: 95%+ retention with 10-20% spend increase—the highest-value intervention target
  • Potential Loyalists Conversion Target: 40-50% conversion to Loyal status represents significant revenue growth opportunity
  • Value at Risk: All segments show $0 estimated value at risk, indicating no immediate churn threat across the portfolio
  • Segment Coverage: Five distinct strategies address the full customer lifecycle from acquisition through VIP retention

Interpretation

The marketing action framework reflects a tiered engagement model where Champions receive premium retention focus due to their 68.7% revenue contribution despite representing 41.7% of customers. Loyal Customers require maintenance-level investment to prevent erosion, while growth segments (Potential Loyalists, Promising, New Customers) receive lower-priority but conversion-focused campaigns. The absence of at-risk or lost segments suggests healthy

IN

Key Insights

Marketing Action Matrix

Purpose

This section maps each customer segment to prioritized marketing interventions based on their lifecycle stage and revenue contribution. It translates RFM segmentation into actionable strategies, enabling resource allocation toward high-impact retention and growth opportunities while minimizing churn risk across the customer base.

Key Findings

  • Priority Distribution: One HIGH priority segment (Champions), one MEDIUM (Loyal Customers), three LOW priority segments (Potential Loyalists, Promising, New Customers)
  • Champions Expected Outcome: 95%+ retention with 10-20% spend increase—the highest-value intervention target
  • Potential Loyalists Conversion Target: 40-50% conversion to Loyal status represents significant revenue growth opportunity
  • Value at Risk: All segments show $0 estimated value at risk, indicating no immediate churn threat across the portfolio
  • Segment Coverage: Five distinct strategies address the full customer lifecycle from acquisition through VIP retention

Interpretation

The marketing action framework reflects a tiered engagement model where Champions receive premium retention focus due to their 68.7% revenue contribution despite representing 41.7% of customers. Loyal Customers require maintenance-level investment to prevent erosion, while growth segments (Potential Loyalists, Promising, New Customers) receive lower-priority but conversion-focused campaigns. The absence of at-risk or lost segments suggests healthy

Geographic RFM Segmentation

Customer value distribution across countries

GEO

Geographic RFM

Customer Value by Country

7

RFM segment distribution and performance across geographic markets (top 20 countries)

country customer_count total_revenue avg_revenue_per_customer avg_recency_days avg_frequency champions_count at_risk_count
United Kingdom 836.000 110215.050 131.840 0.000 51.000 352.000 0.000
Germany 44.000 6117.320 139.030 0.000 44.000 44.000 0.000
EIRE 30.000 3254.700 108.490 0.000 30.000 0.000 0.000
France 20.000 1291.110 64.560 0.000 18.100 0.000 0.000
Australia 18.000 727.200 40.400 0.000 18.000 0.000 0.000
USA 1.000 141.000 141.000 0.000 1.000 0.000 0.000
Belgium 1.000 130.000 130.000 0.000 1.000 0.000 0.000
7
countries analyzed
110215
top country revenue
countries analyzed: 7
top country revenue: 110215
IN

Key Insights

Geographic RFM

Purpose

This section maps RFM performance across geographic markets to identify which regions drive customer value and engagement. It reveals market concentration, regional purchase behavior patterns, and opportunities for localized strategies—essential for understanding whether revenue is diversified or dependent on specific geographies.

Key Findings

  • United Kingdom Dominance: 836 customers generating $110,215 (90.4% of total revenue) with 352 Champions, indicating extreme geographic concentration
  • Germany’s High Per-Customer Value: 44 customers averaging $139.03 per customer—highest among all markets—with all 44 classified as Champions, suggesting premium engagement
  • Frequency Variation: UK customers average 51 transactions vs. France (18.1) and Australia (18), showing significant regional purchase behavior differences
  • No At-Risk Customers: Zero at-risk counts across all markets indicates strong overall retention, though this may reflect data limitations
  • Emerging Markets Underpenetrated: EIRE, France, Australia, USA, and Belgium combined represent only 70 customers despite geographic diversity

Interpretation

The analysis reveals extreme revenue concentration in the UK market, which accounts for nearly all revenue despite representing only 88% of the customer base. Germany demonstrates that smaller markets can deliver exceptional per-customer value through high engagement. The absence of at-risk customers across all geographies suggests either strong market

IN

Key Insights

Geographic RFM

Purpose

This section maps RFM performance across geographic markets to identify which regions drive customer value and engagement. It reveals market concentration, regional purchase behavior patterns, and opportunities for localized strategies—essential for understanding whether revenue is diversified or dependent on specific geographies.

Key Findings

  • United Kingdom Dominance: 836 customers generating $110,215 (90.4% of total revenue) with 352 Champions, indicating extreme geographic concentration
  • Germany’s High Per-Customer Value: 44 customers averaging $139.03 per customer—highest among all markets—with all 44 classified as Champions, suggesting premium engagement
  • Frequency Variation: UK customers average 51 transactions vs. France (18.1) and Australia (18), showing significant regional purchase behavior differences
  • No At-Risk Customers: Zero at-risk counts across all markets indicates strong overall retention, though this may reflect data limitations
  • Emerging Markets Underpenetrated: EIRE, France, Australia, USA, and Belgium combined represent only 70 customers despite geographic diversity

Interpretation

The analysis reveals extreme revenue concentration in the UK market, which accounts for nearly all revenue despite representing only 88% of the customer base. Germany demonstrates that smaller markets can deliver exceptional per-customer value through high engagement. The absence of at-risk customers across all geographies suggests either strong market

Customer Cohort Retention

Lifetime value trends by first purchase cohort

CHRT

Cohort Retention

Customer Cohort Performance

1

Customer acquisition cohorts by first purchase month - tracks retention evolution over time

cohort cohort_size still_active at_risk lost retention_rate
2009-12 950.000 837.000 0.000 0.000 88.100
1
cohorts tracked
cohorts tracked: 1
IN

Key Insights

Cohort Retention

Purpose

This section tracks customer retention by acquisition cohort to identify which customer groups remain engaged and valuable over time. With only one cohort analyzed (December 2009), this snapshot reveals the baseline retention health of the customer base and establishes a benchmark for measuring future cohort performance and the effectiveness of retention initiatives.

Key Findings

  • Cohort Size: 950 customers acquired in December 2009 - represents the entire analyzed customer base
  • Still Active: 837 customers (88.1%) - exceptionally high retention rate indicating strong product-market fit
  • At Risk: 0 customers - no customers currently flagged as at-risk based on RFM scoring
  • Lost Customers: 0 - complete absence of churned customers in the dataset
  • Retention Rate: 88.1% - well above the 50% benchmark for healthy retention

Interpretation

The 88.1% retention rate demonstrates robust customer engagement and satisfaction within this cohort. The absence of at-risk or lost segments aligns with the RFM analysis showing 41.7% Champions and 22.7% Loyal Customers—indicating the cohort contains predominantly high-value, repeat purchasers. This single-cohort snapshot reflects a snapshot analysis rather than longitudinal tracking, limiting visibility into seasonal patterns or acquisition quality trends across multiple periods.

Context

The

IN

Key Insights

Cohort Retention

Purpose

This section tracks customer retention by acquisition cohort to identify which customer groups remain engaged and valuable over time. With only one cohort analyzed (December 2009), this snapshot reveals the baseline retention health of the customer base and establishes a benchmark for measuring future cohort performance and the effectiveness of retention initiatives.

Key Findings

  • Cohort Size: 950 customers acquired in December 2009 - represents the entire analyzed customer base
  • Still Active: 837 customers (88.1%) - exceptionally high retention rate indicating strong product-market fit
  • At Risk: 0 customers - no customers currently flagged as at-risk based on RFM scoring
  • Lost Customers: 0 - complete absence of churned customers in the dataset
  • Retention Rate: 88.1% - well above the 50% benchmark for healthy retention

Interpretation

The 88.1% retention rate demonstrates robust customer engagement and satisfaction within this cohort. The absence of at-risk or lost segments aligns with the RFM analysis showing 41.7% Champions and 22.7% Loyal Customers—indicating the cohort contains predominantly high-value, repeat purchasers. This single-cohort snapshot reflects a snapshot analysis rather than longitudinal tracking, limiting visibility into seasonal patterns or acquisition quality trends across multiple periods.

Context

The

Job ID: test_demo__online_retail__transactions__rfm_analysis_20260216_092903
Secret Hash: 36f2d40ab80e