当前位置:文档之家› 电商用户大数据分析与挖掘

电商用户大数据分析与挖掘


1%
0%
201309 201310 201311 201312 201401 201402 201403 201404
店铺年活跃客户数与回头客概览
年滚动回头客比例 5% 5% 4% 4% 3% 3% 2% 2% 1% 1% 0%
x万
14Leabharlann 年滚动活跃客户数12
10 8 6 4
整体客户数同销售额类似,呈现一定 的稳定增长态势; 相比而言,老客户的客单价高于新客 户。 但是目前的整体现状仍需改进。
2
0
201308 201309 201310 201311 201312 201401 201402 201403 201404
**备注:回头客比例=(一年购买2次及以上新客户+一年前购买过又来买的客户)/一年总客户数,如,201308指201209-201308
1.2.2 月趋势
从销售额的趋势来看,波动非常大,中间竟然出现几个月非常低的销售情况,如2013年的1、2、6、 7、8月份。需引起高度重视。 去年下半年以来整体情况还不错。
新老客户数占比
100% 90% 80% 70% 60%
从客户数可以明显的看出,老客 户的贡献人均贡献大于新客户的 人均贡献值。
50% 40% 30% 20% 10% 0%
老客户 新客户
2.1 客户属性 2.1.1 地域 2.1.2 地址—职业
2.2 客户消费行为 2.2.1 RFM 2.2.2 购物时间分析 2.2.3 商品分析
二、客户特征
2.1.1 地域
2.1.2 地址—职业
地址-职业回购情况:
2.2.1 RFM:F&M
新客户复购分析:R
新客户复购分析:首次客单价
首次客单价在100元以下的属于低价值客户,复购率低于4%右,占比总客户数的40%;
首次客单价在100~200元的属于中价值客户,复购率也低于4%,占比约为57%; 首次客单价大于200元的可以归类为高价值客户,复购率略高,占比约为3%;
电商用户数据分析与挖掘
说明
分析: 分析店铺的整体运营状况; 分析客户特征,从不同细分角度寻找不同客户之间的差异; • 客户属性特征分析 客户消费行为分析 • 目的: 为了卖家能更直观的了解自己店铺的运营现状; 了解客户特征,为客户维护和回购刺激提供决策依据; 提供个性化的实施建议;

剔除批发商:购买次数大于
50次
2015/12/3
3.如何实施? 2.客户特征表现? 1.整体现状?

