题解 | #日活与每日次日留存率#
日活与每日次日留存率
https://www.nowcoder.com/practice/18b168ada98d4bdb9108444443cea7d3
这样写还可以直接加上n日留存率
select
a.visit_date,
count(distinct a.id) as dau,
count(distinct if(datediff(b.visit_date,a.visit_date)=1,b.id,null))/count(distinct a.id) as next_day_per
from user_visit_log a
left join user_visit_log b on a.id=b.id and datediff(b.visit_date,a.visit_date) >0
group by a.visit_date;
阿里云成长空间 760人发布
