Common API Queries

The following common business reports will return the relevant data from slicer when the POST payload contains the example query. See the Query Endpoint endpoint for more details.

Daily spend

{
  "data_fields": [
    "imps",
    "payout.actual_pub"
  ],
  "end_date": "2021-02-21",
  "include_mappings": 1,
  "need_others": 1,
  "order_by": {
    "direction": "DESC",
    "name": "granularity_day"
  },
  "slicer_name": "<name: ask Account Manager>",
  "project_name": "<name: ask Account Manager>",
  "token": "<token>",
  "split_by": [
    "granularity_day",
    "bid_context_wrapper.bid.ssp"
  ],
  "start_date": "2021-02-08"
}

Daily spend and imps per Supplier

{
  "data_fields": [
    "payout.actual_pub"
  ],
  "end_date": "2021-02-21",
  "include_mappings": 1,
  "need_others": 1,
  "order_by": {
    "direction": "ASC",
    "name": "granularity_day"
  },
  "slicer_name": "<name: ask Account Manager>",
  "project_name": "<name: ask Account Manager>",
  "token": "<token>",
  "split_by": [
    "granularity_day"
  ],
  "start_date": "2021-02-08"
}

CTR and Spend Per Campaign

{
  "data_fields": [
    "imps",
    "clicks",
    "ctr",
    "payout.actual_pub"
  ],
  "end_date": "2021-02-21",
  "include_mappings": 1,
  "need_others": 1,
  "order_by": {
    "direction": "DESC",
    "name": "ctr"
  },
  "slicer_name": "<name: ask Account Manager>",
  "project_name": "<name: ask Account Manager>",
  "token": "<token>",
  "split_by": [
    "bid_context_wrapper.demand.campaign_id",
    "bid_context_wrapper.bid.ssp"
  ],
  "start_date": "2021-02-08"
}

Deal Reporting split by Creative

{
  "data_fields": [
    "imps",
    "bids",
    "win_rate",
    "payout.actual_pub"
  ],
  "end_date": "2021-03-09",
  "filters": [
    {
      "case_insensitive": true,
      "match": "equals",
      "name": "bid_context_wrapper.demand.deal_id",
      "search_mappings": true,
      "value": [
        "DEAL-ID-123"
      ]
    }
  ],
  "include_mappings": 1,
  "need_others": 1,
  "order_by": {
    "direction": "DESC",
    "name": "imps"
  },
  "slicer_name": "<name: ask Account Manager>",
  "project_name": "<name: ask Account Manager>",
  "token": "<token>",
  "split_by": [
    "bid_context_wrapper.demand.creative_id"
  ],
  "start_date": "2021-02-24"
}

Line Item Reporting per Campaign

{
  "data_fields": [
    "imps",
    "bids",
    "win_rate",
    "payout.actual_pub"
  ],
  "end_date": "2021-03-09",
  "filters": [
    {
      "case_insensitive": true,
      "match": "equals",
      "name": "bid_context_wrapper.demand.campaign_id",
      "search_mappings": true,
      "value": [
        "7"
      ]
    }
  ],
  "include_mappings": 1,
  "need_others": 1,
  "order_by": {
    "direction": "DESC",
    "name": "imps"
  },
  "slicer_name": "<name: ask Account Manager>",
  "project_name": "<name: ask Account Manager>",
  "token": "<token>",
  "split_by": [
    "bid_context_wrapper.demand.line_item_id"
  ],
  "start_date": "2021-02-24"
}