Reporting Keys and Values

u-Slicer API Keys

The following list of available u-Slicer Keys can be found using the info endpoint. Each of these can be used to query your trading data.

Important

The data for certain keys is automatically compressed in u-Slicer to allow for performant data storage and retrieval. The compressed keys are listed in the Data Compressed column and will have a confidence range value attached to any data returned for them.

The more important keys required for publisher payouts and troubleshooting activities are not compressed. If you select only uncompressed keys for your API queries, the results you obtain will be exact. Adding a compressed key to a query will make the result compressed. You can estimate the precision of any values returned by such queries by applying the confidence_range to the returned data values.

Note

Fields marked with an asterisk are compressed.

The only exception is the Publisher Domain field, classified as compressed when adding other granularities beyond country and day. The Publisher Domain field is exact if used by itself or used together with country and day.

u-Slicer Keys

UI Field

API Field

Description

Agency seat ID *

agency_seat_id

The seat ID behind the DSP

App Bundle *

app.bundle

Specifies the app bundle

Bad Request Reason *

bad_request_reason

Indicates the reasons why a request is considered bad and how many such requests were dropped.

Demand Type

bid.demand_type

Indicates the demand type, e.g. RTB for Open RTB bidders

Broker

broker_id

Indicates the broker company name that the impression / bid / revenue is associated with.

CCPA Status *

ccpa

Indicates the User CCPA opt-in/out status associated with requests

Client AB test group

client_ab_test_group

If A/B testing is being tried, this field allows test groups to be compared.

Creative Size

creative_size

Indicated data broken down using the selected creative sizes, e.g. 300x250

Grid Curator

curator_name

The Grid curator that packaged the deals

Deal

deal_id

Specifies the Deal ID as used in the The MediaGrid UI

Demand Source New

demand_source_new

Indicates the Buyer that purchased the inventory

DSP Creative *

dsp.creative_id

The creative ID returned by the Buyer

Landing Page Domain *

dsp.landing_page_domain

Specifies the Ad’s landing page.

GDPR Status *

gdpr.status

Indicates the User GDPR consent status associated with each request

GDPR Version *

gdpr.version

Indicates the version of the TCF Framework.

Day

granularity_day

Returns data broken down by day.

day and hour

granularity_hour

Returns data broken down by day and hour

Month

granularity_month

Returns data broken down by month.

Quarter

granularity_quarter

Returns data broken down by quarter.

Week

granularity_week

Returns data broken down by week.

Year

granularity_year

Returns data broken down by year.

Grid DSP ID

grid_dsp_id

Indicates the Buyer behind The MediaGrid who bought the impression.

Grid Supply Deal

grid_supply_deal

Specifies the Grid Deal ID

hour

hour

Returns data in an hourly format

Inventory Type

inventory_type

Indicates whether the impression was app or site, returns the following values: application or website

Is AMP *

is_amp

Indicates the AMP (Accelerated Mobile Pages) status of request

Account

publisher.account_id

Indicates the Publisher Account

Ad Unit

publisher.ad_unit_id

name and id(UID) of an ad unit

Ads.txt id

publisher.ads_txt_id

Specifies the Ads.txt entry on the publisher site

Publisher Domain

publisher.domain

Specifies the domain that the publisher represents, e.g. forbes.com

Publisher External ID

publisher.external_id

Specifies the publisher’s external ID

Publisher

publisher.id

Specifies the Publisher name, e.g. MediaVine

Media Type

publisher.media_type

Indicates the inventory content type, i.e. video, display, or native

Video Placement Type *

publisher.placement

Specifies the video placement type. This can take the following values:

  • 1: In-stream. Played before, during or after the streaming video content that the consumer has requested (e.g., Pre-roll, Mid-roll, Post-roll).

  • 2: In-banner. Exists within a web banner that leverages the banner space to deliver a video experience as opposed to another static or rich media format. The format relies on the existence of display ad inventory on the page for its delivery.

  • 3: In-article. Loads and plays dynamically between paragraphs of editorial content; existing as a standalone branded message.

  • 4: In-feed. Found in content, social, or product feeds.

  • 5: Interstitial/Slider/Floating. Covers the entire or a portion of screen area, but is always on screen while displayed (i.e. cannot be scrolled out of view). Note that a full-screen interstitial (e.g., in mobile) can be distinguished from a floating/slider unit by the imp.instl field.

Supply Bid Amount Bucket CPM

supply_bid_amount_bucket

