select log_src_channel_lv1_name,count(distinct uuid) as uv
from tmp.dws_kylin_log_page_path
where hq_kdt_id = 92071311
and par = '20220828'
group by log_src_channel_lv1_name
接口数据来源：
dm_dc.wsc_team_uniservice_ds -> dw.dwa_team_channel_unique_ds
select sum(uv) as uv
from dw.dwa_team_channel_unique_ds
where kdt_id = 92071311
and par = '20220828' and date_type = 'day' and src_channel = '全渠道' and hr = 'all'
用手机打开
收藏
赞
···
回复
1
跳至页
复制链接
新浪微博
QQ空间
微信扫码
赞 
回复