南宁市建筑材料试验检测机械设备客户分级评价数据

通过收集和分析南宁市客户对建筑材料试验检测机械设备消费相关数据，了解客户对建筑材料试验检测机械设备的购买力水平和消费偏好，从而了解该产品是否畅销，从而为本行业的所有企业制定生产策略，更好地为用户提供个性化的商品和服务，对于A等级客户可每月1至2次与之沟通，对于B等级客户可每季度1至2次与之客户沟通，对于C等级客户可每半年1至2次与之沟通，从而制定更精准的生产营销策略。1.数据采集：采集南宁市客户对建筑材料试验检测机械设备的相关交易数据。其中，采集数据中“下单时间”为距离统计时间最近的一次订单时间，“订单金额”指的是距离统计时间最近的这次订单金额，“历史购买总次数”“历史购买总金额”中的“历史”指的是2023年1月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≤100000为1分，100000＜Z≤200000为2分，200000＜Z≤300000为3分，300000＜Z≤500000为4分，500000<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 consumer data related to building material testing and inspection machinery and equipment from customers in Nanning City, aiming to understand customers' purchasing power and consumption preferences for such equipment, evaluate the market popularity of the products, and formulate production strategies for all enterprises in the industry to better provide personalized products and services. For targeted customer communication, communicate with Grade A customers 1 to 2 times per month, Grade B customers 1 to 2 times per quarter, and Grade C customers 1 to 2 times per half year, so as to develop more precise production and marketing strategies.

1. Data Collection: Collect relevant transaction data of building material testing and inspection machinery and equipment from customers in Nanning City. Specifically, the "order placement time" in the collected data refers to the time of the most recent order relative to the statistical time; the "order amount" refers to the amount of this most recent order. The term "historical" in "total historical purchase times" and "total historical purchase amount" refers to the period from January 1, 2023 to the statistical time, and the total number of purchases and total purchase amount during this period are counted.

2. Data Processing: Classify, merge and accumulate the collected data including the current order amount (CNY) and total historical order amount (CNY) to facilitate subsequent analysis.

3. Algorithm Processing:
- R Score (Recency Score): Divided into 5 levels based on the number of days (D) between the customer's order placement 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 Score): 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 Score): Divided into 5 levels based on the total historical purchase amount (Z): 1 point for 0 < Z ≤ 100000, 2 points for 100000 < Z ≤ 200000, 3 points for 200000 < Z ≤ 300000, 4 points for 300000 < Z ≤ 500000, and 5 points for Z > 500000.
- Comprehensive RFM Score (X) = 0.3*R + 0.4*F + 0.6*M. Customer membership levels are categorized into three grades: A, B and C, where Grade C corresponds to 0 ≤ X ≤ 3, Grade B corresponds to 3 < X ≤ 6, and Grade A corresponds to X > 6.

搜集汇总

背景与挑战

背景概述

该数据集包含585条南宁市建筑材料试验检测机械设备的客户交易数据，采用RFM模型（基于最近购买时间、频率和金额）对客户进行分级评价，分为A、B、C三个等级，用于分析客户购买力和偏好，支持企业制定个性化生产和营销策略。数据格式为Excel，更新频次按需，适用于制造业企业优化客户管理和决策。