REDS impressions feed columns (Walmart DSP)
The following table lists the Impressions feed columns (also known as stream fields) in the order they appear in the data file. Here's what you need to know about the content presented on this page:
- To help you navigate through this lengthy table, we've provided two separate lists to highlight the fields with enum values: Fields with no more than five enum values and Fields with more than five enum values. We've used five as the cutoff point for simplicity, though this threshold is arbitrary.
- For fields with too many enum values to fit in the main table, the Fields with more than five enum values list links to separate tables with all the options. These fields are also listed in the navigation panel on the right.
- The field length is only a suggestion and can include more characters.
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.
| 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 impression event. | 0ce7c305-74e7-4f25-97bf-433e70f1cb66 |
PartnerId |
String | 32 | The unique platform ID for the partner. | a1b2c34 |
AdvertiserId |
String | 32 | The unique platform ID for the advertiser. | cb12ac3 |
CampaignId |
String | 32 | The unique platform ID for the campaign. | cb45ac6 |
AdGroupId |
String | 32 | The unique platform ID for the ad group. | cb78ac9 |
PrivateContractId |
String | 32 | The unique platform ID for a group of deal IDs that was used to bid on this impression. | q021dabc |
CreativeId |
String | 32 | The unique platform ID for the creative. | 345bc1a |
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 |
SupplyVendorPublisherId |
String | 50 | The unique numeric ID for the publisher from which the impression was purchased. | 1 |
DealId |
String | 128 | The deal ID used to buy a given impression. | 948 |
Site |
String | 128 | The domain or app where the impression was purchased and displayed. |
|
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 |
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 |
CountryLong |
String | 50 | The country associated with the impression event. | United States |
Region |
String | 50 | Region within a country where the impression was served. Could be a state, province, county or other region. | Ohio |
NielsenDMA* |
Integer | N/A | The numeric ID for the metropolitan area associated with the impression event. | 535 |
City |
String | N/A | The city where the impression was served. | Los Angeles |
DeviceType |
Integer | N/A | The numeric ID for type of device on which the impression was served. For supported values, see Device types. | 6 |
OSFamily |
Integer | N/A | The numeric ID for the operating system family associated with the impression event. For supported values, see OS families. | 2 |
Recency |
Integer | N/A | The number of minutes since the user was seen on the targeted data element. | 12339 |
MatchedLanguageCode |
String | 32 | The targeted language that matched the impression. | en |
MediaCostInBucks |
Decimal | N/A | The cost from the SSP/exchange. | 0.003306 |
FeeFeaturesCost |
Decimal | N/A | The cost of our additional platform features. | 0.0000145 |
DataUsageTotalCost |
Decimal | N/A | The cost of additional 3rd-party data. | 0.0008265 |
TTDCostInUSDollars |
Decimal | N/A | The aggregate amount of the Media Cost and Data Cost. | 0.0041325 |
PartnerCostInUSDollars |
Decimal | N/A | The aggregate amount of the platform cost and any additional platform rate fee. | 0.004996386 |
AdvertiserCostInUSDollars |
Decimal | N/A | The total of platform cost, fee features cost, any additional platform rate fee, and partner markup (if it is being tracked in our platform). | 0.004996386 |
ProcessedTime |
DateTime | N/A | The timestamp of when the log line was processed in REDS, formatted as HH:mm:ss. |
45:26.6 |
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 |
RenderingContext |
String | 32 | The environment in which the impression event took place. | mobileoptimizedweb |
Carrier |
Integer | N/A | The Carrier of the device associated with the Impression event | 635 |
PartnerCurrency |
String | 3 | Three letter currency code for partner, chosen during setup | NZD (New Zealand Dollar) |
PartnerCurrencyExchangeRateFromUSD |
Decimal | N/A | Numeric rate of exchange in use at the time of the event to convert from USD to PartnerCurrency | 1.54 |
AdvertiserCurrency |
String | 3 | Three letter currency code for advertiser, chosen during setup | PYG (Paraguay Guarani) |
AdvertiserCurrencyExchangeRateFromUSD |
Decimal | N/A | Numeric rate of exchange in use at the time of the event to convert from USD to AdvertiserCurrency | 6,297.75 |
PartnerIdInteger |
Integer | N/A | The integer unique ID for the partner as assigned by The Trade Desk. | 1234 |
AdvertiserIdInteger |
Integer | N/A | The integer unique ID for the advertiser as assigned by The Trade Desk. | 1234567 |
CampaignIdInteger |
Integer | N/A | The integer unique ID for the campaign as assigned by The Trade Desk. | 123456 |
AdGroupIdInteger |
Integer | N/A | The integer unique ID for the ad group as assigned by The Trade Desk. | 123456 |
CreativeIdInteger |
Integer | N/A | The integer unique ID for the creative as assigned by The Trade Desk. | 123456 |
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 |
AdsTxtSellerType |
Integer | N/A | The ads.txt seller type that indicates the relationship between SSP and Publisher for a given impression, as defined by the IAB. The supported values include:
|
1 |
AuctionType |
String | 25 | The SSP declared auction type. The supported values include:
|
FirstPrice |
SupplyVendorId |
String | 50 | The unique numeric ID for the supply vendor from which the impression was purchased. | 2 |
VolumeControlPriority |
Integer | N/A | The numeric value of the volume control priority associated with the impression event. The supported values include:
|
-1 |
NativePlacementTypeId |
Integer | N/A | The numeric ID for the format or layout of the native ad unit in which the impression occurred. The supported values include:
|
1 |
TTDNativeContextTypeId |
Integer | N/A | The numeric ID for the context in which the native ad associated with the impression appeared. For supported values, see Native context types. | 112 |
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 |
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 |
LiveStream |
Boolean | N/A | Indicates whether the content was shown in real time (true) or not (false).If this field has the null value, it means that there was no value present in the original log line. |
true |
InventoryChannelName |
String | 32 | The inventory channel name assigned to the impression served. For channel names, see Inventory channels. | TV |
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 |
* © 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.
Fields with no more than five enum values
The following fields contain up to five enum values and are listed in alphabetical order. Clicking the respective link returns you to the previous table.
- AdsTxtSellerType
- AuctionType
- NativePlacementTypeId
- UserHourOfWeek
- VolumeControlPriority
Fields with more than five enum values
The following fields contain more than five enum values and are listed in alphabetical order. Clicking the respective link takes you to the table associated with the field. These fields are also listed in the navigation panel on the right.
NOTE: Some fields not listed here have more than five enum values, but they require querying, such as Matched genre.
| Value Group | Fields |
|---|---|
| Audio feed | AudioFeedId,AudioFeedName |
| Content duration ranges | ContentDuration |
| Device types | DeviceType |
| Inventory channels | InventoryChannel, InventoryChannelName |
| OS families | OSFamily |
| The Trade Desk native context types | TTDNativeContextTypeId |
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 |
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.
| ID | Name | Notes |
|---|---|---|
| 1 | Other | N/A |
| 2 | PC | N/A |
| 3 | Tablet | N/A |
| 4 | Mobile | N/A |
| 5 | Roku | Deprecated |
| 6 | ConnectedTV | N/A |
| 7 | OutOfHome | N/A |
| 8 | HomeAssistant | N/A |
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 | Notes |
|---|---|---|---|
| 0 | Other | Other |
Deprecated |
| 1 | Display | Display |
N/A |
| 2 | Video | Video |
N/A |
| 3 | Audio | Audio |
N/A |
| 4 | TV | TV |
N/A |
| 5 | Native Display | NativeDisplay |
N/A |
| 6 | Native Video | NativeVideo |
N/A |
| 7 | Out of Home | OutOfHome |
N/A |
OS families
The following table lists the IDs for the OSFamily field.
| ID | Name |
|---|---|
| 1 | Other |
| 2 | Windows |
| 3 | OS X |
| 4 | Linux |
| 5 | iOS |
| 6 | Android |
| 7 | Windows Phone |
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 |