MediaOcean Prisma SPOT Data Definitions

client_code

client_code

Unique client code.

client_name

client_name

Client's full name.

start_date

start_date

Start date for the estimate.

Format: YYYYMMDD.

end_date

end_date

End date for the estimate.

Format: YYYYMMDD.

daypart_code

daypart_code

Daypart code.

daypart_key

daypart_key

Daypart primary key.

rotation_days

rotation_days

Rotation days associated with this buyline.

rotation_time

rotation_time

Rotation time associated with this buyline.

market_name

market_name

Market's name.

product_code

product_code

Product code.

estimate_key

estimate_key

Estimate primary key.

estimate_code

estimate_code

Estimate code.

estimate_name

estimate_name

Estimate name.

media_key

media_key

Media foreign key from the SPOT MEDIA table.

cable_id

cable_id

Cable code for the buyline, if chosen in addition to the station.

station_code

station_code

Station code.

station_name

station_name

Station's name.

station_key

station_key

Station primary key.

nielsen_currency

nielsen_currency

A code for the Nielsen currency (e.g., Live+3) associated with the estimate.

nielsen_rating_service

nielsen_rating_service

A code for the Nielsen rating service (e.g., H for Hispanic) associated with the estimate.

client_key

2nd and 3rd parts of buyline_key

Client primary key.

buyline_key

buyline_key

Buyline foreign key from the SPOT BUYLINE table.

buylinespot_key

buylinespot_key

Buylinespot primary key.

length

length

Length of the spot (in seconds).

spot_number

spot_number

Serial number of one spot among the spots for the week. 

program_name

program_name

Name of the program on which this spot ran or will run. 

ordered_gross

ordered_gross

Gross ordered amount for this spot.

ordered_net

ordered_net

Net ordered amount for this buyline.

traffic_isci_code

traffic_isci_code

Industry Standard Coding Identification (ISCI) code of the commercial trafficked for this spot.

affidavit_isci_code

affidavit_isci_code

ISCI code of the commercial that aired for this spot.

week_start_date

week_start_date

First day of the week that has this spot in YYYYMMDD format.

affidavit_date

affidavit_date

Date on which the spot ran as, reported on the station's affidavit, in YYYYMMDD format. 

affidavit_time

affidavit_time

Time on which the spot ran, as reported on the station's affidavit, in hh:mm:ss format.

affidavit_program_name

affidavit_program_name

The name of the program on which this spot actually run.

buylinespotdemo_buylinespot_key

buylinespot_key

Buylinespot foreign key from the BUYLINESPOT table.

buylinespotdemo_buyline_key

buyline_key

Buyline foreign key from the SPOT BUYLINE table.

buylinespotdemo_client_key

client_key

2nd and 3rd parts of buyline_key.

buylinespotdemo_estimate_key

estimate_key

Estimate primary key.

achieved_demo_{demo_category}_{demo_metric}

pivoted out achieved_demo using the demo_category and demo_metric columns and then aggregated for each buyline.

Achieved metric value for a specific demographic.
(e.g., achieved_demo_ad2554_ratings is the ratings achieved by the 25-54 Adult demographic)

affidavit_demo_{demo_category}_{demo_metric}

pivoted out affidavit_demo using the demo_category and demo_metric columns and then aggregated for each buyline.

Affidavit reported metric value for a specific demographic.
(e.g., affidavit_demo_ad2554_ratings is the ratings achieved by the 25-54 Adult demographic as reported in the affidavit)

purchased_demo_{demo_category}_{demo_metric}

pivoted out purchased_demo using the demo_category and demo_metric columns and then aggregated at the buyline spot level.

Purchased or estimated metric value for a specific demographic.

(e.g., purchased_demo_ad2554_ratings is the estimated ratings achieved by the 25-54 Adult demographic)

achieved_demo_{demo_category}_{demo_metric}_{position}

pivoted out achieved_demo using the demo_category, demo_metric, and position columns. Aggregated at buyline spot level.

Achieved metric value for a specific demographic, broken further down by the position
(e.g., achieved_demo_mn1849_impressions_pos4 is the impressions achieved by the 18-49 Men secondary demographic which is signified by position 4)

affidavit_demo_{demo_category}_{demo_metric}_{position}

pivoted out affidavit_demo using the demo_category, demo_metric, and position columns. Aggregated at buyline spot level.

Affidavit reported metric value for a specific demographic, broken further down by the position.
(e.g., affidavit_demo_mn1849_impressions_pos4 is the impressions achieved by the 18-49 Men secondary demographic as reported in the affidavit)

purchased_demo_{demo_category}_{demo_metric}_{position}

pivoted out purchased_demo using the demo_category, demo_metric, and position columns. Aggregated at buyline spot level.

Purchased or estimated reported metric value for a specific demographic, broken further down by the position.
(e.g., purchased_demo_mn1849_impressions_pos4 is the estimated or purchased impressions achieved by the 18-49 Men secondary demographic)

demo_category

category

Code for the demographic category. For example, AD18+.

demo_metric

modifier

Code for the demographic modifier. For example, I for Impressions.

position

position

Rank of the demo for the estimate, e.g. 1 for primary demo, 2 for secondary demo, etc.