Data Dictionary for Video SSP

The report designer provides a number of dimension and metric options for creating custom reports. Dimensions (often called "pivots") are aspects used to breakdown the data into meaningful pieces or slices. Metrics come from numerical data that is accumulated and stored in our system. These are real statistics, such as total ad impressions, which can be broken out into dimensions.

 

Dimensions

Note: special value for Dimensions -1 is unknown, -2 is not applicable (e.g. impression not applicable to opportunities).

Media is defined as the Site or App where impressions are purchased for or served to a specific connection.

 

Dimension Name	Data Type	Description
Active Tab	AD
Ad (IS MPC Digital Ad)	AD
Ad Click Url	AD
Ad End Date	AD
Ad Error	AD
Ad Error Id	AD
Ad Goal	AD
Ad Goal Type	AD
Ad Group	AD
Ad Group Id	AD
Ad Player Size	AD	The size of the ad player that displays the creative (L >=500px, M <500px, S <350px)
Ad Policy	AD
Ad Pricing Type	AD	.
Ad priority	AD	A number between 1 and 11 assigned to each ad representing its priority when competing in actions on the open market and marketplace.
Ad Priority Type	AD
Ad Sequence Id	AD
Ad source id	AD
Ad Spot Type	AD	A flag declaring direct versus marketplace placements.
Ad Start Date	AD	.
Ad Tag Url	AD	.
Ad type	AD	The type of ad to be displayed.  Yahoo system includes: Ad for Partner Marketplace Connection Digital Ad RTB Ad Source RTB Inventory Source.
Advertiser Domain	AD
Advertiser Id	AD
Advertiser name (per campaign)	AD	Name of the advertiser associated with the campaign.
Advertiser Vertical	AD
AOL SAP id: buyer organization	AD	The registered SAP vendor id of the buyer organization in AOL's SAP system.
AOL SAP id: seller organization	AD	The registered SAP vendor id of the seller organization in AOL's SAP system.
Auction Type	AD
Bid id	AD
Brand	AD
Buyer deal external id	AD
Buyer deal id	AD	The identifier used to specify a buyer deal.
Buyer deal name	AD	The buyer's deal name.
Buyer deal price type	AD
Buyer deal type	AD
Buyer Manager Organization	AD	The managing organization representing the buyers demand. An organization may have relationships with both parent/managing org and child/affiliate org.
Buyer Manager Organization Id	AD	An identifier specific to the buyers managing organization.
Buyer managing currency	AD	The currency configured for the managing organization of the buyer.
Buyer Organization AM	AD
Buyer Organization BD	AD
Buyer organization id	AD	An identifier for a specific buyer organization.
Buyer organization name	AD	Name of the buyer organization executing demand (direct and/or programmatic).
Buyer Seat	AD
Buyer Seat Id	AD
Campaign Id	AD
Campaign name	AD
Clearance flag for Yahoo Managed Media	AD	Denotes whether transactions are cleared by Yahoo Managed Media
Conversion Event	AD
Creative Category	AD
Creative Duration	AD
Creative Id	AD
Creative Name	AD
Deal Filter Reason	AD
Deal Filter Reason Id	AD
Detected ad duration	AD	The duration of the ad creative listed in the VAST Response. This duration is only available for the Video SSP VPAID JS player and the OpenAPI player set-up. It is not available when the VAST-only method is used.
Device Category	AD	Top-level categorization of the device (Desktop CTV/Gaming Mobile)
Digital Ad	AD
Double Auction Reason	AD
Exchange Name	AD	.
External Creative	AD	Name of the creative from RTB buyers.
External Creative ID	AD	ID of the creative from RTB buyers.
External Video Name	AD	Name of the O2 Video
First Party Id	AD
Inventory Format Type	AD
Inventory Source Id	AD	Unique ID of an inventory source.
Inventory Source Name	AD	Name of the placement grouping which can deliver ads via direct campaigns or backfill into marketplaces.
Inventory Sources Label	AD
IO Line Id	AD
Location Id	AD
Marketplace Clearing House	AD	.
Marketplace Connection Id	AD
Marketplace Connection Name	AD	Name of the Marketplace connection which allows a publisher to sell inventory into marketplaces.
Marketplace Id	AD
Marketplace Name	AD
Marketplace Reporting Type	AD	.
Media	AD	Media is defined as the Site or App where impressions can be purchased / served for this connection.
Media Category	AD
Media detected	AD	The site that is detected using our Automatic Site Verification technology.
Media Id	AD
Media Language	AD
Media reported	AD	The media that was reported by the seller.
Media type	AD	Specifies the type of media in the inventory source or marketplace connection. Values include Site, App, iOS, Android etc.
Media: IAB topic	AD	The IAB categorization of the detected media.
MPS Campaign ID	AD
MPS Line Item #	AD
Organization Account Type	AD	Type account (managed vs self service) the organization uses.
Organization Id	AD	An identifier specific to the organization on the Video SSP platform.
Organization Name	AD
Placement Type	AD	A flag identifies placements as direct versus marketplace.
Platform deal external id	AD
Platform deal id	AD	The deal ID identifier for a platform deal used by open demand team.
Platform deal name	AD	The Deal name that allows RTB buyers to purchase inventory on the platform via OpenRTB spec.
Player Type Id	AD
Player Type Name	AD
Secure Flag	AD
Segment (Longname)	AD
Segment Id	AD	Segment Id
Segment Provider	AD
Segment Provider Id	AD
Seller Deal Goal	AD
Seller Deal Goal Type	AD
Seller deal id	AD	Unique identifier that allows publishers to transact programmatically in a pre negotiated relationship with buyer(s).
Seller deal name	AD	The name of the deal that allows publishers to transact programmatically.
Seller Deal Price Type	AD
Seller Deal Priority	AD
Seller Deal Type	AD	Type of Seller Deal e.g. Guaranteed, Open, Preferred, Private, etc.
Seller filter reason	AD
Seller managing currency	AD	The currency configured for the sellers managing organization.
Seller Managing Organization	AD	The managing organization representing the seller's supply. An organization may have a relationship with a parent/managing org and a child/affiliate org.
Seller Managing Organization Id	AD	An identifier for the seller's managing organization.
Seller Organization	AD	Name of seller organization representing the supply
Seller Organization AM	AD
Seller Organization BD	AD
Seller Organization Id	AD	An identifier in the Video SSP platform representing the seller organization.
Site (Detection Method)	AD
Site (Targeting Method)	AD
User Id	AD	User Id
Validity Reason	AD
Viewability Opportunity	AD
hour1V	DATE_TIME
scaledDate1V	DATE_TIME	date
scaledDay1V	DATE_TIME
scaledDayOfWeek1V	DATE_TIME
scaledMonth1V	DATE_TIME
scaledWeek1V	DATE_TIME
Stats Date	DATE_TIME
View Hour	DATE_TIME	The hour at local time when the event was recorded.
App bundle name	DEVICE_OS_BROWSER	If available the name of the mobile app bundle identified on the inventory source.
App store url availability	DEVICE_OS_BROWSER	Denotes whether the ad opportunity contained an App Store url. Expected values are “Yes” or “No”.
Browser	DEVICE_OS_BROWSER
Browser Id	DEVICE_OS_BROWSER
Device Id	DEVICE_OS_BROWSER
Device Id Status	DEVICE_OS_BROWSER
Device Id Type	DEVICE_OS_BROWSER
Device sub-category	DEVICE_OS_BROWSER	The device category detected from the user (tablet mobile game console etc).
Operating System	DEVICE_OS_BROWSER
User Device Name	DEVICE_OS_BROWSER	Specific type of device being used (Android phone, iPhone, Android tablet, Windows phone, etc).
Area Code Id	GEO
City Id	GEO
Country	GEO
Country Code	GEO	3 Character Country Code (ISO 3166-1 alpha-3)
Metro Code Id	GEO
Region/DMA	GEO
State/Province	GEO
Moat Pre-bid Viewability (Trusted Player)	MOAT
Pre-bid viewable detection	MOAT	If user is on an active browser tab and 50% of pixels are in-view on the ad player the opportunity is considered pre-bid viewable. Based detection from the Video SSP ad player. 1 = pre-bid viewable. -1 = non-viewable. Blank = unknown.
Trusted Moat Viewability	MOAT
Bid Id (Fallout)	LONG
Continent Id	LONG
Digital Ad (Fallout)	OPS
Opportunity to Impression TS Bucket	OPS
Custom key 1	OTHER	Custom key 1
Custom key 10	OTHER	Custom key 10
Custom key 11	OTHER	Custom key 11
Custom key 12	OTHER	Custom key 12
Custom key 13	OTHER	Custom key 13
Custom key 14	OTHER	Custom key 14
Custom key 15	OTHER	Custom key 15
Custom key 16	OTHER	Custom key 16
Custom key 17	OTHER	Custom key 17
Custom key 18	OTHER	Custom key 18
Custom key 19	OTHER	Custom key 19
Custom key 2	OTHER	Custom key 2
Custom key 20	OTHER	Custom key 20
Custom key 3	OTHER	Custom key 3
Custom key 4	OTHER	Custom key 4
Custom key 5	OTHER	Custom key 5
Custom key 6	OTHER	Custom key 6
Custom key 7	OTHER	Custom key 7
Custom key 8	OTHER	Custom key 8
Custom key 9	OTHER	Custom key 9
Player Size (Trusted Player)	PLAYER
Break sequence	VIDEO
Break type name	VIDEO
Content type name	VIDEO
External Schema ID	VIDEO
External Video ID	VIDEO
Slot sequence	VIDEO
Slot type name	VIDEO

 

