全国角加速度传感器进货商层级数据

通过计算全国区域内的不同进货商进货本公司角加速度传感器的进货明细信息，对不同的进货商按照RFM模型进行分层，通过对进货商进行分层管理，所有企业可在后期对不同层级的进货商采取不同的运营策略提供数据依据。1、数据采集：利用进货存管理系统（金蝶供应链云）导出全国区域内的不同进货商每月进货本公司角加速度传感器的进货明细。2、数据处理：以进货商编号作为唯一标识，对数据进行清洗、去除无效数据和极限数据等操作。3、数据加工：通过LOOKUP函数计算出进货商最近一次进货距离当月月底的天数R，COUNTIF函数计算该月份进货次数F，SUMIF函数计算该月份进货总金额M，进货商最近一次进货距离当月月底的天数大于或者等于当月进货平均天数则R的定档值为1，进货商最近一次进货距离当月月底的天数小于当月进货平均天数则R的定档值为0，同理也分别计算出F、M的定档值（分别用进货次数、进货总金额与各自的平均值相比较），再根据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 purchase details of the company's angular acceleration sensors from various regional buyers across the country, aiming to tier these buyers via the RFM model. Such tiered buyer management provides a data basis for enterprises to formulate differentiated operational strategies for buyers of different tiers in the future.
1. Data Collection: Export the monthly purchase records of the company's angular acceleration sensors from all regional buyers nationwide through the inventory and sales management system (Kingdee Supply Chain Cloud).
2. Data Processing: Take the buyer ID as the unique identifier, and clean the data by removing invalid and outlier records.
3. Data Enrichment & Calculation: Calculate the number of days R between a buyer's most recent purchase and the end of the current month using the LOOKUP function; calculate the number of purchases F in the current month using the COUNTIF function; calculate the total purchase amount M in the current month using the SUMIF function. Assign a tiered value of 1 to R if the number of days from the most recent purchase to the end of the current month is greater than or equal to the average purchase interval days in the current month, and assign a tiered value of 0 if it is less than the average purchase interval days. Similarly, calculate the tiered values for F and M by comparing the number of purchases and total purchase amount with their respective averages. Then classify buyers into 8 tiers according to the RFM model tiering rules: Important Value Customers (RFM=111), Important Retention Customers (RFM=101), Important Development Customers (RFM=011), Important Re-engagement Customers (RFM=001), General Value Customers (RFM=110), General Retention Customers (RFM=100), General Development Customers (RFM=010), and General Churned Customers (RFM=000).
4. Data Application: Tiered management of buyers provides a data foundation for enterprises to customize differentiated operational strategies for buyers of different tiers.

搜集汇总

数据集介绍

特点

该数据集包含全国角加速度传感器进货商的层级数据，采用RFM模型进行分层管理，每月更新，适用于企业制定不同层级的进货商运营策略。