新绍兴人满减消费券不同年龄段消费数据

通过采集新绍兴人满减消费券核销相关订单记录数据，统计分析各年龄段的消费券使用情况和核销情况等，得出不同年龄段的消费能力情况，优化后续消费券活动，提升后续消费券使用率、核销率等。消费券与文旅、教育、体育等商户平台建立常态化合作机制，根据每个年龄段消费指数，优化合作商户渠道，如针对年纪较大群体消费指数较低的问题，加大对社区菜场、医保定点药店等合作推广；针对年轻群体消费指数较高的情况，增加对时尚购物、休闲娱乐等领域的合作力度，精准投放优惠券，提升整体消费活跃度，进一步促进消费市场繁荣。1.数据采集：通过消费券活动平台，采集消费券发放，核销交易数据等信息，采集的用户名为平台统计的实名身份证信息，对隐私信息进行匿名化，根据身份证上的出生年月来统计归类年龄段用户；消费券相关订单金额统计为直接带动消费金额。
2.数据处理：对采集到的数据按人员年龄汇总分类，排列清洗，对各个年龄段的领取用户数、发放总额、核销用户数、核销总额、和直接带动消费总额等进行汇总。计算使用率=核销用户数/领取用户数；核销率=核销总额/发放总额；直接撬动杠杆率=直接带动消费总额/核销总额；每个年龄段的使用率和总使用率的比值=使用率/总使用率；
每个年龄段的核销率和总核销率的比值=核销率/总核销率；每个年龄段的杠杆率和总杠杆率的比值=直接撬动杠杆率/总直接撬动杠杆率；消费指数=每个年龄段的使用率和总使用率的比值*每个年龄段的核销率和总核销率的比值*每个年龄段的杠杆率和总杠杆率的比值。消费指数从大到小进行排名
3、数据应用：该数据将被用于进一步的决策分析和运营支持，帮助优化后续消费券活动配置，提升消费券核销率，促进经济发展。

This dataset is developed by collecting order records related to the redemption of full-reduction consumption vouchers for new Shaoxing citizens. Through statistical analysis of the usage and redemption status of consumption vouchers across different age groups, we derive the consumption capacity of each age group, so as to optimize subsequent consumption voucher campaigns and improve the usage rate and redemption rate of such vouchers.

The consumption voucher program has established a regular cooperation mechanism with merchant platforms covering culture and tourism, education, sports and other sectors. We will optimize the channels of cooperative merchants based on the consumption index of each age group. For example, in view of the relatively low consumption index of the elderly groups, we will increase cooperative promotion with community vegetable markets, designated medical insurance pharmacies and other merchants; for young groups with relatively high consumption indexes, we will strengthen cooperation in fields such as fashion shopping and leisure entertainment, accurately distribute vouchers, enhance overall consumption activity, and further promote the prosperity of the consumer market.

1. Data Collection:
Relevant information including the distribution and redemption transaction data of consumption vouchers is collected via the consumption voucher campaign platform. The usernames for statistical purposes are derived from the real-name ID card information provided by the platform, and privacy information is anonymized. Users are classified into age groups based on their date of birth on the ID card. The order amount associated with consumption vouchers is counted as the directly driven consumption amount.

2. Data Processing:
The collected data is summarized, classified, sorted and cleaned according to user age. We compile statistics for each age group including the number of voucher recipients, total issued voucher amount, number of redeemed users, total redeemed amount, and total directly driven consumption amount. The following indicators are calculated:
- Usage Rate = Number of Redeemed Users / Number of Voucher Recipients
- Redemption Rate = Total Redeemed Amount / Total Issued Voucher Amount
- Direct Leverage Ratio = Total Directly Driven Consumption Amount / Total Redeemed Amount
- Age Group Usage Ratio = Usage Rate of the Target Age Group / Overall Usage Rate
- Age Group Redemption Ratio = Redemption Rate of the Target Age Group / Overall Redemption Rate
- Age Group Leverage Ratio = Direct Leverage Ratio of the Target Age Group / Overall Direct Leverage Ratio
- Consumption Index = Age Group Usage Ratio × Age Group Redemption Ratio × Age Group Leverage Ratio
Finally, all age groups are ranked in descending order based on their consumption indexes.

3. Data Application:
This dataset will be used for further decision-making analysis and operational support, helping to optimize the configuration of subsequent consumption voucher campaigns, improve the redemption rate of consumption vouchers, and promote economic development.

搜集汇总

背景与挑战

背景概述

该数据集包含108,619条记录，聚焦于新绍兴人满减消费券的核销数据，通过匿名化处理身份证信息按年龄段分类用户，计算消费指数以分析不同年龄段的消费能力。数据用于优化消费券活动和商户合作，例如针对年轻群体增加时尚购物合作，提升整体消费活跃度，促进市场繁荣。