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

with t1 as
(
    select
    team_id,
    date(min(usage_timestamp)) as first_ever_usage_date
    from feature_usage
    group by 1
),
t2 as
(
    select
    team_id,
    team_name,
    count(*) as cnt
    from feature_usage fu
    left join teams t
    using(team_id)
    where plan_level = 'Enterprise'
    and feature_name = 'Advanced_Analytics'
    and usage_timestamp like '2025-04%'
    group by 1,2
)
select
team_id,
team_name,
cnt as april_usage_count,
case when cnt > 50 then '深度采纳团队' else '普通采纳团队' end as adoption_category,
first_ever_usage_date
from t1
inner join t2
using(team_id)
order by 4 desc, 3 desc, 1 asc