“增加产品列表增加数据统计及分段功能”的版本间的差异
来自qingwei personal wiki
（创建页面，内容为“== 描述 == https://aone.alibaba-inc.com/req/18338586 == 表 == * 老版： dwp_en_dm_prod_terminal_eff_d * 新版： dwp_en_dm_vip_prod_eff_d == 分段功能字段…”） |
（没有差异）
|
2019年1月24日 (四) 05:25的版本
描述
https://aone.alibaba-inc.com/req/18338586
表
- 老版： dwp_en_dm_prod_terminal_eff_d
- 新版： dwp_en_dm_vip_prod_eff_d
分段功能字段
| 字段 | 前端key | 数据库key （天表） | 数据库key （周表） | 数据库key （月表） | 类型 |
|---|---|---|---|---|---|
| 曝光 | minViews: 20 maxViews: 100 | imps_cnt_1d_027 | imps_cnt_1w_027 | imps_cnt_cm_027 | BIGINT(20) |
| 点击 | minClicks: 2 maxClicks: 100 | clk_cnt_1d_092 | clk_cnt_1w_092 | clk_cnt_cm_092 | BIGINT(20) |
| 点击率 | minClkRate: 22 maxClkRate: 33 | clk_rate_1d_068 | clk_rate_1w_068 | clk_rate_cm_068 | DECIMAL(20,4) |
| 反馈 | minInquiries: 12 maxInquiries: 24 | fb_cnt_1d_013 | fb_cnt_1w_013 | fb_cnt_cm_013 | BIGINT(20) |
分段功能需要做的事
- 修改sql [vip.product.getEffectiveProductsTotal]
- 修改业务流： vip/product/getEffectiveProductsTotal， 增加4*2个参数 http://oneness2.alibaba-inc.com/businessFlow?moduleId=114&interfaceId=1943&group=alidata
- 修改业务流： vip/product/getEffectiveProducts
数据统计需要做的事
vip/product/getEffectiveProductsTotal
statistics: {total: 5, clkRate: "0.00", inquiries: 13, crtOrd: 1, views: 0, clicks: 0}
sql过长，参照
http://oneness2.alibaba-inc.com/businessFlow?moduleId=157&interfaceId=2877&group=alidata
数据统计hsf测试
[
"vip/product/getEffectiveProductsTotal-new",
{
"statDate": "2018-12-01",
"adminMemberSeq": "200042360",
"statisticsType": "month",
"region": "all",
"minViews": "1",
"maxViews":"11",
"minClicks": "1",
"maxClicks": "22",
"minClkRate": "0.0",
"maxClkRate": "50",
"minInquiries": "1",
"maxInquiries": "22"
}
]
产品列表hsf测试(有问题)
[
"vip/product/getEffectiveProducts-new",
{
"statDate": "2018-12-01",
"adminMemberSeq": "200042360",
"statisticsType": "month",
"region": "all",
"minViews": "1",
"maxViews":"11",
"minClkRate": "0",
"maxClkRate": "22"
}
]
测试问题分析
select
lst_name as lastName,
uv_cm_169 as sumProdVisitorCnt,
imps_cnt_cm_027 as sumProdShowNum,
is_intlbw as isIntlbw,
is_kw_prod as isKwSearch,
prod_name as subject,
is_std_prod as isStdProd,
uv_cm_610 as cmp,
clk_cnt_cm_092 as sumProdClickNum,
fb_cnt_cm_013 as sumProdFbNum,
is_p4p_prod as isP4pProd,
crt_ord_cnt as crtOrd,
fst_name as firstName,
clk_rate_cm_068 as sumProdClickRate,
vst_fb_rate_cm_006 as sumProdFbRate,
keyword_effect as keywordEffect,
uv_cm_612 as fav,
uv_cm_611 as share,
is_show_win as isShowcase,
prod_id as id
from
dwp_en_dm_vip_prod_eff_m
where
stat_date = '2018-12-01'
and admin_mbr_seq = '200042360'
and statistic_type = 'all'
and imps_cnt_cm_027 >= 1
and 1 >= imps_cnt_cm_027
and clk_rate_cm_068 >= 2.0
and 2.0 >= clk_rate_cm_068
order by
imps_cnt_cm_027 asc,
prod_id limit 0,
30
