Audience-curated REDS feeds

The following tables list fields used in Audience-Curated REDS feeds by data type:

Here's what you need to know about the content presented in this reference table:

Impressions

Field (Column) Data Type Suggested String Length Description Example
AdFormat String 10 The size of the creative expressed as width x height.
Some ad formats, such as 1920x1080 may apply to both video and display media type. If you do reporting by media type (also known as inventory type) rather than by ad format, you can map the ad format ID to the inventory type by using the POST/adformat/query endpoint.		 300x250
AdGroupId String 32 The unique platform ID for the ad group. cb78ac9
AdgroupName String 256 The name of the ad group. Ad Group Name
AdvertiserCostInUSDollars Decimal N/A The total of platform cost, fee features cost, any additional platform rate fee, and partner markup. 0.004996386
AdvertiserCurrency String 3 Three letter currency code for advertiser, chosen during setup. PYG
AdvertiserCurrencyExchangeRateFromUSD Decimal N/A Numeric rate of exchange in use at the time of the event to convert from USD to the advertiser's currency. 6,297.75
AdvertiserId String 32 The unique platform ID for the advertiser. cb12ac3
AdvertiserName String 64 The name of the advertiser. Advertiser Name
AudienceId String 32 The unique platform ID for the audience. An audience is made up of one or more data groups. zbcavmlz
AudienceName String 64 The name of the audience. Audience Name
Browser Integer N/A The numeric ID for the browser associated with the impression event. For supported values, see Browsers. 5
BrowserName String 32 The name of the browser associated with the impression event. For supported values, see Browsers. Chrome
CampaignId String 32 The unique platform ID for the campaign. cb45ac6
CampaignName String 256 The name of the campaign. Campaign Name
City String N/A The city where the impression was served. Los Angeles
CombinedIdentifier String 512 The unique ID associated with the impression. The ID type is specified in the CombinedIdentifierType column. c953a21c-2760-42f6-a2c0-08e88bbbb525
CombinedIdentifierForm String 100 This column indicates whether the ID specified in the CombinedIdentifier column is one of the following:
  • Originating—the ID used to target the user. The originating ID (OGID) can be found in your first-party or third-party data segments and are already known to you. This ID is available only when targeting is based on an identifier (non-contextual or non-programmatic guaranteed). Otherwise, a legacy ID is returned.
    NOTE: To turn on the ability to receive OGIDs, contact your Technical Account Manager.
  • Legacy—the ID used to purchase the impression. If the OGID is not available or is disabled, only the legacy DAID or TDID is returned.
  • Removed: Restriction—the ID was removed due to privacy regulations, contractual agreements, or other policies. For details, see REDS data privacy.
  • Hashed: Restriction—the ID was hashed due to privacy regulations, contractual agreements, or other policies. For details, see REDS data privacy
 Legacy
CombinedIdentifierType String 32 The type of the ID specified in the CombinedIdentifier column. This can be any supported ID type, such as TDID, DAID, RampID, RawUID2, UID2Token, EUID, or RawEUID, as well as any new types that may be supported in the future.
NOTE: If the ID type is RampID, you can convert the value to your own encoding with the LiveRamp RampID translation.		 TDID
ContentChannel String 64 The channel on which the impression appeared. WABC-TV
ContentNetwork String 64 The network on which the impression appeared. ABC
CountryLong String 50 The country associated with the impression event. United States
CreativeId String 32 The unique platform ID for the creative. 345bc1a
CreativeName String 256 The name of the creative.
IMPORTANT: Do not include any of the following special characters: <>;^\r\n		 CreativeName
DataElementMetadata Object array N/A Metadata describing a data segment includes the following:
  • FullPath: The unique IDs assigned to the segment by the data provider.
  • ThirdPartyDataBrandElementId: The segment display name and full path of the taxonomy.
 [{"FullPath":"Custom Audiences > Audience Profile","ThirdPartyDataBrandElementId":"TTD123"}]