个性化实施方案
客户属性特征 消费行为特征
购物体验 深入客户关系管理
2015/12/3
1.1 购物体验 DSR评分 1.2 深入客户关系管理 1.2.1 年滚动趋势 1.2.2 月滚动趋势
2.2.2 购物时间分析
地域—时点:
东北 辽宁省 吉林省 0 0.6% 0.4% 1 0.2% 0.1% 2 1.1% 1.3% 3 1.8% 2.5% 4 0.3% 0.4% 5 0.1% 0.1% 6 0.5% 0.3% 7 0.6% 0.6% 8 0.8% 0.7% 9 1.7% 1.3% 10 16.1% 11.8% 11 5.1% 3.9% 12 3.7% 3.2% 13 3.5% 2.9% 14 6.5% 7.4% 15 13.0% 16.8% 16 4.3% 4.0% 17 2.2% 1.6% 18 2.4% 2.3% 19 3.4% 3.0% 20 4.3% 3.3% 21 9.0% 10.0% 22 10.3% 11.5% 23 8.5% 10.5% 黑龙江省 0.3% 0.1% 1.3% 2.1% 0.5% 0.2% 0.6% 1.1% 0.9% 1.7% 13.5% 4.2% 3.3% 3.1% 7.8% 15.7% 4.1% 2.3% 3.0% 3.4% 3.4% 8.9% 10.0% 8.3% 北京 1.1% 0.6% 1.2% 1.6% 0.3% 0.1% 0.1% 0.6% 0.6% 1.7% 15.7% 5.1% 4.0% 4.0% 7.7% 12.3% 4.1% 3.3% 2.0% 2.8% 3.4% 8.2% 10.3% 9.3% 天津 0.6% 0.2% 1.5% 2.4% 0.6% 0.1% 0.2% 0.6% 0.4% 1.1% 12.1% 4.3% 3.1% 2.9% 7.9% 17.1% 4.4% 2.0% 1.8% 2.3% 2.5% 9.4% 12.3% 10.2% 华北 河北省 0.7% 0.4% 0.9% 1.5% 0.4% 0.1% 0.3% 1.0% 0.7% 1.5% 17.8% 6.1% 4.3% 4.4% 6.7% 12.0% 4.3% 2.7% 2.5% 3.5% 4.2% 7.9% 9.0% 7.3% 华东 山西省 内蒙古自治 上海 山东省 江苏省 安徽省 江西省 0.6% 1.0% 1.2% 0.7% 1.0% 0.8% 0.9% 0.2% 0.3% 0.4% 0.3% 0.3% 0.2% 0.3% 1.0% 0.3% 1.4% 0.7% 0.8% 1.0% 1.2% 1.6% 0.3% 1.5% 1.0% 0.6% 1.4% 1.6% 0.4% 0.2% 0.2% 0.3% 0.2% 0.2% 0.3% 0.1% 0.2% 0.1% 0.1% 0.2% 0.1% 0.2% 0.2% 0.4% 0.4% 0.4% 0.5% 0.2% 0.4% 0.7% 0.8% 0.6% 1.0% 0.9% 0.7% 0.8% 0.6% 0.7% 0.7% 0.9% 1.0% 0.6% 0.7% 1.4% 1.6% 1.1% 1.5% 1.7% 1.5% 1.3% 14.2% 17.5% 16.1% 22.2% 21.8% 19.3% 17.2% 5.1% 5.1% 5.1% 7.0% 6.5% 6.0% 6.0% 3.9% 4.2% 4.6% 4.2% 5.6% 5.6% 4.3% 3.8% 3.6% 4.5% 5.0% 4.8% 5.0% 4.4% 7.0% 8.9% 6.6% 6.3% 6.2% 6.5% 7.0% 14.8% 19.5% 12.4% 9.5% 8.7% 11.6% 11.6% 4.8% 5.9% 4.5% 5.0% 4.1% 4.5% 4.6% 3.1% 3.5% 2.6% 3.4% 3.1% 2.9% 3.1% 2.6% 2.9% 2.3% 2.7% 2.9% 2.4% 2.5% 2.8% 3.6% 3.3% 3.7% 4.0% 3.0% 3.2% 3.9% 4.7% 3.8% 4.6% 4.7% 4.0% 4.0% 8.9% 5.9% 8.2% 6.9% 7.4% 7.8% 8.1% 9.8% 5.4% 9.6% 7.2% 7.3% 7.9% 8.2% 8.6% 3.6% 8.9% 5.3% 5.5% 6.8% 8.0% 浙江省 0.9% 0.3% 0.7% 0.8% 0.2% 0.1% 0.5% 0.9% 0.8% 1.5% 22.7% 7.2% 6.2% 5.4% 6.3% 8.3% 4.2% 2.8% 2.8% 4.2% 5.0% 7.1% 6.3% 4.8% 福建省 1.5% 0.6% 1.3% 1.3% 0.3% 0.1% 0.2% 0.6% 0.7% 1.2% 17.0% 6.5% 4.7% 4.5% 6.6% 11.6% 4.6% 3.0% 2.4% 3.0% 4.1% 7.1% 9.2% 8.2% 湖北省 1.3% 0.3% 0.8% 1.2% 0.3% 0.1% 0.3% 0.6% 0.7% 1.4% 19.5% 6.9% 5.1% 4.8% 6.4% 9.1% 4.8% 3.3% 3.0% 3.5% 4.1% 7.4% 7.9% 7.1% 华中 湖南省 1.2% 0.5% 1.0% 1.2% 0.2% 0.1% 0.3% 0.5% 0.8% 1.3% 18.8% 7.5% 5.0% 5.2% 6.2% 10.8% 4.5% 3.2% 3.0% 3.4% 4.2% 7.4% 7.9% 6.1% 河南省 0.9% 0.2% 1.0% 1.0% 0.2% 0.0% 0.2% 0.7% 0.7% 1.5% 21.6% 7.3% 4.4% 5.1% 6.8% 9.6% 4.6% 3.7% 2.6% 3.0% 4.2% 7.2% 7.2% 6.2% 华南 西南 西北 广东省 广西壮族自 海南省 重庆 四川省 贵州省 云南省 西藏自治区 陕西省 甘肃省 宁夏回族自 新疆维吾尔 青海省 2.3% 1.8% 3.0% 1.0% 1.3% 2.0% 1.2% 0.1% 0.7% 1.3% 0.9% 4.8% 0.3% 0.8% 0.5% 1.4% 0.5% 0.4% 0.7% 0.4% 0.2% 0.3% 0.1% 0.4% 1.6% 0.2% 0.9% 1.8% 0.5% 1.5% 1.1% 0.7% 1.0% 0.5% 1.5% 0.3% 0.1% 0.3% 0.4% 0.8% 1.9% 0.0% 1.9% 1.1% 0.3% 1.5% 0.6% 1.6% 0.4% 0.5% 0.3% 0.5% 0.3% 0.5% 0.0% 0.3% 0.2% 0.2% 0.4% 0.4% 0.3% 0.2% 0.4% 0.2% 0.4% 0.1% 0.1% 0.0% 0.0% 0.1% 0.1% 0.0% 0.0% 0.1% 0.0% 0.0% 0.1% 0.0% 0.1% 0.1% 0.2% 0.2% 0.2% 0.2% 0.0% 0.1% 0.1% 0.1% 0.1% 0.0% 0.0% 0.6% 0.5% 0.7% 0.4% 0.5% 0.6% 0.4% 0.0% 0.4% 0.3% 0.4% 0.1% 0.0% 0.7% 0.5% 0.2% 0.4% 0.6% 0.5% 0.5% 0.1% 0.6% 0.3% 0.4% 0.3% 0.3% 1.3% 1.0% 1.1% 1.0% 1.4% 1.2% 1.3% 0.2% 1.5% 1.5% 1.0% 0.6% 0.3% 17.2% 12.9% 18.2% 13.1% 16.4% 15.1% 16.8% 1.8% 13.6% 14.7% 10.7% 17.6% 5.8% 7.6% 5.6% 9.1% 5.1% 7.1% 6.2% 6.6% 0.8% 6.1% 7.1% 5.3% 9.8% 2.4% 5.4% 3.7% 7.1% 3.9% 4.9% 5.1% 4.4% 1.0% 4.4% 3.8% 3.1% 8.2% 1.1% 5.3% 4.5% 5.2% 4.0% 5.4% 4.5% 4.5% 1.3% 4.0% 4.7% 2.8% 5.9% 1.8% 6.0% 6.6% 7.7% 6.6% 6.0% 9.3% 6.7% 18.2% 7.3% 9.5% 12.4% 5.5% 16.4% 9.2% 14.5% 9.1% 14.3% 9.6% 20.1% 14.1% 51.7% 13.5% 22.0% 34.7% 4.3% 42.9% 4.8% 4.7% 4.3% 4.1% 4.8% 5.7% 4.3% 6.8% 4.4% 6.1% 5.2% 5.0% 7.6% 3.8% 2.8% 4.3% 2.6% 3.6% 2.9% 3.1% 0.5% 3.2% 3.3% 1.7% 5.3% 1.5% 2.9% 2.1% 4.8% 2.4% 2.7% 2.2% 2.0% 0.6% 2.6% 2.6% 2.5% 4.9% 1.2% 3.2% 2.5% 2.1% 2.9% 3.6% 3.1% 2.1% 1.1% 3.3% 3.0% 1.8% 4.6% 1.6% 4.0% 2.8% 5.9% 3.5% 4.8% 4.0% 3.4% 0.7% 3.6% 3.3% 2.4% 4.0% 1.5% 6.8% 8.2% 5.7% 8.2% 8.1% 5.1% 7.3% 4.6% 8.7% 6.2% 4.3% 4.4% 4.5% 8.3% 10.2% 4.1% 11.6% 8.6% 5.9% 9.4% 4.4% 9.3% 5.2% 4.8% 5.6% 5.9% 7.5% 10.0% 5.2% 10.3% 7.5% 4.2% 8.9% 4.1% 8.8% 3.9% 4.0% 6.4% 3.6%
相关主题