济南市地区购买媒体投流客户价值评估数据

采集erp系统中济南市地区的数据，通过客户最近一次消费时间的天数R、消费频次F和消费金额M（元）， 采用 RFM 模型对客户进行价值评级，实现精准化运营。通过对济南市地区客户价值管理，满足不同价值客户的个性化需求。对A级客户，每个月进行一次回访维护；对B级客户，每个季度进行一次回访维护；对C级客户，每半年进行一次回访维护；对D级客户，每年进行一次回访维护。另外可以为本地区客户群体高度重叠企业提供不同价值类型的客户个性化服务的数据支持。
1、数据处理：对从erp系统中采集到的数据进行脱敏、降噪、清洗、聚集、分析。2、数据加工：运用RFM模型结合客户最近一次消费时间的天数R、消费频次F和消费金额M（元）的得分排名对客户进行一个综合排名，最终得出一个RFM综合分。3、规则评分：a.提取出距离最近一次消费时间的天数R、消费频次F和消费金额M进行分类，距离最近一次消费时间的天数R间隔最短的客户排在最上面。按照从1-5评分，前20%的客户获得5分，接下来的20%用户获得4分,再下来20%的客户为3分，再下来20%的客户为2分，最后20%的客户为1分。b.根据客户消费频次F从高到底依次对用户进行分类，前20%的客户在用户活动频率的分数为5，以此类推。C,根据客户消费金额M（元），前20%的客户在消费金额的分数为5，以此类推。消费金额最少的20%客户则分数为1。4、综合评分计算：RFM综合分=0.3*（R评分）+0.3*（F评分）+0.4*（M评分），评分大于等于4分的客户等级为A，大于等于3小于4的客户等级为B，大于等于2小于3的客户等级为C，低于2的客户等级为D。

This dataset collects data of Jinan City from ERP systems. It adopts the RFM model to conduct customer value rating based on three metrics: R (days since the customer's last consumption), F (consumption frequency) and M (consumption amount in RMB), to achieve precise operational management. Through customer value management in Jinan City, it meets the personalized demands of customers at different value levels. For Level A customers, follow-up maintenance is carried out once a month; for Level B customers, once every quarter; for Level C customers, once every six months; and for Level D customers, once a year. In addition, it can provide data support for personalized services targeting customers of different value types for enterprises with highly overlapping customer bases in this region.

1. Data Processing: Perform data desensitization, denoising, cleaning, aggregation and analysis on the data collected from the ERP system.
2. Data Processing & Enrichment: Conduct comprehensive customer ranking using the RFM model based on the score rankings of the three metrics R, F and M, and finally obtain the comprehensive RFM score.
3. Rule-based Scoring:
a. Extract the three metrics R, F and M for classification. Customers with the shortest interval since their last consumption are ranked first. Score from 1 to 5: the top 20% of customers get 5 points, the next 20% get 4 points, the subsequent 20% get 3 points, another 20% get 2 points, and the last 20% get 1 point.
b. Classify customers based on consumption frequency F in descending order: the top 20% get 5 points for consumption frequency, and so on.
c. Classify customers based on consumption amount M (in RMB): the top 20% get 5 points for consumption amount, and so on. The bottom 20% of customers with the lowest consumption amount get 1 point.
4. Comprehensive Score Calculation: The comprehensive RFM score = 0.3*(R score) + 0.3*(F score) + 0.4*(M score). Customer levels are divided as follows: Level A for scores ≥4, Level B for 3 ≤ score <4, Level C for 2 ≤ score <3, and Level D for score <2.

搜集汇总

背景与挑战

背景概述

该数据集包含801条记录，聚焦于济南市地区购买媒体投流客户的RFM价值评估，通过分析客户最近消费时间、频次和金额进行等级划分（A到D级），用于精准化运营和个性化服务支持，每半年更新一次。