![]() |
#2
tlliqi2014-11-28 10:07
|
select
a.os,
a.country,
datediff(b.member_gmt_create,a.hp_stat_date) as PP,
count(distinct a.imeisi) as geshu
from bdl_en_app_wdm_v3_user_track_d a
join idl_en_ent_signin_fdt0 b
on a.session_id = b.session_id
and a.newly_imeisi is not null
and a.hp_stat_date>='2014-06-20'
and b.hp_stat_date>='2014-06-20'
group by
a.os,
a.country,
datediff(b.member_gmt_create,a.hp_stat_date)
统计app用户 从装机时间到注册时间的差 的用户数量。
就是用户在装机后一天注册的有XX个,后两天注册的有XXX个·····这样