Video events feed

  • Articolo

The Video Events Feed provides you with a listing of all video-specific events that occur on your video impressions. The feed contains one row per video event.

The Xandr internal name for this feed is video_events_feed.

Sequence

The columns below are listed in the same order in which they appear in the log-level feed file (top to bottom here, left to right in the file).

Integer key

  • tinyint = 1 byte (8 bit)
  • smallint = 2 byte (16 bit)
  • int = 4 byte (32 bit)
  • bigint = 8 byte (64 bit)

Columns

Note

Microsoft Advertising may need to remove values for certain log level data (LLD) fields in order to comply with current data sharing restrictions.

Column Index Column Name Type Description Visibility
01 date_time UNIX Epoch time The time and date truncated to the hour that the record was processed by Xandr. For cross-hour events, for example, starting at 12:59 and finishing at 13:01, the hour recorded would be the last event's hour, which is 13 in this example. Both
02 auction_id_64 bigint The Xandr unique auction identifier. Both
03 buyer_member_id int The member ID of the buyer.
- For imp_type = 1 (Blank), the buyer_member_id and creative_id is 0.
- For imp_type = 2 (PSA), the Xandr PSA member_id displays.
- For imp_type = 3 or 4 (Default Error or Default), the seller_member_id displays.		 Both
04 seller_member_id int The member ID of the seller. Both
05 advertiser_id int The ID of the advertiser. Buyer
06 publisher_id int The ID for the publisher of the placement. Buyer member may map the Publisher ID to a name using the Inventory Resold Service if the seller has chosen to expose the publisher. Exposure to buyer depends on the seller's visibility profile. Both
07 site_id int The ID for site associated with placement. Cannot be associated with a name, except by the seller member who owns the site. Exposure to buyer depends on the seller's visibility profile. Seller
08 tag_id int The ID of placement tag of the impression. Cannot be associated with a name, except by the seller member who owns the tag. Exposure to buyer depends on the seller's visibility profile. Both
09 insertion_order_id int The ID for insertion order if used. Buyer
10 line_item_id int The identifier of line item. Buyer
11 campaign_id int The ID of the campaign. Buyer
12 creative_id int The ID of the creative served. Both
13 creative_freq int The creative-level frequency (times the user has seen this creative by this advertiser). Buyer
14 creative_rec int The creative-level recency in minutes (how long it has been since the user has seen this creative ad). Buyer
15 brand_id int The ID for brand of the creative. Both
16 country string(2) The geographic country of the impression passed in on the ad call. Uses ISO 3166 country codes. Both
17 creative_width smallint The width of the creative. Both
18 creative_height smallint The height of the creative. Both
19 deal_id int The Deal ID associated with this impression. Both
20 video_was_served boolean Whether or not the video was served this hour Both
21 video_started boolean Whether or not the video was started this hour Both
22 video_was_skipped boolean Whether or not the video was skipped this hour Both
23 video_had_error boolean Whether or not the video had an error this hour Both
24 video_hit_25_pct boolean Whether or not the video hit 25 pct this hour Both
25 video_hit_50_pct boolean Whether or not the video hit 50 pct this hour Both
26 video_hit_75_pct boolean Whether or not the video hit 75 pct this hour Both
27 video_completed boolean Whether or not the video completed this hour Both
28 imp_type tinyint The type of impression. Possible values:
- 0 = Video event error
- 1 = Blank: "200 OK" response (blank) served.
- 2 = PSA: A public service announcement served because no other creative was eligible.
- 3 = Default Error: A default creative served due to timeout issue.
- 4 = Default: A default creative served because no campaigns bid or no other creative was eligible.
- 5 = Kept: One of your managed advertisers served a creative.
- 6 = Resold: The impression was sold to a third-party buyer.
- 7 = RTB: Your creative served on third-party inventory.
- 8 = PSA Error: A public service announcement served due to timeout issue.
- 9 = External Impression: An impression from an impression tracker.
- 10 = External Click: A click from a click tracker.		 Both
29 advertiser_currency string(3) The currency used by advertiser. Buyer
30 publisher_currency string(3) The currency in which publisher is paid. Seller
31 site_domain string(100) The most granular identifier of the site that we can offer (but not the full domain). This may be the domain of a supply partner (e.g., doubleclick.com), the network who owns the resold inventory, or just "resold inventory". Exposure to buyer depends on the seller's visibility profile settings. Both
32 application_id string The ID of the mobile application (if applicable). Exposure to buyer depends on the seller's visibility profile. Both
33 media_cost_cpm numeric For buyers, the dollar amount * 1000 that a network is paying for the video impression associated to this video event. For sellers, the dollar amount * 1000 paid to publisher for the impression associated to this video event. Both
34 booked_revenue numeric The dollar amount earned by network on the impression associated with this video event Buyer
35 seller_revenue_cpm numeric The amount the seller is paid for the impression associated with this video event.

