Qeasy Cloud
Get Started

领星ERP 查询沃尔玛广告 - SP广告搜索词列表 API

Platform
领星ERP
Type
WebAPI
Effect
QUERY
API Version
1.0
Adapter
\Adapter\LingXing\LXQueryAdapter
Auth Mode
OTHER
Description
多平台 / 广告 / Walmart广告 · POST · 请求参数 12 个(必填 3) · 响应参数 37 个 · 限流令牌桶容量 1
Updated At
2026-11-21

查询沃尔玛广告 - SP广告搜索词列表

POST/basicOpen/multiplatform/ads/reportSearchImpressionSpList
Factory
{
  "operation": {
    "method": "POST",
    "path": "/basicOpen/multiplatform/ads/reportSearchImpressionSpList"
  },
  "protocol": "HTTPS",
  "host": "https://openapi.lingxing.com",
  "rateLimit": {
    "tokenBucketCapacity": 1,
    "text": ""
  },
  "requestExample": "curl --location 'https://openapi.lingxing.com/basicOpen/multiplatform/ads/reportSearchImpressionSpList?access_token=value&timestamp=value&sign=value&app_key=value' \\\n--header 'Content-Type: application/json' \\\n--data '{\n    \"searchText\": \"phone case\",\n    \"campaignIds\": [\n        123456789\n    ],\n    \"searchedKeywords\": [\n        \"phone case\"\n    ],\n    \"startDate\": \"2026-09-01\",\n    \"endDate\": \"2026-09-07\",\n    \"advertiserIds\": [\n        123456789012345\n    ],\n    \"reportFieldFilter\": {\n        \"adSpend\": [\n            10,\n            100\n        ]\n    },\n    \"pageSize\": 20,\n    \"pageNum\": 1,\n    \"day\": 14,\n    \"orderField\": \"adSpend\",\n    \"orderType\": \"DESC\",\n    \"operationSourceType\": \"gateway\"\n}'",
  "responseExample": {
    "code": 0,
    "message": "success",
    "error_details": [],
    "request_id": "a0d54debf93140f3b58d1ed81e8e3583",
    "response_time": "2026-09-11 12:00:00",
    "data": {
      "total": 1,
      "list": [
        {
          "mpSellerName": "Walmart美国店",
          "mpAdvertiserName": "Walmart广告账户",
          "advertiserId": 123456789012345,
          "campaignName": "手机配件推广",
          "biddingStrategy": "fixed",
          "campaignType": "sponsoredProducts-manual",
          "targetingType": "manual",
          "campaignStatus": "enabled",
          "campaignId": 123456789,
          "searchedKeyword": "phone case",
          "numAdsShown": 1000,
          "numAdsClicks": 100,
          "adSpend": 50,
          "advertisedSkuSales": 200,
          "advertisedSkuUnits": 10,
          "attributedOrders": 10,
          "otherSkuSales": 100,
          "otherSkuUnits": 5,
          "cpc": 0.5,
          "ctr": 10,
          "cvr": 10,
          "cpa": 5,
          "adSpendPercent": 10,
          "numAdsShownPercent": 10,
          "numAdsClicksPercent": 10,
          "attributedOrdersPercent": 10,
          "advertisedSkuSalesPercent": 10,
          "advertisedSkuUnitsPercent": 10,
          "otherSkuSalesPercent": 10,
          "otherSkuUnitsPercent": 10
        }
      ]
    },
    "total": 1
  }
}

Request Parameters

No.FieldNameTypeDefaultRequiredDescription
1searchText搜索词string—Optional搜索词,模糊匹配 searchedKeyword
2campaignIds广告活动ID列表array<any>—Optional广告活动ID列表,Long数组
3searchedKeywords搜索词精确筛选列表array<any>—Optional搜索词精确筛选列表,String数组
4startDate开始日期string—Required开始日期,格式:yyyy-MM-dd
5endDate结束日期string—Required结束日期,格式:yyyy-MM-dd
6advertiserIds广告账号ID列表array<any>—Required广告账号ID列表,Long数组
7reportFieldFilter指标范围筛选对象object—Optional指标范围筛选对象,key为指标字段的驼峰名称(来源为返参的指标字段),value为[min,max]数值数组
8pageSize每页条数integer—Optional每页条数,默认20,最大200
9pageNum页码integer—Optional页码,从1开始,默认1
10day归因天数integer—Optional归因天数,可选值: 3 14 30
11orderField排序字段string—Optional排序字段,使用驼峰字段名
12orderType排序方向string—Optional排序方向,可选值: ASC:升序 DESC:降序

