KP工作台数据漏斗（二期）

描述

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

曝访点反

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

来源分析

SELECT
    terminal_type,
    sum(imps_cnt_1d_027) as imp,
    sum(clk_cnt_1d_092) as clk,
    sum(uv_1d_169) as uv,
    sum(fb_cnt_1d_013) as fb
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"
group by
    terminal_type

测试

大盘漏斗

[
  "external/kpwork/dashboard",
  {
    "startDate": "2018-11-20",
    "endDate": "2018-11-23",
    "adminMemberSeq": "14"
  }
]

时间趋势

[
  "external/kpwork/trends",
  {
    "startDate": "2018-11-20",
    "endDate": "2018-11-23",
    "adminMemberSeq": "14"
  }
]

来源分析

[
  "external/kpwork/origin",
  {
    "startDate": "2018-11-20",
    "endDate": "2018-11-23",
    "adminMemberSeq": "14"
  }
]

oneness

external.kpwork.amtDays

select
    ${returnFields}
from
    dwp_en_dm_comp_maincatelv2_eff_d   
where
    ( stat_date >= #{startDate}
       and stat_date <= #{endDate} )
    and admin_mbr_seq = #{adminMemberSeq}
order by
    stat_date ASC