天猫平台胸牌商品优势型号识别数据

根据胸牌商品在天猫平台的销售情况，计算出基于固定方式特征（别针、磁性）和尺寸特征（大、小）的各种型号胸牌的销售占比，识别出优势型号，有助于本公司及同行业内其他生产、销售胸牌商品的企业制定、优化营销、仓储、物流和供应链方案。1.数据收集和预处理：（1）数据收集：收集公司在天猫平台上胸牌商品订单信息，包括商品类目、商品名称、销售渠道/平台、订单编号、购买数量、固定方式特征、尺寸特征。（2）数据预处理：对收集的原始数据进行清洗。
2.计算销售总量：利用SUM函数将历史采集的购买数量累加计算出胸牌商品销售总量。
3.基于图案特征识别优势型号：（1）筛选固定方式特征为卡别针的订单，利用SUM函数将购买数”累加计算出别针胸牌销售总量，并计算出销售占比=别针胸牌销售总量/胸牌商品销售总量*100%。同理，计算磁性胸牌销售总量及占比。（2）比较两种固定方式的销售占比，最大的为基于固定方式特征的优势型号。
4.基于尺寸特征识别优势型号：（1）筛选尺寸特征为大胸牌的订单，利用SUM函数将购买数量累加计算出大胸牌销售总量，并计算出销售占比=大胸牌销售总量/胸牌商品销售总量*100%。同理，计算小胸牌销售总量及占比。（2）比较两种尺寸特征的销售占比，较大的为基于尺寸特征的优势型号。

Based on the sales data of name badge products on the Tmall platform, this work calculates the sales proportion of various name badge models categorized by fixed features (pin, magnetic) and size features (large, small), and identifies the dominant models. This analysis can support enterprises including our company and other manufacturers and retailers of name badge products in the same industry to formulate and optimize their marketing, warehousing, logistics and supply chain solutions.

1. Data Collection and Preprocessing:
(1) Data Collection: Collect order information of name badge products on the Tmall platform, including product category, product name, sales channel/platform, order number, purchase quantity, fixed feature, and size feature.
(2) Data Preprocessing: Clean the collected raw data.

2. Calculation of Total Sales Volume: Use the "SUM function" to accumulate the historically collected purchase quantities to calculate the total sales volume of name badge products.

3. Identification of Dominant Models Based on Fixed Feature:
(1) Filter orders with pin as the fixed feature, use the "SUM function" to accumulate purchase quantities to calculate the total sales volume of pin name badges, and calculate the sales proportion = total sales volume of pin name badges / total sales volume of name badge products * 100%. Similarly, calculate the total sales volume and proportion of magnetic name badges.
(2) Compare the sales proportions of the two fixed features, and the one with the higher proportion is the dominant model based on the fixed feature.

4. Identification of Dominant Models Based on Size Feature:
(1) Filter orders for large name badges, use the "SUM function" to accumulate purchase quantities to calculate the total sales volume of large name badges, and calculate the sales proportion = total sales volume of large name badges / total sales volume of name badge products * 100%. Similarly, calculate the total sales volume and proportion of small name badges.
(2) Compare the sales proportions of the two size features, and the one with the higher proportion is the dominant model based on the size feature.

搜集汇总

数据集介绍

特点

该数据集聚焦于天猫平台胸牌商品的销售数据，通过分析固定方式和尺寸特征的销售占比，识别出优势型号，适用于企业优化营销和供应链策略。