查看“MA切流反馈修复”的源代码

== 首页经营效果中，增加按发布产品拆分指标选项 ==
[[首页经营效果中，增加按发布产品拆分指标选项]]
== 新版产品>产品分析缺失 顶级展位、P4P （前端） ==
[https://aone.alibaba-inc.com/req/18437178 aone]
* 前端问题；增加两个参数： TR, P4P 
<source lang="json">
" 如果没有，不传递参数 "
{
"TR": "TR",
"P4P": "P4P"
}
</source>
* 后端接口[ vip/product/getEffectiveProductsTotal ]
** http://oneness2.alibaba-inc.com/businessFlow?moduleId=114&interfaceId=1943&group=alidata

== 增加产品列表增加数据统计及分段功能 ==
=== 描述 ===
https://aone.alibaba-inc.com/req/18338586
=== 表 ===
* 老版： dwp_en_dm_prod_terminal_eff_d
* 新版： dwp_en_dm_vip_prod_eff_d
=== 分段功能字段 ===
{| class="wikitable"
|-
! 字段 !! 前端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<br />

<source lang="json">
statistics: {total: 5, clkRate: "0.00", inquiries: 13, crtOrd: 1, views: 0, clicks: 0}
</source>

=== sql过长，参照 ===
http://oneness2.alibaba-inc.com/businessFlow?moduleId=157&interfaceId=2877&group=alidata
=== 数据统计hsf测试 ===
<source lang="json">
[
  "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"
  }
]
</source>
=== 产品列表hsf测试(有问题) ===
<source lang="json">
[
  "vip/product/getEffectiveProducts-new",
  {
    "statDate": "2018-12-01",
    "adminMemberSeq": "200042360",
    "statisticsType": "month",
    "region": "all",
    "minViews": "1",
    "maxViews":"11",
    "minClkRate": "0",
    "maxClkRate": "22"
  }
]

</source>

== 我的词行业TOP10点击与曝光口径调整 ==
=== 描述 ===
[https://aone.alibaba-inc.com/req/18465143 aone]<br />
https://hz-mydata.alibaba.com/self/keyword.htm?spm=a271v.8028089.0.0.30803e5fXm3PST  自定义列
=== 前端 ===
Top10平均曝光：avgSumClickCnt: 3<br />
Top10平均点击：avgSumShowCnt: 169
=== 表 ===
{| class="wikitable"
|-
!  !! 周表 !! 月表
|-
| 新版数据管家 || 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
|}

== （高优先级）新版数据管家热门搜索词逻辑优化 ==
=== 描述 ===
[https://aone.alibaba-inc.com/req/18361082 aone]<br />
https://data.alibaba.com/industry/keyword/hot?spm=a2793.12386102.0.0.19a83e5fqqUPjy<br />
=== openSearch应用(表) ===
https://opensearch-cn-shanghai-in.console.aliyun.com/?spm=5176.7946605.209387.09080706050409.42babc75D46zHL#/apps?page=1&name=sc_mydata_hot_keyword<br />
{| class="wikitable"
|-
! - !! 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）
<pre>
- DA会增加新的一列 买家搜索原词
- 后端加灰度控制，灰度里的使用 买家搜索原词（orig_kw） 代替原来的 归一化词(keywords)
</pre>
===灰度id===
com.alibaba.intl.mydata.maopt
=== 业务背景 ===
新版热门词 发现 lady 显示为ladi   所以关键词搜lady xx 关键词很少,其它有些词也一样 还有e结尾的会被吃掉  比如 wholesale 搜很少  wholesal 词超多,purse同理  purse少,purs很多

== 员工管理增加指标汇总 ==
=== 描述 ===
https://aone.alibaba-inc.com/req/18341488
=== 测试 ===
<source lang="json">
[
  "vip/home/getAccountsAndTotal",
  {
    "statDate": "2018-12-01",
    "adminMemberSeq": "200042360",
    "statisticsType": "month",
    "region": "os"
  }
]
</source>
== 新版热门搜索词中增加“卖家竞争度” ==
=== 描述 ===
https://aone.alibaba-inc.com/req/18557644
=== 新增字段 ===
mbr_cnt_std_052
[[category: 阿里]]
[[category: 数据管家]]