宁波地区微商平台消费者分析数据
收藏资源简介:
通过采集分析线上销售平台中消费者的性别、年龄、地区,90天內的消费次数、浏览次数、搜索次数、关注商家、关注商品等关键信息,根据消费不同权重系数对消费者进行评分,可衡量消费者价值和创利能力,为电商平台提供精细化运营策略支持,提升用户活跃度和消费能力。1.数据采集:数据采集于浙里金消公众号,内容包括用户编号、姓名、性别、年龄、区/县、90天內的消费次数、浏览次数、搜索次数、关注商家、关注商品等。 2.数据处理:对采集到数据进行去重、合并、累加,以F、G、H列数据“消费次数(90天内)”、“浏览次数(90天内)”、“搜索次数(90天内)”建立线性组合模型,以权重重要程度设定WF=0.6,WG=0.3,WH=0.1,计算消费者总评分为T,T=0.6×F+0.3×G+0.1×H。 3.数据分析:根据消费者评分进行分级,大于0小于等于10的为D级客户,大于10小于等于20的为C级客户,大于20小于等于30的为B级客户,大于30小于等于40的为A级客户,大于40的为S级客户。 4.数据反馈:通过对客户的分级管理,为不同价值类型的客户个性化服务提供数据支持,进一步促进商户产品改进,提升消费者活跃度与消费能力。
This dataset collects and analyzes key consumer metrics from online sales platforms, including gender, age, region, 90-day consumption frequency, browsing frequency, search frequency, followed merchants and followed products. It scores consumers based on consumption-related weight coefficients, enabling evaluation of consumer value and profitability, and providing support for refined operation strategies of e-commerce platforms to boost user activity and consumption capacity. 1. Data Collection: Data is collected from the Zheli Jinxiao official WeChat account, covering user ID, name, gender, age, district/county, 90-day consumption frequency, 90-day browsing frequency, 90-day search frequency, followed merchants, followed products, etc. 2. Data Processing: Deduplication, merging and accumulation are conducted on the collected data. A linear combination model is established using the data of columns F, G and H, namely "90-day consumption frequency", "90-day browsing frequency" and "90-day search frequency". The weight coefficients are set as WF=0.6, WG=0.3 and WH=0.1 respectively, and the total consumer score T is calculated as T = 0.6×F + 0.3×G + 0.1×H. 3. Data Analysis: Consumers are graded by their scores: D-level customers for scores greater than 0 and ≤10, C-level customers for 10 < scores ≤20, B-level customers for 20 < scores ≤30, A-level customers for 30 < scores ≤40, and S-level customers for scores >40. 4. Data Feedback: Through tiered customer management, this dataset provides data support for personalized services targeting customers of different value tiers, further facilitating merchants' product improvements and enhancing consumer activity and consumption capacity.




