API接口目录

广告业务

商品推广API
广告API
效果报表API
线下广告API
账号API
站外广告API
人群包API
异常码自查工具
suning.advertise.getpromotionunitrepbypage.query 查询单元报表历史数据
¥增值

查询单元报表历史数据

公共参数
请求参数
名称 类型 是否必须 示例值 描述
custnumStringY777777操作用户id
pagerNumberStringY1当前页数
pagerSizeStringY1每页条数
throwTypeStringN0:PC,1:mobile,其他:全部投放终端
startDateStringYyyyy-MM-dd开始日期
endDateStringYyyyy-MM-dd结束日期
orderByStringN可为空,默认按更新时间倒序,可自己设置的排序字段如下:orderByFields.add(showNum);排序字段
promotionNameStringNxxxx计划名称
productTypeStringN1.聚客宝 2.生意通 3.大聚惠 4.生意通店铺推广产品类型
promotionUnitIdStringN54321计划单元id
promotionDateStringNyyyy-MM-dd计划日期
goodsNameStringN可乐商品名称
dayTypeStringN_:1天,3day:3天,_7day:7天,_15day:15天ROI及订单统计范围
isDayStringYtrue:分日报表 false:统计报表是否分日报表
响应参数
名称 类型 示例值 描述
statusString0:成功,1:失败状态
msgString成功状态说明
dataString
dataListString
avgCostString0.39平均点击成本(单位:元)
clickNumString 111点击量
clickRateString55.50%点击率
clickRateSortString 55.5点击率排序
conversionRateString444.14%下单转化率
conversionRateSortString444.14下单率排序
costString43花费(单位:元)
directAddshoppingcartNumString 154直接加购数
directDealAmountString1200直接成交金额
directDealNumString 1000直接成交笔数
directSubmitAmountString650直接提交订单金额
directSubmitOrderString 252直接提交订单数
goodsFocusNumString504商品关注数
goodsNameStringC店球票商品测试数据201911230726382mq3商品名称
indirectAddshoppingcartNumString 245间接加购数
indirectDealAmountString 200间接成交金额
indirectDealOrderString 244间接成交订单总数
promotionNameString大促报文测试_勿删计划名称
promotionStatusString 1计划状态
promotionDateString时间格式:yyyy-MM-dd推广日期
promotionUnitIdString8880001000002057计划单元ID
roiString5.74下单ROI
showNumString200展现量
throwSourceString全部投放终端
totalAddshoppingcartNumString 399总加购数
totalDealAmountString1000总成交金额
totalSubmitAmountString 247总下单金额
indirectSubmitAmountString1010
indirectSubmitOrderString1间接提交订单
overViewDataString
avgCostString0.5平均点击成本(单位:元)
clickNumString136点击量
clickRateString45.33%点击率
conversionRateString 725.00%下单转化率
costString 68花费(单位:元)
directAddshoppingcartNumString 308直接加购数
directDealAmountString 1500直接成交金额
directDealNumString 1500直接成交订单数
directSubmitAmountString 1300直接下单金额
directSubmitOrderString 504直接下单量
goodsFocusNumString 1008商品关注数
goodsNameString商品名称商品名称
indirectAddshoppingcartNumString490间接加购数
indirectDealAmountString 400间接成交金额
indirectDealOrderString 488间接成交订单数
indirectSubmitAmountString490间接下单金额
indirectSubmitOrderString482间接下单量
promotionNameString计划名称计划名称
roiString26.32下单ROI
showNumString300展现量
throwSourceString投放终端投放终端
totalAddshoppingcartNumString798总加购数
totalDealAmountString1500总成交金额
totalSubmitAmountString 494下单金额
pagerNumberString1当前页数
totalCountString2记录总是
请求示例
  • XML示例
  • JSON示例
复制全部代码
                                
