Data Dictionary for SSP Sellers

The report designer provides many options for dimensions and metrics to use when creating custom reports. Reports are broken out by dimensions and metrics.

Dimensions

Metrics

Dimensions are aspects used to slice metric data. These are your "pivots" or ways  to breakdown the data

Example: Site, Country

Metrics are numerical data accumulated and stored in our system. These are real statistics, such as total ad impressions, which can be broken out by the dimensions selected.

Example: Net Revenue, Ad Requests

 

SSP Terminology: Reporting Terms Mapping for Video SSP Sellers

Reporting Dimensions for Sellers

Reporting Metrics for Sellers

 

 

Reporting Dimensions for Sellers

Ads

Dimension

Reporting API field

Description

Metrics Available

Ad Tag

adTag1M

The name of the Ad Source or default RTB Profile

Clicks, CTR, Impressions, Impressions (includes Passbacks), Fill Rate, Bid Requests, Fraudulent Impressions, Ads Sent, Invalid Net Revenue, Net eCPM, Net Revenue, Net RPM, Win Rate

Ad Tag ID

adTagGUID1M

The external ad tag id

Same metrics as ad tag

Ad Tag ID (internal)

adTagId1M

The internal unique identifier for an ad source or default RTB Profile

Same metrics as ad tag

Advertiser Domain

advertiser1M

Domain of the advertiser for whom the bid was won

Impressions, Fraudulent Impressions, Ads Sent, Invalid Net Revenue, Net eCPM, Net Revenue, Win Rate
Alias positionAlias1M Custom field identifier for a placement configured by a user. An alias can be used to group placements in reports. All metrics except In-View metrics
App Bundle appBundleName1M An application identifier that is unique to an app and independent of the exchange. On Android , this should be a bundle package name. On iOS, it is a numeric ID Clicks, Impressions, Invalid Net Revenue, Net eCPM, Net Revenue
App/Site site1M Name of site as configured in the SSP All metrics
App/Site ID siteId1M Internal unique identifier for an app/site All metrics

App/Site ID (DCN)

siteDcn1M

External ID for an app/site

All metrics

Bidder

bidder1M

Name of the bidder account. A bidder is a regional endpoint for a DSP.

Impressions, Fraudulent Impressions, Ads Sent, Invalid Net Revenue, Net eCPM, Net Revenue, Win Rate

Bidder ID

bidderId1M

Internal unique identifier for bidder

Same metrics as bidder
Bid Request Filter Reason prebidFilterReason1M Reason why a bid request was filtered Bid Requests (Filtered)
Bid Status Category postBidStatusCategoryName1M Indicates whether the bid was the winning bid for the auction, or if the bid was not the winning bid, the reason why the bid lost the auction Bids

Buyer Seat

seatName1M

The name assigned to the buyer seat provided on the seat level bid. Represents the buyer on whose behalf the bid is made.

Impressions, Fraudulent Impressions, Ads Sent, Invalid Net Revenue, Net eCPM, Net Revenue, Win Rate
Buyer Seat ID seatId1M The buyer seat provided on the seat level bid. Represents the buyer on whose behalf the bid is made. Impressions, Fraudulent Impressions, Ads Sent, Invalid Net Revenue, Net eCPM, Net Revenue, Win Rate
Buyer Seat ID (Internal) internalSeatId1M Internal unique identifier for a buyer seat Same metrics as Buyer seat
Current Deal Price dealPrice1M The current value of floor or fixed price set for the deal. This price will be used to evaluate deal bids in an auction. Same metrics as deal
Current Deal Price Type dealPriceTypeName1M Indicates the pricing associated with the Deal. Floor Price value = the price entered is the minimum bid price accepted for the Deal. Fixed Price value = the Deal will always be evaluated at the price value entered, as long as the bid price is equivalent to or above that price. Same metrics as deal
Current Deal Priority dealTierName1M The current setting for the priority tier of a deal. In the auction, a high priority type deal will win over a bid from a lower priority type. The priorities are Open (lowest), Priority, and VIP (highest) Same metrics as deal

Deal

deal1M

Name of deal

Impressions, Fraudulent Impressions, Ads Sent, Invalid Net Revenue, Net eCPM, Net Revenue, Win Rate

Deal ID

dealId1M

Unique identifier of a deal

