KP工作檯數據漏斗

描述

aone

接口

external/kpwork/overview

oneService

SELECT
    stat_date,
    imps_cnt_1d_027,
    clk_cnt_1d_092,
    uv_1d_169,
    fb_cnt_1d_013,
    fst_reply_rate_1m_003
FROM
    dwp_en_dm_comp_term_catelv2_eff_d
where
    stat_date="2018-10-8"
    and statistic_type="ALL"
    and admin_mbr_seq="14"
    and terminal_type="PC"
    and is_main_cate="Y"
    and cate_lv2_id=100010695

參數

• statDate (根據statisticsType校驗，返回相應錯誤) 
• terminalType
• statisticsType
• adminMemberSeq

SQL配置

• external.kpwork.overview

select
    ${returnFields}    
from
    <if test='statisticsType == "day"'> 
        dwp_en_dm_comp_term_catelv2_eff_d
    </if>  
    <if test='statisticsType == "week"'> 
        dwp_en_dm_comp_term_catelv2_eff_w
    </if>
    <if test='statisticsType == "month"'> 
        dwp_en_dm_comp_term_catelv2_eff_m
    </if>         
where
    stat_date= #{statDate}
    and admin_mbr_seq= #{adminMemberSeq}
    and statistic_type= #{region}
    and terminal_type= #{terminalType}
    and is_main_cate= #{isMainCate}
    and cate_lv2_id= #{cateLv2Id}