晚间无人零售智能货柜支付渠道分析数据

本数据对晚间智能货柜的消费者支付渠道进行分析，通过分析消费者对不同支付渠道的选择，得出使用各支付渠道的占比，体现无人零售智能货柜晚间的支付渠道分布情况，帮助各充实无人零售智能货柜的企业优化智能货柜在不同支付渠道的广告投放比重，指导各商家合理分配不同支付渠道特定时段的优惠方式及优惠力度。1、提取了saas平台中无人零售智能货柜22:00后发生售卖的订单号、机器号以支付渠道等数据，2、同一渠道购买商品金额，是通过SUMIFS函数对相同渠道购买商品金额的求和；3、购买商品总金额通过SUM函数将数据统计范围内金额求和；4、同一渠道购买商品金额占总金额占比=同一渠道购买商品金额/购买商品总金额*100%；5、占比排名按同一渠道购买商品金额占总金额占比从大到小进行排名；6、产品分类运用了ABC分类法，对占比40%以上的，则给予“A级渠道”的评价，如占比10%到39%区间的，则给予“B级渠道”的评价，如占比在9%的，则给予“C级渠道”的评价。

This dataset analyzes consumer payment channels for unmanned retail smart vending cabinets during evening hours. By examining consumers' choices of different payment channels, it calculates the usage proportion of each payment channel, reflecting the distribution of payment channels for such vending cabinets after 22:00. The findings can help enterprises operating unmanned retail smart vending cabinets optimize the proportion of advertising placement across different payment channels, and guide merchants to reasonably allocate preferential methods and intensities for specific time periods across various payment channels.
1. Relevant data including order numbers, machine IDs, payment channels and other transaction details of unmanned retail smart vending cabinets with completed sales transactions after 22:00 were extracted from the SaaS platform;
2. The total purchase amount for a single payment channel is calculated using the SUMIFS function to sum the purchase amounts of all transactions under the same channel;
3. The total purchase amount of all transactions within the statistical scope is summed via the SUM function;
4. The proportion of purchase amount from a single payment channel in the total purchase amount is calculated as (Single channel purchase amount / Total purchase amount) * 100%;
5. The ranking of payment channels is conducted in descending order based on their calculated proportion in the total purchase amount;
6. The ABC classification method is adopted for payment channel categorization: channels accounting for 40% or more of the total purchase amount are classified as "Level A Channel"; those with a proportion between 10% and 39% are classified as "Level B Channel"; and those with a proportion of 9% or less are classified as "Level C Channel".

搜集汇总

数据集介绍

特点

该数据集包含22571条晚间无人零售智能货柜的支付渠道数据，用于分析消费者支付渠道的选择和占比，帮助企业优化广告投放和优惠策略。数据来源于企业，按需更新，应用场景为无人零售智能货柜的支付渠道分析。