拼多多平台易拉扣商品优势型号识别数据

根据易拉扣商品在拼多多平台的销售情况，计算出基于颜色特征（绿、蓝、粉、黑）和伸缩特征（可伸缩、不可伸缩）的各种型号易拉扣的销售占比，识别出优势型号，有助于本公司及同行业内其他生产、销售易拉扣商品的企业制定、优化营销、仓储、物流和供应链方案。1.数据收集和预处理：（1）数据收集：收集公司在拼多多平台上易拉扣商品订单信息，包括商品类目、商品名称、销售渠道/平台、订单编号、购买数量、颜色特征、伸缩特征。（2）数据预处理：对收集的原始数据进行清洗。 2.计算销售总量：利用SUM函数将历史采集的购买数量累加计算出易拉扣商品销售总量。 3.基于颜色特征识别优势型号：（1）筛选颜色特征为绿的订单，利用SUM函数将购买数”累加计算出绿易拉扣销售总量，并计算出销售占比=绿颜色易拉扣销售总量/易拉扣商品销售总量*100%。同理，计算蓝、粉、黑颜色易拉扣销售总量及占比。（2）比较四种颜色的销售占比，最大的为基于颜色特征的优势型号。 4.基于伸缩特征识别优势型号：（1）筛选伸缩特征为可伸缩的订单，利用SUM函数将购买数量累加计算出可伸缩易拉扣销售总量，并计算出销售占比=可伸缩易拉扣销售总量/易拉扣商品销售总量*100%。同理，计算不可伸缩易拉扣销售总量及占比。（2）比较两种伸缩特征的销售占比，较大的为基于伸缩特征的优势型号。Based on the sales data of retractable buckle products on the Pinduoduo platform, this dataset calculates the sales proportions of various retractable buckle models based on color features (green, blue, pink, black) and telescopic features (stretchable, non-stretchable), and identifies the dominant models. This will help our company and other enterprises in the same industry that produce and sell retractable buckle products to formulate and optimize marketing, warehousing, logistics and supply chain solutions. 1. Data Collection and Preprocessing: (1) Data Collection: Collect the order information of retractable buckle products on the Pinduoduo platform from our company, including product category, product name, sales channel/platform, order number, purchase quantity, color feature, and telescopic feature. (2) Data Preprocessing: Clean the collected raw data. 2. Calculate Total Sales Volume: Use the SUM function to accumulate the historically collected purchase quantities and calculate the total sales volume of retractable buckle products. 3. Identify Dominant Models Based on Color Features: (1) Filter the orders with green color feature, use the SUM function to accumulate the purchase quantities to calculate the total sales volume of green retractable buckles, and calculate the sales proportion = (total sales volume of green retractable buckles / total sales volume of all retractable buckle products) * 100%. Similarly, calculate the total sales volume and sales proportion of blue, pink and black retractable buckles. (2) Compare the sales proportions of the four colors, and the one with the largest proportion is the dominant model based on color features. 4. Identify Dominant Models Based on Telescopic Features: (1) Filter the orders with stretchable feature, use the SUM function to accumulate the purchase quantities to calculate the total sales volume of stretchable retractable buckles, and calculate the sales proportion = (total sales volume of stretchable retractable buckles / total sales volume of all retractable buckle products) * 100%. Similarly, calculate the total sales volume and sales proportion of non-stretchable retractable buckles. (2) Compare the sales proportions of the two telescopic features, and the one with the larger proportion is the dominant model based on telescopic features.

搜集汇总

数据集介绍

特点

该数据集包含拼多多平台易拉扣商品的销售数据，通过分析颜色和伸缩特征的销售占比识别优势型号，用于优化企业营销和供应链方案。数据集规模524条，每日更新，已区块链存证。