Note: The impression_seller_revenue_cpm is also calculated for imp_type = 5 (managed impressions). If you wish to calculate total revenue from resold impressions, sum seller_revenue_cpm only for imp_type = 6.		 Seller
36 playback_method enum The type of initiation method. Possible values:
- 0 = Unknown
- 1 = Auto-play, sound on
- 2 = Auto-play, sound off
- 3 = Click-to-play
- 4 = Mouse-over
- 5 = Auto-play, sound unknown
37 video_context enum The type of context. Possible values:
- 0 = Unknown
- 1 = Pre-Roll
- 2 = Mid-Roll
- 3 = Post-Roll
- 4 = Outstream
- 5 = Bannerstream
38 player_size_id tinyint The size of the video player. Possible values:
- 0 = Unknown
- 1 = Small
- 2 = Medium
- 3 = Large
39 supply_type enum The type of supply. Possible values:
- 0 = Web
- 1 = Mobile_Web
- 2 = Mobile_App
40 view_result enum The Xandr viewability measurement result of the impression. Possible values:
- 0 = VIEW_UNKNOWN
- 1 = VIEW_DETECTED
- 2 = VIEW_NOT_DETECTED
- 3 = VIEW_NON_MEASURABLE
- -1 = UNKNOWN
For non-impression events, this will be NULL.

Note: For more details about viewability, see Introduction to Viewability.		 Both
41 view_non_measurable_reason enum The reason an impression could not be measured for viewability. Possible values:
- 0 = N/A. The impression was measured for viewability
- 1 = SCRIPT_NOT_SERVED. The viewability script was not served with the creative. For example, on mobile-app inventory.
- 2 = NO_SCRIPT_CALLBACK. The viewability script was served with the creative, but no callback/event was received. For example, the user left the page before the creative was served.
- 3 = TECHNICAL_LIMITATION. The viewability script was served and loaded, but was unable to measure for a technical reason. For example, a cross-domain iFrame with Flash disabled.
- -1 = UNKNOWN

Note: For more information regarding viewability, see Introduction to Viewability.		 Both
42 error_code int For a detailed description of error codes and their meanings, see the IAB's VAST 3.0 documentation or view the list of Error Codes below.
43 partition_time_millis UNIX Epoch time The hourly partition any record row falls into, represented as a UNIX Epoch timestamp value (in milliseconds). Useful for defining hourly partitions when loading into a database or data warehouse. For the Avro format, this field is given the timestamp-millis logical type for native timestamp detection. For example, 1568077200000 can also be represented as Tuesday, September 10, 2019 1 AM (UTC).
44 split_id int32 The ID of the split that purchased the impressions in this data set. Splits are only applicable to augmented line items. Buyer
45 video_served_timestamp UNIX Epoch time The time and date when the video ad response was recorded. Both
46 video_started_timestamp UNIX Epoch time The time and date when the video started event was received by Xandr. Both
47 video_skipped_timestamp UNIX Epoch time The time and date when the video skipped event was received by Xandr. Both
48 video_errored_timestamp UNIX Epoch time The time and date when the video error event was received by Xandr. Both
49 video_hit_25_pct_timestamp UNIX Epoch time The time and date when the video first quartile event was received by Xandr. Both
50 video_hit_50_pct_timestamp UNIX Epoch time The time and date when the video second quartile event was received by Xandr. Both
51 video_hit_75_pct_timestamp UNIX Epoch time The time and date when the video third quartile event was received by Xandr. Both
52 video_completed_timestamp UNIX Epoch time The time and date when the video completed event was received by Xandr. Both
53 vg_id Int Field is part of an ongoing alpha release. Buyer

Error codes

The table below shows a complete listing of error codes and their meanings.

Note

You may receive error codes in the feed that are not present in the list below. If you do, those error codes are generally non-VAST-compliant custom codes sent from the video player.

Error Codes Definition
100 XML parsing error.
101 VAST schema validation error.
102 VAST version of response not supported.
200 Trafficking error. Video player received an ad type that it was not expecting and/or cannot display.
201 Video player expecting different linearity.
202 Video player expecting different duration.
203 Video player expecting different size.
300 General Wrapper error.
301 Timeout of VAST URI provided in Wrapper element, or of VAST URI provided in a subsequent Wrapper element. Includes request errors such as invalid URI, unreachable or request timeout for URI, and security or other exceptions related to requesting a VAST URI.
302 Wrapper limit reached, as defined by the video player. Too many Wrapper responses have been received with no InLine response.
303 No ads VAST response after one or more Wrappers. Also includes number of empty VAST responses from fallback.
400 General linear error. Video player is unable to display the linear ad.
401 File not found. Unable to find Linear/MediaFile from URI.
402 Timeout of MediaFile URI.
403 Could not find MediaFile that is supported by this video player, based on the attributes of the MediaFile element.
405 Problem displaying MediaFile.
500 General NonLinearAds error.
501 Unable to display NonLinear Ad because creative dimensions do not align with creative display area (i.e., creative dimension too large).
502 Unable to fetch NonLinearAds/NonLinear resource.
503 Could not find NonLinearresource with supported type.
600 General CompanionAds error.
601 Unable to display companion because creative dimensions do not fit within Companion display area (i.e., no available space).
602 Unable to display Required Companion.
603 Unable to fetch CompanionAds/Companion resource.
604 Could not find Companion resource with supported type.
900 Undefined error.
901 General VPAID error.