浙江省杭州市九洲大药房启智街店活跃度分级数据

通过分析九洲大药房启智街店的会员消费金额、消费次数、消费周期，从而确定会员分级，不仅可用于门店会员分类管理、个性化精准营销以及服务优化策略制定；也可用于针对与医药行业相关、对消费者行为模式与消费能力分析有需求的企业或机构，例如同类医药电商与零售企业、健康管理与咨询服务机构、医药研发与生产企业、金融机构与保险公司等。1.数据来源
采集了浙江省杭州市九洲大药房启智街店的会员、消费时间、消费金额等数据。
2.数据处理
基于采集数据，分析该店会员在统计周期（一年）内的消费金额（累计会员在统计周期内的总支出）、消费次数（统计会员的购买频率）、消费周期（分析会员消费的时间间隔，判断其活跃程度），根据上述参数确定五个会员等级：
核心会员：消费金额≥a1、消费次数≥b1，消费周期≤c1，对店铺贡献最大；
普通会员：a2≤消费金额<a1、b2≤消费次数<b1，c1<消费周期≤c2，保持一定频率和额度的消费，是稳定客户群。
轻度睡眠会员：a3≤消费金额<a2、b3≤消费次数<b2，c2<消费周期≤c3，消费频率有所下降，但仍偶有购买。
中度睡眠会员：a3≤消费金额<a2、b3≤消费次数<b2，c2<消费周期≤c3，消费间隔延长，消费次数明显减少。
深度睡眠会员：0≤消费金额<a3、消费次数<b3，c3<消费周期≤12，长时间未进行任何消费，几乎不活跃。
重度睡眠会员：消费金额0元、消费次数0次，消费周期>12，比深度睡眠会员更为不活跃，需要特别唤醒策略。
其中，消费金额值a1、a2、a3，消费次数值b1、b2、b3，消费周期值c1、c2、c3的具体数值为申请人企业机密。

A member tiering system is developed by analyzing the consumption amount, purchase frequency and consumption cycle of members at Jiuzhou Pharmacy Qizhi Street Store in Hangzhou, Zhejiang Province. This tiering system can not only support member classification management, personalized precision marketing and service optimization strategy formulation for the store, but also be applied to enterprises and institutions in the pharmaceutical industry that require analysis of consumer behavior patterns and consumption capabilities, including peer pharmaceutical e-commerce and retail enterprises, health management and consulting service institutions, pharmaceutical research and development and production enterprises, financial institutions and insurance companies, etc.

1. Data Source
Data including member information, consumption time and consumption amount were collected from Jiuzhou Pharmacy Qizhi Street Store in Hangzhou, Zhejiang Province.

2. Data Processing
Based on the collected data, we analyze the consumption amount (total cumulative expenditure of each member during the one-year statistical cycle), number of purchase transactions (i.e., member purchase frequency), and consumption cycle (i.e., time interval between member purchases to judge their activity level), and determine five member tiers based on the above parameters:
- Core Members: Those with consumption amount ≥ a1, number of purchase transactions ≥ b1, consumption cycle ≤ c1, who contribute the most to the store;
- Regular Members: Those with a2 ≤ consumption amount < a1, b2 ≤ number of purchase transactions < b1, c1 < consumption cycle ≤ c2, who maintain a certain consumption frequency and amount and are a stable customer group;
- Mildly Dormant Members: Those with a3 ≤ consumption amount < a2, b3 ≤ number of purchase transactions < b2, c2 < consumption cycle ≤ c3, who have decreased purchase frequency but still make occasional purchases;
- Moderately Dormant Members: Those with a3 ≤ consumption amount < a2, b3 ≤ number of purchase transactions < b2, c2 < consumption cycle ≤ c3, who have extended consumption intervals and significantly reduced purchase frequency;
- Deeply Dormant Members: Those with 0 ≤ consumption amount < a3, number of purchase transactions < b3, c3 < consumption cycle ≤ 12, who have not made any purchases for a long time and are almost inactive;
- Severely Dormant Members: Those with 0 consumption amount, 0 purchase transactions, consumption cycle > 12, who are even less active than deeply dormant members and require special reactivation strategies.
The specific values of a1, a2, a3 for consumption amount, b1, b2, b3 for number of purchase transactions, and c1, c2, c3 for consumption cycle are trade secrets of the applicant enterprise.

搜集汇总

背景与挑战

背景概述

该数据集包含九洲大药房启智街店的会员消费数据，共计94186条，用于分析会员消费金额、次数和周期以确定会员分级。应用场景包括会员分类管理、精准营销和服务优化，适用于医药行业及相关机构。