云人访抖店品类构成数据

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

Ningbo Yunrenfang Tea Culture Co., Ltd. sells its products on the Douyin Shop platform. The platform allows exporting sales data of the past six months, but the data from Douyin Shop backend is relatively fine-grained, requiring manual further processing to obtain the desired product sales statistics. This dataset is developed by further processing the backend data from Douyin Shop, enabling the company to evaluate product sales performance from the perspective of product categories and assist in formulating sales strategies.

The sales amount of all products per month was calculated using a specific algorithm, since the Douyin Shop backend only provides daily detailed sales data.

The algorithms for each product indicator are as follows:
1. Total transaction amount: Sum of the transaction amount of each individual order within a month;
2. Average unit price per transaction: Sum of individual transaction prices / total transaction volume;
3. Product click-to-payment conversion rate: Sum of daily product conversion rates / total number of product conversion days.