“KP工作台数据漏斗（二期）”的版本间的差异

来自qingwei personal wiki
跳转至： 导航， 搜索
（→‎爆访点反）
（→‎external.kpwork.amtDays）
第36行： 第36行：
 
=== external.kpwork.amtDays ===
 
=== external.kpwork.amtDays ===
 
<source lang="sql">
 
<source lang="sql">
−
select
+
SELECT
−
     ${returnFields}
+
     stat_date,
 +
    imps_cnt_1d_027,
 +
    clk_cnt_1d_092,
 +
    uv_1d_169,
 +
    fb_cnt_1d_013,
 +
    fst_reply_rate_1m_003,
 +
    terminal_type
 
from
 
from
−
     dwp_en_dm_comp_maincatelv2_eff_d    
+
     dwp_en_dm_comp_term_catelv2_eff_d    
 
where
 
where
−
     ( stat_date &amp;gt;= #{startDate}
+
     ( stat_date >= "2018-11-20"
−
       and stat_date &amp;lt;= #{endDate} )
+
       and stat_date <= "2018-11-23" )
−
     and admin_mbr_seq = #{adminMemberSeq}
+
     and admin_mbr_seq = 14
 +
    and is_main_cate = "Y"
 +
    and terminal_type="TOTAL"
 
order by
 
order by
 
     stat_date ASC
 
     stat_date ASC

2018年11月28日 (三) 09:16的版本

描述

https://aone.alibaba-inc.com/req/17899072

二级页面SQL

大盘漏斗

投入

select
    stat_date as statDate,
    adm_amt_1d as admAmt  
from
    dwp_en_dm_comp_maincatelv2_eff_d  
where
    (
        stat_date >= '2018-11-20'          
        and stat_date <= '2018-11-23'      
    )      
    and admin_mbr_seq = '14' 
order by
    stat_date ASC

爆访点反

from
    dwp_en_dm_comp_term_catelv2_eff_d     
where
    ( stat_date &amp;gt;= #{startDate}
       and stat_date &amp;lt;= #{endDate} )
    and admin_mbr_seq = #{adminMemberSeq}
    and is_main_cate = "Y"
    and terminal_type="TOTAL"
order by
    stat_date ASC

oneness

external.kpwork.amtDays

SELECT
    stat_date,
    imps_cnt_1d_027,
    clk_cnt_1d_092,
    uv_1d_169,
    fb_cnt_1d_013,
    fst_reply_rate_1m_003,
    terminal_type
from
    dwp_en_dm_comp_term_catelv2_eff_d   
where
    ( stat_date >= "2018-11-20"
       and stat_date <= "2018-11-23" )
    and admin_mbr_seq = 14
    and is_main_cate = "Y"
    and terminal_type="TOTAL"
order by
    stat_date ASC
取自“http://106.14.10.253:8190/index.php?title=KP工作台数据漏斗（二期）&oldid=800”