/basicOpen/adReport/productOrderAnalysis/list{
"operation": {
"method": "POST",
"path": "/basicOpen/adReport/productOrderAnalysis/list"
},
"protocol": "HTTPS",
"host": "https://openapi.lingxing.com",
"rateLimit": {
"tokenBucketCapacity": 1,
"text": ""
},
"requestExample": "curl --location 'https://openapi.lingxing.com/basicOpen/adReport/productOrderAnalysis/list?access_token=value&app_key=value&sign=value×tamp=value' \\\n--header 'Content-Type: application/json' \\\n--data '{\n \"sid\": \"1\",\n \"sku\": [\"DEE-1020\",\"PEE-7\"],\n \"start_date\": \"2024-09-20\",\n \"end_date\": \"2024-09-26\",\n \"group_type\": \"hourly\",\n \"sponsored_type\": [\"sp\"]\n}'",
"responseExample": {
"code": 0,
"message": "success",
"error_details": [],
"request_id": "c2d091a6ed6a4c78b558bda2816a4346.1727338836028",
"response_time": "2024-09-26 16:20:36",
"data": {
"list": [
{
"key": "sub_total",
"store_orders": "0",
"store_orders_percent": "--",
"store_units": "0",
"store_units_percent": "--",
"store_sales": "0",
"store_sales_percent": "--",
"ad_orders": "0",
"ad_orders_percent": "--",
"ad_sales": "0",
"ad_units": "0",
"ad_units_percent": "--",
"spend": "0",
"impressions": "0",
"clicks": "0",
"ad_sales_percent": "--",
"spend_percent": "--",
"acos": "--",
"ad_spend_store_percent": "--",
"ad_order_store_percent": "--",
"as_sales_store_percent": "--",
"ad_units_store_percent": "--",
"impression_percent": "--",
"clicks_percent": "--",
"roas": "--",
"ctr": "--",
"cpc": "--",
"cvr": "--",
"cpa": "--",
"key_chart": "汇总",
"key_table": "汇总"
}
]
},
"total": 0
}
}| No. | Field | Name | Type | Default | Required | Description |
|---|---|---|---|---|---|---|
| 1 | sid | sid | string | — | Required | sid |
| 2 | profile_id | VC广告店铺profile_id | integer | — | Required | VC广告店铺profile_id,对应查询广告账号列表接口对应字段【profile_id】,sid跟profile_id其中一个必填 |
| 3 | sku | msku最多10个 | array<any> | — | Required | msku最多10个 |
| 4 | start_date | 开始日期 | string | — | Required | 开始日期,格式:Y-m-d |
| 5 | end_date | 结束日期 | string | — | Required | 结束日期,格式:Y-m-d |
| 6 | group_type | 时间维度 | string | — | Required | 时间维度 hourly 按小时 weekly 按周 |
| 7 | sponsored_type | 广告类型 | array<any> | — | Optional | 广告类型 sp sd |
| 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 | f8411a4fc19148348c7499b3f619c811.1727251040129 | Required | 请求链路id |
| 5 | response_time | 响应时间 | string | 2024-09-25 15:57:20 | Required | 响应时间 |
| 6 | data | 响应数据 | object | — | Required | 响应数据 |
| 6.1 | list | list | array<object> | — | Required | |
| 6.1.1 | key | key | string | sub_total | Required | sub_total 汇总行 group_type= hourly 时对应小时 group_type =weekly 对应周 |
| 6.1.2 | store_orders | 店铺订单 | string | 4934 | Required | 店铺订单 |
| 6.1.3 | store_orders_percent | 店铺订单百分比 | string | 100 | Required | 店铺订单百分比 |
| 6.1.4 | store_units | 店铺销量 | string | 4934 | Required | 店铺销量 |
| 6.1.5 | store_units_percent | 店铺销量百分比 | string | 100 | Required | 店铺销量百分比 |
| 6.1.6 | store_sales | 店铺销售额 | string | 14500.57 | Required | 店铺销售额 |
| 6.1.7 | store_sales_percent | 店铺销售额百分比 | string | 100 | Required | 店铺销售额百分比 |
| 6.1.8 | ad_orders | 广告订单 | string | 4218 | Required | 广告订单 |
| 6.1.9 | ad_orders_percent | 广告订单百分比 | string | 100% | Required | 广告订单百分比 |
| 6.1.10 | ad_sales | 广告销售额 | string | 12175.52 | Required | 广告销售额 |
| 6.1.11 | ad_units | 广告销量 | string | 4218 | Required | 广告销量 |
| 6.1.12 | ad_units_percent | 广告销量百分比 | string | 100% | Required | 广告销量百分比 |
| 6.1.13 | spend | 花费 | string | 4404.64 | Required | 花费 |
| 6.1.14 | impressions | 曝光 | string | 51991 | Required | 曝光 |
| 6.1.15 | clicks | 点击 | string | 4684 | Required | 点击 |
| 6.1.16 | ad_sales_percent | 广告销售额百分比 | string | 100 | Required | 广告销售额百分比 |
| 6.1.17 | spend_percent | 花费百分比 | string | 100 | Required | 花费百分比 |
| 6.1.18 | acos | acos | string | 36.18% | Required | acos |
| 6.1.19 | ad_spend_store_percent | 广告花费占比 | string | 30.38 | Required | 广告花费占比 |
| 6.1.20 | ad_order_store_percent | 广告订单占比 | string | 85.49 | Required | 广告订单占比 |
| 6.1.21 | as_sales_store_percent | 广告销售额占比 | string | 83.97 | Required | 广告销售额占比 |
| 6.1.22 | ad_units_store_percent | 广告销量占比 | string | 85.49 | Required | 广告销量占比 |
| 6.1.23 | impression_percent | 曝光百分比 | string | 100 | Required | 曝光百分比 |
| 6.1.24 | clicks_percent | 点击百分比 | string | 100 | Required | 点击百分比 |
| 6.1.25 | roas | roas | string | 2.76 | Required | roas |
| 6.1.26 | ctr | ctr | string | 9.01% | Required | ctr |
| 6.1.27 | cpc | cpc | string | 0.94 | Required | cpc |
| 6.1.28 | cvr | cvr | string | 90.05% | Required | cvr |
| 6.1.29 | cpa | cpa | string | 1.04 | Required | cpa |
| 6.1.30 | key_chart | key_chart | string | — | Required | group_type= hourly 对应小时的描述 group_type =weekly 周的描述 |
| 6.1.31 | key_table | key_table | string | — | Required | group_type= hourly 对应小时的描述 group_type =weekly 周的描述 |
| 7 | total | total | integer | 0 | Required |
The 出单时段分析(产品) API (/basicOpen/adReport/productOrderAnalysis/list) 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.