新加坡地区气动自动化产品客户分级评价数据

通过收集和分析新加坡地区客户对气动自动化产品的采购消费相关数据，使用RFM客户价值模型，了解客户的购买力水平和消费偏好，对客户进行等级评级，实现精准化运营。通过对客户价值管理，满足不同价值客户的个性化需求。对于A等级客户可每月1至2次与之沟通，对于B等级客户可每季度1至2次与之沟通，对于C等级客户可每半年1至2次与之沟通。通过客户全生命周期价值管理，不仅满足不同等级客户的个性化需求，更深度挖掘客户在产业链中的协同价值。对于上游企业（原材料供应商、零部件制造商、物流服务商等），数据可提供需求预测支持，帮助其掌握气动产品市场的采购趋势、区域需求分布、产品品类偏好，从而优化生产计划、库存管理和资源配置；对于下游企业（设备集成商、工程总包商、终端用户、区域经销商等），数据可提供市场洞察和客户画像，帮助其了解目标客户的采购行为特征、价值等级分布、消费能力水平，为其产品定位、市场开拓、销售策略制定提供决策依据。1.数据采集：采集新加坡地区客户对气动自动化产品的相关交易数据。其中，采集数据中"订单日期"为距离统计时间（如样例中的2025年7月1日）最近的一次订单时间，"订单金额（美元）"指的是每次订单的交易金额，"历史购买总次数"和"历史购买总金额（美元）"指的是历史服务时间段内（2019年11月1日至统计日期）统计得出的购买次数和购买金额。 2. 数据处理：对采集到的订单金额（美元）、订单数量（件）、历史购买总金额（美元）等数据进行分类、合并、累加，便于分析使用，其中订单编号、客户编码已进行脱敏转换处理。 3. 算法加工：R评分：根据客户订单时间距离统计时间天数（D）划分为5个等级：0≤D≤150为5分，150＜D≤350为4分，350＜D≤600为3分，600＜D≤900为2分，D>900为1分；F评分：消费频率评分根据历史购买总次数（S）划分为5个等级：S≥5为5分，S=4为4分，S=3为3分，S=2为2分，S=1为1分；M评分：根据历史购买总金额（Z，单位：美元）划分为5个等级：Z>5000为5分，3500＜Z≤5000为4分，2500＜Z≤3500为3分，1500＜Z≤2500为2分，Z≤1500为1分；RFM综合评分（X）=0.3×R+0.4×F+0.6×M；会员等级分为ABC三级，X>6为A级，3＜X≤6为B级，X≤3为C级。

This dataset is developed by collecting and analyzing procurement and consumption data of pneumatic automation products from customers in Singapore, adopting the RFM customer value model to identify customers' purchasing power and consumption preferences, perform hierarchical rating, and realize precise operation. Through customer value management, personalized demands of customers with different value tiers are satisfied. Specifically, 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 every six months. By managing the full customer lifecycle value, we can not only meet the personalized needs of customers at different levels, but also deeply explore the collaborative value of customers in the industrial chain.

For upstream enterprises (including raw material suppliers, component manufacturers, logistics service providers, etc.), this dataset provides demand forecasting support, helping them grasp the procurement trends, regional demand distribution, and product category preferences of the pneumatic product market, so as to optimize production planning, inventory management and resource allocation. For downstream enterprises (including equipment integrators, general contractors, end users, regional distributors, etc.), this dataset offers market insights and customer portraits, assisting them in understanding the purchasing behavior characteristics, value grade distribution and consumption capacity of target customers, and providing decision-making basis for product positioning, market development and sales strategy formulation.

1. Data Collection: Collect relevant transaction data of pneumatic automation products from customers in Singapore. In the collected dataset, "order date" refers to the most recent order time prior to the statistical cutoff date (e.g., July 1, 2025 in the sample), "order amount (USD)" refers to the transaction amount of each individual order, and "total historical purchase times" and "total historical purchase amount (USD)" refer to the total purchase times and amount calculated within the historical service period (from November 1, 2019 to the statistical date).

2. Data Processing: Classify, merge and accumulate the collected data such as order amount (USD), order quantity (units), total historical purchase amount (USD) and other related data to facilitate subsequent analysis. Order numbers and customer codes have been processed via desensitization transformation.

3. Algorithm Processing:
- R Score: Divided into 5 levels based on the number of days (D) between the customer’s most recent order date and the statistical cutoff date: 5 points for 0≤D≤150, 4 points for 150<D≤350, 3 points for 350<D≤600, 2 points for 600<D≤900, 1 point for D>900;
- F Score: Divided into 5 levels based on total historical purchase times (S): 5 points for S≥5, 4 points for S=4, 3 points for S=3, 2 points for S=2, 1 point for S=1;
- M Score: Divided into 5 levels based on total historical purchase amount (Z, unit: USD): 5 points for Z>5000, 4 points for 3500<Z≤5000, 3 points for 2500<Z≤3500, 2 points for 1500<Z≤2500, 1 point for Z≤1500;
- RFM Composite Score (X) = 0.3×R + 0.4×F + 0.6×M;
- Membership levels are divided into three grades A, B and C: Grade A for X>6, Grade B for 3<X≤6, Grade C for X≤3.

搜集汇总

背景与挑战

背景概述

该数据集包含580条新加坡地区气动自动化产品客户的交易数据，采用RFM模型对客户进行A、B、C三级评价，每日更新，旨在通过分析采购行为实现精准运营和客户价值管理，支持上下游企业优化生产和市场决策。