DealId String 128 The deal ID used to buy a given impression. 948
DeviceMake String 32 The make of the device associated with the impression event. Samsung, Apple
DeviceModel String 32 The model of the device associated with the impression event. iPad, iPhone, schi-i545
DeviceType Integer N/A The numeric ID for type of device on which the impression was served. For supported values, see Device types. 6
DeviceTypeName String 32 The type name of device on which the impression was served. For supported values, see Device types. ConnectedTV
ImpressionId GUID 36 The unique ID associated with the impression event. 0ce7c305-74e7-4f25-97bf-433e70f1cb66
InventoryChannel Integer N/A The inventory channel ID assigned to the impression served. For supported values, see Inventory channels.
NOTE: For details on how channels are used to buy inventory in campaigns and ad groups, see Channels.		 1
InventoryChannelName String 32 The inventory channel name assigned to the impression served. For channel names, see Inventory channels. TV
LogEntryTime DateTime N/A The timestamp that identifies when an event occurred in the format yyyy-MM-ddTHH:mm:ss. 2025-02-22T22:30:38
OSFamilyName String 32 The name of the operating system family associated with the impression event. For supported values, see OS families. Windows
OSName String 32 The name of the operating system (OS) associated with the impression event. iOS 15.2
PartnerId String 32 The unique platform ID for the partner. a1b2c34
PrivateContractId String 32 The unique platform ID for a group of deal IDs that was used to bid on this impression. q021dabc
PrivateContractName String 256 The name of the inventory contract. Private Contract Name
Site String 128 The domain or app where the impression was purchased and displayed.
  • Web: thetradedesk.com
  • iOS: 343200656
  • Android: com.rovio.angrybirds
AudienceUnlimitedTierName String N/A The Audience Unlimited tier that is associated with the campaign. The supported values include:
  • Full
  • Lite
  • None
 Full

Browsers

The following table lists the IDs for the Browser field, along with their respective property values in the BrowserName field.

ID Name
1 Other
2 Internet Explorer 7
3 Internet Explorer 8
4 Internet Explorer 9
5 Firefox
6 Chrome
7 Safari
8 Opera
9 Internet Explorer 10
10 Internet Explorer 11
11 InApp (deprecated)
12 Edge
13 Baidu
14 Yandex
15 WebView

Device types

The following table lists the IDs for the DeviceType field, along with their respective property values in the DeviceTypeName field.

ID Name
1 Other
2 PC
3 Tablet
4 Mobile
5 Roku (deprecated)
6 ConnectedTV
7 OutOfHome
8 HomeAssistant

Inventory channels

The following table lists the IDs for the InventoryChannel field, along with their respective property values in the InventoryChannelName field.

ID Name API Property
0 Other Other (Deprecated)
1 Display Display
2 Video Video
3 Audio Audio
4 TV TV
5 Native Display NativeDisplay
6 Native Video NativeVideo
7 Out of Home OutOfHome

OS families

The following table lists the IDs for the OSFamily field, along with their respective property values in the OSFamilyName field.

ID Name
1 Other
2 Windows
3 OS X
4 Linux
5 iOS
6 Android
7 Windows Phone

Clicks

Field (Column) Data Type Suggested String Length Description Example
AdvertiserId String 32 The unique ID for the advertiser as assigned by TTD. cb12ac3
CampaignId String 32 The unique ID for the campaign as assigned by TTD. cb45ac6
ChannelId String 32 The channel from which the click was recorded. Click here to view a mapping of IDs and names.
ClickRedirectId GUID 36 The unique identifier associated with the click event. 0ce7c305-74e7-4f25-97bf-433e70f1cb66
DisplayImpressionId GUID 36 The unique identifier associated with the impression event. w063a21c-8760-42f6-a2c0-08e68b4db125
LogEntryTime DateTime The timestamp identifying when a click event occurred, formatted as yyyy-MM-ddTHH:mm:ss. 2025-02-22T22:30:38
ProcessedTime DateTime 19 The timestamp of when the log line was processed in REDS, formatted as yyyy-MM-ddTHH:mm:ss. 2025-05-15T20:30:00
RedirectUrl String 1000 The address of the webpages that a click redirects through. https://redir.com/?utm\_source=hx&utm\_medium=display&utm\_campaign=prospecting&dclid=CLeXwZzyltICFVNfXgodgNwHsA
ReferrerUrl String 1000 The address of the webpage that is linked to the click request. http://redir.site.com/redir/client/VPAIDClient.swf?adTagUrl=http%3A%2F%2Fads.site.advertising.com%2Fa%2Fh%2FWuipbaNL\_wYBSFY8UN%2BWMaDrdJaix

