题解 | SaaS平台企业客户新功能采纳度分析

with t as (
select team_id,team_name,
sum(if(date_format(usage_timestamp,'%Y-%m') = '2025-04' and feature_name = 'Advanced_Analytics',1,0)) as april_usage_count,
if(sum(if(date_format(usage_timestamp,'%Y-%m') = '2025-04' and feature_name = 'Advanced_Analytics',1,0)) > 50,'深度采纳团队','普通采纳团队') as adoption_category,
date_format(min(usage_timestamp),'%Y-%m-%d') as first_ever_usage_date
from teams
join feature_usage using(team_id)
where plan_level = 'Enterprise' 
group by team_id,team_name
order by adoption_category desc,april_usage_count desc, team_id asc)

select * from t 
where april_usage_count > 0