iSpot.tv: Most-used fields#
The table below gives information about most-used fields that you can import from iSpot.tv. Other fields might also be available in Adverity.
The fields that you can fetch in Adverity are updated regularly to reflect updates to data source APIs.
API name |
Adverity UI name |
Description |
Use in Adverity |
|---|---|---|---|
aired_at_et_date |
aired_at_et_date |
The date an ad aired in Eastern Time. |
dimension |
aired_at_pt_date |
aired_at_pt_date |
The date an ad aired in Pacific Time. |
dimension |
airing.data.aired_at_et |
airing.data.aired_at_et |
The date and time an ad aired in Eastern Time. |
dimension |
airing.data.aired_at_pt |
airing.data.aired_at_pt |
The date and time an ad aired in Pacific Time. |
dimension |
airing.data.dma |
airing.data.dma |
The Designated Market Area (DMA) where the ad aired. |
dimension |
airing.data.id |
airing.data.id |
The unique identifier for this specific airing. |
metric |
airing.data.media_value |
airing.data.media_value |
The estimated media value of the airing. |
metric |
airing.data.pod |
airing.data.pod |
Information about the commercial break (pod) in which the ad aired. |
metric |
airing.data.pod_order |
airing.data.pod_order |
The placement of the spot within the commercial pod, represented as a numerical order. |
metric |
airing.data.pod_position |
airing.data.pod_position |
The placement of the spot within the commercial pod (e.g., First, Middle, Last). |
dimension |
airing.data.pod_position_abmyz |
airing.data.pod_position_abmyz |
The position of the advertisement within a commercial break (pod). |
dimension |
airing.data.pod_position_fml |
airing.data.pod_position_fml |
The placement of the spot within the commercial pod, represented as First, Middle, Last. |
dimension |
airing.data.spend_estimated |
airing.data.spend_estimated |
The estimated spend for this individual ad airing. |
metric |
airing.data.type |
airing.data.type |
The type of airing (e.g., National, Local, Regional). |
dimension |
airings.data.spend_estimated |
airings.data.spend_estimated |
The estimated spend for the ad airings. |
metric |
audience.data.female_age_18_20_impressions |
audience.data.female_age_18_20_impressions |
Total impressions delivered to females aged 18-20. |
dimension |
audience.data.female_age_25_29_impressions |
audience.data.female_age_25_29_impressions |
Total impressions delivered to females aged 25-29. |
dimension |
audience.data.female_age_30_34_impressions |
audience.data.female_age_30_34_impressions |
Total impressions delivered to females aged 30-34. |
dimension |
audience.data.female_age_35_39_impressions |
audience.data.female_age_35_39_impressions |
Total impressions delivered to females aged 35-39. |
dimension |
audience.data.female_age_45_49_impressions |
audience.data.female_age_45_49_impressions |
Total impressions delivered to females aged 45-49. |
dimension |
audience.data.female_age_50_54_impressions |
audience.data.female_age_50_54_impressions |
Total impressions delivered to females aged 50-54. |
dimension |
audience.data.female_age_60_64_impressions |
audience.data.female_age_60_64_impressions |
Total impressions delivered to females aged 60-64. |
dimension |
audience.data.female_age_75_99_impressions |
audience.data.female_age_75_99_impressions |
Total impressions delivered to females aged 75-99. |
dimension |
audience.data.gender_female_impressions |
audience.data.gender_female_impressions |
Total impressions delivered to the female audience. |
dimension |
audience.data.gender_male_impressions |
audience.data.gender_male_impressions |
Total impressions delivered to the male audience. |
dimension |
audience.data.igrp |
audience.data.igrp |
Impressions Gross Rating Points (IGRP), a measure of the total volume of impressions delivered by an ad campaign across a target audience. |
metric |
audience.data.impressions |
audience.data.impressions |
Total audience impressions delivered. |
metric |
audience.data.impressions_cpm |
audience.data.impressions_cpm |
Cost Per Mille (CPM) for impressions, representing the cost per thousand impressions. |
metric |
audience.data.impressions_national_c3 |
audience.data.impressions_national_c3 |
National commercial impressions for an advertisement, measured within 3 days of live viewing (C3 metric). |
metric |
audience.data.impressions_national_c30 |
audience.data.impressions_national_c30 |
National commercial impressions for an advertisement, measured within 30 days of live viewing (C30 metric). |
dimension |
audience.data.impressions_national_c7 |
audience.data.impressions_national_c7 |
National commercial impressions for an advertisement, measured within 7 days of live viewing (C7 metric). |
metric |
audience.data.impressions_national_linear |
audience.data.impressions_national_linear |
National linear TV audience impressions. |
metric |
audience.data.impressions_national_live |
audience.data.impressions_national_live |
National audience impressions for live viewing. |
metric |
audience.data.impressions_raw |
audience.data.impressions_raw |
Raw, unfiltered audience impressions. |
metric |
audience.data.male_age_18_20_impressions |
audience.data.male_age_18_20_impressions |
Total impressions delivered to males aged 18-20. |
dimension |
audience.data.male_age_21_24_impressions |
audience.data.male_age_21_24_impressions |
Total impressions delivered to males aged 21-24. |
dimension |
audience.data.male_age_25_29_impressions |
audience.data.male_age_25_29_impressions |
Total impressions delivered to males aged 25-29. |
dimension |
audience.data.male_age_30_34_impressions |
audience.data.male_age_30_34_impressions |
Total impressions delivered to males aged 30-34. |
dimension |
audience.data.male_age_35_39_impressions |
audience.data.male_age_35_39_impressions |
Total impressions delivered to males aged 35-39. |
dimension |
audience.data.male_age_40_44_impressions |
audience.data.male_age_40_44_impressions |
Total impressions delivered to males aged 40-44. |
dimension |
audience.data.male_age_45_49_impressions |
audience.data.male_age_45_49_impressions |
Total impressions delivered to males aged 45-49. |
dimension |
audience.data.male_age_50_54_impressions |
audience.data.male_age_50_54_impressions |
Total impressions delivered to males aged 50-54. |
dimension |
audience.data.male_age_55_59_impressions |
audience.data.male_age_55_59_impressions |
Total impressions delivered to males aged 55-59. |
dimension |
audience.data.male_age_60_64_impressions |
audience.data.male_age_60_64_impressions |
Total impressions delivered to males aged 60-64. |
dimension |
audience.data.male_age_65_74_impressions |
audience.data.male_age_65_74_impressions |
Total impressions delivered to males aged 65-74. |
dimension |
audience.data.male_age_75_99_impressions |
audience.data.male_age_75_99_impressions |
Total impressions delivered to males aged 75-99. |
dimension |
brand |
brand |
Represents a brand for which data is available. |
dimension |
brand.data.has_retail_location |
brand.data.has_retail_location |
Indicates whether the brand has physical retail locations. |
dimension |
brand.data.id |
brand.data.id |
Unique identifier for the brand. |
metric |
brand.data.is_consumer_packaged_goods |
brand.data.is_consumer_packaged_goods |
Indicates if the brand is categorized as a consumer packaged goods brand. |
dimension |
brand.data.is_direct_to_consumer |
brand.data.is_direct_to_consumer |
Indicates if the brand operates as a direct-to-consumer business model. |
dimension |
brand.data.name |
brand.data.name |
Name of the brand. |
dimension |
brand.data.parent_id |
brand.data.parent_id |
Unique identifier for the parent brand, if applicable. |
dimension |
brand.data.parent_name |
brand.data.parent_name |
Name of the parent brand, if applicable. |
dimension |
conversion.data.rate |
conversion.data.rate |
The rate at which TV ad views lead to conversions (e.g., website visits, app downloads). |
metric |
conversion.data.total |
conversion.data.total |
The total number of conversions attributed to TV advertising. |
metric |
creative.data |
creative.data |
A grouping for creative-related data. |
dimension |
creative.data.airing_date_first_et |
creative.data.airing_date_first_et |
The date and time (Eastern Time) of the first airing of this creative. |
dimension |
creative.data.airing_date_first_pt |
creative.data.airing_date_first_pt |
The date and time (Pacific Time) of the first airing of this creative. |
dimension |
creative.data.airing_date_last_et |
creative.data.airing_date_last_et |
The date and time (Eastern Time) of the last airing of this creative. |
dimension |
creative.data.airing_date_last_pt |
creative.data.airing_date_last_pt |
The date and time (Pacific Time) of the last airing of this creative. |
dimension |
creative.data.description |
creative.data.description |
A textual description of the creative content. |
dimension |
creative.data.duration |
creative.data.duration |
The running time of the creative in seconds. |
metric |
creative.data.equivalized_unit |
creative.data.equivalized_unit |
A standardized measure of an ad’s length, typically expressed as an equivalent to a standard unit (e.g., 30-second commercial). |
dimension |
creative.data.id |
creative.data.id |
Unique identifier for the specific creative variation. |
metric |
creative.data.isci_code |
creative.data.isci_code |
The International Standard Commercial Identifier (ISCI) code, a unique identifier for a television commercial creative. |
dimension |
creative.data.language |
creative.data.language |
The primary language used in the creative. |
dimension |
creative.data.lifetime_airings_count |
creative.data.lifetime_airings_count |
The total number of times this creative has aired over its lifetime. |
metric |
creative.data.lifetime_spend_estimated |
creative.data.lifetime_spend_estimated |
The estimated total spend on airings for this creative over its lifetime. |
metric |
creative.data.spot_id |
creative.data.spot_id |
Unique identifier for the associated spot. |
dimension |
creative.data.title |
creative.data.title |
The title of the creative. |
dimension |
creative.data.title_custom |
creative.data.title_custom |
A custom title or name assigned to the creative. |
dimension |
creative.data.title_short |
creative.data.title_short |
A shortened version of the creative’s title. |
dimension |
creative.data.type |
creative.data.type |
The type or category of the creative. |
dimension |
date.data.date |
date.data.date |
The specific date for which the data is reported. |
dimension |
date_est |
date_est |
The date in Eastern Standard Time. |
dimension |
day_of_week.data.id |
day_of_week.data.id |
Unique identifier for the day of the week. |
dimension |
day_of_week.data.name |
day_of_week.data.name |
The name of the day of the week. |
dimension |
day_part.data.description |
day_part.data.description |
Description of the day part (e.g., Prime Time, Late Night). |
dimension |
day_part.data.display_id |
day_part.data.display_id |
A display-friendly identifier for the day part. |
dimension |
day_part.data.id |
day_part.data.id |
Unique identifier for the day part. |
metric |
day_part.data.name |
day_part.data.name |
The name of the day part. |
dimension |
dma.data.id |
dma.data.id |
Unique identifier for the Designated Market Area (DMA). |
metric |
episode.data.id |
episode.data.id |
Unique identifier for the episode. |
dimension |
episode.data.is_new |
episode.data.is_new |
Indicates if the episode is a new airing. |
dimension |
episode.data.title |
episode.data.title |
The title of the episode. |
dimension |
genre.data.id |
genre.data.id |
Unique identifier for the genre. |
metric |
genre.data.name |
genre.data.name |
The name of the genre. |
dimension |
industry.data.id |
industry.data.id |
Unique identifier for the industry. |
metric |
industry.data.name |
industry.data.name |
The name of the industry. |
dimension |
industry.data.parent_id |
industry.data.parent_id |
Unique identifier for the parent industry, if applicable. |
dimension |
industry.data.parent_name |
industry.data.parent_name |
The name of the parent industry, if applicable. |
dimension |
lift_percent |
lift_percent |
The percentage increase in conversion rate for exposed viewers compared to unexposed viewers. |
metric |
network.data.id |
network.data.id |
Unique identifier for the television network. |
metric |
show.data.id |
show.data.id |
Unique identifier for the show. |
dimension |
show.data.name |
show.data.name |
The name of the show. |
dimension |
show.data.type |
show.data.type |
The type of show (e.g., series, movie). |
dimension |
spot |
spot |
Represents a specific television commercial. |
dimension |
spot.data |
spot.data |
A grouping for spot-related data. |
dimension |
spot.data.airing_date_first_et |
spot.data.airing_date_first_et |
The date and time (Eastern Time) of the first airing of this spot. |
dimension |
spot.data.airing_date_first_pt |
spot.data.airing_date_first_pt |
The date and time (Pacific Time) of the first airing of this spot. |
dimension |
spot.data.airing_date_last_et |
spot.data.airing_date_last_et |
The date and time (Eastern Time) of the last airing of this spot. |
dimension |
spot.data.airing_date_last_pt |
spot.data.airing_date_last_pt |
The date and time (Pacific Time) of the last airing of this spot. |
dimension |
spot.data.cobrands |
spot.data.cobrands |
A list of cobrands or additional brands featured within the advertisement. |
dimension |
spot.data.description |
spot.data.description |
A textual description of the spot. |
dimension |
spot.data.engagement_industry_avg |
spot.data.engagement_industry_avg |
The average engagement score for the industry relevant to the advertisement. Engagement score measures digital activity triggered by the ad. |
dimension |
spot.data.engagement_industry_med |
spot.data.engagement_industry_med |
The median engagement score for the industry relevant to the advertisement. Engagement score measures digital activity triggered by the ad. |
dimension |
spot.data.engagement_score |
spot.data.engagement_score |
A measurement of digital activity triggered by the spot campaign. |
dimension |
spot.data.engagement_score_stars |
spot.data.engagement_score_stars |
A rating of the advertisement’s engagement score, typically represented on a star scale. The engagement score reflects digital activity driven by the ad. |
dimension |
spot.data.events |
spot.data.events |
A list of events associated with the spot (e.g., special promotions). |
dimension |
spot.data.hash |
spot.data.hash |
A unique hash identifier for the spot content. |
dimension |
spot.data.id |
spot.data.id |
Unique identifier for the television commercial spot. |
metric |
spot.data.language |
spot.data.language |
The primary language used in the spot. |
dimension |
spot.data.lifetime_spend_estimated |
spot.data.lifetime_spend_estimated |
The estimated total spend on airings for this spot over its lifetime. |
metric |
spot.data.movie_genres |
spot.data.movie_genres |
The genre categories of a movie being advertised by the spot. |
dimension |
spot.data.movie_rating |
spot.data.movie_rating |
The official rating (e.g., G, PG, PG-13, R) of a movie being advertised by the spot. |
dimension |
spot.data.movie_release_date |
spot.data.movie_release_date |
The release date of a movie being advertised by the spot. |
dimension |
spot.data.phone |
spot.data.phone |
Phone number displayed or promoted in the spot. |
dimension |
spot.data.product_categories |
spot.data.product_categories |
Categories of products featured in the spot. |
dimension |
spot.data.products |
spot.data.products |
Specific products featured in the spot. |
dimension |
spot.data.sub_type |
spot.data.sub_type |
A more specific classification of the spot’s type. |
dimension |
spot.data.title |
spot.data.title |
The title of the spot. |
dimension |
spot.data.title_short |
spot.data.title_short |
A shortened version of the spot’s title. |
dimension |
spot.data.type |
spot.data.type |
The general type or category of the spot. |
dimension |
spot.data.url |
spot.data.url |
URLs related to the advertisement, such as links to IMDB, Rotten Tomatoes, or other relevant external sites. |
dimension |
sub_genre.data.id |
sub_genre.data.id |
Unique identifier for the sub-genre. |
metric |
sub_genre.data.name |
sub_genre.data.name |
The name of the sub-genre. |
dimension |