<sn_request>
  <sn_body>
    <queryGetpromotionunitrepbypage>
      <throwType>0:PC,1:mobile,其他:全部</throwType>
      <endDate>yyyy-MM-dd</endDate>
      <custnum>777777</custnum>
      <pagerNumber>1</pagerNumber>
      <orderBy>可为空,默认按更新时间倒序,可自己设置的排序字段如下:orderByFields.add(showNum);</orderBy>
      <promotionDate>yyyy-MM-dd</promotionDate>
      <isDay>true:分日报表 false:统计报表</isDay>
      <pagerSize>1</pagerSize>
      <dayType>_:1天,3day:3天,_7day:7天,_15day:15天</dayType>
      <promotionUnitId>54321</promotionUnitId>
      <promotionName>xxxx</promotionName>
      <goodsName>可乐</goodsName>
      <startDate>yyyy-MM-dd</startDate>
      <productType>1.聚客宝 2.生意通 3.大聚惠 4.生意通店铺推广</productType>
    </queryGetpromotionunitrepbypage>
  </sn_body>
</sn_request>

			
                                
                                
{
  "sn_request": {
    "sn_body": {
      "queryGetpromotionunitrepbypage": {
        "throwType": "0:PC,1:mobile,其他:全部",
        "endDate": "yyyy-MM-dd",
        "custnum": "777777",
        "pagerNumber": "1",
        "orderBy": "可为空,默认按更新时间倒序,可自己设置的排序字段如下:orderByFields.add(showNum);",
        "promotionDate": "yyyy-MM-dd",
        "isDay": "true:分日报表 false:统计报表",
        "pagerSize": "1",
        "dayType": "_:1天,3day:3天,_7day:7天,_15day:15天",
        "promotionUnitId": "54321",
        "promotionName": "xxxx",
        "goodsName": "可乐",
        "startDate": "yyyy-MM-dd",
        "productType": "1.聚客宝 2.生意通 3.大聚惠 4.生意通店铺推广"
      }
    }
  }
}
			
                                
响应示例
  • XML示例
  • JSON示例
复制全部代码
                              
<sn_responseContent>
  <sn_body>
    <queryGetpromotionunitrepbypage>
      <msg>成功</msg>
      <data>
        <dataList>
          <totalAddshoppingcartNum> 399</totalAddshoppingcartNum>
          <roi>5.74</roi>
          <conversionRateSort>444.14</conversionRateSort>
          <promotionStatus> 1</promotionStatus>
          <promotionUnitId>8880001000002057</promotionUnitId>
          <promotionName>大促报文测试_勿删</promotionName>
          <totalSubmitAmount> 247</totalSubmitAmount>
          <goodsFocusNum>504</goodsFocusNum>
          <clickRate>55.50%</clickRate>
          <directAddshoppingcartNum> 154</directAddshoppingcartNum>
          <clickNum> 111</clickNum>
          <avgCost>0.39</avgCost>
          <indirectDealOrder> 244</indirectDealOrder>
          <totalDealAmount>1000</totalDealAmount>
          <goodsName>C店球票商品测试数据201911230726382mq3</goodsName>
          <indirectAddshoppingcartNum> 245</indirectAddshoppingcartNum>
          <cost>43</cost>
          <directSubmitAmount>650</directSubmitAmount>
          <promotionDate>时间格式:yyyy-MM-dd</promotionDate>
          <directSubmitOrder> 252</directSubmitOrder>
          <indirectSubmitAmount>10</indirectSubmitAmount>
          <throwSource>全部</throwSource>
          <conversionRate>444.14%</conversionRate>
          <indirectSubmitOrder>1</indirectSubmitOrder>
          <showNum>200</showNum>
          <clickRateSort> 55.5</clickRateSort>
          <directDealNum> 1000</directDealNum>
          <directDealAmount>1200</directDealAmount>
          <indirectDealAmount> 200</indirectDealAmount>
        </dataList>
        <pagerNumber>1</pagerNumber>
        <totalCount>2</totalCount>
        <overViewData>
          <cost> 68</cost>
          <totalAddshoppingcartNum>798</totalAddshoppingcartNum>
          <directSubmitAmount> 1300</directSubmitAmount>
          <directSubmitOrder> 504</directSubmitOrder>
          <indirectSubmitAmount>490</indirectSubmitAmount>
          <throwSource>投放终端</throwSource>
          <conversionRate> 725.00%</conversionRate>
          <roi>26.32</roi>
          <indirectSubmitOrder>482</indirectSubmitOrder>
          <showNum>300</showNum>
          <promotionName>计划名称</promotionName>
          <totalSubmitAmount> 494</totalSubmitAmount>
          <goodsFocusNum> 1008</goodsFocusNum>
          <clickRate>45.33%</clickRate>
          <directAddshoppingcartNum> 308</directAddshoppingcartNum>
          <directDealNum> 1500</directDealNum>
          <clickNum>136</clickNum>
          <directDealAmount> 1500</directDealAmount>
          <indirectDealAmount> 400</indirectDealAmount>
          <avgCost>0.5</avgCost>
          <indirectDealOrder> 488</indirectDealOrder>
          <totalDealAmount>1500</totalDealAmount>
          <goodsName>商品名称</goodsName>
          <indirectAddshoppingcartNum>490</indirectAddshoppingcartNum>
        </overViewData>
      </data>
      <status>0:成功,1:失败</status>
    </queryGetpromotionunitrepbypage>
  </sn_body>
