安徽区域不同种类茶叶销售数据
收藏资源简介:
通过收集线上平台茶叶销售数据,可评估在安徽区域内不同种类茶叶销售情况,并通过消费者购买不同种类的茶叶判断茶叶销售比例,实现后续在该区域内更有针对性投入线上推广流量的产品,实现区域针对性产品销售;也为茶叶种植户种植菜叶品类提供决策依据。根据购买时间,取出对应时间数据,然后通过茶叶种类进行数据透视,绿茶比例=绿茶销售量/2024年4月-6月总量,黑茶比例=黑茶销售量/2024年4月-6月总量 ,红茶比例=红茶销售量/2024年4月-6月总量,乌龙茶比例=乌龙茶销售量/2024年4月-6月总量,白茶比例=白茶销售量/2024年4月-6月总量,黄茶比例=红黄销售量/2024年4月-6月总量,计算出区域内各品类茶叶销售量占比情况。
By collecting online tea sales data, this dataset aims to evaluate the sales status of various tea categories in the Anhui region, and determine the sales proportions of different tea types based on consumers' purchasing behaviors. The findings can help allocate targeted online promotion traffic for specific products in the region to boost targeted regional product sales, and provide decision-making references for tea farmers when selecting tea categories to plant. Specifically, we first extract data corresponding to the purchase time window, then conduct data pivoting based on tea categories. The sales proportion of each tea category is calculated as: Green Tea Proportion = Green Tea Sales Volume / Total Sales Volume (April–June 2024); Dark Tea Proportion = Dark Tea Sales Volume / Total Sales Volume (April–June 2024); Black Tea Proportion = Black Tea Sales Volume / Total Sales Volume (April–June 2024); Oolong Tea Proportion = Oolong Tea Sales Volume / Total Sales Volume (April–June 2024); White Tea Proportion = White Tea Sales Volume / Total Sales Volume (April–June 2024); Yellow Tea Proportion = Yellow Tea Sales Volume / Total Sales Volume (April–June 2024). Finally, the sales proportion of each tea category in the Anhui region is derived.




