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

来自qingwei personal wiki
跳转至： 导航， 搜索
（→‎增加产品列表增加数据统计及分段功能）
第16行： 第16行：
 
=== 描述 ===
 
=== 描述 ===
 
https://aone.alibaba-inc.com/req/18338586
 
https://aone.alibaba-inc.com/req/18338586
 +
=== 老版分段产品统计sql ===
 +
<source lang="xml">
 +
<sql id="effectiveProductWhereCondition" >
 +
            stat_date = #statDate# and
 +
            admin_mbr_seq = #adminMemberSeq# and
 +
 +
            <isEqual property="newProductTable" compareValue="true">
 +
                terminal_type = 'TOTAL'
 +
            </isEqual>
 +
 +
            <isEqual property="newProductTable" compareValue="false">
 +
                terminal_type = 'PC_WAP'
 +
            </isEqual>
 +
 +
          <dynamic>
 +
            <isNotNull prepend=" and " property="minViews">
 +
                imps_cnt_1d_027 &gt;= #minViews#</isNotNull>
 +
            <isNotNull prepend=" and " property="maxViews">
 +
                imps_cnt_1d_027 &lt;= #maxViews#</isNotNull>
 +
            <isNotNull prepend=" and " property="minClicks">
 +
                clk_cnt_1d_092 &gt;= #minClicks#</isNotNull>
 +
            <isNotNull prepend=" and " property="maxClicks">
 +
                clk_cnt_1d_092 &lt;= #maxClicks#</isNotNull>
 +
            <isNotNull prepend=" and " property="minInquiries">
 +
                fb_cnt_1d_013 &gt;= #minInquiries#</isNotNull>
 +
            <isNotNull prepend=" and " property="maxInquiries">
 +
                fb_cnt_1d_013 &lt;= #maxInquiries#</isNotNull>
 +
            <isNotNull prepend=" and " property="minVisitors">
 +
                uv_1d_169 &gt;= #minVisitors#</isNotNull>
 +
            <isNotNull prepend=" and " property="maxVisitors">
 +
                uv_1d_169 &lt;= #maxVisitors#</isNotNull>
 +
            <isNotNull prepend=" and " property="minClkRate">
 +
                clk_rate_1d_068 &gt;= #minClkRate#</isNotNull>
 +
            <isNotNull prepend=" and " property="maxClkRate">
 +
                clk_rate_1d_068 &lt;= #maxClkRate#</isNotNull>
 +
            <isNotNull prepend=" and " property="name">
 +
                prod_name like #name#</isNotNull>
 +
            <isNotNull prepend=" and " property="AD">
 +
                is_kw_prod = 'Y'</isNotNull>
 +
            <isNotNull prepend=" and " property="PS">
 +
                is_show_win = 'Y'</isNotNull>
 +
            <isNotNull prepend=" and " property="TR">
 +
                is_intlbw = 'Y'</isNotNull>
 +
            <isNotNull prepend=" and " property="P4P">
 +
                is_p4p_prod = 'Y'</isNotNull>
 +
            <isNotNull prepend=" and " property="owner">
 +
                owner_mbr_seq = #owner#</isNotNull>
 +
            <isNotNull prepend=" and " property="groupLevel1">
 +
                prod_group_id = #groupLevel1#</isNotNull>
 +
            <isNotNull prepend=" and " property="groupLevel2">
 +
                group_id2 = #groupLevel2#</isNotNull>
 +
            <isNotNull prepend=" and " property="groupLevel3">
 +
                group_id3 = #groupLevel3#</isNotNull>
 +
            <isNotNull prepend=" and " property="model">
 +
                prod_model like #model#</isNotNull>
 +
            <isNotNull prepend=" and " property="beginUpdatedDate">
 +
                mdf_time &gt;= #beginUpdatedDate#</isNotNull>
 +
            <isNotNull prepend=" and " property="endUpdatedDate">
 +
                mdf_time &lt;= #endUpdatedDate#</isNotNull>
 +
            <isNotNull prepend=" and " property="hasEffect">
 +
              is_effer_prod = 'Y'</isNotNull>
 +
 +
          </dynamic>
 +
    </sql>
 +
</source>
 
[[category: 阿里]]
 
[[category: 阿里]]
 
[[category: 数据管家]]
 
[[category: 数据管家]]

2018年12月27日 (四) 11:13的版本

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

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

新版产品>产品分析缺失 顶级展位、P4P

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

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

描述

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

老版分段产品统计sql

<sql id="effectiveProductWhereCondition" >
            stat_date = #statDate# and
            admin_mbr_seq = #adminMemberSeq# and

            <isEqual property="newProductTable" compareValue="true">
                terminal_type = 'TOTAL'
            </isEqual>

            <isEqual property="newProductTable" compareValue="false">
                terminal_type = 'PC_WAP'
            </isEqual>

          <dynamic>
            <isNotNull prepend=" and " property="minViews">
                imps_cnt_1d_027 &gt;= #minViews#</isNotNull>
            <isNotNull prepend=" and " property="maxViews">
                imps_cnt_1d_027 &lt;= #maxViews#</isNotNull>
            <isNotNull prepend=" and " property="minClicks">
                clk_cnt_1d_092 &gt;= #minClicks#</isNotNull>
            <isNotNull prepend=" and " property="maxClicks">
                clk_cnt_1d_092 &lt;= #maxClicks#</isNotNull>
            <isNotNull prepend=" and " property="minInquiries">
                fb_cnt_1d_013 &gt;= #minInquiries#</isNotNull>
            <isNotNull prepend=" and " property="maxInquiries">
                fb_cnt_1d_013 &lt;= #maxInquiries#</isNotNull>
            <isNotNull prepend=" and " property="minVisitors">
                uv_1d_169 &gt;= #minVisitors#</isNotNull>
            <isNotNull prepend=" and " property="maxVisitors">
                uv_1d_169 &lt;= #maxVisitors#</isNotNull>
            <isNotNull prepend=" and " property="minClkRate">
                clk_rate_1d_068 &gt;= #minClkRate#</isNotNull>
            <isNotNull prepend=" and " property="maxClkRate">
                clk_rate_1d_068 &lt;= #maxClkRate#</isNotNull>
            <isNotNull prepend=" and " property="name">
                prod_name like #name#</isNotNull>
            <isNotNull prepend=" and " property="AD">
                is_kw_prod = 'Y'</isNotNull>
            <isNotNull prepend=" and " property="PS">
                is_show_win = 'Y'</isNotNull>
            <isNotNull prepend=" and " property="TR">
                is_intlbw = 'Y'</isNotNull>
            <isNotNull prepend=" and " property="P4P">
                is_p4p_prod = 'Y'</isNotNull>
            <isNotNull prepend=" and " property="owner">
                owner_mbr_seq = #owner#</isNotNull>
            <isNotNull prepend=" and " property="groupLevel1">
                prod_group_id = #groupLevel1#</isNotNull>
            <isNotNull prepend=" and " property="groupLevel2">
                group_id2 = #groupLevel2#</isNotNull>
            <isNotNull prepend=" and " property="groupLevel3">
                group_id3 = #groupLevel3#</isNotNull>
            <isNotNull prepend=" and " property="model">
                prod_model like #model#</isNotNull>
            <isNotNull prepend=" and " property="beginUpdatedDate">
                mdf_time &gt;= #beginUpdatedDate#</isNotNull>
            <isNotNull prepend=" and " property="endUpdatedDate">
                mdf_time &lt;= #endUpdatedDate#</isNotNull>
            <isNotNull prepend=" and " property="hasEffect">
               is_effer_prod = 'Y'</isNotNull>

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