Platform-curated REDS feeds

The following tables list fields used in Platform-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
AdsTxtSellerType Integer N/A The ads.txt seller type that indicates the relationship between SSP and Publisher. 1
AdsTxtSellerTypeName String 32 The ads.txt seller type that indicates the relationship between SSP and Publisher. Direct
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
AuctionType String 25 The SSP declared auction type. FirstPrice
AudienceId String 32 The unique platform ID for the audience. An audience is made up of one or more data groups. zbcavmlz
AudienceImpressionMultiplier Decimal N/A The estimated number of viewers per digital out-of-home (DOOH) ad play. For example, if an ad plays once but is expected to be seen by five people, the number of impressions is 1 and the multiplier is 5.0.
Impression multipliers are provided by partners, such as SSPs or media owners sending these values in the bidstream.
The following formula shows how the impression multiplier is used to estimate audience reach.
Impression count × AudienceImpressionMultiplier = estimated audience reach
NOTE: For non-DOOH impressions, this field is set to 1 or NULL, meaning no multiplication is applied.		 1.3
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
Carrier Integer N/A The Carrier of the device associated with the impression event. 635
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
ContentDuration String 32 The length (in minutes) of the content in which the impression appeared. Content duration is passed as a range. For supported values, see Content duration ranges.
If this field has the null value, it means that there was no value present in the original log line.		 30.01-45
ContentGenre1 String 32 The genre of the content in which the impression appeared. To retrieve a list of supported values, use the GET /v3/content/genre/query endpoint. Action
ContentGenre2 String 32 The second genre of the content in which the impression appeared. To retrieve a list of supported values, use the GET /v3/content/genre/query endpoint. Comedy
ContentGenre3 String 32 The third genre of the content in which the impression appeared. To retrieve a list of supported values, use the GET /v3/content/genre/query endpoint. Adventure
ContentGenre4 String 32 The fourth genre of the content in which the impression appeared. To retrieve a list of supported values, use the GET /v3/content/genre/query endpoint. Romance
ContentGenre5 String 32 The fifth genre of the content in which the impression appeared. To retrieve a list of supported values, use the GET /v3/content/genre/query endpoint. Horror
ContentRating String 128 The matched rating of the content in which the impression appeared. To retrieve a list of supported values, use the GET /v3/content/rating/query endpoint. MPAA PG-13 - Parents Strongly Cautioned
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
DataUsageTotalCost Decimal N/A The cost of additional 3rd-party data. 0.0008265
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
DigitalOutOfHomeScreenName String 128 The name of the DOOH screen where the impression was served. PE-QUTRANS-NU803
DigitalOutOfHomeVenueTypeId String 32 The ID of the out-of-home venue type for digital out-of-home (DOOH) advertising displays. 0302
DigitalOutOfHomeVenueTypeName String 32 The categorization of venue types for DOOH advertising displays. For details, see Digital Out-of-Home Screen Venue Types. Outdoor>Urban Panels
FeeFeaturesCost Decimal N/A The cost of our additional platform features. 0.0000145
ImpressionId GUID 36 The unique ID associated with the impression event. 0ce7c305-74e7-4f25-97bf-433e70f1cb66
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
InventoryChannel Integer N/A The inventory channel ID assigned to the impression served. For supported values, see Inventory channels. 1
InventoryChannelName String 32 The inventory channel name assigned to the impression served. For channel names, see Inventory channels. TV
IPAddress String 100 The IP address of the device that received an impression at the time of impression. 69.114.16.131
Latitude Decimal N/A The latitude associated with the impression event truncated to two decimals of precision. 40.65
LiveStream Boolean N/A Indicates whether the content was shown in real time (true) or not (false). true
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
Longitude Decimal N/A The longitude associated with the impression event truncated to two decimals of precision. -111.92
MatchedGenre String 32 The genre of the content in which the impression appeared. If there is no match found, the genre is reported as other. To retrieve a list of supported values, use the GET /v3/content/genre/query endpoint.
If this field has the null value, it means that there was no value present in the original log line.		 game-show
MatchedLanguageCode String 32 The targeted language that matched the impression. en
MediaCostInBucks Decimal N/A The cost from the SSP/exchange. 0.003306
NielsenDMA* Integer N/A The numeric ID for the metropolitan area associated with the impression event. 535
NativePlacementTypeId Integer N/A The numeric ID for the format or layout of the native ad unit in which the impression occurred. 1
OS Integer N/A The numeric ID for the operating system (OS) associated with the impression event. For supported values, see Operating systems. 122
OSFamily Integer N/A The numeric ID for the operating system family associated with the impression event. For supported values, see OS families. 2
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
PartnerCostInUSDollars Decimal N/A The aggregate amount of the The Trade Desk cost and any additional platform rate fee. 0.004996386
PartnerCurrency String 3 Three letter currency code for partner, chosen during setup. NZD
PartnerCurrencyExchangeRateFromUSD Decimal N/A Numeric rate of exchange in use at the time of the event to convert from USD to the partner currency. 1.54
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
ProcessedTime DateTime N/A The timestamp of when the log line was processed in REDS, formatted as HH:mm:ss. 45:26.6
Recency Integer N/A The number of minutes since the user was seen on the targeted data element. 12339
ReferrerCategories String 500 A comma-separated list of site category IDs from The Trade Desk universal taxonomy. NOTE: This column is populated only if ad groups are targeting the referrer's categories. N/A
Region String 50 Region within a country where the impression was served. Could be a state, province, county or other region. Ohio
RenderingContext String 32 The environment in which the impression event took place. mobileoptimizedweb
Site String 128 The domain or app where the impression was purchased and displayed.
  • Web: thetradedesk.com
  • iOS: 343200656
  • Android: com.rovio.angrybirds
