沙特阿拉伯地区个人护理用品客户价值评价数据

通过收集和分析沙特阿拉伯客户对个人护理用品的消费相关数据，使用RFM客户价值模型，了解客户的购买力水平和消费偏好，对客户进行等级评级，实现精准化运营。通过对客户价值管理，满足不同价值客户的个性化需求。对于A等级客户可每月1至2次与之沟通，对于B等级客户可每季度1至2次与之客户沟通，对于C等级客户可每半年1至2次与之沟通。另外可以为沙特阿拉伯区域销售团队提供不同等级客户个性化服务的数据支持。上游原料商、包材厂、代工/物流可据各等级的需求节奏做配方与香型备料、SKU 组合与补货排程，降低成本和缺断供风险；下游经销商、零售与电商平台可按等级投放差异化权益、促销与客服脚本，提升复购与转化。同时输出可执行的客户清单与跟进建议，帮助上下游协同增效。1. 数据采集：采集沙特阿拉伯客户对个人护理用品的历史交易数据。其中，采集数据中"下单时间"为距离统计时间）最近的一次订单时间，"订单金额"指的是距离统计时间最近的这次订单金额，"历史购买总次数""历史购买总金额"指的是历史服务时间段内统计得出的购买次数和购买金额。
2. 数据处理：对采集到的订单金额（元，人民币）、历史订单总金额（元，人民币）等数据进行分类、合并、累加，便于分析使用，其中客户编号已进行脱敏转换处理。
3. 算法加工：
R评分：根据用户下单时间距离统计时间的天数（D）划分为5个等级：0≤D≤71为5分，71＜D≤131为4分，131＜D≤243为3分，243＜D≤443为2分，443<D为1分；
F评分：消费频率评分根据历史购买总次数（S），划分为5个等级：S≤2为1分，2＜S≤3为2分，3＜S≤5为3分，5＜S≤8为4分，8<S为5分；
M评分：根据历史购买总金额（Z，单位：元，人民币），划分为5个等级：0<Z≤7537为1分，7537＜Z≤19471为2分，19471＜Z≤47270为3分，47270＜Z≤88218为4分，88218<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 consumer behavior data of Saudi Arabian customers in the personal care product sector, adopting the RFM Customer Value Model to gain insights into customers' purchasing power and consumption preferences, perform hierarchical customer segmentation and rating, and enable precise operational management. Through customer value management, personalized needs of customers at different value tiers are addressed. For Class A customers, 1 to 2 communication touches per month are recommended; for Class B customers, 1 to 2 communication touches per quarter; and for Class C customers, 1 to 2 communication touches per half-year. In addition, the dataset can offer data support for personalized service delivery for different customer tiers to the regional sales teams in Saudi Arabia. Upstream raw material suppliers, packaging material manufacturers, OEM partners and logistics providers can formulate raw material recipes, prepare fragrance inventory, optimize SKU combinations and arrange restocking schedules based on the demand rhythm of each customer tier, thereby reducing costs and risks of supply shortages and disruptions; downstream distributors, retail merchants and e-commerce platforms can launch differentiated benefits, promotional campaigns and customer service scripts tailored to each customer tier to improve repurchase rates and conversion rates. Additionally, executable customer lists and follow-up suggestions are provided to facilitate collaborative efficiency improvements for upstream and downstream stakeholders.
1. Data Collection: Collect historical transaction data of Saudi Arabian customers in the personal care product sector. For the collected data, "order placement time" refers to the timestamp of the most recent order relative to the statistical cutoff time; "order amount" refers to the transaction amount of the most recent order relative to the statistical cutoff time; "total historical purchase times" and "total historical purchase amount" refer to the total number of purchases and total purchase amount calculated within the predefined historical service period.
2. Data Processing: Classify, merge and accumulate the collected data such as order amount (unit: CNY, Chinese Yuan) and total historical order amount (unit: CNY, Chinese Yuan) to facilitate subsequent analysis. Customer IDs have undergone desensitization conversion processing.
3. Algorithm Processing:
- R (Recency) Score: Divide the number of days (D) between the customer's order placement time and the statistical cutoff time into 5 tiers: 5 points for 0 ≤ D ≤ 71, 4 points for 71 < D ≤ 131, 3 points for 131 < D ≤ 243, 2 points for 243 < D ≤ 443, and 1 point for D > 443;
- F (Frequency) Score: The consumption frequency score is divided into 5 tiers based on the total number of historical purchases (S): 1 point for S ≤ 2, 2 points for 2 < S ≤ 3, 3 points for 3 < S ≤ 5, 4 points for 5 < S ≤ 8, and 5 points for S > 8;
- M (Monetary) Score: Divide the total historical purchase amount (Z, unit: CNY, Chinese Yuan) into 5 tiers: 1 point for 0 < Z ≤ 7537, 2 points for 7537 < Z ≤ 19471, 3 points for 19471 < Z ≤ 47270, 4 points for 47270 < Z ≤ 88218, and 5 points for Z > 88218;
- RFM Comprehensive Score (X) = 0.3*R + 0.4*F + 0.6*M; Customer tiers are divided into three levels: Class C for 0 ≤ X ≤ 3, Class B for 3 < X ≤ 6, and Class A for X > 6.

搜集汇总

背景与挑战

背景概述

该数据集包含501条沙特阿拉伯地区个人护理用品客户的消费数据，采用CSV格式并每月更新。它基于RFM客户价值模型，通过分析客户的下单时间、购买频率和总金额，将客户划分为A、B、C三个等级，旨在支持精准营销和上下游供应链的协同优化。