浙江地区瑜伽服类购买者分析数据

采集浙江地区瑜伽服类购买者的最近一次购买时间R（天数）和购买频率F（次数）、购买总金额M（元），采用RFM模型对购买者进行价值评级，用RFM分析方法把购买者分为ABCD四级，对细分过后的不同购买者采取相应营销策略，进行精准有效的运营。通过对购买者进行分级管理，满足不同等级购买者的个性化需求，并为同行业企业管理不同等级的购买者，实现精准个性化服务提供数据支持。1、数据处理：对浙江地区采集到的购买者数据进行脱敏、降噪、清洗、聚集、分析。2、数据加工：运用RFM模型结合最近一次购买时间R（天数）和购买频率F（次数）、购买总金额M（元）的得分排名对购买者进行一个综合排名，最终得出一个RFM总评分。a.提取出购买者最近一次购买时间R（天数）、购买频率F（次数）和购买总金额M（元）进行分类，运用IF+RANK函数将最近一次购买时间R（天数）时间间隔最短的购买者，按照1-5评分，前20%的购买者获得5分，接下来的20%购买者获得4分,再下来20%的购买者为3分，再下来20%的购买者为2分，最后20%的购买者为1分。b.根据购买者购买频率F（次数）从高到底依次对购买者进行分类，用IF+RANK函数将前20%的购买者在购买频率F（次数）的分数评为5分，以此类推。c.根据购买总金额M（元），运用IF+RANK函数将前20%的购买者在购买总金额M（元）的分数评为5分，以此类推。最少的20%购买分数为1。RFM得分=0.3*（R得分）+0.3*（F得分）+0.4*（M得分） 评分大于等于4分的为A级购买者，大于等于3分小于4分的为B级购买者，大于等于2分小于3分的为C级购买者，低于2分的为D级购买者。

This dataset collects the recency (R, in days) of the last purchase, purchase frequency (F, number of times), and total purchase amount (M, in yuan) of yoga apparel purchasers in the Zhejiang region. The RFM model is adopted to conduct value segmentation for purchasers, and the RFM analysis method is used to divide purchasers into four tiers: A, B, C and D. Corresponding marketing strategies are implemented for segmented purchasers to carry out precise and effective operations. This customer tier-based management not only meets the personalized demands of purchasers at different tiers, but also provides data support for enterprises in the same industry to manage purchasers by tiers and deliver precise personalized services.
1. Data Processing: Desensitize, denoise, clean, aggregate and analyze the collected purchaser data from the Zhejiang region.
2. Data Refinement: Use the RFM model combined with the score rankings of recency (R), purchase frequency (F) and total purchase amount (M) to perform a comprehensive ranking of purchasers, and finally derive an overall RFM score.
a. Extract the recency (R, in days), purchase frequency (F, number of times) and total purchase amount (M, in yuan) of purchasers for classification. Utilize the IF+RANK function to score purchasers based on the shortest interval of recent purchase (R) on a 1-5 scale: the top 20% of purchasers receive 5 points, the subsequent 20% get 4 points, the next 20% get 3 points, the following 20% get 2 points, and the last 20% get 1 point.
b. Classify purchasers in descending order of their purchase frequency (F, number of times). Employ the IF+RANK function to assign 5 points to the top 20% of purchasers for their purchase frequency, and follow the same ranking rule for the remaining tiers.
c. For the total purchase amount (M, in yuan), use the IF+RANK function to award 5 points to the top 20% of purchasers based on their total purchase amount, and so on. The bottom 20% of purchasers will get 1 point.
The overall RFM score is calculated as: RFM Score = 0.3 × (R Score) + 0.3 × (F Score) + 0.4 × (M Score)
Purchasers are categorized as follows:
- Level A: RFM score ≥ 4
- Level B: 3 ≤ RFM score < 4
- Level C: 2 ≤ RFM score < 3
- Level D: RFM score < 2

搜集汇总

背景与挑战

背景概述

该数据集聚焦浙江地区瑜伽服购买者，包含1030条记录，基于RFM模型分析购买行为（如时间、频率、金额），将购买者分为A/B/C/D四级以支持精准营销和个性化服务，每季度更新。