SupplyType String N/A The source of the inventory. OpenPath
SupplyVendorId Integer 32
  • The numeric ID for the supply vendor from which the impression would be purchased.
  • For OpenPath, this is 0.
 123456
SupplyVendorName String 32
  • The name of the supply vendor from which the impression would be purchased.
  • For OpenPath, this is an empty string.
 Yahoo Exchange
SupplyVendorPublisherId String 50 The unique ID for the publisher from which the impression was purchased.
NOTE: For OpenPath, this is 0.		 1
TemperatureBucketEndInCelsius Integer N/A Ending value of temperature range associated with the geo in which the impression was logged. For supported values, see Temperature values in celsius. null
TemperatureBucketStartInCelsius Integer N/A Starting value of temperature range associated with the geo in which the impression was logged. For supported values, see Temperature values in celsius. 10
TemperatureInCelsius Decimal N/A The Temperature associated with the geo in which the impression was logged. 21.87
TTDNativeContextTypeId Integer N/A The numeric ID for the context in which the native ad associated with the impression appeared. For supported values, see The Trade Desk native context types. 112
TVQualityIndex Decimal N/A The TV Quality Index (TVQI) measures the quality of inventory a campaign runs, on a scale of 1 - 100. It is an aggregate of the weighted scores for eight criteria (content, addressability, playback type, device type, content duration, production quality, content signal transparency, and market type) across three pillars of quality (content, ad experience, and signals). For details on each score component, see TV Quality Index in the Knowledge Portal. 0.6
UserHourOfWeek Integer N/A The hour of the week from the user's timezone in which the impression occurred. Possible values are between 0 and 167. For supported values, see User's days and hours of the week. 15
VolumeControlPriority Integer N/A The numeric value of the volume control priority associated with the impression event. The supported values include:
  • 2 (Highest)
  • 1 (High)
  • 0 (Neutral)
  • -1 (Lowest)
 -1
Zip String N/A The ZIP code or postal code. 440022
TradingModeName String N/A Deprecated and no longer returns a value. null
AudienceUnlimitedTierName String N/A The Audience Unlimited tier that is associated with the campaign. The supported values include:
  • Full
  • Lite
  • None
 Full
ImpressionCostInUSDollars Decimal N/A Deprecated and no longer returns a value. null
SellingPartyName String 64 The name of the seller, publisher, or intermediary. FreeWheel
SellingPartyType String N/A The type of selling party, such as seller, publisher, or intermediary. Intermediary
SellingPartyId Integer 32 The known agent ID of the selling party. 123456
ContentProductionQuality Integer N/A The production quality of the content in which the impression appears. Possible values include the following:
  • 0 (Unknown)
  • 1 (Professionally Produced)
  • 2 (Prosumer)
  • 3 (User Generated Content (UGC))
 1
