文档
测试

3.查看计划投放数据-万象

GET
http://open-data.bilibili.co/dataplatform/stat/svc/ad/board/boardAccountCampaign

接口描述

获取计划相关信息。返回指定账户的计划详情及投放数据

请求参数

参数名
类型
描述
必填
account_id
Integer
账号id
必填
campaign_ids
List
计划id列表
可选
status_list
List
计划状态列表 1:有效, 2:已暂停, 3:已结束, 4:已删除, 5:预算超限
可选
start_time
String
查询的起始时间,yyyyMMdd格式
必填
end_time
String
查询的起始时间,yyyyMMdd格式 时间范围不能⼤于7天
必填
filter_show_account
Integer
是否过滤曝光点击均为0的计划,不填默认不过滤
可选
sort_field
String
排序的字段 仅⽀持 "cost": , "show_count": , "click_count": , "click_rate": , "cost_per_click" , "average_cost_per_thousand": 总 花费、展示量、点击量、点击率、单次点击价格、千次展示价格
可选
sort_type
Integer
"0-正序, 1-倒序", 默认desc
可选
page
Integer
⻚数,从1开始,默认为1
可选
size
Integer
每⻚数量,默认15,最多100
可选

响应数据

表名: 计划投放表 **展示字段:** account_id : 账户id username:账户名 campaign_id: 计划id campaign_name: 计划名称 status_desc:计划状态 budget:预算 cost: 总消费 show_count: 广告曝光 click_count: 广告点击 click_rate: 点击率 order_count: 支付UV todo_new_order_count: 支付新客 todo_old_order_count: 支付老客 order_payment: 支付用户GMV todo_new_order_payment: 新客GMV todo_old_order_payment: 老客GMV cac: CAC new_cac: 新客CAC old_cac: 老客CAC goods_roi: ROI new_goods_roi: 新客ROI old_goods_roi: 老客ROI ```json { "msg": "success", "code": 0, "data": { "total": 168, "records": [ { "account_id": 399, "username": "内部电商-商品推广", "campaign_report_list": [ { "campaign_id": 1761508, "campaign_name": "魔力赏-游戏3C-小图-达达2", "speed_mode": 2, "status": 1, "status_desc": "投放中", "budget": 10000000, "cost": 460198.7, "show_count": 37286116, "click_count": 146770, "click_rate": "0.39%", "order_count": 2027, "order_payment": 64217.81, "todo_new_order_count": 0, "todo_new_order_payment": 0, "todo_old_order_count": 2027, "todo_old_order_payment": 64217.81, "cac": 227.03438579181056, "new_cac": 0, "old_cac": 227.03438579181056, "goods_roi": 0.14, "new_goods_roi": 0, "old_goods_roi": 0.1395436579894728, "average_cost_per_thousand": "12.34", "cost_per_click": 3.14, "order_add_count": 2236, "order_add_price": 70867.81, "goods_conversion_rate": "1.38%" }, { "campaign_id": 1972605, "campaign_name": "魔力赏-老客-小图-达达", "speed_mode": 2, "status": 1, "status_desc": "投放中", "budget": 10000000, "cost": 193031.95, "show_count": 12636698, "click_count": 104148, "click_rate": "0.82%", "order_count": 2306, "order_payment": 74867.76, "todo_new_order_count": 0, "todo_new_order_payment": 0, "todo_old_order_count": 2306, "todo_old_order_payment": 74867.76, "cac": 83.7085646140503, "new_cac": 0, "old_cac": 83.7085646140503, "goods_roi": 0.39, "new_goods_roi": 0, "old_goods_roi": 0.3878516483929214, "average_cost_per_thousand": "15.28", "cost_per_click": 1.85, "order_add_count": 2606, "order_add_price": 83188.76, "goods_conversion_rate": "2.21%" }, { "campaign_id": 1761243, "campaign_name": "魔力赏-手办-IP-小图-达达1", "speed_mode": 2, "status": 1, "status_desc": "投放中", "budget": 10000000, "cost": 134500.59, "show_count": 6340028, "click_count": 64189, "click_rate": "1.01%", "order_count": 505, "order_payment": 13584, "todo_new_order_count": 0, "todo_new_order_payment": 0, "todo_old_order_count": 505, "todo_old_order_payment": 13584, "cac": 266.33780198019804, "new_cac": 0, "old_cac": 266.33780198019804, "goods_roi": 0.1, "new_goods_roi": 0, "old_goods_roi": 0.10099583949780444, "average_cost_per_thousand": "21.21", "cost_per_click": 2.1, "order_add_count": 587, "order_add_price": 15863, "goods_conversion_rate": "0.79%" } ] } ] } } ```