</sn_responseContent>

			
                              
                              
{
  "sn_responseContent": {
    "sn_body": {
      "queryGetpromotionunitrepbypage": {
        "msg": "成功",
        "data": [
          {
            "dataList": [
              {
                "totalAddshoppingcartNum": " 399",
                "roi": "5.74",
                "conversionRateSort": "444.14",
                "promotionStatus": " 1",
                "promotionUnitId": "8880001000002057",
                "promotionName": "大促报文测试_勿删",
                "totalSubmitAmount": " 247",
                "goodsFocusNum": "504",
                "clickRate": "55.50%",
                "directAddshoppingcartNum": " 154",
                "clickNum": " 111",
                "avgCost": "0.39",
                "indirectDealOrder": " 244",
                "totalDealAmount": "1000",
                "goodsName": "C店球票商品测试数据201911230726382mq3",
                "indirectAddshoppingcartNum": " 245",
                "cost": "43",
                "directSubmitAmount": "650",
                "promotionDate": "时间格式:yyyy-MM-dd",
                "directSubmitOrder": " 252",
                "indirectSubmitAmount": "10",
                "throwSource": "全部",
                "conversionRate": "444.14%",
                "indirectSubmitOrder": "1",
                "showNum": "200",
                "clickRateSort": " 55.5",
                "directDealNum": " 1000",
                "directDealAmount": "1200",
                "indirectDealAmount": " 200"
              }
            ],
            "pagerNumber": "1",
            "totalCount": "2",
            "overViewData": [
              {
                "cost": " 68",
                "totalAddshoppingcartNum": "798",
                "directSubmitAmount": " 1300",
                "directSubmitOrder": " 504",
                "indirectSubmitAmount": "490",
                "throwSource": "投放终端",
                "conversionRate": " 725.00%",
                "roi": "26.32",
                "indirectSubmitOrder": "482",
                "showNum": "300",
                "promotionName": "计划名称",
                "totalSubmitAmount": " 494",
                "goodsFocusNum": " 1008",
                "clickRate": "45.33%",
                "directAddshoppingcartNum": " 308",
                "directDealNum": " 1500",
                "clickNum": "136",
                "directDealAmount": " 1500",
                "indirectDealAmount": " 400",
                "avgCost": "0.5",
                "indirectDealOrder": " 488",
                "totalDealAmount": "1500",
                "goodsName": "商品名称",
                "indirectAddshoppingcartNum": "490"
              }
            ]
          }
        ],
        "status": "0:成功,1:失败"
      }
    }
  }
}
			
                              
异常示例
  • XML示例
  • JSON示例
复制全部代码

  
  	API异常码
  	异常码中文描述
  

                           	  
{
  "sn_responseContent": {
    "sn_error": {
      "error_code": "API异常码",
      "error_msg": "异常码中文描述"
    }
  }
}
                           		
业务异常码
异常码 错误描述 解决方案
biz.advertise.querygetpromotionunitrepbypage.missing-parameter:* 参数必填 请检查此参数的值,*号表示参数字段名
biz.handler.data-get:no-result 查询没结果 请检查查询参数
isp.sys.service.unavailable.adss 服务不可用 请联系苏宁技术人员
公共异常码
API工具
FAQ