配送全国区域内的各个医院层级数据

通过计算本公司与全国区域内的不同医院的配送消费信息，对不同的医院按照RFM模型进行分层，本行业所有配送公司可对不同层级的医院采取不同的运营策略。其次，本数据还能为配送行业的相关医院如物流公司等提供整体性参考，从而有效洞察市场趋势，更好地做出科学的营销决策。1、数据采集：导出本公司与全国区域内的不同医院的配送消费信息。2、数据处理：以医院编号作为唯一标识，对数据进行清洗、去除无效数据和极限数据等操作。3、数据加工：通过LOOKUP函数计算出医院最近一次配送距离当月月底的天数，COUNTIF函数计算当月配送次数，SUMIF函数计算当月配送总金额，最近一次配送距离当月月底的天数大于或者等于当月平均配送间隔天数则R定档值为1，反之R定档值为0，当月配送次数大于或者等于当月平均配送次数则F定档值为1，反之F定档值为0，当月配送总金额大于或者等于当月配送平均金额则M定档值为1，反之M定档值为0，再根据RFM模型分层规则按RFM值将医院分为8个层级，即分为重要价值客户(RFM为111)、重要保持客户(RFM为101)、重要发展客户(RFM为011)、重要挽留客户(RFM为001)、一般价值客户(RFM为110)、一般保持客户(RFM为100)、一般发展客户(RFM为010)和一般挽留客户(RFM为000)。4、数据应用：通过对医院进行分层管理，所有医院可对不同层级的医院定制不同的运营策略。This dataset is developed based on the delivery and consumption records between our company and various hospitals across the nation, and applies the RFM model to tier hospitals. All delivery enterprises in the industry can adopt differentiated operational strategies for hospitals of different tiers. Additionally, this dataset can provide holistic references for relevant stakeholders in the delivery industry, such as logistics companies, to effectively gain insights into market trends and make more scientific marketing decisions. 1. Data Collection: Export the delivery and consumption information between our company and various hospitals nationwide. 2. Data Processing: Use hospital ID as the unique identifier to clean the dataset, removing invalid and outlier data. 3. Data Calculation and Tiering: Utilize the LOOKUP function to calculate the number of days between the last delivery and the end of the current month, the COUNTIF function to calculate the number of deliveries in the current month, and the SUMIF function to calculate the total delivery amount in the current month. Then, assign the R score as 1 if the number of days between the last delivery and the end of the current month is greater than or equal to the average delivery interval days of the current month, otherwise assign 0; assign the F score as 1 if the number of deliveries in the current month is greater than or equal to the average monthly number of deliveries, otherwise assign 0; assign the M score as 1 if the total delivery amount in the current month is greater than or equal to the average monthly delivery amount, otherwise assign 0. Subsequently, hospitals are divided into 8 tiers based on their RFM values according to the RFM model tiering rules: Important Value Customers (RFM="111"), Important Retention Customers (RFM="101"), Important Development Customers (RFM="011"), Important Win-back Customers (RFM="001"), General Value Customers (RFM="110"), General Retention Customers (RFM="100"), General Development Customers (RFM="010"), and General Abandoned Customers (RFM="000"). 4. Data Application: Through tiered management of hospitals, all delivery enterprises in the industry can customize differentiated operational strategies for hospitals of different tiers.

搜集汇总

数据集介绍

特点

该数据集记录了全国区域内各医院的配送信息，包括配送次数、金额、间隔天数等关键指标，并通过RFM模型对医院进行分层管理。数据每月更新，适用于配送公司和物流公司进行市场趋势分析和制定科学的营销策略。