直播销售产品转化过程分析数据集

1、数据采集：从电商平台订单系统与直播中台获取一年内（2024年9月1日-2025年8月31日）酸辣粉直播的用户行为与交易数据，包括直播场次、产品类型、商品曝光量、商品点击量、加入购物车数量、下单数量、支付成功订单数等原始日志数据。
2、数据处理：1）按“日期”和“产品类型”对数据进行分组聚合；2）计算各产品在各直播场次中的“加购转化量”（加入购物车数量）与“支付转化量”（支付成功订单数）；3）基于支付转化量与加购转化量，计算“支付转化率”（支付转化量 / 加购转化量 × 100%）；4）识别各产品类别的转化瓶颈（如：加购高但支付低），生成结构化分析结果集。
3、数据应用：输出按日期与产品类型划分的转化路径数据，支持运营团队进行产品表现评估、转化漏斗诊断与营销策略优化。

1. Data Collection: User behavior and transaction data of spicy vermicelli livestream broadcasts over the one-year period from September 1, 2024 to August 31, 2025 were collected from e-commerce platform order systems and live streaming middleware platforms. The collected raw log data includes livestream sessions, product types, product impressions, product clicks, cart addition counts, order counts, and number of successfully paid orders, etc.
2. Data Processing: 1) Group and aggregate the data by "date" and "product type"; 2) Calculate the "cart addition conversion volume" (cart addition count) and "payment conversion volume" (number of successfully paid orders) of each product in each livestream session; 3) Calculate the "payment conversion rate" (payment conversion volume / cart addition conversion volume × 100%) based on the payment conversion volume and cart addition conversion volume; 4) Identify conversion bottlenecks for each product category (e.g., high cart addition but low payment) and generate structured analysis result datasets.
3. Data Application: Output conversion path data grouped by date and product type, to enable the operations team to conduct product performance evaluation, conversion funnel diagnosis and marketing strategy optimization.

搜集汇总

背景与挑战

背景概述

该数据集由贵州佳里佳农业发展有限公司在农业领域自行产生，聚焦于直播带货中酸辣粉产品的用户转化路径分析，包括加购和支付转化数据，用于优化选品、库存管理和营销策略。数据规模为14KB，每日更新，来源于2024年9月至2025年8月的电商平台和直播中台，通过计算转化率识别产品瓶颈，支持运营团队科学决策以提升销售效率。