每日新增用户的次日留存率
第一种办法，传统解法：
先去重，然后3个join
selectlog_day '日期',count(user_id_d0) '新增数量',count(user_id_d1) / count(user_id_d0) '次日留存率',count(user_id_d3) / count(user_id_d0) '3日留存率',count(user_id_d7) / count(user_id_d0) '7日留存率',from (select distinct log_day,a.user_id_d0,b.device_id as user_id_d1,c.device_id as user_id_d3,d.device_id as user_id_d7from (select distinct date(event_time) as log_day, device_id as user_id_d0from role_login_backgroup by device_idorder by log_day) aleft join role_login_back b on datediff(date(b.event_time),a.log_day) = 1 and a.user_id_d0 = b.device_idleft join role_login_back c on datediff(date(c.event_time), a.log_day) = 2and a.user_id_d0 = c.device_idleft join role_login_back don datediff(date(d.event_time), a.log_day) = 6and a.user_id_d0 = d.device_id )group by log_day;
如果觉得《每日新增用户的次日留存率》对你有帮助，请点赞、收藏，并留下你的观点哦！