The CPM broken down into price ranges.

Supply Source

supply_source

Indicates the source from where the inventory was sources, e.g. hb for header bidding, or hbjson for Header Bidding using OpenRTB

Browser *

user.agent.browser.name

Specifies the browser name, e.g Chrome

Browser Version *

user.agent.browser.version

Specifies the browser name and version, e.g Chrome_78

Device Maker *

user.agent.device.maker

Specifies the device model, e.g. samsung

Device Model *

user.agent.device.model

Specifies the device model, e.g. Samsung_Nexus_10

Device Type *

user.agent.device.type

Specifies the device type, e.g. phone

OS *

user.agent.os.name

Specifies the Operating System, e.g. Android

OS Version *

user.agent.os.version

Specifies the Operating System Version, e.g. OSX_10.12

City *

user.geo.city

Specifies the city in which the impression was displayed

Country

user.geo.country

Specifies the country in which the impression was displayed

Country Region *

user.geo2.subdivision_1

Indicates the country subdivision where the inventory was sold, i.e. state, provence, or department etc, e.g. California or Western Australia

Region Subdivision *

user.geo2.subdivision_2

Indicates the secondary level subdivision where the inventory was sold, i.e. county, or possibly smaller city etc, e.g. Limerick

User Is Matched

user.is_matched

Used to asses the percentage of matched users.

Languages *

user_languages

The user language

Vast Error Code *

vast_err_code

The VAST error code returned from a troubled video impression

u-Slicer API Data Fields

u-Slicer Data Fields

API Field

UI Field

Description

ads_served

The MediaGrid bids

Returns bids submitted to The MediaGrid publisher

bad_requests

Bad Requests

Returns incoming ad requests from the Publisher that failed The MediaGrid validation rules

curation_bid_offers

Deal bid offers

Returns bid offers to DSPs containing deal IDs

custom_column_19433

Fill Rate %

Returns the data filtered by the fill rate

custom_column_26095

Response Rate

Returns the data filtered by the response rate

custom_column_26245

Net Media eCPM

Returns the data filtered by Net Media eCPM

custom_column_40323

MRC Viewability %

Viewability percentage calculated as viewable imps / all imps, viewability is measured following the MRC standard

  • Use Seat –> The MediaGrid as the key to get data on this metric

custom_column_40325

GroupM Viewability %

Viewability percentage calculated as viewable imps / all imps, viewability is measured following the GroupM standard standard

  • Use Seat –> The MediaGrid as the key to get data on this metric

expired_imps

Expired Imps

Returns impressions fired on the publisher’s page after the expiration window closed. The default impressions expiration window for The MediaGrid is 5 mins. However, it can be controlled by The MediaGrid internal team per account level per Client’s request.

fallbacks

Fallbacks

Returns the data filtered by fallbacks

header_nobids

Header Nobids

Returns the data filtered by lack of bid responses on header bidding inventory

imps

Imps

Returns the data filtered by impressions

imps_viewable

Imps MRC Viewable

Returns the amount of viewable impressions based on MRC viewability measurement methodology. The viewability data is available for demand coming from any The MediaGrid Curators and for Publisher Deals

  • Use Seat –> The MediaGrid as the key to get data on this metric

imps_groupm_viewable

Imps GroupM Viewable

Returns the amount of viewable impressions based on GroupM viewability measurement methodology. The viewability data is available for demand coming from any MediaGrid Curators and for Publisher Deals

  • Use Seat –> The MediaGrid as the key to get data on this metric

media_revenue_cpm

Media Revenue eCPM

Returns the data filtered by Gross Media CPM

noads

Noads

Returns the data filtered by No Ads

pub_payout

Net Media Revenue

Returns the data filtered by Net Media Revenue

supply_nobids

Supply Nobids

Returns the data filtered by the number

total_traffic

Total Traffic

Returns the data filtered by the number of Ads Served

vast_errors

Vast Errors

Videos which triggered VAST errors

vast_event_complete

Vast Event Complete

Videos which triggered the VAST complete event

vast_event_firstQuartile

Vast Event First Quartile

Videos which triggered the VAST firstQuartile event

vast_event_midpoint

Vast Event Midpoint

Videos which triggered the VAST midPoint event

vast_event_start

Vast Event Start

Videos which triggered the VAST start event

vast_event_thirdQuartile

Vast Event Third Quartile

Videos which triggered the VAST thirdQuartile event

win_rate

Win Rate %

Returns the data filtered by win rate