/pb/openapi/newad/spAdvertiseHourData{
"operation": {
"method": "POST",
"path": "/pb/openapi/newad/spAdvertiseHourData"
},
"protocol": "HTTPS",
"host": "https://openapi.lingxing.com",
"rateLimit": {
"tokenBucketCapacity": 1,
"text": ""
},
"responseExample": {
"code": 0,
"message": "操作成功",
"data": [
{
"profile_id": 2537307927915183,
"report_date": "2024-05-25",
"hour": 9,
"campaign_id": 93889904442110,
"ad_id": 559437347444970,
"asin": "B07VC7ZN6P",
"impressions": 4,
"clicks": 7,
"cost": 5.18,
"same_orders": 1,
"orders": 6,
"same_sales": 36.93,
"sales": 71.82,
"same_units": 3,
"units": 5,
"match_type": "TARGETING_EXPRESSION_PREDEFINED",
"ctr": 1.75,
"cpc": 0.74,
"cvr": 0.8571,
"cpa": 0.86,
"acos": 0.0721,
"roas": 13.86,
"group_id": 332914711385626,
"msku": null,
"targeting_id": 371645786382332,
"targeting": "complements"
}
],
"total": 1,
"error_details": [],
"request_id": "42d2ba31-e50e-44e4-8870-5b4d945a52ae",
"response_time": "2024-05-28 17:31:17"
}
}| No. | Field | Name | Type | Default | Required | Description |
|---|---|---|---|---|---|---|
| 1 | report_date | 报告日期 | string | — | Required | 报告日期,格式:Y-m-d 只能查询最近60天 |
| 2 | campaign_id | 广告活动id | number | — | Required | 广告活动id |
| 3 | campaign_ids | 广告活动id列表 | array<any> | — | Required | 广告活动id列表,最多传50个 |
| 4 | agg_dimension | 聚合维度 | string | — | Required | 聚合维度: ad 广告维度 both_ad_target 广告+投放维度 |
| No. | Field | Name | Type | Default | Required | Description |
|---|---|---|---|---|---|---|
| 1 | code | 状态码 | integer | 0 | Required | 状态码,0 成功 |
| 2 | message | 提示消息 | string | 操作成功 | Required | 提示消息 |
| 3 | error_details | 错误信息 | array<any> | — | Required | 错误信息 |
| 4 | request_id | 请求链路id | string | DHJ9190-7404-9BDF-3F41-01F0401D1315 | Required | 请求链路id |
| 5 | response_time | 响应时间 | string | 2023-02-17 09:59:19 | Required | 响应时间 |
| 6 | total | 总数 | integer | 1 | Required | 总数 |
| 7 | data | 响应数据 | array<object> | — | Required | 响应数据 |
| 7.1 | profile_id | 店铺id | number | 2537307927915183 | Required | 店铺id |
| 7.2 | report_date | 报告日期 | string | 2024-05-25 | Required | 报告日期 |
| 7.3 | hour | 小时 | number | 9 | Required | 小时: 0 表示0-1点之间 1 表示 1-2点之间 以此类推 |
| 7.4 | campaign_id | 广告活动id | number | 93889904442110 | Required | 广告活动id |
| 7.5 | ad_id | 广告id | number | 559437347444970 | Required | 广告id |
| 7.6 | msku | msku | string | — | Required | msku |
| 7.7 | asin | asin | object | B07VC7ZN6P | Required | asin |
| 7.8 | impressions | 曝光量 | object | 4 | Required | 曝光量 |
| 7.9 | clicks | 点击量 | number | 7 | Required | 点击量 |
| 7.10 | cost | 花费 | object | 5.18 | Required | 花费 |
| 7.11 | same_orders | 直接成交订单 | number | 1 | Required | 直接成交订单 |
| 7.12 | orders | 订单数 | number | 6 | Required | 订单数 |
| 7.13 | same_sales | 直接销售额 | number | 36.93 | Required | 直接销售额 |
| 7.14 | sales | 销售额 | number | 71.82 | Required | 销售额 |
| 7.15 | same_units | 直接成交销量 | number | 3 | Required | 直接成交销量 |
| 7.16 | units | 销量 | number | 5 | Required | 销量 |
| 7.17 | match_type | 匹配方式(当聚合维度为 | string | TARGETING_EXPRESSION_PREDEFINED | Required | 匹配方式(当聚合维度为:both_ad_target 该字段有值) |
| 7.18 | targeting_id | 投放id(当聚合维度为 | number | 371645786382332 | Required | 投放id(当聚合维度为:both_ad_target 该字段有值) |
| 7.19 | targeting | 投放表达式(当聚合维度为 | string | complements | Required | 投放表达式(当聚合维度为:both_ad_target 该字段有值) |
| 7.20 | ctr | 点击/曝光 | number | 1.75 | Required | 点击/曝光 |
| 7.21 | cpc | 花费/点击 | number | 0.74 | Required | 花费/点击 |
| 7.22 | cvr | 订单数/点击 | number | 0.8571 | Required | 订单数/点击 |
| 7.23 | cpa | 花费/订单数 | number | 0.86 | Required | 花费/订单数 |
| 7.24 | acos | 花费/销售额 | number | 0.0721 | Required | 花费/销售额 |
| 7.25 | roas | 销售额/花费 | number | 13.86 | Required | 销售额/花费 |
| 7.26 | group_id | 广告组id | number | 332914711385626 | Required | 广告组id |
The SP广告小时数据 API (/pb/openapi/newad/spAdvertiseHourData) 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.