Response Parameters

No.FieldNameTypeDefaultRequiredDescription
1code状态码integer0Required状态码,0:成功
2message消息提示stringsuccessRequired消息提示
3error_details数据校验失败时的错误详情array<any>[]Required数据校验失败时的错误详情
4request_id请求链路idstringa0d54debf93140f3b58d1ed81e8e3583Required请求链路id
5response_time响应时间string2026-09-11 12:00:00Required响应时间
6data响应数据object—Required响应数据
6.1total总记录数integer1Required总记录数
6.2list搜索词列表array<object>—Required搜索词列表
6.2.1mpSellerName店铺名称stringWalmart美国店Required店铺名称
6.2.2mpAdvertiserName广告账号名称stringWalmart广告账户Required广告账号名称
6.2.3advertiserId广告账号IDinteger123456789012345Required广告账号ID
6.2.4campaignName广告活动名称string手机配件推广Required广告活动名称
6.2.5biddingStrategy广告活动竞价策略stringfixedRequired广告活动竞价策略
6.2.6targetingType投放类型stringmanualRequired投放类型
6.2.7campaignStatus广告活动状态stringenabledRequired广告活动状态
6.2.8campaignId广告活动IDinteger123456789Required广告活动ID
6.2.9searchedKeyword搜索词stringphone caseRequired搜索词
6.2.10numAdsShown曝光次数integer1000Required曝光次数
6.2.11numAdsClicks广告点击量integer100Required广告点击量
6.2.12adSpend广告花费number50Required广告花费
6.2.13advertisedSkuSales直接销售额--广告直接点击归因销售额number200Required直接销售额--广告直接点击归因销售额
6.2.14advertisedSkuUnits直接销量--广告直接点击归因销量number10Required直接销量--广告直接点击归因销量
6.2.15attributedOrders广告订单数--归因总订单数integer10Required广告订单数--归因总订单数
6.2.16otherSkuSales关联销售额--间接归因销售额number100Required关联销售额--间接归因销售额
6.2.17otherSkuUnits关联销量--间接归因销量number5Required关联销量--间接归因销量
6.2.18cpc点击成本CPC--计算公式number0.5Required点击成本CPC--计算公式: 广告花费 / 点击量
6.2.19ctr点击率CTR--计算公式number10Required点击率CTR--计算公式: 点击量 / 曝光量 * 100%
6.2.20cvr转化率CVR--计算公式number10Required转化率CVR--计算公式: 广告订单 / 点击量 * 100%
6.2.21cpa平均订单成本CPA--计算公式number5Required平均订单成本CPA--计算公式: 广告花费 / 广告订单
6.2.22adSpendPercentadSpendPercentnumber10Required广告花费占比 = 当前行adSpend / 汇总行adSpend * 100%
6.2.23numAdsShownPercentnumAdsShownPercentnumber10Required曝光量占比 = 当前行numAdsShown / 汇总行numAdsShown * 100%
6.2.24numAdsClicksPercentnumAdsClicksPercentnumber10Required点击占比 = 当前行numAdsClicks / 汇总行numAdsClicks * 100%
6.2.25attributedOrdersPercentattributedOrdersPercentnumber10Required广告订单占比 = 当前行attributedOrders / 汇总行attributedOrders * 100%
6.2.26advertisedSkuSalesPercentadvertisedSkuSalesPercentnumber10Required直接销售额占比 = 当前行advertisedSkuSales / 汇总行advertisedSkuSales * 100%
6.2.27advertisedSkuUnitsPercentadvertisedSkuUnitsPercentnumber10Required直接销量占比 = 当前行advertisedSkuUnits / 汇总行advertisedSkuUnits * 100%
6.2.28otherSkuSalesPercentotherSkuSalesPercentnumber10Required关联销售额占比 = 当前行otherSkuSales / 汇总行otherSkuSales * 100%
6.2.29otherSkuUnitsPercentotherSkuUnitsPercentnumber10Required关联销量占比 = 当前行otherSkuUnits / 汇总行otherSkuUnits * 100%

The 查询沃尔玛广告 - SP广告搜索词列表 API (/basicOpen/multiplatform/ads/reportSearchImpressionSpList) of 领星ERP is curated by the API asset management module of the Qeasy Cloud data integration platform and kept in sync with 领星ERP version updates.

Need to integrate this API?

Qeasy ships with prebuilt adaptation for this API — contact us to start configuring data integration.