云人访抖店载体构成数据

宁波云人访茶文化有限公司将其商品在抖音“抖店”平台进行出售，抖店可以将其近半年的销售数据进行统计导出，但是由于抖店的数据较为细碎，需要人工进行进一步处理才能得到期望的商品销售数据。该数据为在抖店后台数据的基础上进行的进一步销售数据处理，用以公司评估门店销售情况，辅助销售策略的制定。利用抖店数据分析工具将宁波云人访茶文化有限公司在抖店商铺上的销售数额导出，由于抖店后台只有每日的具体数据，因此采用一定算法计算得到所有销售终端每月的销售情况。
具体的，销售终端各指标算法如下：
成交金额：当月商品成交金额之和，每日商品成交金额由抖店后台数据提供
成交订单数：当月成交订单数之和，每日订单数由抖店后台数据提供
成交人数：当月不重复成交人数之和，每日成交人数数据由抖店后台数据提供
商品点击次数：当月商品点击次数之和，每日商品点击次数数据由抖店后台数据提供
商品点击-支付转化率：交易次数/商品点击次数
平均成交客单价：成交金额/成交订单数

Ningbo Yunrenfang Tea Culture Co., Ltd. sells its products on Douyin's 'DianShop' platform. DianShop can export the sales statistics of the past six months, but the data from DianShop is quite fragmented, requiring manual further processing to obtain the desired product sales data. This dataset is generated through further processing of the sales data from the DianShop backend, which is used by the company to evaluate store sales performance and assist in formulating sales strategies.

The sales amount of Ningbo Yunrenfang Tea Culture Co., Ltd. on its DianShop store was exported using the DianShop data analysis tool. Since the DianShop backend only provides daily detailed data, certain algorithms were adopted to calculate the monthly sales performance of all sales terminals.

Specifically, the calculation algorithms for each indicator of the sales terminals are as follows:
1. Transaction Amount: Sum of the transaction amounts of all products in the current month; the daily product transaction amount is provided by the DianShop backend data.
2. Number of Transaction Orders: Sum of the number of transaction orders in the current month; the daily number of orders is provided by the DianShop backend data.
3. Number of Unique Transaction Customers: Sum of the count of unique transaction customers in the current month; the daily data of transaction customers is provided by the DianShop backend data.
4. Product Click Count: Sum of the product click counts in the current month; the daily product click count data is provided by the DianShop backend data.
5. Product Click-to-Payment Conversion Rate: Number of transactions / Product click count
6. Average Transaction Unit Price per Customer: Transaction Amount / Number of Transaction Orders

搜集汇总

数据集介绍

特点

该数据集记录了云人访茶文化在抖音抖店平台的销售数据，包括成交金额、订单数等关键指标，用于销售分析和策略制定，数据规模为233条，每月更新。