AudioFeedId Integer N/A The ID assigned to a type of audio feed. For supported values, see Audio feed. 3
AudioFeedName String 32 The name of the type of audio feed. For supported values, see Audio feed. Podcast
AudioContentSeries String 256 The series title of the audio content, such as a playlist or podcast name. On Purpose with Jay Shetty
CustomCampaignFlightLabel String 40 The campaign flight label set by the advertiser or agency within the platform. BI-00009801

* © 2026, The Nielsen Company (US), LLC. The DMA® data is used pursuant to a license from The Nielsen Company (US), LLC. Any use and/or reproduction of these materials without the express written consent of The Nielsen Company (US), LLC, is strictly prohibited. DMA® data is valid for the period 2025 - 2026. DMA® is a registered service mark of The Nielsen Company (US), LLC and is used pursuant to license.

Audio feed

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

ID Name API Property
1 Music streaming service MUSIC_STREAMING_SERVICE
2 FM/AM broadcast FM_AM_BROADCAST
3 Podcast PODCAST
4 Catch-up radio CATCH_UP_RADIO
5 Web Radio WEB_RADIO
6 Video game VIDEO_GAME
7 Text to speech TEXT_TO_SPEECH

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

Content duration ranges

The following table lists the range values in minutes for the ContentDuration field.

Range
0-15
15.01-30
30.01-45
45.01-60
60.01-75
75.01-90
90.01-105
105.01-120
120.01+

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

Operating systems (OS)

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

ID Name
101 Other
102 Windows XP
103 Windows Vista
104 Windows 7
105 Windows 8
106 Android 2.3
107 Android 4.0
108 Android 4.1
109 Android 4.2
110 Android 4.3
111 Android 4.4
112 Android 5.0
113 iOS 5.1
114 iOS 6.0
115 iOS 6.1
116 iOS 7.0
117 iOS 7.1
118 iOS 8.0
120 Windows Phone 8.0
121 Windows Phone 8.1
122 Windows 10
129 iOS 8.1
130 iOS 8.2
131 iOS 8.3
132 iOS 8.4
133 iOS 9.0
134 iOS 9.1
135 iOS 9.2
136 Android 6.0
137 iOS 9.3
138 iOS 10.0
139 Android 7.0
140 Android 7.1
141 Android 5.1
142 iOS 10.1
143 iOS 10.2
144 iOS 10.3
145 Android 8.0
146 iOS 11.0
147 iOS 11.1
148 iOS 11.2
149 iOS 11.3
150 iOS 12.0
151 iOS 12.1
152 iOS 12.2
153 iOS 12.3
154 Android 8.1
155 Android 9.0
156 Android 10.0
157 iOS 12.4
158 iOS 13.0
159 iOS 13.1
160 iOS 13.2
161 iOS 13.3
162 Android 11.0
163 iOS 13.4
164 iOS 14.0
165 iOS 14.1
166 iOS 14.2
167 iOS 14.3
168 iOS 13.5
169 iOS 13.6
170 iOS 13.7
171 iOS 14.4
172 iOS 14.5
173 iOS 14.6
174 iOS 14.7
175 iOS 15.0
176 iOS 15.1
177 iOS 15.2
178 iOS 14.8
179 Android 12.0
180 iOS 15.3
181 iOS 15.4
182 iOS 15.5
183 iOS 15.6
184 iOS 16.0
185 iOS 15.7
186 iOS 16.1
187 iOS 16.2
188 iOS 16.3
189 Android 12.1
190 Android 13.0
191 iOS 12.5
192 iOS 16.4
193 iOS 16.5
194 iOS 16.6
195 iOS 17.0
196 iOS 16.7
197 iOS 17.1
198 iOS 17.2
199 Android 14.0
200 iOS 17.3
201 iOS 17.4
202 iOS 17.5
203 iOS 18.0
204 iOS 17.6
205 MacOS 10.0
206 MacOS 10.1
207 MacOS 10.2
208 MacOS 10.3
209 MacOS 10.4
210 MacOS 10.5
211 MacOS 10.6
212 MacOS 10.7
213 MacOS 10.8
214 MacOS 10.9
215 MacOS 10.10
216 MacOS 10.11
217 MacOS 10.12
218 MacOS 10.13
219 MacOS 10.14
220 MacOS 10.15
221 MacOS 11.0
222 MacOS 11.1
223 MacOS 11.2
224 MacOS 11.3
225 MacOS 11.4
226 MacOS 11.5
227 MacOS 11.6
228 MacOS 11.7
229 MacOS 12.0
230 MacOS 12.1
231 MacOS 12.2
232 MacOS 12.3
233 MacOS 12.4
234 MacOS 12.5
235 MacOS 12.6
236 MacOS 12.7
237 MacOS 13.0
238 MacOS 13.1
239 MacOS 13.2
240 MacOS 13.3
241 MacOS 13.4
242 MacOS 13.5
243 MacOS 13.6
244 MacOS 14.0
245 MacOS 14.1
246 MacOS 14.2
247 MacOS 14.3
248 MacOS 14.4
249 MacOS 14.5
250 MacOS 14.6
251 MacOS 15.0
252 iOS 18.1
253 iOS 17.7
254 Android 15.0
255 iOS 18.2
256 iOS 18.3
257 iOS 18.4
258 Windows 11
259 iOS 18.5
260 Android 16.0
261 iOS 18.6
262 iOS 19.0
263 iOS 18.7
264 iOS 26.0
265 iOS 26.1
266 iOS 26.2
267 iOS 26.3
268 iOS 26.4
269 iOS 26.5
270 iOS 26.6
271 iOS 27.0
272 Android 17.0

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

