u-Slicer API Business Queries

For all of the example on this page, you will need to add the Always Required Fields. Contact your Account Manager if you don’t know them.

Daily Impressions and Revenue

Here’s how you can pull your exact impressions and revenue data by day for the past 7 days in the default UTC timezone

{
  "data_fields":[
      "imps",
      "pub_payout",
      "media_revenue_cpm"
  ],
  "end_date":"2020-10-13",
  "include_mappings":1,
  "limit":100,
  "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":"2020-10-07"
}

Daily Imps, Rev, Pubs, TZ

Here’s how you can pull your exact impressions and revenue data by day for the past 7 days split by publisher domain in UTC -5

{
  "data_fields":[
      "imps",
      "pub_payout",
      "media_revenue_cpm"
  ],
  "end_date":"2020-10-13",
  "include_mappings":1,
  "limit":100,
  "need_others":1,
  "order_by":{
      "direction":"DESC",
      "name":"pub_payout"
  },
  "slicer_name":"<name: ask Account Manager>",
  "project_name":"<name: ask Account Manager>",
  "token":"<token>",
  "split_by":[
      "granularity_day",
      "publisher.domain"
  ],
  "start_date":"2020-10-07",
  "timezone":-5
}

Monthly Demand Sources

Here’s how you can pull your sources for the previous month in the default UTC timezone

{
  "data_fields":[
      "imps",
      "pub_payout",
      "media_revenue_cpm"
  ],
  "end_date":"2020-09-30",
  "include_mappings":1,
  "limit":100,
  "need_others":1,
  "order_by":{
      "direction":"DESC",
      "name":"pub_payout"
  },
  "slicer_name":"<name: ask Account Manager>",
  "project_name":"<name: ask Account Manager>",
  "token":"<token>",
  "split_by":[
      "demand_source",
      "granularity_month"
  ],
  "start_date":"2020-09-01"
}

Monthly Billing

Here’s how you can pull your monthly billing numbers, in the default UTC timezone. Note: End of month billing is calculated in UTC

{
  "data_fields":[
      "imps",
      "pub_payout",
      "media_revenue_cpm"
  ],
  "end_date":"2020-09-30",
  "include_mappings":1,
  "limit":100,
  "need_others":1,
  "order_by":{
      "direction":"ASC",
      "name":"granularity_month"
  },
  "slicer_name":"<name: ask Account Manager>",
  "project_name":"<name: ask Account Manager>",
  "token":"<token>",
  "split_by":[
      "granularity_month"
  ],
  "start_date":"2020-09-01"
}

Monthly Billing by Domain

Here’s how you can pull your monthly billing numbers split by domain.

{
  "data_fields":[
      "imps",
      "pub_payout",
      "media_revenue_cpm"
  ],
  "end_date":"2020-09-30",
  "include_mappings":1,
  "limit":100,
  "need_others":1,
  "order_by":{
      "direction":"ASC",
      "name":"granularity_month"
  },
  "slicer_name":"<name: ask Account Manager>",
  "project_name":"<name: ask Account Manager>",
  "token":"<token>",
  "split_by":[
      "publisher.domain",
      "granularity_month"
  ],
  "start_date":"2020-09-01"
}