Excel - film metadata fields

Field-by-field reference for the Film Excel template.

Overview

This reference describes the fields in the Film Excel metadata template. For template downloads and rules on formatting, structure, row limits, and file format, see the Excel Metadata Overview.

Deliver the workbook and its referenced files using the Aspera or S3 delivery method approved during onboarding.

Each row represents a single movie. The language column identifies the language of the title, synopses, video, captions, subtitles, audio dub, and artwork in that row. See the Excel Metadata Overview.

Fields are grouped below into: Package Info, Content Descriptors, Ad Breaks & Cue Points, Cast & Crew, Assets, Artwork, and Availability.


Package Info

provider

Name of the content owner, studio, or network.

Excel ColumnAccepted ValuesRequired
providerExample: Roku OriginalsRequired

contentType

Content type of the package.

Excel ColumnAccepted ValuesRequired
contentTypefilmRequired

language

Language of the title, synopses, video, captions, subtitles, audio dubs, and artwork listed in the row. The value must use a supported language code. A region code is recommended to distinguish variants such as es-MX and es-ES.

Excel ColumnAccepted ValuesRequired
languageValid language valueRequired

original_spoken_language

Original production language of the title. The value must use a supported language code. A region code is recommended.

Excel ColumnAccepted ValuesRequired
original_spoken_languageValid language valueRequired

country_of_origin

The primary country where the film was produced, and where the main creators, crew, and producers are established. Must conform to a supported ISO 3166-1 alpha-2 code.

Excel ColumnAccepted ValuesRequired
country_of_originValid 2-character country code per ISO 3166-1 alpha-2Preferred

asset_id

Immutable, unique identifier for a movie. The partner generates or supplies this ID. It must match the Title ID in the Avails document so Roku can track the title through processing. 50-character limit.

Excel ColumnAccepted ValuesRequired
asset_idAlphanumeric characters, hyphens, and underscores only. 50 characters maximum.Required

eidr

EIDR ID, if one exists.

Excel ColumnAccepted ValuesRequired
eidrAny valid EIDR IDOptional

tms_id

Gracenote ID, if one exists.

Excel ColumnAccepted ValuesRequired
tms_idAny valid TMS IDOptional

Content Descriptors

title

Title of the movie, in the language defined in the language column. Include only the name as it should appear on the platform. Do not add parenthetical information that is not part of the title (e.g., (Classic), (1987), (Season 1), (HD)).

Excel ColumnAccepted ValuesRequired
titleExample: Movie TitleRequired

genres

Genre classification of the content. Each movie must be delivered with at least one supported genre. See the enumerated genre list.

Excel ColumnAccepted ValuesRequired
genresSee enumerated list. No more than 10 genres per title.Required

tags

Freeform tags that describe the content beyond its genre. Roku's editorial team and recommendations engine use these tags to help viewers find content. There is no limit on the number of tags and no predefined tag list. Tags are case-sensitive, so use consistent capitalization (e.g., "Rom-Com" and "rom-com" are two distinct tags).

Excel ColumnAccepted ValuesRequired
tagsAny string under 50 charactersHighly recommended

runtime

Total runtime of the content, in whole minutes.

Excel ColumnAccepted ValuesRequired
runtimeIntegers only. Example: 90Required

release_date

Original date the content was first made available in any presentation. Must include an accurate year of release at minimum.

Excel ColumnAccepted ValuesRequired
release_dateISO 8601 format: YYYY-MM-DDRequired

rating_system and ratings

A valid movie or TV rating from the rating authority (ratingSystem) of the territory where the content will be available must be provided for each movie. If not rated by that territory's official authority, use a valid USA_PR rating instead, per tvguidelines.org guidelines (there is no official ratings body for USA_PR).

Excel ColumnAccepted ValuesRequired
rating_systemSee rating values by system and countryRequired
ratingsSee rating values by system and countryRequired

brief_synopsis