Temperature values in celsius

The following table lists the IDs for the TemperatureBucketStartInCelsius and TemperatureBucketEndInCelsius fields.

ID Name
null Below Freezing
-30 Below Freezing
-10 Freezing
0 Cold
10 Cold
18 Comfortable
24 Warm
38 Sweltering

The Trade Desk native context types

The following table lists the IDs for the TTDNativeContextTypeId field.

ID Name
0 Unclassified
10 Content—Unclassified
110 Content—General
111 Content—Article
112 Content—Video
113 Content—Audio
114 Content—Image
115 Content—User-Generated
20 Social—Unclassified
220 Social—General
221 Social—Email
222 Social—Chat or IM
30 Product—Unclassified
330 Product—Selling Products
331 Product—Application Store/Marketplace
332 Product—Review

User's days and hours of the week

The following table lists the IDs for the UserHourOfWeek field.

ID Value
0 Sunday: 0:00
1 Sunday: 1:00
2 Sunday: 2:00
3 Sunday: 3:00
4 Sunday: 4:00
5 Sunday: 5:00
6 Sunday: 6:00
7 Sunday: 7:00
8 Sunday: 8:00
9 Sunday: 9:00
10 Sunday: 10:00
11 Sunday: 11:00
12 Sunday: 12:00
13 Sunday: 13:00
14 Sunday: 14:00
15 Sunday: 15:00
16 Sunday: 16:00
17 Sunday: 17:00
18 Sunday: 18:00
19 Sunday: 19:00
20 Sunday: 20:00
21 Sunday: 21:00
22 Sunday: 22:00
23 Sunday: 23:00
24 Monday: 0:00
25 Monday: 1:00
26 Monday: 2:00
27 Monday: 3:00
28 Monday: 4:00
29 Monday: 5:00
30 Monday: 6:00
31 Monday: 7:00
32 Monday: 8:00
33 Monday: 9:00
34 Monday: 10:00
35 Monday: 11:00
36 Monday: 12:00
37 Monday: 13:00
38 Monday: 14:00
39 Monday: 15:00
40 Monday: 16:00
41 Monday: 17:00
42 Monday: 18:00
43 Monday: 19:00
44 Monday: 20:00
45 Monday: 21:00
46 Monday: 22:00
47 Monday: 23:00
48 Tuesday: 0:00
49 Tuesday: 1:00
50 Tuesday: 2:00
51 Tuesday: 3:00
52 Tuesday: 4:00
53 Tuesday: 5:00
54 Tuesday: 6:00
55 Tuesday: 7:00
56 Tuesday: 8:00
57 Tuesday: 9:00
58 Tuesday: 10:00
59 Tuesday: 11:00
60 Tuesday: 12:00
61 Tuesday: 13:00
62 Tuesday: 14:00
63 Tuesday: 15:00
64 Tuesday: 16:00
65 Tuesday: 17:00
66 Tuesday: 18:00
67 Tuesday: 19:00
68 Tuesday: 20:00
69 Tuesday: 21:00
70 Tuesday: 22:00
71 Tuesday: 23:00
72 Wednesday: 0:00
73 Wednesday: 1:00
74 Wednesday: 2:00
75 Wednesday: 3:00
76 Wednesday: 4:00
77 Wednesday: 5:00
78 Wednesday: 6:00
79 Wednesday: 7:00
80 Wednesday: 8:00
81 Wednesday: 9:00
82 Wednesday: 10:00
83 Wednesday: 11:00
84 Wednesday: 12:00
85 Wednesday: 13:00
86 Wednesday: 14:00
87 Wednesday: 15:00
88 Wednesday: 16:00
89 Wednesday: 17:00
90 Wednesday: 18:00
91 Wednesday: 19:00
92 Wednesday: 20:00
93 Wednesday: 21:00
94 Wednesday: 22:00
95 Wednesday: 23:00
96 Thursday: 0:00
97 Thursday: 1:00
98 Thursday: 2:00
99 Thursday: 3:00
100 Thursday: 4:00
101 Thursday: 5:00
102 Thursday: 6:00
103 Thursday: 7:00
104 Thursday: 8:00
105 Thursday: 9:00
106 Thursday: 10:00
107 Thursday: 11:00
108 Thursday: 12:00
109 Thursday: 13:00
110 Thursday: 14:00
111 Thursday: 15:00
112 Thursday: 16:00
113 Thursday: 17:00
114 Thursday: 18:00
115 Thursday: 19:00
116 Thursday: 20:00
117 Thursday: 21:00
118 Thursday: 22:00
119 Thursday: 23:00
120 Friday: 0:00
121 Friday: 1:00
122 Friday: 2:00
123 Friday: 3:00
124 Friday: 4:00
125 Friday: 5:00
126 Friday: 6:00
127 Friday: 7:00
128 Friday: 8:00
129 Friday: 9:00
130 Friday: 10:00
131 Friday: 11:00
132 Friday: 12:00
133 Friday: 13:00
134 Friday: 14:00
135 Friday: 15:00
136 Friday: 16:00
137 Friday: 17:00
138 Friday: 18:00
139 Friday: 19:00
140 Friday: 20:00
141 Friday: 21:00
142 Friday: 22:00
143 Friday: 23:00
144 Saturday: 0:00
145 Saturday: 1:00
146 Saturday: 2:00
147 Saturday: 3:00
148 Saturday: 4:00
149 Saturday: 5:00
150 Saturday: 6:00
151 Saturday: 7:00
152 Saturday: 8:00
153 Saturday: 9:00
154 Saturday: 10:00
155 Saturday: 11:00
156 Saturday: 12:00
157 Saturday: 13:00
158 Saturday: 14:00
159 Saturday: 15:00
160 Saturday: 16:00
161 Saturday: 17:00
162 Saturday: 18:00
163 Saturday: 19:00
164 Saturday: 20:00
165 Saturday: 21:00
166 Saturday: 22:00
167 Saturday: 23:00

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
DeviceType Integer N/A The numeric ID for type of device on which the impression was served. For supported values, see Device types. 6
DisplayImpressionId GUID 36 The unique identifier associated with the impression event. w063a21c-8760-42f6-a2c0-08e68b4db125
LogEntryTime DateTime N/A 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
Keyword String 250 A word or phrase describing the content surrounding the click event. TradeDeskTradeDesk RTBTradeDesk Programmatic
KeywordId String 25 The unique identifier associated with the keyword. abc123
MatchType String 100 Determines how closely an input matches your keyword. ExactBroadPhrase
DistributionNetwork String 25 Used for search clicks via The Trade Desk Click Tag Converter. googlebing
RawUrl String 100 The full URL received to track the click. /track/clk?imp=a72306d5-452a-45e8-b307-427f886161d2&ag=8iucaai&crid=zafvmlzs&fq=0&td_s=site.com&rcats=7sp&mcat=&mste=&

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
CampaignId String 32 The unique platform ID for the campaign. cb45ac6
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

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