Segment performance based on customer’s frequency and recency. Web Page RFM Customer Segmentation Dashboard

Desciption

Title: RFM Customer Segmentation Dashboard

Overall Summary:
This dashboard provides an overview of customer segmentation based on Recency, Frequency and Monetary (RFM) scores. It provides insights into the number of customers in each segment, total sales made across each segment, average recency, frequency and monetary scores, and segment performance based on customer’s frequency and recency.

Bullet Points:
Get an overview of customer segmentation based on RFM scores.
See the number of customers in each segment, total sales made across each segment, average recency, frequency and monetary scores.
Identify customers who are at risk, loyal, champions, potential loyalists, hibernating customers, about to sleep, new customers, and lost customers.
Segment performance based on customer’s frequency and recency.
Unique customers in each RFM segment.
Average Monetary.

Summary of Who Can Benefit:
This dashboard is perfect for businesses that want to gain insights into their customer segmentation and understand the performance of each segment. It can help businesses identify customers who are at risk, loyal, champions, potential loyalists, hibernating customers, about to sleep, new customers, and lost customers. It can also help businesses understand the number of customers in each segment, total sales made across each segment, average recency, frequency and monetary scores.

Who Can Benefit:
Businesses
Marketers
Sales teams
Customer service teams

Benefits:
Gain insights into customer segmentation
Identify customers who are at risk, loyal, champions, potential loyalists, hibernating customers, about to sleep, new customers, and lost customers.
Understand the number of customers in each segment, total sales made across each segment, average recency, frequency and monetary scores.

Data

RFM CUSTOMER
SEGMENTATION
HOW MANY CUSTOMERS IN EACH SEGMENT
POTENTIAL LOYALIST
AT RISK
CHAMPIONS
LOYAL
HIBERNATING CUSTOMERS
NEED ATTENTION
ABOUT TO SLEEP
NEW CUSTOMERS
LOST CUSTOMERS
PROMISING
CANNOT LOSE THEM 6
21
21
PROMISING
NEW CUSTOMERS
39
37
13,274
8,631
ABOUT TO SLEEP
LOST CUSTOMERS
3,548
CANNOT LOSE THEM 3,359
TOTAL SALES MADE ACROSS EACH RFM SEGMENT
CHAMPIONS
LOYAL
AT RISK
NEED ATTENTION
POTENTIAL LOYALIST
HIBERNATING CUSTOMERS
44,954
27,202
59.3
47.3
42.3
89
84
101
99
AVERAGE RECENCY (Days since last purchase)
LOST CUSTOMERS
CANNOT LOSE THEM
AT RISK
HIBERNATING CUSTOMERS
ABOUT TO SLEEP
LOYAL
NEED ATTENTION
NEW CUSTOMERS
115.1
114,679
94,706
88,074
157.5
149,986
174.8
184,803
1132
284.0
N. of Customers
693
TOTAL CUSTOMERS
CUSTOMERS PURCHASING ITEMS WITHIN A SPECIFIC PERIOD
Frequency
60
2
35
10-
100
NUMBER OF CUSTOMERS BY NUMBER OF ORDERS
75
87.37
AVG RECENCY
Why
Recency in days
117 112
95
81
300
10
12
SEGMENT PERFORMANCE BASED ON CUSTOMER’S FREQUENCY
AND RECENCY
1
17
2
R sco. F sc..
1
1
2
3
4
6.623
AVG FREQUENCY
5
3
4
1
2
3
4
5
1
2
3
5
1
2
3
5
1
2
3
UNIQUE CUSTOMERS IN EACH RFM SEGMENT
M score
3
1
11
3
6
6
16
3
1
10
6
7
4
5
6
5
2
9
2
1
1
8
2
1
7
9
11
4
2
7
11
3
2
6
6
10
3
3,013
AVG MONETARY
11
8
2
17
7
1
4
7
12
5
16
17
5
1
3
8
11
10
9
19
11
1
2
11
11
15
2
1
1
19
9
1
1
7
11
10
1
1
9
10
17