护眼贴在拼多多平台上的优势型号识别数据
收藏资源简介：
根据护眼贴商品在拼多多平台的销售情况，计算出基于成分特征（叶黄素、花青素）的各种型号护眼贴的销售占比，识别出优势型号，有助于本公司及同行业内其他生产、销售护眼贴商品的企业制定、优化营销、仓储、物流和供应链方案。1.数据收集和预处理：（1）数据收集：收集公司在拼多多平台上护眼贴商品订单信息，包括商品类目、商品名称、统计时间、销售渠道/平台、订单编号、购买数量、成分特征。（2）数据预处理：对收集的原始数据进行清洗。 2.计算销售总量：利用SUM函数将历史采集的购买数量累加计算出护眼贴商品销售总量。 3.基于成分特征识别优势型号：（1）筛选成分特征为叶黄素的订单，利用SUM函数将购买数量累加计算出叶黄素护眼贴销售总量，并计算出销售占比=叶黄素护眼贴销售总量/护眼贴商品销售总量*100%。同理，计算花青素护眼贴销售总量及占比。（2）比较两种成分的销售占比，较大的为基于成分特征的优势型号。
Based on the sales data of eye protection patch products on the Pinduoduo platform, calculating the sales proportions of various eye protection patch models based on their ingredient characteristics (lutein, anthocyanidin) and identifying the dominant product models can help enterprises producing and selling eye protection patches, including our company and other peers, formulate and optimize their marketing, warehousing, logistics and supply chain solutions. 1. Data Collection and Preprocessing: (1) Data Collection: Collect the order information of the company’s eye protection patch products on the Pinduoduo platform, including product category, product name, statistical time, sales channel/platform, order number, purchase quantity, and ingredient characteristics. (2) Data Preprocessing: Clean the collected raw data. 2. Calculation of Total Sales Volume: Use the SUM function to sum up the historically collected purchase quantities and calculate the total sales volume of eye protection patch products. 3. Identification of Dominant Product Models Based on Ingredient Characteristics: (1) Filter the orders with lutein as the ingredient characteristic, use the SUM function to sum up their purchase quantities and calculate the total sales volume of lutein-based eye protection patches, then compute their sales proportion = (total sales volume of lutein-based eye protection patches / total sales volume of all eye protection patch products) * 100%. Similarly, calculate the total sales volume and sales proportion of anthocyanidin-based eye protection patches. (2) Compare the sales proportions of the two ingredient-based product models, and the one with the higher proportion is the dominant product model based on ingredient characteristics.
