/basicOpen/multiplatform/ads/reportSearchImpressionSpList{
"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×tamp=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
}
}| No. | Field | Name | Type | Default | Required | Description |
|---|---|---|---|---|---|---|
| 1 | searchText | 搜索词 | string | — | Optional | 搜索词,模糊匹配 searchedKeyword |
| 2 | campaignIds | 广告活动ID列表 | array<any> | — | Optional | 广告活动ID列表,Long数组 |
| 3 | searchedKeywords | 搜索词精确筛选列表 | array<any> | — | Optional | 搜索词精确筛选列表,String数组 |
| 4 | startDate | 开始日期 | string | — | Required | 开始日期,格式:yyyy-MM-dd |
| 5 | endDate | 结束日期 | string | — | Required | 结束日期,格式:yyyy-MM-dd |
| 6 | advertiserIds | 广告账号ID列表 | array<any> | — | Required | 广告账号ID列表,Long数组 |
| 7 | reportFieldFilter | 指标范围筛选对象 | object | — | Optional | 指标范围筛选对象,key为指标字段的驼峰名称(来源为返参的指标字段),value为[min,max]数值数组 |
| 8 | pageSize | 每页条数 | integer | — | Optional | 每页条数,默认20,最大200 |
| 9 | pageNum | 页码 | integer | — | Optional | 页码,从1开始,默认1 |
| 10 | day | 归因天数 | integer | — | Optional | 归因天数,可选值: 3 14 30 |
| 11 | orderField | 排序字段 | string | — | Optional | 排序字段,使用驼峰字段名 |
| 12 | orderType | 排序方向 | string | — | Optional | 排序方向,可选值: ASC:升序 DESC:降序 |
| No. | Field | Name | Type | Default | Required | Description |
|---|---|---|---|---|---|---|
| 1 | code | 状态码 | integer | 0 | Required | 状态码,0:成功 |
| 2 | message | 消息提示 | string | success | Required | 消息提示 |
| 3 | error_details | 数据校验失败时的错误详情 | array<any> | [] | Required | 数据校验失败时的错误详情 |
| 4 | request_id | 请求链路id | string | a0d54debf93140f3b58d1ed81e8e3583 | Required | 请求链路id |
| 5 | response_time | 响应时间 | string | 2026-09-11 12:00:00 | Required | 响应时间 |
| 6 | data | 响应数据 | object | — | Required | 响应数据 |
| 6.1 | total | 总记录数 | integer | 1 | Required | 总记录数 |
| 6.2 | list | 搜索词列表 | array<object> | — | Required | 搜索词列表 |
| 6.2.1 | mpSellerName | 店铺名称 | string | Walmart美国店 | Required | 店铺名称 |
| 6.2.2 | mpAdvertiserName | 广告账号名称 | string | Walmart广告账户 | Required | 广告账号名称 |
| 6.2.3 | advertiserId | 广告账号ID | integer | 123456789012345 | Required | 广告账号ID |
| 6.2.4 | campaignName | 广告活动名称 | string | 手机配件推广 | Required | 广告活动名称 |
| 6.2.5 | biddingStrategy | 广告活动竞价策略 | string | fixed | Required | 广告活动竞价策略 |
| 6.2.6 | targetingType | 投放类型 | string | manual | Required | 投放类型 |
| 6.2.7 | campaignStatus | 广告活动状态 | string | enabled | Required | 广告活动状态 |
| 6.2.8 | campaignId | 广告活动ID | integer | 123456789 | Required | 广告活动ID |
| 6.2.9 | searchedKeyword | 搜索词 | string | phone case | Required | 搜索词 |
| 6.2.10 | numAdsShown | 曝光次数 | integer | 1000 | Required | 曝光次数 |
| 6.2.11 | numAdsClicks | 广告点击量 | integer | 100 | Required | 广告点击量 |
| 6.2.12 | adSpend | 广告花费 | number | 50 | Required | 广告花费 |
| 6.2.13 | advertisedSkuSales | 直接销售额--广告直接点击归因销售额 | number | 200 | Required | 直接销售额--广告直接点击归因销售额 |
| 6.2.14 | advertisedSkuUnits | 直接销量--广告直接点击归因销量 | number | 10 | Required | 直接销量--广告直接点击归因销量 |
| 6.2.15 | attributedOrders | 广告订单数--归因总订单数 | integer | 10 | Required | 广告订单数--归因总订单数 |
| 6.2.16 | otherSkuSales | 关联销售额--间接归因销售额 | number | 100 | Required | 关联销售额--间接归因销售额 |
| 6.2.17 | otherSkuUnits | 关联销量--间接归因销量 | number | 5 | Required | 关联销量--间接归因销量 |
| 6.2.18 | cpc | 点击成本CPC--计算公式 | number | 0.5 | Required | 点击成本CPC--计算公式: 广告花费 / 点击量 |
| 6.2.19 | ctr | 点击率CTR--计算公式 | number | 10 | Required | 点击率CTR--计算公式: 点击量 / 曝光量 * 100% |
| 6.2.20 | cvr | 转化率CVR--计算公式 | number | 10 | Required | 转化率CVR--计算公式: 广告订单 / 点击量 * 100% |
| 6.2.21 | cpa | 平均订单成本CPA--计算公式 | number | 5 | Required | 平均订单成本CPA--计算公式: 广告花费 / 广告订单 |
| 6.2.22 | adSpendPercent | adSpendPercent | number | 10 | Required | 广告花费占比 = 当前行adSpend / 汇总行adSpend * 100% |
| 6.2.23 | numAdsShownPercent | numAdsShownPercent | number | 10 | Required | 曝光量占比 = 当前行numAdsShown / 汇总行numAdsShown * 100% |
| 6.2.24 | numAdsClicksPercent | numAdsClicksPercent | number | 10 | Required | 点击占比 = 当前行numAdsClicks / 汇总行numAdsClicks * 100% |
| 6.2.25 | attributedOrdersPercent | attributedOrdersPercent | number | 10 | Required | 广告订单占比 = 当前行attributedOrders / 汇总行attributedOrders * 100% |
| 6.2.26 | advertisedSkuSalesPercent | advertisedSkuSalesPercent | number | 10 | Required | 直接销售额占比 = 当前行advertisedSkuSales / 汇总行advertisedSkuSales * 100% |
| 6.2.27 | advertisedSkuUnitsPercent | advertisedSkuUnitsPercent | number | 10 | Required | 直接销量占比 = 当前行advertisedSkuUnits / 汇总行advertisedSkuUnits * 100% |
| 6.2.28 | otherSkuSalesPercent | otherSkuSalesPercent | number | 10 | Required | 关联销售额占比 = 当前行otherSkuSales / 汇总行otherSkuSales * 100% |
| 6.2.29 | otherSkuUnitsPercent | otherSkuUnitsPercent | number | 10 | Required | 关联销量占比 = 当前行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.
Qeasy ships with prebuilt adaptation for this API — contact us to start configuring data integration.