The following attributes are captured for each occurrence of an creative in the media types monitored for media data.
Attribute | Definition | Data Type | Example |
Ad Code | Ad ID (Foreign Key to Ad-Level Detail) | Text | ENSUFB-0284 |
Market/DMA | Market | Text | National |
Country | Country | Text | United States |
MediaOutlet | Station for Broadcast; Publication for Print; Website for Digital | Text | FX |
RunDate | Run Date for TV/Radio/Print; First day of media week for Digital | Datetime | 4/25/2020 |
RunTime/Edition | Run Time (in datetime of given DMA) for Broadcast; Edition for Print; NA for Digital | Text | 16:27 |
Daypart | Daypart for Broadcast; Color for Print; Parent Website for Digital | Text | Early Fringe |
Program | Program for TV; Program Format for Radio; Page Count for Print; File Type for Digital | Text | Mike & Molly |
AdSpend/Cost ($000's) | Estimated Spend in thousands of dollars | Number | 1.822 |
Month | (Calendar) Month of Run Date | Number | 4 |
Quarter | (Calendar) Quarter of Run Date | Text | Q2 |
Media Week | Media Week of Run Date | Number | 17 |
Year | (Calendar) Year of Run Date | Number | 2020 |
Media Type | Medium (TV; Radio; Online Video; etc.) | Text | TV |
Media Sub Type/Submedium | National Cable/Network/National Syndication/Spot for TV; Newspaper/Magazine for Print; NA for other media | Text | National Cable |
General Media/Hispanic Media/Asian Media | Indication of whether this occurrence was on General, Hispanic, or Asian Targeted Media Outlets | Text | Hispanic Media |
African American Media | Indication of whether this occurrence was on an African American targeted media outlet within our General Media Universe. | Text | African American Media |
LGBTQ+ Media | Indication of whether this occurrence was on an LGBTQ+ targeted media outlet within our General Media Universe. | Text | LGBTQ+ Media |
IDNumber | Occurrence level ID, unique by medium | Number | 38484620755 |
Network Affiliation/Spot Station | Network Affiliation for TV; Nullable for other media | Text | FOX |
Impressions | Online Display, Online Video, and Mobile; Nullable for other media. May require additional subscription fees. | Number | 26151 |
Ad Size | Ad size | Number (L x W) | 3 x 21.0 |
Format | Format for digital (Leaderboard); page size for print (1/6th page) | Varchar | Leaderboard |
Program Genre | Program genre | Text | Sports-Event |
Audience | Requires a separate Nielsen license. May require additional subscription fees. | Number | 330201 |
Rating (GRPs/TRPs) | Requires a separate Nielsen license. May require additional subscription fees. | Number | 0.42 |
Occurrences | Separate line for each occurrence | Number | 1 |
Digital App/Website Genre | Genre of App/Website of a digital ad occurrence | Text | News & Information: General News |
Circulation | Circulation or number of copies distributes on an average day of the source publication of the print ad. | Number | 38483 |
Week Of | Monday date of the media week. Media types typically run from Monday - Sundays. | Number | 5/25/2020 |