“MA切流反馈修复”的版本间的差异

来自qingwei personal wiki
跳转至： 导航， 搜索
（→‎新版热门搜索词中增加“卖家竞争度”）
（→‎产品列表hsf测试(有问题)）
第84行： 第84行：
 
]
 
]
  
 +
</source>
 +
 +
=== 测试问题分析 ===
 +
<source lang="sql">
 +
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
 
</source>
 
</source>
  

2019年1月23日 (三) 15:40的版本

首页经营效果中，增加按发布产品拆分指标选项

首页经营效果中，增加按发布产品拆分指标选项

新版产品>产品分析缺失 顶级展位、P4P （前端）

aone

  • 前端问题；增加两个参数： TR, P4P 
" 如果没有，不传递参数 "
{
"TR": "TR",
"P4P": "P4P"
}

增加产品列表增加数据统计及分段功能

描述

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)

分段功能需要做的事

  1. 修改sql [vip.product.getEffectiveProductsTotal]
  2. 修改业务流： vip/product/getEffectiveProductsTotal， 增加4*2个参数 http://oneness2.alibaba-inc.com/businessFlow?moduleId=114&interfaceId=1943&group=alidata
  3. 修改业务流： 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

我的词行业TOP10点击与曝光口径调整

描述

aone
https://hz-mydata.alibaba.com/self/keyword.htm?spm=a271v.8028089.0.0.30803e5fXm3PST 自定义列

前端

Top10平均曝光：avgSumClickCnt: 3
Top10平均点击：avgSumShowCnt: 169

表

周表 月表
新版数据管家 dwp_en_dm_vip_comp_term_kw_myself_eff_w dwp_en_dm_vip_comp_term_kw_myself_eff_m
老版数据管家 dwp_en_dm_comp_term_kw_myself_eff_w dwp_en_dm_comp_term_kw_myself_eff_m

（高优先级）新版数据管家热门搜索词逻辑优化

描述

aone
https://data.alibaba.com/industry/keyword/hot?spm=a2793.12386102.0.0.19a83e5fqqUPjy

openSearch应用(表)

https://opensearch-cn-shanghai-in.console.aliyun.com/?spm=5176.7946605.209387.09080706050409.42babc75D46zHL#/apps?page=1&name=sc_mydata_hot_keyword

- openSearch应用 odps表
老版使用 -- 将被废弃 sc_mydata_hot_keyword dwp_en_dm_kw_hot_eff_m
周表 sc_mydata_hot_keyword_w dwp_en_dm_vip_kw_hot_eff_w
y月表 sc_mydata_hot_keyword_m dwp_en_dm_vip_kw_hot_eff_m
  • 加一个词： orig_kw （别名：orig_keywords）
- DA会增加新的一列 买家搜索原词
- 后端加灰度控制，灰度里的使用 买家搜索原词（orig_kw） 代替原来的 归一化词(keywords)

灰度id

com.alibaba.intl.mydata.maopt

业务背景

新版热门词 发现 lady 显示为ladi 所以关键词搜lady xx 关键词很少,其它有些词也一样 还有e结尾的会被吃掉 比如 wholesale 搜很少 wholesal 词超多,purse同理 purse少,purs很多

员工管理增加指标汇总

描述

https://aone.alibaba-inc.com/req/18341488

测试

[
  "vip/home/getAccountsAndTotal",
  {
    "statDate": "2018-12-01",
    "adminMemberSeq": "200042360",
    "statisticsType": "month",
    "region": "os"
  }
]

新版热门搜索词中增加“卖家竞争度”

描述

https://aone.alibaba-inc.com/req/18557644

新增字段

mbr_cnt_std_052

取自“http://106.14.10.253:8190/index.php?title=MA切流反馈修复&oldid=977”