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

select 
    t.team_id,
    t.team_name,
    count(*) as april_usage_count,
    case when count(*) >50 then "深度采纳团队" else "普通采纳团队" end as adoption_category,
    t1.min_date as first_ever_usage_date
from
    teams t
join
    feature_usage f on t.team_id=f.team_id
join
    (
        select
            team_id,
            min(date(usage_timestamp)) as min_date
        from
            feature_usage
        group by
            team_id
    ) t1 on t1.team_id=t.team_id
where   
    t.plan_level='Enterprise' and f.        feature_name='Advanced_Analytics' and f.usage_timestamp>='2025-04-01' and f.usage_timestamp<'2025-05-01'
group by
    t.team_id,t.team_name
order by
    adoption_category desc,april_usage_count desc,t.team_id