午餐消费群体RFM客户价值分析数据

采集用户在午餐时段消费行为数据，通过这些数据，能够执行精细化的客户关系管理。根据客户的最近一次消费时间间隔(R)、最近一段时间内消费频次(F)和最近一段时间内消费金额(M)，采用RFM模型对进行价值评级，从而识别出高价值客户和核心客户。针对不同价值类型的客户提供个性化服务，比如对不同群体采取对应的营销活动，以增强客户忠诚度和提升服务体验。1、数据采集：采集用户在午餐时段消费行为数据：序号、姓名、用户编号、单位、用餐食堂、消费金额、操作方式等字段；2、数据处理：对采集到的数据进行清洗、分类汇总，对驾校进行匿名化处理；3、数据加工：使用COUNTIF、SUMIF、VLOOKUP函数从原始数据中提取出最近一次消费时间（R）、最近一段时间消费频次(F)、最近一段时间消费金额(M)，根据RFM模型计分法对用户进行分层管理，RFM计分规则如下：10≤R<15为1分，15≤R<20 为2分，20≤R<30为3分，30≤R<40为4分，40<R 为5分；0≤F≤15为1分，15<F≤30 为2分，30<F≤50 为3分，50<F≤100 为4分，100<F为5分；0≤M≤100 为1分，100<M≤250 为2分，250<M≤500 为3分，500<M≤1000为 4分，1000<M 为5分；计算每条数据的RFM综合得分X，根据公司要求对客户进行分层，1≤X≤8为基础客户，8<X≤12 为核心客户，12<X 为高价值客户；；4、数据应用：采用RFM模型对进行价值评级，从而识别出高价值客户和核心客户、基础客户。

This dataset collects user consumption behavior data during lunch hours, enabling refined customer relationship management (CRM). By leveraging three metrics including Recency (R, the time interval since the user's last consumption), Frequency (F, the number of consumption occurrences within a specified period), and Monetary value (M, the total consumption amount within a specified period), the RFM model is adopted to conduct customer value rating, so as to identify high-value customers and core customers. Personalized services can be provided for customers of different value tiers, such as targeted marketing campaigns for distinct groups, to enhance customer loyalty and service experience.
1. Data Collection: Collect user consumption behavior data during lunch hours, with fields including serial number, name, user ID, affiliated work unit, dining canteen, consumption amount, transaction operation mode, etc.
2. Data Processing: Clean, classify and summarize the collected data, and perform anonymization processing on the driving school-related data.
3. Data Refinement: Extract the Recency (R), Frequency (F), and Monetary value (M) metrics from the raw data using functions including COUNTIF, SUMIF, and VLOOKUP. Conduct user tiered management based on the RFM model scoring method, with the specific rules as follows:
- 1 point for 10 ≤ R < 15; 2 points for 15 ≤ R < 20; 3 points for 20 ≤ R < 30; 4 points for 30 ≤ R < 40; 5 points for R ≥ 40
- 1 point for 0 ≤ F ≤ 15; 2 points for 15 < F ≤ 30; 3 points for 30 < F ≤ 50; 4 points for 50 < F ≤ 100; 5 points for F > 100
- 1 point for 0 ≤ M ≤ 100; 2 points for 100 < M ≤ 250; 3 points for 250 < M ≤ 500; 4 points for 500 < M ≤ 1000; 5 points for M > 1000
Calculate the comprehensive RFM score X for each record. Classify customers into tiers per company requirements: basic customers for 1 ≤ X ≤ 8, core customers for 8 < X ≤ 12, and high-value customers for X > 12.
4. Data Application: Conduct customer value rating using the RFM model to identify high-value customers, core customers, and basic customers.