Aggregated curated feeds
The following table lists the feed fields used in aggregated curated feeds.
Here's what you need to know about the content presented in this reference table:
- The field length is only a suggestion and can include more characters.
- When parsing files, use file headers instead of column positions. The order of columns in these tables may not match the order in the feeds.
- Certain fields in this feed might be modified to comply with regional regulations. For data scrubbing and retention details, see Curated REDS data practices.
- To learn more about curated REDS, review our Curated REDS feeds documentation.
Aggregated curated feeds table reference
| Field (Column) | Data Type | Suggested String Length | Description | Example |
|---|---|---|---|---|
City |
String | N/A | The city where the impression was served. | Los Angeles |
NielsenDMA* |
Integer | N/A | The numeric ID for the metropolitan area associated with the impression event. | 535 |
Site |
String | 128 | The domain or app where the impression was purchased and displayed. |
|
Date |
Date | N/A | The hour that identifies when the event occurred in UTC. | N/A |
UserDayOfWeek |
N/A | N/A | The day of the week. | 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 |
UserHourOfDay |
N/A | N/A | The hour of the day. | N/A |
AudienceId |
String | 32 | The unique platform ID for the audience. An audience is made up of one or more data groups. | zbcavmlz |
CampaignId |
String | 32 | The unique platform ID for the campaign. | cb45ac6 |
AdGroupId |
String | 32 | The unique platform ID for the ad group. | cb78ac9 |
CreativeId |
String | 32 | The unique platform ID for the creative. | 345bc1a |
PrivateContractId |
String | 32 | The unique platform ID for a group of deal IDs that was used to bid on this impression. | q021dabc |
Country |
String | N/A | The country associated with the bid event. | N/A |
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 |
Media Type |
String | N/A | Type of media used. | Display, Video, Native, Audio |
App |
N/A | N/A | The name of the application. | N/A |
DealId |
String | 128 | The deal ID used to buy a given impression. | 948 |
Seller Domain |
N/A | N/A | The domain of the seller. | N/A |
SellerName |
String | 128 | The name of the seller. IMPORTANT: You cannot change this name after the proposal is created. |
Seller Name |
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 |
Impressions |
N/A | N/A | The total count of times an ad was served. | N/A |
Clicks |
N/A | N/A | The total count of click events recorded. | N/A |
CTR |
N/A | N/A | Click-through rate. | N/A |
Player Completed Views |
N/A | N/A | The total number of times a video ad was played all the way to the end (completed) by users, as tracked by the video player. | N/A |
Player Engaged Views |
N/A | N/A | The number of times a video ad was considered engaged by a user. | N/A |
Sampled Tracked Impressions |
N/A | N/A | This creative was trackable. | N/A |
Sampled Viewed Impressions |
N/A | N/A | This creative was trackable. | N/A |
01 - Total Click + View Conversions |
Integer | N/A | Total number of conversions from both click attribution conversion count and view attribution conversion count. | 1 |
02 - Total Click + View Conversions |
Integer | N/A | Total number of conversions from both click attribution conversion count and view attribution conversion count. | 1 |
03 - Total Click + View Conversions |
Integer | N/A | Total number of conversions from both click attribution conversion count and view attribution conversion count. | 1 |
04 - Total Click + View Conversions |
Integer | N/A | Total number of conversions from both click attribution conversion count and view attribution conversion count. | 1 |
05 - Total Click + View Conversions |
Integer | N/A | Total number of conversions from both click attribution conversion count and view attribution conversion count. | 1 |
AdvertiserCostInPartnerCurrency |
Decimal | N/A | The sum of the partner cost and agency fees in the partner-specified currency, if applied in the campaign's fees and rates. | 0.00123457890123 |
AdvertiserCurrency |
String | 3 | Three letter currency code for advertiser, chosen during setup. | PYG |
AdvertiserId |
String | 32 | The unique platform ID for the advertiser. | cb12ac3 |
AdvertiserName |
String | 64 | The name of the advertiser. | Advertiser Name |
CampaignName |
String | 256 | The name of the campaign. | Campaign Name |
AdGroupName |
String | 256 | The name of the ad group. | Ad Group Name |
CreativeName |
String | 256 | The name of the creative. | CreativeName |
AudienceName |
String | 64 | The name of the audience. | Audience Name |
PrivateContractName |
String | 256 | The name of the inventory contract. | Private Contract Name |
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 |
* © 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.
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 |
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 |