本文介绍了一种使用SQL进行客户意向及沟通状态分析的方法，通过CASE WHEN语句对客户数据进行多维度统计，包括已沟通、未沟通、有意向、无意向、已签单和未签单的数量。
不说废话
SELECT case when c1.custom_principal is null then '统计' else c1.custom_principal end as '客服' ,count(*) as '总数量',
sum(CASE WHEN c1.custom_communicate='1' THEN 1 ELSE 0 END) as '已沟通' ,
sum(CASE WHEN c1.custom_communicate='0' THEN 1 ELSE 0 END) as '未沟通' ,
sum(CASE WHEN c1.custom_intention='0' THEN 1 ELSE 0 END) as '无意向' ,
sum(CASE WHEN c1.custom_intention='1' THEN 1 ELSE 0 END) as '有意向' ,
sum(CASE WHEN c1.custo_Signing='0' THEN 1 ELSE 0 END) as '未签单' ,
sum(CASE WHEN c1.custo_Signing='1' THEN 1 ELSE 0 END) as '已签单'
from custom c1 group by c1.custom_principal WITH ROLLUP
扫一扫
2003
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
