辽宁省陶瓷工艺品进货商层级数据

通过计算辽宁省区域内的不同进货商进货本公司陶瓷工艺品的进货明细信息，对不同的进货商按照RFM模型进行分层，通过对进货商进行分层管理，所有企业可在后期对不同层级的进货商采取不同的运营策略提供数据依据。1、数据采集：导出辽宁省区域内的不同进货商每月进货本公司陶瓷工艺品的进货明细。2、数据处理：以进货商编号作为唯一标识，对数据进行清洗、去除无效数据和极限数据等操作。3、数据加工：通过LOOKUP函数计算出进货商最近一次进货距离当月月底的天数R，COUNTIF函数计算该月份进货次数F，SUMIF函数计算该月份进货总金额M，R的定档值通过以下计算，进货商最近一次进货距离当月月底的天数高于或者等于当月进货平均天数则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 ceramic crafts from our company by various distributors in the Liaoning Province region. It stratifies different distributors using the RFM model, providing a data foundation for enterprises to formulate differentiated operational strategies for distributors at different tiers in the later stage. 1. Data Collection: Export the monthly purchase details of ceramic crafts from our company by distributors operating in Liaoning Province. 2. Data Cleaning: Take the distributor ID as the unique identifier, and conduct data cleaning operations including removing invalid data and outlier data. 3. Data Processing and Stratification: Calculate the number of days R from a distributor's last purchase to the end of the current month via the LOOKUP function, the number of purchases F in the current month via the COUNTIF function, and the total purchase amount M in the current month via the SUMIF function. The tier value of R is determined as follows: if the number of days from the last purchase to the end of the current month is greater than or equal to the average value of such days for all distributors in the current month, the tier value of R is 1; otherwise, it is 0. The tier values for F and M are calculated similarly by comparing the number of purchases and total purchase amount with their respective averages. Finally, distributors are stratified into 8 tiers according to the RFM model stratification 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 Re-engagement Customers (RFM=000). 4. Data Application: By implementing stratified management of distributors, enterprises can customize distinct operational strategies for distributors at different tiers.

搜集汇总

数据集介绍

特点

该数据集为辽宁省陶瓷工艺品进货商层级数据，包含1511条记录，每月更新。通过RFM模型将进货商分为8个层级，为企业提供分层管理依据。