Column Type

Description

Time Period

Years, Months, Quarters, Weeks, etc. in the columns. Good for time period trending.

Pivot Export

Removes column headings for easy export & pivot table manipulation in Excel.

Media

Media Types in the columns. Good for Media Mix reports.

Market

Markets in the columns

Property

TV Stations, Websites, Radio Stations, Publications, etc. in the columns.

Time Period/Property

Double Pivot on Time Period & Property in separate columns. EX: Jan 2023/WNBC, Feb 2023 WNBC)

Property/Time Period

Double Pivot on Property/Time Period in separate columns. (EX: WNBC Jan 2023, WNBC Feb 2023)

Daypart

TV Dayparts in the columns. (EX: Prime, Late News, Early Fringe)

Length

Length of spot in the columns (EX: :15 sec, :30 sec, :60 sec)

Pod Placement

Position of the spot in the commercial pod.

Pod Position Break

Designates all spots following a promo break or local break interval of 10-to-124 seconds in length.

Media Owner

The parent company of media brands in the columns. (EX: Walt Disney Co.)

Media Ultimate Brand

Subsidiary group of media brands in columns. (EX: ESPN)

Media Brand

Group of properties within the same market with the same media brand in columns. (EX: ESPN Boston, ESPN Desportes)

TV Schedule

Includes granular details for each TV spot captured.

Radio Schedule

Includes granular details for each Local Radio spot captured.

Magazine Schedule

Includes granular details for each Magazine ad captured.

Newspaper Schedule

Includes granular details for each Newspaper ad captured.