Digital Measurement Content Asset Metadata

Engineering Portal / Digital / US DCR & DTVR / Digital Measurement Content Asset Metadata

The Nielsen "Server-To-Server" method of collecting DCR data requires the distributor to make available each Asset (Episode) referenced in the DCR Viewing file in a separate metadata file (a.k.a metadata catalog). In the case of a stream that has one version with blackouts and one without, one with mobile and one non-mobile, each stream would have its own unique asset id.

Delivery Specifications

Consolidated list of asset metadata catalog that is up to date for a particular hour needs to be provided in a single file following the naming convention specified below. The metadata needs to be in a json lines format, including a header line. A reasonable effort needs to be made to remove expired/inactive asset ids, to avoid size creep.

S3 Bucket and Prefix Naming Convention

useast1-nlsn-w-dig-sei-<partnerid>-feeds-<env>/<filetype>/yyyy/mm/dd/hh/<object>

Name	Description
partnerid	Abbreviation provided by Nielsen for each provider or publisher
env	test or prod
filetype	dcrassetmetadata
split	a separate data split, can be by platform (ex.: ios, browser, android, ctv), by country (us, ca, jp, etc.), by publisher, by team, etc. or “all” (if data is provided in one split).
yyyy/mm/dd/hh	yyyy - year mm - month dd - date padded with 0 example 01, 02,..., 31 hh - hour padded with 0 example 00, 02,..., 23

S3 Bucket and Prefix Naming Convention

<partner_id>_<file_type>_<int_id>[.gz]

Name	Description
partnerid	Abbreviation provided by Nielsen for each provider or publisher
filetype	dcrassetmetadata
initid	integration id: unique identifier provided by Nielsen
[.gz]	Uncompressed json lines (no extension) -  splittable, ideal for medium size files, less than 5 GB, preferred for metadata. Optional compression formats supported: [.gz] - non splittable, requires multiple files, if data larger than 32 MB

Success File

Empty _SUCCESS file should be provided to indicate that data delivery for a particular hour and split is completed (even if there is no data for that particular hour and split).

Data delivery example for hour 10 (10:00:00 AM UTC to 10:59:59 PM UTC):

useast1-nlsn-w-dig-sei-acme-feeds-prod/dcrassetmetadata/2022/06/12/10/ acme_dcrassetmetadata_a9ddf15ea054ea415718767ea6

useast1-nlsn-w-dig-sei-acme-feeds-prod/dcrassetmetadata/2022/06/12/10/_SUCCESS

SLA

The files must be delivered into the proper S3 bucket within 2 hours of the broadcast. For example, files from 1:00 AM to 1:15 AM must be delivered before 3:00 AM. The metadata file should be delivered to an S3 bucket before any Viewing file has been delivered.

Schema Parameter Definitions

Parameter		Description	Required	Format / Example
assetid		In-house id used for a video asset (TMS ID if available)	Yes	Format: alphanumeric, Example: VID123456789 AssetId needs to be unique at episode level
assetname		In-house video asset name, for troubleshooting	Yes	Format: alphanumeric Examples: TMS ID, EIDR ID or Episode title
programname		Name of the program	Yes	Format: alphanumeric, Max 25 char’s; no special characters Example: Nightly News
episodetitle		Title of the episode	Yes	Format: alphanumeric
episodelen		Total episode length	Yes	Format: Integer (seconds) Example: 3600 For continuous live stream or unknown duration use 24*60*60 (86400) Can be updated with a replacement asset file when the live playout ends, and the exact duration becomes known
isfullepisode		Full episode Flag (indicates full episode or a clip)	Yes	Format: integer – 0 (not full episode), 1 (full episode)
genre		Nielsen genre code	No	Format: alphanumeric Example: CV (comedy variety), N (news)
airdate		The date the episode was first made available on Traditional TV	No	Format: US ET:  YYYYMMDDHHMMSS Example: 19970716231256 For the US, the time should be specified as Eastern Timezone. Other countries will use a local timezone. This value can be updated with a replacement asset file if the original air date changes
webpageurl		Website Identifier, for diagnostics, can be turned off/on as needed	Optional	Format: alphanumeric  (max 2k) Example:https://www.myapp.com/video.html

Note: All parameters are case sensitive.