A brief synopsis of the movie, in the language defined in the language column. 100-character limit. Required for Linear OTT distribution.

Excel ColumnAccepted ValuesRequired
brief_synopsisUp to 100 charactersRequired for Linear OTT distribution

short_synopsis

A short synopsis of the content, in the language defined in the language column. 250-character limit.

Excel ColumnAccepted ValuesRequired
short_synopsis250-character synopsisRequired

long_synopsis

An optional long synopsis of the content, in the language defined in the language column. 500-character limit.

Excel ColumnAccepted ValuesRequired
long_synopsis500-character synopsisOptional

localized_brief_synopsis

A localized brief synopsis of the movie, in the language defined in the localized_language column. 100-character limit. Required for Linear OTT distribution.

Excel ColumnAccepted ValuesRequired
localized_brief_synopsisUp to 100 charactersRequired for Linear OTT distribution

closed_captions

Indicates whether the delivered title contains closed captions. The Y/N flag is required for all content intended for Roku Channel in the US. Providing this flag does not by itself require a caption file; the partner determines whether captions are required for that delivery.

Excel ColumnAccepted ValuesRequired
closed_captionsY or NRequired

closed_captions_exemption

FCC exemption code for the closed caption requirement. Required in the US if closed_captions = N.

CodeDefinition
1The content has never aired on television in the United States.
2The content has only aired on television in the United States without captions.
3The content has not aired on television in the United States with captions since September 30, 2012.
4The content does not consist of full-length video programming.
5The content does not fall within a category of online programming that requires captions under FCC regulations (47 C.F.R. § 79.4(b)).
6The FCC and/or U.S. Congress has granted an exemption from caption requirements for this content.
Excel ColumnAccepted ValuesRequired
closed_captions_exemption1, 2, 3, 4, 5, 6Required in US if closed_captions = N

Ad Breaks & Cue Points

ad_breaks

Identifies ad breaks for ad-supported content. Values must be accurate to the millisecond. If the video contains black frames for a commercial break, provide the timecode at the midpoint of that interval. This field is not required for SVOD, but Roku can ingest frame-accurate data if available.

Excel ColumnAccepted ValuesRequired
ad_breaksHH:MM:SS.sssPreferred

cue_points

Identifies the start and end times of opening credits, recaps, end credits, and behind-the-scenes footage. Values must be accurate to the millisecond.

Enter cue points as a single comma-separated text string in one cell. XML provides the same information in nested cuePoint elements; see the Film XML Reference.

Format: a comma-separated list of type=startTime>endTime pairs.

Example:

intro=00:05:10.253>00:07:15.123,recap=00:01:12.456>00:03:12.052
Excel ColumnAccepted ValuesRequired
cue_pointsFormat: type=HH:MM:SS.sss>HH:MM:SS.sss. Allowable type values: ad overlay, behind the scenes, intro, recap, endOptional

Cast & Crew

cast

Names of cast members.

Excel ColumnAccepted ValuesRequired
castComma-separated list of Firstname LastnamePreferred

director

Name of the movie's director or directors.

Excel metadata currently supports only the director role for crew credits. The Film XML Reference lists the additional roles available in XML.

Excel ColumnAccepted ValuesRequired
directorComma-separated list of Firstname LastnamePreferred

Assets

video_file_name

File name of the video, in the language defined in the language column, delivered using the approved method. Only one video is allowed per asset_id. The file name must exactly match the delivered file, including capitalization, and must not contain whitespace or special characters.

Excel ColumnAccepted ValuesRequired
video_file_nameExample: movieVideoFile.movRequired

video_file_language

Primary language of the video file's spoken dialogue, visible text, or both. If there is no dialogue or visible text, use the language spoken by the intended audience. Also applies to caption_file_name and forced_subtitle_file_name. Only one language is allowed.

Excel ColumnAccepted ValuesRequired
video_file_languageOne valid language valueRequired

audio_layout

