REDS video events feed columns (Walmart DSP)

The following table lists the Video Events feed columns (also known as stream fields).

NOTE: Certain fields in this feed might be modified to comply with regional regulations. For data scrubbing and retention details, see REDS data privacy and retention.

NOTE: The Video Events stream also contains audio event data. For details, see Post-impression event types.

Field (Column) Data Type Suggested String Length Description Example
LogEntryTime DateTime 24 The time stamp that identifies when the event occurred in the format yyyy-MM-ddTHH:mm:ss. 2025-02-22T22:30:38
ImpressionId GUID 36 The unique ID associated with the video event. 0ce7c305-74e7-4f25-97bf-433e70f1cb66
VideoEventCreativeView Integer N/A The value of 1 indicates that the creative was displayed (impression). 1
VideoEventStart Integer N/A The value of 1 indicates that the video started playing. 1
VideoEventFirstQuarter Integer N/A The value of 1 indicates that the video played to the first quartile. 1
VideoEventMidPoint Integer N/A The value of 1 indicates that the video played to the midpoint. 1
VideoEventThirdQuarter Integer N/A The value of 1 indicates the video played to the third quartile. 1
VideoEventComplete Integer N/A The value of 1 indicates that the video played to completion. 1
VideoEventMute Integer N/A The value of 1 indicates that the video was muted. 1
VideoEventUnmute Integer N/A The value of 1 indicates that the video was unmuted. 1
VideoPlayTimeInSeconds Integer N/A For the above events, after how many seconds of playback did the event occur? 12
VideoViewableTimeInSeconds Integer N/A For the above events, after how many seconds of viewable playback did the event occur? 17
VideoEventCompanionCreativeView Integer N/A The value of 1 indicates that a companion creative for the video was displayed alongside the video. 1
ProcessedTime DateTime N/A The timestamp of when the log line was processed in REDS, formatted as HH:mm:ss. 06:07.5
ImpressionPlacementId String 25 The unique ID, defined by publisher, attributed to each ad placement on a webpage. This value may be a Global Placement ID (GPID) or another supply-specific identifier. abc123xyz
DeclaredPlayerSize Integer N/A Numeric ID for the declared video player size for the impression served. For supported values, see Video player sizes. 3
ActualPlayerSize Integer N/A The numeric ID for the actual video player size for the impression served. For supported values, see Video player sizes. 3
AdvertiserId String 32 The unique platform ID for the advertiser. cb12ac3
PostImpressionEventType Integer N/A The numeric ID for the specific video event type for a given record, for example, VideoComplete, MoatVideoThirdQuarter. For supported values, see Post-impression event types. 3
VideoPlaybackType Integer N/A The numeric ID for the video playback type associated with the impression event. For supported values, see Video playback types.
If this field has the null value, it means that there was no value present in the original log line.		 3
CampaignId String 32 The unique platform ID for the campaign. cb45ac6

IDs and names

Video playback types

ID Name
2 PreRoll
3 MidRoll
4 PostRoll
5 OutStream (deprecated)
6 Undeclared
7 InBanner (deprecated)
8 InArticle (deprecated)
9 InFeed (deprecated)
10 InterstitialSliderFloating
11 Accompanying Content
12 No Content/Standalone

Back to IDs and names

Video player sizes

ID Name
1 Unknown
2 Small
3 Medium
4 Large
5 InBanner

Back to IDs and names

Post-impression event types

Clients accessing log-level data via REDS refer to the PostImpressionEventType column to determine what each row in the feed represents. A guide for interpreting this data is below to help in better understanding campaign performance.

Many of these events are standard VAST events, such as VideoStart and VideoComplete. There are also a few standard Moat events, such as CreativeIsTrackable and CreativeWasViewable.

ID to event type mappings: VAST events (included)

The following table lists each event type ID that appears in the PostImpressionEventType column.

NOTE: Despite their names, these event types also map standard DAAST audio events.

ID Type Definition
0 VideoEventCreativeView An individual creative portion of the ad was viewable.
1 VideoStart The video started.
2 VideoFirstQuarter The video played through the first quartile.
3 VideoMidpoint The video played through the midpoint.
4 VideoThirdQuarter The video played through the third quartile.
5 VideoComplete The video played to completion.
6 VideoMute The video was muted.
7 VideoUnmute The video was un-muted.
8 VideoPause The video was paused.
9 VideoResume The video was resumed.
10 VideoFullscreen The video entered fullscreen.
11 VideoError There was an error with the video.
12 VideoSkip The video was skipped.
13 VideoEngagedView An engaged video view.
14 VideoRewind The video was rewound.
15 VideoExpand The video was expanded.
16 VideoCollapse The video was collapsed.
17 VideoAcceptInvitation User activated a control that launched an additional portion of the creative.
18 VideoClose The video was closed.

ID to event type mappings: Moat events

IMPORTANT: Due to Oracle Advertising's decision to sunset their pre- and post-bid products, Grapeshot and Moat, starting September 30, 2024, our Moat metrics no longer receive new data. See Grapeshot and Moat deprecation by Oracle.

Moat viewability metrics (opt-in to The Trade Desk Moat viewability integration - fees apply)

PostImpressionEventType ID 20 is shared for both CreativeIsTrackable and CreativeWasViewable.

ID Type Definition
20 CreativeIsTrackable Moat was able to track this creative
20 CreativeWasViewable This creative was viewable by Moat standards

