常用查询模板
常用查询模板
> 最后更新: 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;
`