Metrics

 

Metric Name	Data Type	Description
100% completion rate	AD	The 100% Ad Completions metric divided by the total number of ad impressions.
100% completions	AD	The number of times a user has completed a video ad. Note: This metrric may not be available for all ads because some ad network ads do not notify the Video SSP platform of the user's progression through the ad.
25% completion rate	AD	A metric representing the number of times an ad has been viewed to the 25% point (but not yet reached 50% completion) divided by the total number of ad impressions.
25% completions	AD	The number of times a user has watched at least 25% of a video ad. Note: This metric may not be available for all ads because some ad network ads do not notify the Video SSP platform of the user's progression through the ad.
50% completion rate	AD	A metric representing the number of times an ad has been viewed to the 50% point (but not yet reached 75% completion) divided by the total number of ad impressions.
50% completions	AD	The number of times a user has watched at least 50% of a video ad. Note: Some ad network ads do not notify the Video SSP platform of the user's progression for the ad so this metric may not be available for some ads.
75% completion rate	AD	A metric representing the number of times an ad has been viewed to the 75% point (but not yet reached 100% completion) divided by the total number of ad impressions.
75% completions	AD	The number of times a user has watched at least 75% of a video ad. Note: This metric may not be available for all ads because some ad network ads do not notify the Video SSP platform of the user's progression through the ad.
Ad Attempts	AD	The number of times the Video SSP platform attempts to display an ad. If trafficking an Video SSP VAST tag in an external ad server this metric indicates the number of times your VAST tag returned an ad. Note: Each time an auction is won an ad attempt is made.
Ad error rate	AD	Ratio of ad errors to ad attempts
Ad Errors	AD	The number of times an error occurs when the Video SSP platform plugin is trying to display an ad.
Ad Impressions	AD	The number of times the Video SSP platform successfully displays an ad (or starts an ad for video ads) in an ad spot. Note: For ad network ads one ad success is counted when the ad network successfully takes over the ad spot to show ads no matter how many ads the ad network actually shows.
Ad Loaded Timeouts	AD
Ad Loads	AD
Ad Opportunities	AD	The opportunity for Video SSP to serve an ad to an end user. The ad request may come from an ad source (supplier) or from the Video SSP ad player. Ad source opportunities are counted when the ad tag is requested. For Video SSP 's ad player integrations the ad opportunity is counted when there is an opportunity to play an ad based on the matching ad policy criteria. Ad opportunities are counted regardless of whether there is an ad to be shown.
Ad Resolution Failures	AD
Ad Skips	AD
Ad Started Timeouts	AD
Ad Success Rate	AD	Ratio of ad impressions to ad attempts. An ad impressions is only flagged when the ad successfully loads and begins playback.
Ad Timeouts	AD	The number of times the Video SSP ad player times out waiting for an ad to display. After an ad spot timeout the ad player no longer attempts to display ads in that ad spot but will try again in future ad spots. (Example: If the adpolicy specifies a 3 second ad spot timeout on the preroll spot and the ad player spends 3 seconds cycling through one or more ads none of which succeed then the ad player will abandon any attempts to show a preroll on that video view.)
Ad Views	AD
Ads Paused	AD
Ads Resumed	AD
Ads sent	AD	The number of times a buyer or direct ad was sent from the Video SSP ad server to the player or client.
Bid Filter Count	AD
Bid requests	AD	The number of potential bid opportunities sent to an RTB buyer
Bid response rate	AD	Ratio of bid responses to total bid requests.
Bid responses	AD	The number of times that an RTB buyer responds to a bid request with a bid.
Billable Views	AD
Blocked Market Opps	AD
Break Impressions	AD
Click Conversions	AD
Click Rate	AD	Ratio of total clicks to ad impressions.
Clicks	AD	The number of times an ad was clicked. Video SSP counts the total viewer clicks even if multiple clicks occur during a single ad view for a single impression.
Companion Ad CTR	AD	Ratio of bid responses to bid requests
Companion Ad Impressions	AD	The number of times a companion ad got an impression
Completed Views	AD
Conversion Rate	AD	Ratio of bid responses to bid requests
Conversions	AD
Deal Requests	AD
Deal Responses	AD
Demand rate	AD	The ratio of times demand was present to total ad opportunities. Demand is recorded when the publisher waterfall or auction results in at least one ad.
Estimated Fill Rate	AD	Determined by the number of ad impressions divided by ad opportunities X (the ratio of ad attempts to ads sent). The ratio of ad attempts to ads sent gives an approximation for true ad opportunities on the page versus pre-fetch ads.
Fill Rate	AD	The ratio of ad impressions to total ad opportunities.
Filtered Ad Impressions	AD
Filtered Clicks	AD
Filtered Completions 100%	AD
Filtered Completions 25%	AD
Filtered Completions 50%	AD
Filtered Completions 75%	AD
Filtered Deal Responses	AD
Gross Clicks	AD
Gross Impressions	AD
Invalid ad impressions	AD
Inventory Sell Rate	AD	Ratio of bid responses to bid requests
Market buy opportunities	AD	Metric that is calculated as ad successes (ad impressions) + ad errors.
Market Opportunities	AD	A market opportunity is an opportunity for a marketplace to show an ad in response to an ad request. Market opportunities are counted regardless of whether a corresponding buyer ad is shown. Please click here for more information on how Market Opportunities are counted.
Market Utilization	AD	The number of preroll ad opportunities divided by the number of market opportunities.
Marketplace Connection Fill Rate	AD
Matched Views	AD	The number of views where at least one ad was displayed.
No Ad Deal Responses	AD
No Ad Plan Views	AD
No Ad Source Views	AD
Prefilled Ad Opportunities	AD	An ad opportunity is an opportunity for Video SSP to serve an ad to an end user. The ad request may come from an ad tag or from the Video SSP ad player. For ad tag requests an ad opportunity is counted when the ad tag is requested. Video SSP's ad player integration counts the ad opportunity when there is an opportunity to play an ad based on the matching ad policy criteria. Ad opportunities are counted regardless of whether or not an ad is available to fill the opportunity.
Seller Market Opportunities	AD
Simple Clicks	AD
Started Views	AD
Total Conversions	AD
Total Views	AD	The number of video views sent to the Video SSP ad player.
Uniques	AD	Count of the number of distinct users
Unused Inv. Source Ad Requests	AD
User frequency	AD	User frequency
User Leaving Views	AD
Valid Ad Opportunities	AD	Ad opportunities that pass through media and fraud checks before conducting an auction or looking for ads.
VPAID fill rate	AD	The ratio of ad impressions to total loads of the Video SSP VPAID JS. Some customers may refer to this as ""opportunity fill.""
VPAID load rate	AD	The ratio of total loads of the Video SSP VPAID JS to ""ads sent"". This measures ratio of Video SSP VPAID loads to the times when there was demand.
VPAID Loads	AD	The number of times the Video SSP VPAID JS player was successfully loaded. This does not apply for VAST-only traffic or inventory sources using the ""Wrapper"" setting.
Min Stats Date SC	DATE_TIME
White ops ad opportunities filter rate	FLASHLIGHT	Ratio of blocked ad opportunities to total ad opportunities. Where blocking is based on White Ops pre-bid fraud and bot detection. Blocked ad opportunities do not proceed further and do initiate bid requests or any demand. This only applies for Video SSP SSP sellers (not 3rd party exchanges).
White ops bid requests filter rate	FLASHLIGHT	Ratio of blocked bid requests to total bid requests. Where requests are blocked for buyers using White Ops pre-bid fraud and bot detection. This applies on third party exchanges listing their supply on Video SSP. It does not apply to direct Video SSP sellers; that supply is filtered by White Ops before bid requests are initiated.
White ops blocked ad opportunities	FLASHLIGHT	Ad opportunities blocked based on White Ops pre-bid fraud and bot detection. Blocked ad opportunities do not proceed further and do initiate bid requests or any demand. This only applies for Video SSP sellers (not 3rd party exchanges).
White ops blocked bid requests	FLASHLIGHT	Bid requests blocked for buyers using White Ops pre-bid fraud and bot detection. This applies on third party exchanges listing their supply on Video SSP. It does not apply to direct Video SSP sellers; that supply is filtered by White Ops before bid requests are initiated.
White Ops Guarded Ad Opportunities	FLASHLIGHT
White Ops Guarded Bid Requests	FLASHLIGHT
White Ops Measured Ad Impressions	FLASHLIGHT
Average Ad Spot Resolution Time	MOAT
IAB 2-sec in-view rate	MOAT	The % in-view rate per the IAB/MRC video viewability standard: 50% of pixels in-view for at least 2 seconds. Ratio of in-view impressions to measured impressions. Based on Video SSP's proprietary viewability detection.
IAB Detections Failed	MOAT	.
IAB measured rate	MOAT	That ratio of measured impressions to total impressions. This means measured by Video SSP s proprietary viewability code.
IAB Non Viewable Impressions Rate	MOAT
IAB Non-viewable ad impressions	MOAT	Ad impressions that were not in-view according to the IAB/MRC video viewability standard: 50% of pixels in-view for at least 2 seconds. This is measured by Video SSP's proprietary viewability detection.
IAB Viewability measurable ad impressions	MOAT	The number of ad impressions successfully measured by Video SSP's proprietary viewability detection.
IAB Viewability Undetermined Impressions	MOAT	.
IAB Viewability Undetermined Rate	MOAT
IAB Viewability Unknown Impressions	MOAT	.
IAB Viewable ad impressions	MOAT	The number of in-view ad impressions per the IAB/MRC video viewability standard: 50% of pixels in-view for at least 2 seconds. This is measured by Video SSP's proprietary viewability detection.
IAB Viewable Impressions Rate	MOAT
IAB Viewable rate	MOAT	That ratio of measured impressions to total viewable impressions. This means measured by Video SSP's proprietary viewability code.
MOAT 2-sec in-view	MOAT	The # of in-view impressions measured by MOAT according to the MRC video viewability standard: 50% of pixels in-view for at least 2-seconds. Requires the use of the Moat Viewability app
MOAT 2-sec in-view rate	MOAT	The % in-view rate measured by MOAT according to the MRC video viewability standard: 50% of pixels in-view for at least 2-seconds. Ratio of in-view ad impressions to measured ad impressions. Requires the use of the Moat Viewability app
MOAT impressions analyzed	MOAT	Impressions where MOAT viewability detection was loaded and started measuring. Requires the use of the MOAT Viewability app.
MOAT impressions measured	MOAT	Impressions where MOAT viewability detection was loaded and successfully measured. Requires the use of the Moat Viewability app.
MOAT Measured Rate	MOAT	The ratio of impressions measured by MOAT viewability to total impressions. Requires the use of the Moat Viewability app.
Ad Attempts resulting in Failover	OPS	The number of times an Ad Attempt failed and went to failover.
Ad Loads (Fallout)	OPS
Ad Opportunities (Failover)	OPS
AVG Ad Attempts (Fallout)	OPS
AVG TS Diff Ad Attempt (1 2) (Fallout)	OPS
AVG TS Diff Ad Attempt (2 3) (Fallout)	OPS
AVG TS Diff Ad Attempt (3 4) (Fallout)	OPS
AVG TS Diff Ad Attempt (4 5) (Fallout)	OPS
AVG TS Diff Ad Attempt (5 6) (Fallout)	OPS
AVG TS Diff Ad Attempt (6 7) (Fallout)	OPS
AVG TS Diff Attempt 1 -> Ad Impression (Fallout)	OPS
AVG TS Diff Opp -> Attempt 1 (Fallout)	OPS
AVG TS Diff Opp -> Imp (Fallout)	OPS
Buyer Ad Type (Fallout)	OPS
Buyer Adomain (Fallout)	OPS
Count Ad Attempt 1 TS (Fallout)	OPS
Count Ad Attempt 2 TS (Fallout)	OPS
Failed Ad Attempt with No Error (Failover)	OPS	Ad Attempts that went to failover and delivered an Ad (position of Ad will determine if ad impression was from failover).
Failover ad attempts with no impressions	OPS	Ad Attempts that went to failover and did not deliver an Ad (position of Ad will determine if failover did not result in an impression)
Failover Converted to Impression	OPS	Ad Attempts that went to failover and delivered an Ad
Failover did not complete (Failover)	OPS	Ad Attempts that failed and did not go to failover. (More ad attempts than errors and no impression)
Revenue Loss (Fallout)	OPS	The amount of revenue lost through ad fallout.
Revenue Loss With Ad Success (Fallout)	OPS	The amount of revenue we lost because the ad at position 1 failed to deliver.
Revenue Loss Without Ad Success (Fallout)	OPS	The amount of revenue we would have gained if we delivered an impression successfully .
Revenue When Failover Converted to Impression	OPS
Seller Ad Type (Fallout)	OPS
Seller Adomain (Fallout)	OPS
Total TS Diff Ad Attempt (1 2) (Fallout)	OPS
Ad Revenue	REVENUE	The amount of revenue made.
Ad revenue (converted)	REVENUE
ATA Media Cost	REVENUE
Buyer Margin	REVENUE	A percentage mark-up of the cost of the ad used to calculate your Gross Spend. It applies to media spend and vendor fees through our platform but does not include platform fees.
CDN Fees	REVENUE	The CDN fees incurred based off the number of ad impressions.
Cost Per Completed View	REVENUE
Data Cost	REVENUE	The fees associated with audience targeting buys using 3rd party data providers such as BlueKai and Lotame.
eCPM (Ad revenue / imps)	REVENUE
eCPM (Ad revenue / imps) (converted)	REVENUE
eCPM (Ad Revenue/View)	REVENUE
eCPM (Ata Media Cost / imps)	REVENUE	.
eCPM (Gross revenue / imps)	REVENUE
eCPM (Gross revenue / imps) (converted)	REVENUE
Gross Revenue	REVENUE
Gross revenue (converted)	REVENUE
Media Spend	REVENUE	The cost for impressions delivered on media purchased in marketplaces. Media spend does not include CDN fees vendor fees or other fees.
Non Market Vendor Fees	REVENUE	Total spend = media spend + vendor fee + CDN fee. This metric reflects the amount a buyer pays Video SSP excluding platform fees.
Passthrough Cost	REVENUE	Additional cost for vendor services outside of our platform. The pass-through cost is informational and does not affect ad spend.
Seller Payment Cost	REVENUE	Ad revenue seller makes after taking out margins and fees.
Total Buyer Spend	REVENUE	Total Buyer Spend
Total Cdn Cost CPM (CDN Cost / Impressions)	REVENUE
Total Spend	REVENUE	Total spend = media spend + vendor fee + CDN fee. This metric reflects the amount a buyer pays Video SSP excluding platform fees.
Vcpm Gross Spend / Impressions	REVENUE
Vendor Fees	REVENUE	The sum of data measurement and verification fees.