Same metrics as deal

DSP

buyer1M

Name of Demand Side Platform (DSP); the parent account for the bidder

Impressions, Fraudulent Impressions, Ads Sent, Invalid Net Revenue, Net eCPM, Net Revenue, Win Rate

DSP ID

buyerId1M

Internal unique identifier for a DSP

Same metrics as DSP

Exchange/Mediation Partner

adSource1M

Indicates the ad source type and whether the ad provided is sourced via programmatic demand from the Yahoo exchange or via an ad network partner

Ads Sent,Clicks, CTR, Impressions, Impressions (includes Passbacks), Fill Rate, Bid Requests, Invalid Net Revenue, Net eCPM, Net Revenue, Net RPM, Win Rate

Exchange/Mediation Partner ID

adSourceId1M

Internal unique identifier for an ad source type

Same metrics as exchange/mediation partner

Header Bidding

headerBidding1M

Indicates whether the winning bid from the auction will be used to submit a bid into an upstream header bidding auction

All metrics

Impression Group

impressionGroup1M

Impression groups provide a method to group impressions under a specific Site for reporting, based on a value passed on the inbound request. Ad Requests, Ad Sent, Bots, Clicks, CTR, Fill Rate, Fraudulent Ad Requests, Impressions (includes Passbacks), All TCF 2.0 metrics
Integration Partner hbPartnerName1M For Sellers who are integrated via a Server to Server (s2s) header bidding connection, this field provides the name of the exchange that sent the request to the Yahoo SSP (e.g., Google Open Bidding, MoPub, Amazon TAM) Ad Requests, Ads Sent, Bots, Clicks, CTR, Impresssions, Impressions (includes Passbacks), Fill Rate, Fraudulent Ad Requests, Fraudulent Impressions, Invalid Net Revenue, Net eCPM, Net Revenue, Net RPM, All TCF 2.0 metrics, Win Rat
Integration Partner ID hbPartnerId1M Internal unique identifier for header bidding partner Same metrics as HB Partner
Net Bid Price Bucket netBidPriceBuckets1M Grouped net bid prices sent by bidders during an auction Bids, Clicks, Impressions, Net eCPM, Net Revenue, Video Attempts, Video Completes, Video Starts
Page URL pageUrl1M URL of the page in which the ad will be shown sent on the incoming ad request. If page url is not sent on the incoming ad request, the page URL will be null (N/A). Ad Requests , Ads Sent, Impressions, Fill Rate, Net eCPM, Net Revenue, Win Rate

Placement

position1M

Placement ID as configured in the SSP

All metrics

Placement ID

positionId1M

Internal unique numeric identifier of a placement

Same metrics as placement

Placement Type

placementType1M

Indicates the type of placement (ex: Banner, Video, etc.)

Same metrics as placement

Seller

sellerName1M

Publisher name

All metrics
Seller ID sellerId1M Internal unique identifier for a publisher Same metrics as seller

Source Type

sourceType1M

Indicates whether the impression was filled by demand from Open RTB or a Mediation partner

Ads Sent, Bid Requests, Clicks, CTR, Fill Rate, Fraudulent Ad Requests, Invalid Net Revenue, Net eCPM, Net Revenue, Net RPM, Win Rate
Winning Creative ID winningCreativeId1M The creative ID provided by the DSP on the seat level bid that won the auction. A creative ID may represent different creatives across bidders. Clicks, Impressions, Net eCPM, Net Revenue, Video Attempts, Video Completes, Video Starts

 

Date and Time

Dimension

Reporting API field

Description

Metrics Available

Date

scaledDay1M

Day formatted to MM/DD/YYYY)

All metrics

Hour

scaledDayHourly1M

Hour of the day formatted to 0-23

Ad Requests, Ads Sent, Bots, Clicks, CTR, Fill Rate, Fraudulent Ad Requests, Fraudulent Impressions, Impressions, Impressions (includes Passbacks), Invalid Net Revenue, Net eCPM, Net Revenue All TCF 2.0 metrics

Month

scaledMonth1M

Month formatted to month’s full name (ex: January)

All metrics except in-view

 

Device/OS/Browser

Dimension

Reporting API field

Description

Metrics Available

Device Model Group

deviceModelGroupName1M

