“首页经营效果中，增加按发布产品拆分指标选项”的版本间的差异
来自qingwei personal wiki
| 第149行： | 第149行： | ||
and statistic_type = 'all' | and statistic_type = 'all' | ||
</source> | </source> | ||
| + | == 线上问题 == | ||
| + | |||
[[category: 阿里]] | [[category: 阿里]] | ||
[[category: 数据管家]] | [[category: 数据管家]] | ||
2019年1月9日 (三) 04:36的版本
目录
描述
https://aone.alibaba-inc.com/req/17665713
新表
- dwp_en_dm_vip_comp_term_region_catelv3_cube_d (dwp_en_dm_vip_comp_term_region_cube_d)
- dwp_en_dm_vip_catelv3_term_cube_d (dwp_en_dm_vip_cate_term_cube_d)
- 获取具体类目的指标在行业平均效果 （老表不分类目，是店铺的所有类目汇总）
- 指标包括 'comp_fb_uv' , 'comp_ord_amt' , 'shop_pv' , 'comp_ord_cnt' , 'comp_clk_cnt' , 'comp_atm_uv' , 'shop_uv' , 'comp_imps_cnt' , 'comp_fb_cnt'
- dwp_en_dm_vip_comp_cate_term_eff_d (dwp_en_dm_vip_comp_term_eff_d)
oneness
vip.home.getShopSummary
select
${returnFields}
from
<if test='statisticsType == "day" and seperateByCate == "false"'>
dwp_en_dm_vip_comp_term_eff_d
</if>
<if test='statisticsType == "week" and seperateByCate == "false"'>
dwp_en_dm_vip_comp_term_eff_w
</if>
<if test='statisticsType == "month" and seperateByCate == "false"'>
dwp_en_dm_vip_comp_term_eff_m
</if>
<if test='statisticsType == "day" and seperateByCate == "true"'>
dwp_en_dm_vip_comp_cate_term_eff_d
</if>
<if test='statisticsType == "week" and seperateByCate == "true"'>
dwp_en_dm_vip_comp_cate_term_eff_w
</if>
<if test='statisticsType == "month" and seperateByCate == "true"'>
dwp_en_dm_vip_comp_cate_term_eff_m
</if>
where
admin_mbr_seq = #{adminMemberSeq}
and terminal_type = #{terminalType}
<if test='seperateByCate == "true"'>
and cate_lv3_id = #{cateId}
</if>
<if test="statDateList != null">
and stat_date in
<foreach collection="statDateList" item="item" open="(" separator="," close=")">
#{item}
</foreach>
</if>
<if test="region!= null">
and statistic_type = #{region}
</if>
hsf 测试
vip/home/getShopSummary
[
"vip/home/getShopSummary-new",
{
"adminMemberSeq": "14",
"statDate": "2018-12-04",
"statisticsType": "day",
"prevDate": "2018-12-03",
"cateId": "330",
"seperateByCate": "true"
}
]
- 比较老版少了4个字段 (dwp_en_dm_vip_comp_cate_term_eff_d)
- statDate {1} fbUv {4} orderAmount {4} shopPv {4} orderCount {4} searchClicks {4} shopUv {4} tmUv {4} searchImps {4} fbPv
- statDate {1} fbUv {4} searchClicks {4} tmUv {4} searchImps {4} fbPv {4}
- 少的字段： orderAmount shopPv orderCount shopUv
vip/home/getShopTrends
[
"vip/home/getShopTrends-new",
{
"adminMemberSeq": "14",
"beginDate": "2018-12-03",
"endDate": "2018-12-04",
"statisticsType": "day",
"cateId": "145",
"seperateByCate": "true"
}
]
vip/home/getShopRegionAnalysis
[
"vip/home/getShopRegionAnalysis-new",
{
"adminMemberSeq": "14",
"statDate": "2018-12-04",
"statisticsType": "day",
"cateId": "1521",
"seperateByCate": "true"
}
]
[
"vip/home/getShopRegionAnalysis-new",
{
"adminMemberSeq": "14",
"statDate": "2018-12-08",
"statisticsType": "week",
"cateId": "1521",
"seperateByCate": "true"
}
]
oneness查询
行业平均(数据有问题！！！)
select
stat_date as statDate,
round(cate_lv3_top10_avg,
1) as cateAvg,
target_type as indicatorType,
round(cate_lv3_top10_avg) as cateTop10Avg
from
dwp_en_dm_vip_catelv3_term_cube_m
where
cate_lv3_id = '127726013'
and stat_date >= '2018-11-01'
and '2018-12-01' >= stat_date
and terminal_type = 'TOTAL'
and statistic_type = 'all'
and target_type in (
'comp_fb_uv' , 'adm_click_cnt' , 'comp_clk_cnt' , 'comp_atm_uv' , 'comp_imps_cnt' , 'comp_fb_cnt' , 'adm_imps_cnt'
)
卡片数据与趋势数据最后一天对应不上（添加选择框后）
# 为 空
select
stat_date as statDate,
fb_uv_1d_013 as fbUv,
clk_cnt_1d_092 as searchClicks,
fb_uv_1d_014 as tmUv,
imps_cnt_1d_027 as searchImps,
fb_cnt_1d_013 as fbPv
from
dwp_en_dm_vip_comp_cate_term_eff_d
where
admin_mbr_seq = '200042360'
and terminal_type = 'TOTAL'
and cate_lv3_id = '127820002'
and stat_date = '2018-12-23'
and statistic_type = 'all'
