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

来自qingwei personal wiki
跳转至： 导航， 搜索
（→‎sql）
（→‎SQL配置）
第49行： 第49行：
 
     </if>         
 
     </if>         
 
where
 
where
−
     stat_date= #{statDate}
+
     stat_date >= #{prevDate}
−
     and admin_mbr_seq= #{adminMemberSeq}
+
    and stat_date <= #{statDate}
−
     and statistic_type= #{statisticType}
+
     and admin_mbr_seq = #{adminMemberSeq}
−
     and terminal_type= #{terminalType}
+
     and statistic_type = #{statisticType}
−
     and is_main_cate= #{isMainCate}
+
     and terminal_type = #{terminalType}
−
     and cate_lv2_id= #{cateLv2Id}
+
     and is_main_cate = #{isMainCate}
 +
     and cate_lv2_id = #{cateLv2Id}
 
</source>
 
</source>
 
[[category: 阿里]]
 
[[category: 阿里]]
 
[[category: 数据管家]]
 
[[category: 数据管家]]

2018年11月12日 (一) 08:20的版本

描述

aone

便签

接口

external/kpwork/overview

sql

  • terminal_type: PC, TOTAL, WS
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 stat_date<="2018-10-9"
    and statistic_type="ALL"
    and admin_mbr_seq="14"
    and terminal_type="PC"
    and is_main_cate="Y"
    and cate_lv2_id=100010695

oneService

参数

  • 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 >= #{prevDate}
    and stat_date <= #{statDate}
    and admin_mbr_seq  = #{adminMemberSeq}
    and statistic_type = #{statisticType}
    and terminal_type = #{terminalType}
    and is_main_cate = #{isMainCate}
    and cate_lv2_id = #{cateLv2Id}
取自“http://106.14.10.253:8190/index.php?title=KP工作台数据漏斗&oldid=725”