北京市茶叶客户分级评价数据

通过收集和分析各区域客户对茶叶消费相关数据，了解客户对茶叶的购买力水平和消费偏好，从而了解该产品是否畅销，从而为本行业的所有企业制定生产策略，更好地为用户提供个性化的商品和服务，对于A等级客户可每月1至2次与之沟通，对于B等级客户可每季度1至2次与之客户沟通，对于C等级客户可每半年1至2次与之沟通，从而制定更精准的生产营销策略。1.数据采集：采集各年各个客户对茶叶的相关交易数据。 2.数据处理：对采集到本次订单金额（元）、历史订单总金额（元）等数据进行分类、合并、累加，便于分析使用。 3.算法加工：R评分 根据用户下单时间距离统计时间的天数（D）划分为5个等级: 0≤D≤10为5分，10＜D≤20 为4分，20＜D≤30 为3分，30＜D≤50为2分，50<D 为1分； F消费频率评分根据历史购买总次数（S）,划分为5个等级: 0<S≤2为1分，2＜S≤5 为2分，5＜S≤10 为3分，10＜S≤15为4分，15< S为5分； M评分根据历史购买总金额 （Z）,划分为5个等级，0<Z≤500为1分，500＜Z≤1000 为2分，1000＜Z≤2000 为3分，2000＜Z≤3000为4分，3000< Z为5分；RFM综合评分（X）=0.3*R+0.4*F+0.6*M；会员等级分为ABC三级，0≤X≤3为C级，3＜X≤6为B级，6＜X 为A级

This dataset is constructed by collecting and analyzing tea consumption-related data of customers across various regions, aiming to gain insights into customers' tea purchasing power and consumption preferences, evaluate the market sales of tea products, and formulate production strategies for all enterprises in the tea industry to better deliver personalized products and services to users. For tier-A customers, engage in communication 1 to 2 times per month; for tier-B customers, conduct customer outreach 1 to 2 times per quarter; for tier-C customers, communicate with them 1 to 2 times every six months, so as to develop more precise production and marketing strategies.
1. Data Collection: Collect relevant transaction data for each customer's tea purchases across all years.
2. Data Processing: Classify, merge, and accumulate the collected data such as current order amount (yuan), total historical order amount (yuan), and other relevant metrics to facilitate subsequent analytical work.
3. Algorithm-Based Processing:
R-score (Recency): Divided into 5 levels based on the number of days (D) between the user's order time and the statistical time: 5 points for 0 ≤ D ≤ 10, 4 points for 10 < D ≤ 20, 3 points for 20 < D ≤ 30, 2 points for 30 < D ≤ 50, and 1 point for D > 50;
F-score (Frequency): Divided into 5 levels based on the total number of historical purchases (S): 1 point for 0 < S ≤ 2, 2 points for 2 < S ≤ 5, 3 points for 5 < S ≤ 10, 4 points for 10 < S ≤ 15, and 5 points for S > 15;
M-score (Monetary): Divided into 5 levels based on the total historical purchase amount (Z): 1 point for 0 < Z ≤ 500, 2 points for 500 < Z ≤ 1000, 3 points for 1000 < Z ≤ 2000, 4 points for 2000 < Z ≤ 3000, and 5 points for Z > 3000;
RFM composite score (X) = 0.3*R + 0.4*F + 0.6*M;
Member levels are divided into three tiers: A, B, and C, where Tier C corresponds to 0 ≤ X ≤ 3, Tier B to 3 < X ≤ 6, and Tier A to X > 6.

搜集汇总

背景与挑战

背景概述

该数据集是北京市茶叶客户的消费行为数据，基于RFM模型（最近购买时间、购买频率、购买金额）对客户进行分级评价，包含会员等级、订单金额等关键字段，每月更新，旨在帮助企业分析客户购买力和偏好，制定个性化营销策略。数据集规模超过616条，适用于茶叶行业的生产规划和客户关系管理。