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

SELECT t.team_id,team_name,COUNT(usage_id) as april_usage_count,
(CASE 
WHEN COUNT(usage_id) > 50 THEN '深度采纳团队'
ELSE '普通采纳团队'
end) as adoption_category,
date_format(c.first_date,'%Y-%m-%d') as first_ever_usage_date
FROM teams t
INNER JOIN feature_usage f
ON t.team_id = f.team_id
AND feature_name = 'Advanced_Analytics'
AND usage_timestamp between '2025-04-01' and '2025-04-30' 
INNER JOIN (
SELECT team_id,min(usage_timestamp) as first_date
FROM feature_usage
GROUP BY team_id) c 
ON t.team_id = c.team_id
WHERE plan_level = 'Enterprise'
GROUP BY t.team_id,team_name
ORDER BY adoption_category DESC,april_usage_count DESC,team_id;