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

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

This dataset collects user consumption behavior data during breakfast hours, supporting refined customer relationship management (CRM). By applying the RFM model based on three metrics—Recency (R: time elapsed since the most recent consumption), Frequency (F: total number of consumption transactions within a specified period), and Monetary Value (M: total consumption amount within a specified period)—we can conduct customer value grading to identify high-value and core customers, and deliver personalized services (e.g., targeted marketing campaigns) for different customer segments to boost customer loyalty and improve service experience.

1. Data Collection: Gather breakfast-time user consumption data with fields including serial number, name, user ID, affiliated unit, dining canteen, consumption amount, transaction method, and other relevant items.

2. Data Processing: Clean, classify, and summarize the collected data, and perform anonymization for data entries where the affiliated unit is a driving school.

3. Data Enrichment and Tiered Management: Extract the three RFM metrics (R, F, M) from the raw dataset using Excel functions including COUNTIF, SUMIF, and VLOOKUP. Adopt the standardized RFM scoring framework to implement user tiered management, with specific scoring rules as follows:
- R score: 1 point for 0≤R<10, 2 points for 10≤R<20, 3 points for 20≤R<30, 4 points for 30≤R<40, 5 points for R≥40;
- F score: 1 point for 0≤F≤10, 2 points for 10<F≤20, 3 points for 20<F≤35, 4 points for 35<F≤50, 5 points for F>50;
- M score: 1 point for 0≤M≤50, 2 points for 50<M≤100, 3 points for 100<M≤150, 4 points for 150<M≤250, 5 points for M>250;
Calculate the comprehensive RFM score X for each user record. Tier customers 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: Utilize the RFM model to perform customer value rating, so as to distinguish high-value customers, core customers, and basic customers.

搜集汇总

数据集介绍

特点

该数据集通过RFM模型分析早餐消费群体的客户价值，包含消费时间、频次和金额等关键字段，用于客户分层和个性化服务。