常用查询模板

最后更新: 2026-06-07

---

客户分析

RFM 客户分层查询

sql
SELECT * FROM ruimeiyun.v_customer_rfm
WHERE `客户分层` = '🏆 高价值VIP'
ORDER BY `M_总实付金额` DESC;

沉睡客户激活列表

sql
SELECT * FROM ruimeiyun.v_customer_wakeup
WHERE `储值余额` > 0
  AND `回访状态` IN ('严重超期(3月+)', '从未回访')
ORDER BY `消费总额` DESC;

流失预警客户

sql
SELECT * FROM ruimeiyun.v_churn_warning
WHERE `流失风险等级` LIKE '%严重流失%'
ORDER BY `消费总额` DESC;

---

业绩分析

本月各门店业绩

sql
SELECT * FROM ruimeiyun.v_monthly_performance
WHERE `业绩月份` = DATE_FORMAT(NOW(), '%Y-%m')
ORDER BY `结算业绩` DESC;

咨询师月度排名

sql
SELECT * FROM ruimeiyun.v_consultant_ranking;

每日简报

sql
SELECT * FROM ruimeiyun.v_daily_brief
ORDER BY `日期` DESC
LIMIT 7;

---

到院分析

本月到院统计

sql
SELECT * FROM ruimeiyun.v_visit_analysis
WHERE `到院月份` = DATE_FORMAT(NOW(), '%Y-%m')
ORDER BY `到院次数` DESC;

各来源渠道转化率

sql
SELECT * FROM ruimeiyun.v_source_funnel
ORDER BY `到院客户数` DESC;

---

产品分析

本月产品销量排行

sql
SELECT * FROM ruimeiyun.v_product_analysis
WHERE `销售月份` = DATE_FORMAT(NOW(), '%Y-%m')
ORDER BY `实收金额` DESC
LIMIT 20;

---

跨店分析

跨店流动客户

sql
SELECT * FROM ruimeiyun.v_customer_cross_flow
WHERE `客户业务类型` IN ('医美+生美交叉', '医美+美甲交叉')
ORDER BY `累计消费金额` DESC;

报备转化分析

sql
SELECT * FROM ruimeiyun.v_baobei_conversion
ORDER BY `报备客户数` DESC;