Audio layout descriptor for the delivered video file.

Excel ColumnAccepted ValuesRequired
audio_layoutstereoOnly, surroundOnly, stereoPlusSurround, surroundPlusStereoOptional

descriptive_audio_file_name

For audio description files only. File name of the descriptive audio file, in the language defined in descriptive_audio_language, delivered using the approved method. The file name must exactly match the delivered file, including capitalization, and must not contain whitespace or special characters.

Excel ColumnAccepted ValuesRequired
descriptive_audio_file_nameExample: movieDubFile.wavRequired when providing a sidecar descriptive audio file for accessibility purposes

descriptive_audio_language

For audio description files only. Primary language of the audio file's spoken dialogue track. Only one language is allowed.

Excel ColumnAccepted ValuesRequired
descriptive_audio_languageOne valid language valueRequired when providing descriptive audio files

caption_file_name

Roku strongly prefers closed captions. The partner is responsible for determining whether captions are required for a specific delivery.

If supplied, enter the name of the closed caption file delivered using the approved method, in the language defined in the language column. The file name must exactly match the delivered file, including capitalization, and must not contain whitespace or special characters. Its language is derived from video_file_language.

Excel ColumnAccepted ValuesRequired
caption_file_nameExample: movieCaptions.srtStrongly preferred

forced_subtitle_file_name

File name of the forced narrative subtitle, in the language defined in video_file_language, delivered using the approved method. The file name must exactly match the delivered file, including capitalization, and must not contain whitespace or special characters. Its language is derived from video_file_language.

Excel ColumnAccepted ValuesRequired
forced_subtitle_file_nameExample: movieForcedSubtitle.srtRequired when providing forced narrative subtitles

Artwork

keyart_file_name

File name of the texted key art image, in the language defined in the language column, delivered using the approved method. The file name must exactly match the delivered file, including capitalization, and must not contain whitespace or special characters.

Excel ColumnAccepted ValuesRequired
keyart_file_nameExample: movieKeyArt.jpgRequired

background_file_name

File name of the textless background image, delivered using the approved method. The file name must exactly match the delivered file, including capitalization, and must not contain whitespace or special characters.

Excel ColumnAccepted ValuesRequired
background_file_nameExample: movieBGimage.jpgPreferred

boxcover_file_name

File name of the texted 3:4 boxcover image for the movie, in the language defined in the language column, delivered using the approved method. The file name must exactly match the delivered file, including capitalization, and must not contain whitespace or special characters.

Excel ColumnAccepted ValuesRequired
boxcover_file_nameExample: movieBoxArt.jpgRequired for distribution to Howdy

poster_file_name

File name of the texted poster image, in the language defined in the language column, delivered using the approved method. The file name must exactly match the delivered file, including capitalization, and must not contain whitespace or special characters.

Excel ColumnAccepted ValuesRequired
poster_file_nameExample: moviePoster.jpgPreferred

Availability

All four fields below are preferred, as shown in the tables. None is required.

territory

Country codes for the territories where the content is available. You may enter multiple country codes separated by commas, provided vod_type, license_start_date, and license_end_date are identical across them.

Excel ColumnAccepted ValuesRequired
territoryUS, CA, GB, MXPreferred

vod_type

Monetization type of the movie. You may enter multiple values separated by commas, provided territory, license_start_date, and license_end_date are identical across them.

Excel ColumnAccepted ValuesRequired
vod_typeExample: avod, svod, avod,svodPreferred

license_start_date

Start date of content availability. The date must be before license_end_date; the dates must not be the same.

Excel ColumnAccepted ValuesRequired
license_start_dateISO 8601 format: YYYY-MM-DDTHH:MM:SSPreferred

license_end_date

End date of content availability. The date must be after license_start_date; the dates must not be the same.

Excel ColumnAccepted ValuesRequired
license_end_dateISO 8601 format: YYYY-MM-DDTHH:MM:SSPreferred

Did this page help you?