/pb/openapi/newad/spTargetHourData{
"operation": {
"method": "POST",
"path": "/pb/openapi/newad/spTargetHourData"
},
"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": 23,
"campaign_id": 532580134831120,
"ad_id": 347244425807704,
"asin": "B085M7XMJF",
"match_type": "EXACT",
"impressions": 34,
"clicks": 7,
"cost": 3.52,
"same_orders": 2,
"orders": 1,
"same_sales": 28.89,
"sales": 54.03,
"same_units": 3,
"units": 11,
"ctr": 0.2059,
"cpc": 0.5,
"cvr": 0.1429,
"cpa": 3.52,
"acos": 0.0651,
"roas": 15.35,
"group_id": 287918863539910,
"msku": null,
"targeting_id": 339153487021379,
"targeting": "spotting scope with rangefinder"
}
],
"total": 1167,
"next_token": null,
"error_details": [],
"request_id": "f884f0a6-f1e9-49d1-b144-a85ee4b57ed9",
"response_time": "2024-05-28 17:38:00"
}
}| No. | Field | Name | Type | Default | Required | Description |
|---|---|---|---|---|---|---|
| 1 | report_date | 报告日期 | string | — | Required | 报告日期,格式:Y-m-d 只能查询最近61天(最早为当天往前第61天,最晚为当天,含两端) |
| 2 | campaign_id | 广告活动id | number | — | Optional | 广告活动id,必须为正整数;与campaign_ids至少传入一个,两者会合并去重 |
| 3 | campaign_ids | 广告活动id列表 | array<any> | — | Optional | 广告活动id列表,与campaign_id合并去重后最多50个,元素必须为正整数 |
| 4 | agg_dimension | 聚合维度(区分大小写) | string | — | Required | 聚合维度(区分大小写): target 投放维度 both_ad_target 广告+投放维度 both_target_placement 投放+广告位placement维度 all_ad_target_placement 广告+投放+广告位placement维度 |
| No. | Field | Name | Type | Default | Required | Description |
|---|---|---|---|---|---|---|
| 1 | code | 状态码 | number | 0 | Required | 状态码,0 成功 |
| 2 | message | 提示消息 | string | 操作成功 | Required | 提示消息 |
| 3 | total | 总数(等于data数组的条数) | number | 1167 | Required | 总数(等于data数组的条数) |
| 4 | next_token | 游标分页token | string | — | Required | 游标分页token,本接口无分页,恒为null |
| 5 | error_details | 错误信息 | array<any> | — | Required | 错误信息 |
| 6 | request_id | 请求链路id | string | f884f0a6-f1e9-49d1-b144-a85ee4b57ed9 | Required | 请求链路id |
| 7 | response_time | 响应时间 | string | 2024-05-28 17:38:00 | Required | 响应时间 |
| 8 | data | 响应数据 | array<object> | — | Required | 响应数据 |
| 8.1 | profile_id | 店铺id | number | 2537307927915183 | Required | 店铺id |
| 8.2 | report_date | 报告日期 | string | 2024-05-25 | Required | 报告日期 |
| 8.3 | hour | 小时 | number | 23 | Required | 小时: 0 表示0-1点之间 1 表示 1-2点之间 以此类推 |
| 8.4 | campaign_id | 广告活动id | number | 532580134831120 | Required | 广告活动id |
| 8.5 | ad_id | ad_id | number | 347244425807704 | Required | 广告id【agg_dimension 为 both_ad_target 或 all_ad_target_placement 时返回】 |
| 8.6 | asin | asin | string | B085M7XMJF | Required | 广告对应asin【agg_dimension 为 both_ad_target 或 all_ad_target_placement 时返回;匹配不到广告信息时为null】 |
| 8.7 | msku | msku | string | — | Required | 广告对应msku【agg_dimension 为 both_ad_target 或 all_ad_target_placement 时返回;匹配不到广告信息时为null】 |
| 8.8 | match_type | match_type | string | EXACT | Required | 匹配方式【本接口所有合法聚合维度(target/both_ad_target/both_target_placement/all_ad_target_placement)均返回;数据仅存在于转化表时可能为null】 |
| 8.9 | targeting_id | targeting_id | number | 339153487021379 | Required | 投放id【本接口所有合法聚合维度(target/both_ad_target/both_target_placement/all_ad_target_placement)均返回】 |
| 8.10 | targeting | targeting | string | spotting scope with rangefinder | Required | 投放表达式【本接口所有合法聚合维度(target/both_ad_target/both_target_placement/all_ad_target_placement)均返回;数据仅存在于转化表时可能为null】 |
| 8.11 | placement | placement | string | — | Required | 广告位【agg_dimension 为 both_target_placement 或 all_ad_target_placement 时返回】 |
| 8.12 | impressions | 曝光量(无流量数据时为0) | number | 34 | Required | 曝光量(无流量数据时为0) |
| 8.13 | clicks | 点击量(无流量数据时为0) | number | 7 | Required | 点击量(无流量数据时为0) |
| 8.14 | cost | 花费(无流量数据时为0) | number | 3.52 | Required | 花费(无流量数据时为0) |
| 8.15 | same_orders | 直接成交订单(无转化数据时为0) | number | 2 | Required | 直接成交订单(无转化数据时为0) |
| 8.16 | orders | 订单数(无转化数据时为0) | number | 1 | Required | 订单数(无转化数据时为0) |
| 8.17 | same_sales | 直接销售额(无转化数据时为0) | number | 28.89 | Required | 直接销售额(无转化数据时为0) |
| 8.18 | sales | 销售额(无转化数据时为0) | number | 54.03 | Required | 销售额(无转化数据时为0) |
| 8.19 | same_units | 直接成交销量(无转化数据时为0) | number | 3 | Required | 直接成交销量(无转化数据时为0) |
| 8.20 | units | 销量(无转化数据时为0) | number | 11 | Required | 销量(无转化数据时为0) |
| 8.21 | ctr | 点击/曝光【保留4位小数 | number | 0.2059 | Required | 点击/曝光【保留4位小数;曝光量为0时为null】 |
| 8.22 | cpc | 花费/点击【保留2位小数 | number | 0.5 | Required | 花费/点击【保留2位小数;点击量为0时为null】 |
| 8.23 | cvr | 订单数/点击【保留4位小数 | number | 0.1429 | Required | 订单数/点击【保留4位小数;点击量为0时为null】 |
| 8.24 | cpa | 花费/订单数【保留2位小数 | number | 3.52 | Required | 花费/订单数【保留2位小数;订单数为0时为null】 |
| 8.25 | acos | 花费/销售额【保留4位小数 | number | 0.0651 | Required | 花费/销售额【保留4位小数;销售额为0时为null】 |
| 8.26 | roas | 销售额/花费【保留2位小数 | number | 15.35 | Required | 销售额/花费【保留2位小数;花费为0时为null】 |
| 8.27 | group_id | 广告组id | number | 287918863539910 | Required | 广告组id |
The SP投放小时数据 API (/pb/openapi/newad/spTargetHourData) 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.