金骏眉茶叶消费客户分级评价数据

采集销售记录表中购买金骏眉茶叶的数据，通过客户在2025年1月1日距离2025年6月30日间隔的距离最近一次消费时间天数R天、客户在2025年1月1日至2025年6月30日之间消费频次F和客户在2025年1月1日至2025年6月30日之间消费金额M元， 采用 RFM 模型对客户进行价值评级，实现精准化运营，通过对购买金骏眉茶叶客户价值管理，满足不同价值客户的个性化需求。对A级客户，每个月进行一次回访维护，对B级客户，每个季度进行一次回访维护，对C级客户每半年进行一次回访维护，对D级客户每年进行一次回访维护。另外可以为本客户群体高度重叠企业提供不同价值类型的客户个性化服务的数据支持。对从销售记录表中采集到的数据进行脱敏、降噪、清洗、聚集、分析。2、数据加工：运用RFM模型结合客户在2025年1月1日距离2025年6月30日间隔的距离最近一次消费时间天数R天、客户在2025年1月1日至2025年6月30日之间消费频次F和客户在2025年1月1日至2025年6月30日之间消费金额M元的得分排名对客户进行一个综合排名，最终得出一个RFM总评分。a.提取出最近一次消费时间距离当前分析时间的天数R天、客户在2025年1月1日距离2025年6月30日之间消费频次F和客户在2025年1月1日距离2025年6月30日之间消费金额M元进行分类，最近一次消费时间间隔最短的客户排在最上面。按照从1-5评分，前20%的客户获得5分，接下来的20%用户获得4分,再下来20%的客户为3分，再下来20% 的客户为2分，最后20% 的客户为1分。 b.根据客户在2025年1月1日距离2025年6月30日消费频次F从高到底依次对用户进行分类，前20%的客户在用户活动频率的分数为5，以此类推。 C, 根据客户在2025年1月1日距离2025年6月30日消费金额M元，前20%的客户在消费金额的分数为5，以此类推。消费金额最少的20%客户则分数为1。 RFM得分=0.3*（R得分）+0.3*（F得分）+0.4*（M得分） 评分大于等于4分的为A级客户，大于等于3小于4的为B级客户，大于等于2小于3的为C 级客户，低于2的为D级客户。

We collect data on customers who purchased Jinjunmei black tea from the sales record table. We use three metrics: R, the number of days R between the customer’s most recent consumption date and June 30, 2025; F, the customer’s consumption frequency during the period from January 1, 2025 to June 30, 2025; and M, the customer’s total consumption amount (in yuan) during the same period, to conduct customer value grading via the RFM model, achieve precise operation, and manage the value of Jinjunmei black tea purchasers to meet personalized needs of customers with different value tiers. For Class A customers, conduct monthly return visits and maintenance; for Class B customers, conduct return visits once per quarter; for Class C customers, conduct return visits once every six months; and for Class D customers, conduct return visits once per year. Additionally, this dataset can provide data support for enterprises with highly overlapping customer groups to deliver personalized services for different value-type customers. We perform desensitization, denoising, cleaning, aggregation and analysis on the collected data from the sales record table.

2. Data Processing: Use the RFM model combined with the score rankings of R, F and M during the period from January 1, 2025 to June 30, 2025 to conduct a comprehensive ranking of customers, and finally derive the overall RFM score.
a. Extract R (days between most recent consumption date and June 30, 2025), F (consumption frequency) and M (consumption amount) for classification. Customers with the shortest interval between their most recent consumption date and June 30, 2025 are ranked highest. Assign scores from 1 to 5: the top 20% of customers receive 5 points, the next 20% receive 4 points, the subsequent 20% receive 3 points, the following 20% receive 2 points, and the last 20% receive 1 point.
b. Classify customers based on their consumption frequency F from January 1, 2025 to June 30, 2025 in descending order. The top 20% of customers are assigned 5 points for their activity frequency score, and so on for the remaining groups.
c. Classify customers based on their consumption amount M from January 1, 2025 to June 30, 2025. The top 20% of customers receive 5 points for their consumption amount score, while the bottom 20% receive 1 point.

The overall RFM score is calculated as: RFM Score = 0.3*(R Score) + 0.3*(F Score) + 0.4*(M Score). Customers with a score greater than or equal to 4 are classified as Class A, those with a score >= 3 and < 4 are Class B, those with a score >= 2 and < 3 are Class C, and those with a score below 2 are Class D.

搜集汇总

背景与挑战

背景概述

该数据集是金骏眉茶叶消费客户的分级评价数据，包含529条记录，基于RFM模型对客户进行价值评级（A、B、C、D级），用于精准化运营和客户维护。数据集来源于公共数据授权，更新频次按需，适用于农、林、牧、渔业的企业优化客户服务策略。