ChannelId

ID Name
adwords Google Adwords
ae Global Wide Media Affiliate Campaign
ge Global Wide Media Email
google Google

Video events

Field (Column) Data Type Suggested String Length Description Example
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
ActualPlayerSizeName String 32 The name of the actual video player size for the impression served. For supported values, see Video player sizes. Medium
AdvertiserId String 32 The unique platform ID for the advertiser. cb12ac3
DeclaredPlayerSize Integer N/A Numeric ID for the declared video player size for the impression served. For supported values, see Video player sizes. 3
DeclaredPlayerSizeName String 32 The name of the declared video player size for the impression served. For supported values, see Video player sizes. Medium
ImpressionId GUID 36 The unique ID associated with the video event. 0ce7c305-74e7-4f25-97bf-433e70f1cb66
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
PostImpressionEventType Integer N/A The numeric ID for the specific video event type for a given record, for example, VideoComplete. For supported values, see Post-impression event types. 3
PostImpressionEventTypeName String 32 The name of the specific video event type for a given record. For supported values, see Post-impression event types. VideoComplete
ProcessedTime DateTime N/A The timestamp of when the log line was processed in REDS, formatted as HH:mm:ss. 06:07.5
VideoEventCompanionCreativeView Integer N/A The value of 1 indicates that a companion creative for the video was displayed alongside the video. 1
VideoEventComplete Integer N/A The value of 1 indicates that the video played to completion. 1
VideoEventCreativeView Integer N/A The value of 1 indicates that the creative was displayed (impression). 1
VideoEventFirstQuarter Integer N/A The value of 1 indicates that the video played to the first quartile. 1
VideoEventId String 32 The unique platform ID for the video event. cba123xyz
VideoEventMidPoint Integer N/A The value of 1 indicates that the video played to the midpoint. 1
VideoEventMute Integer N/A The value of 1 indicates that the video was muted. 1
VideoEventStart Integer N/A The value of 1 indicates that the video started playing. 1
VideoEventThirdQuarter Integer N/A The value of 1 indicates the video played to the third quartile. 1
VideoEventUnmute Integer N/A The value of 1 indicates that the video was unmuted. 1
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
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
CampaignId String 32 The unique platform ID for the campaign. cb45ac6

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

Video player sizes

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

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.

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: 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

Conversions

Field (Column) Data Type Suggested String Length Description Example
AdvertiserId String 32 Unique advertiser identifier in The Trade Desk system. 13a5cl2
CombinedIdentifier String 512 The unique ID associated with the conversion. The ID type is specified in the CombinedIdentifierType column. c953a21c-2760-42f6-a2c0-08e88bbbb525
CombinedIdentifierType String 32 The type of the ID specified in the CombinedIdentifier column. TDID
ConversionId GUID 36 The unique identifier associated with the conversion event. 939bef59-e69c-4341-86ea-6ce1756e6f63
ConversionType String 32 The tracking tag ID. 2a34c0b
LogEntryTime DateTime 24 The time stamp that identifies when an event occurred in the format yyyy-MM-ddTHH:mm:ss. 2025-02-22T22:30:38
MonetaryValue Decimal The value associated with the conversion; the order value. 124.03
MonetaryValueCurrency String 10 The currency in which the value was recorded. USD
OfflineConversionTime DateTime The time stamp of when the offline conversion occurred, formatted as yyyy-MM-ddTHH:mm:ss. N/A
OfflineProviderId String 32 An ID of the offline provider that may be human-readable as name. N/A
OrderId String 64 The unique identifier associated with a transaction/conversion event. 123456
ProcessedTime DateTime The time stamp of when the log line was processed in REDS, formatted as yyyy-MM-ddTHH:mm:ss. 2025-05-15T20:30:00
ReferrerUrl String 1000 The address of the webpage where the conversion event occurred. http://www.site.com/
TD1-TD10 String 64 Custom field defined by advertiser/agency. N/A