Post by mdjuwel0203 on Nov 14, 2024 4:42:06 GMT
Step 1: Use the right indicators First, call up the customer's consumption records and select the time range you want to use. This article will use the following indicators and time frames as examples: Time frame: 2 years Recency: the number of days since the last consumption Frequency: number of orders Monetary: total consumption amount Step 2: Import data Import the company's customer data into Excel and delete irrelevant data. Take the following figure as an example. We only need to keep Days from last purchase, Orders, and Total Value. All other data can be deleted.
RFM operation: 5 major steps to establish bulk sms master RFM and easily complete focus marketing! Next, write Recency, Frequency, and Monetary in the first column respectively, for a total of three fields. To facilitate sorting, filter functions are added to all fields. Finally, Excel should look like this: RFM operation: 5 major steps to establish RFM and easily complete focus marketing! Step 3: Sort and score according to the Recency indicator Sort the Recency indicator. In this example, we sort " Days since last purchase " in descending order. RFM operation: 5 major steps to establish RFM and easily complete focus marketing! Here we group by percentage, with a perfect score of 4.
Divide the total number of customers by 4 and write a full score of 4 in the Recency field for the first 25% of customers who spent the most recent purchases, 3 for the next 25%, and so on up to 1 point. Therefore, it can be easily judged that a score of 3-4 is a customer with a relatively high score and a relatively valuable customer; a score of 1-2 is a customer with a relatively low score. In addition, since the RFM grouping is very flexible,.
RFM operation: 5 major steps to establish bulk sms master RFM and easily complete focus marketing! Next, write Recency, Frequency, and Monetary in the first column respectively, for a total of three fields. To facilitate sorting, filter functions are added to all fields. Finally, Excel should look like this: RFM operation: 5 major steps to establish RFM and easily complete focus marketing! Step 3: Sort and score according to the Recency indicator Sort the Recency indicator. In this example, we sort " Days since last purchase " in descending order. RFM operation: 5 major steps to establish RFM and easily complete focus marketing! Here we group by percentage, with a perfect score of 4.
Divide the total number of customers by 4 and write a full score of 4 in the Recency field for the first 25% of customers who spent the most recent purchases, 3 for the next 25%, and so on up to 1 point. Therefore, it can be easily judged that a score of 3-4 is a customer with a relatively high score and a relatively valuable customer; a score of 1-2 is a customer with a relatively low score. In addition, since the RFM grouping is very flexible,.