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 SSP 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 |
| Blocked Source | block_source | Indicates if blocks were due to a Publisher's Inbound Request or manually configurable SSP Rules | 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) |
Metrics Available |
|
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) |
Metrics Available |
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 Values and 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 ads successfully displayed, based on a successful rendering of the 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 Yahoo Exchange 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 |