NOTE: Even though it may be logical to expect both CreativeIsTrackable and CreativeWasViewable to be set to true for the same impression ID, it is never the case. If either of the two fields is set to true, the other will always be set to false.

Moat default metrics (Moat subscription required)

ID Type Definition
30 MoatVideoStart The video started
31 MoatVideoViewable Video was viewable by Moat standards
32 MoatVideoFirstQuarter At least 25% of the video was viewed
33 MoatVideoMidpoint At least 50% of the video was viewed
34 MoatVideoThirdQuarter At least 75% of the video was viewed
35 MoatVideoStop The video was stopped or paused
40 VideoCompanionCreativeView The companion banner was displayed (not necessarily in view)
42 ExitFullScreen A video that was being played full screen has been exited

Moat advanced metrics (Moat subscription required)

ID Type Definition
60 MoatDisplayOnScreen The ad was viewable (but the video was not necessarily playing)
61 MoatDisplayInView5Sec The ad was viewable for 5 seconds
62 MoatDisplayInView10Sec The ad was viewable for 10 seconds
63 MoatDisplayInView15Sec The ad was viewable for 15 seconds
64 MoatDisplayInView30Sec The ad was viewable for 30 seconds
65 MoatDisplayInteraction The user’s cursor entered the frame of the ad
66 MoatDisplayInteraction5Sec The user’s cursor entered the frame of the ad for at least 5 seconds
67 MoatDisplayInteraction10Sec The user’s cursor entered the frame of the ad for at least 10 seconds
68 MoatDisplayInteraction15Sec The user’s cursor entered the frame of the ad for at least 15 seconds
69 MoatDisplayInteraction30Sec The user’s cursor entered the frame of the ad for at least 30 seconds
70 MoatVideoInView3Sec Video was playing and in view for 3 seconds
71 MoatVideoInView5Sec Video was playing and in view for 5 seconds
72 MoatVideoVisibleOnCompletion Video was viewable when the video reached 100% completion
73 MoatVideoVisibleAudibleOnCompletion Video was viewable and audio was turned on when the video reached 100% completion

ID to event type mappings: DoubleVerify events (DoubleVerify subscription required)

ID Type Definition
74 DoubleVerifyGroupMMeasuredImpression Impression was measurable per GroupM standards
75 DoubleVerifyGroupMPassedImpression Impression was viewable per GroupM standards
77 DoubleVerifyIABImpressionMeasured Impression was measurable per IAB standards
78 DoubleVerifyIABImpressionViewable Impression was viewable per IAB standards
79 DoubleVerifyIABVideoQuartile1Viewable At least 25% of the video was viewed
80 DoubleVerifyIABVideoQuartile2Viewable At least 50% of the video was viewed
81 DoubleVerifyIABVideoQuartile3Viewable At least 75% of the video was viewed
82 DoubleVerifyIABVideoQuartile4Viewable 100% of the video was viewed
83 DoubleVerifyIABViewableAt10Seconds The ad was viewable for at least 10 seconds
84 DoubleVerifyIABViewableAt15Seconds The ad was viewable for at least 15 seconds
85 DoubleVerifyIABViewableAt5Seconds The ad was viewable for at least 5 seconds
86 DoubleVerifyImpressionServed The impression was served
87 DoubleVerifyVideoImpressionServed The video impression was served
92 DoubleVerifyPublicisImpressionMeasured Impression was measurable per Publicis standards
93 DoubleVerifyPublicisImpressionViewable Impression was viewable per Publicis standards
94 DoubleVerifyGroupMV2PassedImpression Impression was viewable per GroupM standards

Interpret and analyze post-impression event type data

In one feed file, there is usually about one minute of change between first event and last event. REDS is delivered in near-real-time, so we recommend looking at wider data sets to get more accurate performance insights.

Calculate video completion rate

Review 7-10 days' worth of data to identify which PostImpressionEventTypes are being returned. Please refer to the above mapping tables for IDs and definitions of PostImpressionEventType.

You can use PostImpressionEventType to understand the performance of your video creatives.

Step 1: Calculate Total Number of Video Starts

Filter to records with a PostImpressionEventType value of "1". The sum of the filtered VideoEventStart values is equal to the total number of Video Starts.

Sum = 1,213 Video Starts

Step 2: Calculate Total Number of Video Completions

Filter to records with a PostImpressionEventType of "5". The sum of the filtered VideoEventComplete is equal to the total number of Video Completions.

Sum = 1,041 Video Completions

Step 3: Calculate Video Completion Rate

Divide the total number of Video Completions by the total number of Video Starts and multiply by 100 to calculate the Video Completion Rate.

1,041 Video Completes / 1,213 Video Starts x 100 = 85.8% Video Completion Rate

Calculate Moat Viewability Rate

PostImpressionEventType ID 20 is shared for both CreativeIsTrackable and CreativeWasViewable

To calculate Moat viewability:

  1. Calculate the sum of values in the CreativeIsTrackable column.
  2. Calculate the sum of values in the CreativeWasViewable column.
  3. Use the following formula: CreativeWasViewable Total / CreativeWasTrackable Total = Moat Viewability Rate

Calculate Moat Video Viewability and Video Playing Times

To calculate the amount of time that the video was playing or viewable:

  1. Group the data by impression ID.
  2. Identify the max value of VideoViewableTimeInSeconds or VideoPlayTimeInSeconds per bid request ID. Every row is a distinct event and as a user continues to watch a video there will be multiple events for one impression. Using the sum of the row values may be greater than the total length of the video.