The model group of the device through which the user is interacting. If the SS  received an impression event more than 10 minutes after the auction occurred, the device model group cannot be determined and  the count will be bucketed under Impressions for the Other value. This can cause a higher Impression count than Ads Sent for the Other group.

All metrics except in-view

Device Type

deviceTypeName1M

The type of device through which the user is interacting. If the SSP  received an impression event more than 10 minutes after the auction occurred, the device type cannot be determined and the count will be bucketed under Impressions. This can cause a higher Impression count than Ads Sent for the Connected Device value.

All metrics except in-view

Operating System

os1M

The operating system (OS) for the user’s device

All  metrics except in-view, Requests to Exchange/Mediation Partners  Ad Source, Fill Rate (Ads Sent)Served | Out)

 

Geo

Dimension

Reporting API field

Description

Metrics Available
Country country1M Name of the country where the user or device is located. Ad Requests, Ads Sent, Clicks, Fill Rate, Fraudulent Impressions, Impressions, Impressions (includes Passbacks), Invalid Net Revenue, Net eCPM, Net Revenue, Net RPM, All TCF 2.0 metrics

Country Code

countryCode

Country abbreviated to ISO code (ex: USA)

Same metrics as country

 

Other

Dimension

Reporting API field

Description

Metrics Available
Custom Key 01 - 25 customKey18Value_1m (replace the #18 with each key 1- 20) This dimension is used for a key-value pair set up in the SSP. A Key-value pair (KVP) is a set of custom data sent to the SSP from the publisher’s ad call. If the SSP is set up to capture and report on this data, the values will be added into one of these dimensions. The dimension name maps to the Reporting Dimension Name set in the SSP key-value pair UI. Ad Requests, Ads Sent, Bots, Clicks, CTR, Fill Rate, Fraudulent Ad Requests, Impressions, Impressions (includes Passbacks, Net Revenue, Win Rate

 

Bid Status Category Value Definitions

Name

Description

Win 

Bid won the auction

Lost

Bid lost to another bid

Insufficient Bid

Bid does not meet reserve price of the opportunity

Markup Delivery Failure

Bid filtered because the SSP is unable to receive the creative markup.

Unscreenable

Bid filtered based on the seller configuration, a bid may be blocked if missing information that is used in Ad Screening (e.g., advertiser domain or iurl)

Ad Screened

Bids filtered because the creative is blocked by the SSP’s ad screening tool

Advertiser Block

Bids filtered because the seller blocked the advertiser domain (adomain) provided on the bid response

Category Block

Bids filtered because the seller blocked the IAB Category provided on the bid response or the creative has been classified with an IAB category that the seller has chosen to block using the SSP's creative review service

Attributes Block

Bid filtered because the creative has attributes outlined in the OpenRTB spec that are blocked for that placement.

Exchange Wide Block

Bid filtered because either the Creative ID, Campaign ID, Seat ID or Adomain has been blocked across the exchange

Creative Malware Block

Bid filtered because the creative is flagged as malware

Nonsecure For Secure Block

Bid filtered because the creative has been identified as making a non-secure call and the ad request is a secure request

Creative Not Reviewed Block

Bid filtered because the creative has not yet been reviewed by the SSP's creative review service and review is required by the seller

Creative ID Missing

Bid filtered because the Creative ID is missing from the bid

Creative Dedup Block

Bid filtered because the seller blocked the exact same creative from running twice on the page at the same time

Creative Adfeedback Block

Bid filtered because the creative has been blocked due to the user’s previous ad feedback and cannot be shown again to that user within a 30 days time window

Adomain Adfeedback Block

Bid filtered because the adomain has been blocked due to the user’s previous ad feedback and cannot be shown again to the user within a 30 days time window

Creative Spec Block

Bid filtered because the creative has been assigned a custom attribute by the SSP's creative review service and the seller has chosen to block creatives with that specific attribute

Creative Beacon Block

Bid filtered because the creative has a beacon or pixel call the seller has chosen to block

Unscreenable No Domain

Bid filtered because the creative URL is missing from the bid

Creative Ban Block

Bid filtered because the creative has been banned by the platform due to a violation of our ad policy

Buyer Seat Block

Bid filtered because the buyers seat has been disabled (due to low spend or malware) or the buyer seat is not allowed by the seller or deal

Creative Language Block

Bid filtered because the creative has been assigned a language value (e.g., French, Spanish) by the SSP's creative review service that is not allowed by the seller

Creative GDPR Block

Bid is blocked from serving in EMEA due to the creative containing one or more pixels that are not GDPR compliant

Currency Mismatch

Bids filtered due to invalid currency

Native Invalid

Bid filtered because the creative is not using a valid native format

Multi Ad Size Mismatch

Bid filtered because the creative is not a valid ad size for that inventory (multi-size may have more than one valid ad size)

Creative Political Block

Bid filtered because the creative has been tagged as a political ad

Invalid Creative Block

Bid filtered because the creative is not using a valid native format

Unscannable Creative Block

Bid filtered because the creative format is not supported by the SSP’s creative review service

Vast Version Mismatch

Bid filtered because the vast version of the creative does not match the vast versions supported by the publisher

Ad Strict Approval

Bid filtered because the publisher has not approved the creative

Missing Video Creative Duration

Creative Duration not present in Video Bid Response

Video Format Mismatch - VPAID Response

Inventory Format is VAST however the bid response has aVPAID creative

 

Reporting Metrics for Sellers

Ads

Metric

Reporting API field

Description

Ad Requests requestsIn1M Count of inbound requests to the SSP for an ad.

Ads Sent

adsServed1M

Count of ad requests to the Yahoo Exchange that resulted in a won auction

Ads Sent (includes Passbacks) adsServedWithPassbacks1M Count of requests to the Yahoo that had an auction winner or a passback occurred.
Bid Requests requestsOut1M Count of requests sent to bidders during an auction
Bid Requests (Filtered) requestFiltered1M Count of bid requests filtered out prior to being sent out to a bidder. Calculated using 10% sampling data and extrapolated
Bid Responses bidResponses1M Count of responses submitted by bidders for an auction
Bids bids1M The total number of seat bids submitted by bidders

Bots

adsBots1M

Count of inbound requests that are flagged as bot traffic, based on the IAB Bots & Spiders list.

Clicks

adsClicked1M

Counts of when a user clicked an impression

CTR

clickThroughRate1M

Click through rate, calculated by dividing clicks by delivered impressions

Fill Rate (Impressions) trafficFillRateIn1M Calculated by dividing ads delivered by ad requests

Fill Rate (Ads sent)

fillRateIn1M

Calculated by dividing ads served by ad requests

Fill Rate (Requests to Exchange/Mediation Partners)

fillRateOut1M

Calculated by dividing ads delivered by requests to ad sources

Impressions adsDelivered1M Total count of when the ad successfully to be displayed to the user’s screen. This is based on a successfully rendered ad beacon on the site or screen.
Impressions (includes Passbacks) adsDisplayed1M Count of ads rendered programmatically or from a passback

Insufficient Bids

insufficientBidsAuctionType1M

Number of seat bids that were below the placement’s floor price

In-View Impressions inViewImp1M Number of impressions where at least 50% of an ad was In-View for at least one continuous second
In-View Measured Impressions inViewMeasuredImp1M The number of impressions where viewability was measurable
In-View Rate inViewImpRate1M Calculated by dividing in-view impressions by in-view measured impressions
Requests to Exchange/Mediation Partner requestsOut1M Total count of requests sent out to the VYahoo M Exchange or an ad network
Win Rate winRate1M Calculated by dividing total served by total delivered impressions
Valid Ad Requests trafficRequestsIn1M Count of inbound requests into the SSP that are not flagged as fraudulent.
Valid Ad Requests by Mediation Partner requestsIn1M Total count of inbound requests into Yahoo SSP, inclusive of VMX and other mediation ad sources. Ad requests flagged as fraud or bots are excluded. This dimension should be used with the Exchange or Mediation Partner dimension.

 

GDPR

Metric Reporting API field Description
TCF 2.0 Basic Ads Consent gdprBasicAdsConsent1M Total count of ad requests with user consent given to Yahoo to use personal data for basic ad delivery only. It allows frequency capping, creative sequencing, optimization, measurement and reporting, but not targeting or building user profiles and segments.
GDPR EU Jurisdiction gdprEuJurisdiction1M Total count of ad requests coming from GDPR jurisdiction. It includes all ad requests with a GDPR flag or from an IP address located in European Economic Area.
TCF 2.0 Interest-Based Ads Consent gdprInterestBasedAdsConsent1M Total count of ad requests with user consent given to Yahoo to use personal data for interest-based ads. It allows use of personal data for basic ad delivery, as well as for delivering personalized ads and for targeting purposes.
TCF 2.0 No Consent gdprNoConsent1M Number of ad requests without user consent given to Yahoo to process personal data. It allows only to serve contextual ads without using personal data nor tracking users.
TCF 2.0 Precise Geolocation gdprPreciseGeolocation1M Total count of ad requests with user consent given to Yahoo to use precise geolocation. It allows use of IP address or latitude and longitude GPS coordinates to target or contribute to a user profile.

 

Revenue

Metric

Reporting API field

Description

Invalid Net Revenue (includes Mediation partners invalidPublisherRevenueNonRtb1M Revenue associated with a filtered fraudulent impression post auction
Invalid Net Revenue invalidPublisherRevenueRtb1M Revenue associated with a filtered fraudulent impression post auction served in the Yahoo Exchange (excludes other ad sources)

Net eCPM

pubEcpm1M

Publisher average eCPM ((pub revenue/served)*1000)

Net RPM (Valid Ad Requests)

publisherRpm1M

Revenue per thousand impressions and is calculated by dividing publisher revenue by ads requested and multiplying by 1,000.

Net Revenue

publisherRevenueRtb1M

Publisher revenue for RTB demand (excludes other ad sources)

Net Revenue (includes Mediation Partners)

publisherRevenueNonRtb1M

The total revenue attributed to the publisher

 

Video

Metric Reporting API field Description

Video Ad Attempts

adAttempts1M

The number of times the player/external server tries to render a video ad. In VAST tag integration case, the number of times SSP returned a winning Video Ad.

Video Completes (25% Quartile)

video25PctQuartile1M

Number of video ads that were played for at least 25% (but less that 50%) of the total duration.

Video Completes (50% Quartile)

video50PctQuartile1M

Number of video ads that were played for at least 50% (but less that 75%) of the total duration.

Video Completes (75% Quartile)

video75PctQuartile1M

Number of video ads that were played for at least 75% (but less that 100%) of the total duration.

Video Completes (100% Quartile)

video100PctQuartile1M

Number of video ads where the user played 100% of the video

Video Errors

vastError1M

Number of times that an error occurred when trying to display a video.

Video Starts

videoStartedQuartile1M

Count of video ads in which the user clicked and played the ad

 

Filters

The report designer allows a report to be filtered by a specific type of data.

Filter

Reporting API field

Description

App/Site

site1M

Filter by name of site as configured in the SSP

Bidders

bidder1M

Filter by name of bidder

Buyer Seat

seat1M

Filter by buyer seat name associated with an impression

Company ID cid Filter by the unique identifier assigned to the publisher’s company or companies in Analytics Reports. The Company ID is required to run a report.

Country

country1M

Filter by country

Currency Conversion toCurrency1M Filter converts revenue to non-USD currencies. Always select the metrics labeled “Non-USD” when building a report

Deal ID

deal1M

Filter by internal unique identifier for a private marketplace deal

Device Model Group deviceModelGroup1M Filter by the user’s devices model
Device Type deviceType1M Filter by the user’s device type

Exchange/Mediation Partner

adSource1M

Filter by different exchanges and ad networks

Exchange/RTB Only rtbOnly Filters to only include exchange data and excludes all other ad sources
Integration Partner hbPartner1M Filter by header bidding partner. For Sellers integrated via a Server to Server (S2S) header bidding connection, this field provides an internal unique identifier of the exchange that sent the request to the Yahoo SSP (e.g., Google Open Bidding, MoPub, Amazon TAM).

Impression Group

impressionGroup1M

Filter by impression group. Impression groups provide a way of grouping impressions under a specific Site for reporting, based on a value passed on the inbound request. This is a legacy feature that has been replaced by Key Value Pairs.

Include Mediation Partners

includeAdNetworks

Filters data to include all ad sources. This will limit the amount of metrics and dimensions available to build a report.

Placement Type placementType1M Filter by the type of placement as configured in the SSP.
Winning Creative ID winningCreativeIdFilter1M Filter by a creative ID that has won an auction