跳转至

数据报表接口

接口

获取广告主组基本数据,包括花费、点击量、点击单价等

请求地址

https://openapi.aiclk.com/openapi/v1/report/get

所属权限

ads_read

请求方式

GET

频次限制规则

秒级限制(次)
50

请求参数

请求参数字段:

字段名 类型 必须 描述
account_id number 查询的广告账户ID(广告投放平台的userID)
query string(json object) 查询参数结构体,具体结构如下

query格式:

字段名 类型 必须 描述
start_date string 开始日期,格式YYYY-MM-DD
日期不超过当前日期的365天,与结束日期跨度不超过90天
end_date string 结束日期,格式YYYY-MM-DD
与开始日期跨度不超过90天
level string 按照查询维度填写:(account/campaign/ad_group/creative)
page int 页数
page_size int 每页的数据个数
group_by []string 分组依据(STAT_GROUP_BY_FIELD_STAT_TIME:按时间分组;STAT_GROUP_BY_FIELD_STAT_ID:按ID分组;同时传两个代表按时间和id分组)
time_granularity string 时间粒度:"date"表示天,"hour"表示小时
小时维度数据可查询近7日中一天的数据
fields []string 详细字段见数据报表字段定义
order_field string 排序字段,返回的字段均支持排序
order_type string 排序类型
filtering object 过滤条件,格式为map,
key允许的值包括:campaign_id,adgroup_id,creative_id
value允许的值为int数组:[66666,88888]

query例子

{
    "start_date": "2021-02-01",
    "end_date": "2021-02-01",
    "level": "creative",
    "group_by": [
        "STAT_GROUP_BY_FIELD_STAT_ID",
        "STAT_GROUP_BY_FIELD_STAT_TIME"
    ],
    "time_granularity": "date",
    "fields": [
        "impression",
        "load",
        "stay_10",
        "api_app_active",
        "api_app_register",
        "next_day_open",
        "app_first_pay",
        "api_lp_sform",
        "api_app_other",
        "api_lp_other",
        "js_copywx",
        "js_form_click",
        "api_copy_sign",
        "api_app_lahuo"
    ],
    "order_field": "date",
    "order_type": "asc"
}

请求示例

curl -X GET \
  'https://openapi.aiclk.com/openapi/v1/report/get?account_id=1596469&query={"start_date":"2021-02-01","end_date":"2021-02-01","level":"creative","group_by":["STAT_GROUP_BY_FIELD_STAT_ID","STAT_GROUP_BY_FIELD_STAT_TIME"],"time_granularity":"date","fields":["impression","load","stay_10","api_app_active","api_app_register","next_day_open","app_first_pay","api_lp_sform","api_app_other","api_lp_other","js_copywx","js_form_click","api_copy_sign","api_app_lahuo"],"order_field":"date","order_type":"asc"}' \
  -H 'OGW_ACCESS_TOKEN: your_access_token' \

返回格式:

{
    "code": 200,
    "data": {
        "list": [
            {
                "account_id": "1764081",
                "adgroup_id": "3292000",
                "adgroup_name": "502",
                "api_app_active": 0,
                "api_app_lahuo": 0,
                "api_app_other": 0,
                "api_app_register": 0,
                "api_copy_sign": 0,
                "api_lp_other": 0,
                "api_lp_sform": 0,
                "app_first_pay": 0,
                "campaign_id": "2753897",
                "campaign_name": "剧502-趣头条-列表页-竖版激励-美食-xxx",
                "creative_id": "6800397",
                "creative_name": "502",
                "date": "2021-02-01",
                "impression": 328,
                "js_copywx": 0,
                "js_form_click": 0,
                "load": 22,
                "next_day_open": 0,
                "stay_10": 17
            },
            {
                "account_id": "1764081",
                "adgroup_id": "3484186",
                "adgroup_name": "498_程序化创意",
                "api_app_active": 10,
                "api_app_lahuo": 0,
                "api_app_other": 0,
                "api_app_register": 0,
                "api_copy_sign": 0,
                "api_lp_other": 0,
                "api_lp_sform": 0,
                "app_first_pay": 0,
                "campaign_id": "2923859",
                "campaign_name": "剧498-趣头条-激励视频-xxx程序化创意",
                "creative_id": "7387478",
                "creative_name": "xxxx_2",
                "date": "2021-02-01",
                "impression": 38782,
                "js_copywx": 0,
                "js_form_click": 0,
                "load": 382,
                "next_day_open": 8,
                "stay_10": 347
            }...
        ],
        "page_info": {
            "page": 1,
            "page_size": 100,
            "total_number": 1625
        }
    },
    "message": "success",
    "trace_id": "1322e8c37ddd3db1"
}