活动商家会员红包数据集
收藏资源简介:
核心是对红包的“发放-领取-核销”全生命周期进行追踪和归因分析。 红包发放规则: 由活动商家出资配置(如满50元减10元),并设定有效期。 通常在会员完成本次消费后,由系统自动发放,用于刺激下一次消费。 数据记录关键字段: 发放侧:商家ID、红包面额、使用门槛、有效期、成本承担方(商家全额或平台分摊)。 领取侧:会员ID、领取时间、触发领取的订单号。 核销侧:核销时间、核销订单号、订单金额、带来的GMV增量。 效果分析模型: 核销率 = 核销的红包数量 / 发放的红包数量。 红包ROI = (红包核销带来的增量GMV - 红包总成本) / 红包总成本。 会员复购周期分析:分析从领取红包到核销红包的平均时间,评估其对复购频率的提升效果。
This dataset focuses on tracking and conducting attribution analysis across the full lifecycle of red envelopes, including their issuance, collection, and redemption. Red Envelope Issuance Rules: Red envelopes are funded and configured by event merchants (e.g., 10 yuan off for purchases over 50 yuan), with a specified validity period. They are typically automatically issued by the system after a member completes their current consumption, to stimulate subsequent purchases. Key Data Record Fields: Issuance Side: Merchant ID, red envelope denomination, usage threshold, validity period, and cost bearer (fully borne by the merchant or shared by the platform). Collection Side: Member ID, collection timestamp, order number triggering the red envelope collection. Redemption Side: Redemption timestamp, redemption order number, order amount, and incremental GMV generated. Effect Analysis Models: Redemption Rate = Number of redeemed red envelopes / Number of issued red envelopes. Red Envelope ROI = (Incremental GMV brought by redeemed red envelopes - Total cost of red envelopes) / Total cost of red envelopes. Member Repurchase Cycle Analysis: Analyze the average time from red envelope collection to redemption, to evaluate its effect on improving repurchase frequency.




