扬州市茶叶客户分级评价数据

通过收集和分析各区域客户对茶叶消费相关数据，了解客户对茶叶的购买力水平和消费偏好，从而了解该产品是否畅销，从而为本行业的所有企业制定生产策略，更好地为用户提供个性化的商品和服务，对于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 developed by collecting and analyzing tea consumption-related data of customers across diverse regions, with core objectives including: understanding customers' tea purchasing power and consumption preferences, evaluating the market adoption of tea products, formulating evidence-based production strategies for tea industry enterprises, and delivering personalized goods and services to end users. To support precise production and marketing operations, targeted customer communication schedules are proposed: conduct 1 to 2 communications per month for Tier A customers, 1 to 2 communications per quarter for Tier B customers, and 1 to 2 communications every six months for Tier C customers.

The dataset construction workflow consists of three key stages:
1. Data Collection: Gather annual transaction data related to tea purchases from all registered customers.
2. Data Preprocessing: Classify, merge, and aggregate collected metrics including current order amount (yuan) and total historical order amount (yuan) to standardize data for subsequent analysis.
3. Algorithm-based Scoring and Tiering:
- R-score (Recency Score): Customers are categorized into 5 tiers based on the number of days (D) between their most recent order and the statistical cutoff 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 Score): Customers are categorized into 5 tiers based on their total historical purchase transactions (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 Score): Customers are categorized into 5 tiers based on their total historical purchase amount (Z, denominated in yuan): 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.
- The overall RFM composite score (X) is calculated using the formula: X = 0.3 * R + 0.4 * F + 0.6 * M.
- Customer membership tiers are divided into three levels: Tier C for 0 ≤ X ≤ 3, Tier B for 3 < X ≤ 6, and Tier A for X > 6.

搜集汇总

背景与挑战

背景概述

扬州市茶叶客户分级评价数据集包含746条客户交易记录，采用RFM模型对客户进行分级（A、B、C三级），用于分析客户购买力和消费偏好，支持企业制定精准的生产和营销策略。