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 specific date an ad airing occurred, represented in Eastern Time (ET).	dimension
aired_at_pt_date	aired_at_pt_date	The specific date an ad airing occurred, represented in Pacific Time (PT).	dimension
airing.data.aired_at_et	airing.data.aired_at_et	The airing time (local in EST/EDT) of the advertisement.	dimension
airing.data.aired_at_pt	airing.data.aired_at_pt	The airing time (local in PST/PDT) of the advertisement.	dimension
airing.data.dma	airing.data.dma	A designated market area (DMA), representing a geographic area of the US that covers specific television markets where iSpot measures impressions.	dimension
airing.data.id	airing.data.id	The unique identifier for a specific ad airing.	metric
airing.data.media_value	airing.data.media_value	Estimated media value of in-network promotions.	metric
airing.data.pod	airing.data.pod	The commercial block within the show, starting at 1. Within a 60-minute show, there are usually 5-7 pods, each with multiple airings.	metric
airing.data.pod_order	airing.data.pod_order	The numerical placement of the spot within its commercial pod.	metric
airing.data.pod_position	airing.data.pod_position	The placement of the spot within the commercial pod, represented as First, Middle, or Last.	dimension
airing.data.pod_position_abmyz	airing.data.pod_position_abmyz	The placement of the spot within the commercial pod, represented by A (first), B (second), M (middle), Y (second to last), Z (last).	dimension
airing.data.pod_position_fml	airing.data.pod_position_fml	The placement of the spot within the commercial pod, represented by First, Middle, or Last.	dimension
airing.data.spend_estimated	airing.data.spend_estimated	The estimated spend for a single ad airing.	metric
airing.data.type	airing.data.type	The type of airing, such as National, Local, or Spot Cable.	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	The total count of verified impressions for female viewers aged 18-20.	dimension
audience.data.female_age_25_29_impressions	audience.data.female_age_25_29_impressions	The total count of verified impressions for female viewers aged 25-29.	dimension
audience.data.female_age_30_34_impressions	audience.data.female_age_30_34_impressions	The total count of verified impressions for female viewers aged 30-34.	dimension
audience.data.female_age_35_39_impressions	audience.data.female_age_35_39_impressions	The total count of verified impressions for female viewers aged 35-39.	dimension
audience.data.female_age_45_49_impressions	audience.data.female_age_45_49_impressions	The total count of verified impressions for female viewers aged 45-49.	dimension
audience.data.female_age_50_54_impressions	audience.data.female_age_50_54_impressions	The total count of verified impressions for female viewers aged 50-54.	dimension
audience.data.female_age_60_64_impressions	audience.data.female_age_60_64_impressions	The total count of verified impressions for female viewers aged 60-64.	dimension
audience.data.female_age_75_99_impressions	audience.data.female_age_75_99_impressions	The total count of verified impressions for female viewers aged 75-99.	dimension
audience.data.gender_female_impressions	audience.data.gender_female_impressions	The total count of verified impressions for female viewers.	dimension
audience.data.gender_male_impressions	audience.data.gender_male_impressions	The total count of verified impressions for male viewers.	dimension
audience.data.igrp	audience.data.igrp	The iGRP (iSpot Gross Ratings Point) is equivalent to the TV industry standard GRP calculation, representing total impressions related to the total TV household population.	metric
audience.data.impressions	audience.data.impressions	Total audience impressions delivered.	metric
audience.data.impressions_cpm	audience.data.impressions_cpm	The cost per thousand impressions, calculated based on total impressions and estimated spend.	metric
audience.data.impressions_lifetime	audience.data.impressions_lifetime	The total number of audience impressions accumulated over the entire lifetime of an advertisement or campaign.	metric
audience.data.impressions_local_sov	audience.data.impressions_local_sov	The local Share of Voice (SOV) based on audience impressions, indicating the ad’s percentage of total local impressions within its category or market.	metric
audience.data.impressions_national_c3	audience.data.impressions_national_c3	The count of national impressions that occurred post-live until 3 days after the original airing.	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	The count of national impressions that occurred 4 days after airing until 7 days after the original airing.	metric
audience.data.impressions_national_linear	audience.data.impressions_national_linear	National spot impressions viewed either live during the original broadcast or time-shifted via DVR.	metric
audience.data.impressions_national_linear_sov	audience.data.impressions_national_linear_sov	The share of voice (SOV) based on national linear TV impressions, including live and DVR time-shifted views.	metric
audience.data.impressions_national_live	audience.data.impressions_national_live	National audience impressions for live viewing.	metric
audience.data.impressions_national_live_sov	audience.data.impressions_national_live_sov	The share of voice (SOV) based on national live TV impressions, including those viewed during live linear broadcast or same day via DVR or VOD.	metric
audience.data.impressions_raw	audience.data.impressions_raw	Raw, unfiltered audience impressions.	metric
audience.data.impressions_raw_sov	audience.data.impressions_raw_sov	The share of voice (SOV) based on the total raw panel count of impressions.	metric
audience.data.impressions_sov	audience.data.impressions_sov	The overall Share of Voice (SOV) based on audience impressions, indicating the ad’s percentage of total impressions within its category or market.	metric
audience.data.impressions_vod_sov	audience.data.impressions_vod_sov	The share of voice (SOV) based on Video-on-Demand (VOD) impressions.	metric
audience.data.male_age_18_20_impressions	audience.data.male_age_18_20_impressions	The total count of verified impressions for male viewers aged 18-20.	dimension
audience.data.male_age_21_24_impressions	audience.data.male_age_21_24_impressions	The total count of verified impressions for male viewers aged 21-24.	dimension
audience.data.male_age_25_29_impressions	audience.data.male_age_25_29_impressions	The total count of verified impressions for male viewers aged 25-29.	dimension
audience.data.male_age_30_34_impressions	audience.data.male_age_30_34_impressions	The total count of verified impressions for male viewers aged 30-34.	dimension
audience.data.male_age_35_39_impressions	audience.data.male_age_35_39_impressions	The total count of verified impressions for male viewers aged 35-39.	dimension
audience.data.male_age_40_44_impressions	audience.data.male_age_40_44_impressions	The total count of verified impressions for male viewers aged 40-44.	dimension
audience.data.male_age_45_49_impressions	audience.data.male_age_45_49_impressions	The total count of verified impressions for male viewers aged 45-49.	dimension
audience.data.male_age_50_54_impressions	audience.data.male_age_50_54_impressions	The total count of verified impressions for male viewers aged 50-54.	dimension
audience.data.male_age_55_59_impressions	audience.data.male_age_55_59_impressions	The total count of verified impressions for male viewers aged 55-59.	dimension
audience.data.male_age_60_64_impressions	audience.data.male_age_60_64_impressions	The total count of verified impressions for male viewers aged 60-64.	dimension
audience.data.male_age_65_74_impressions	audience.data.male_age_65_74_impressions	The total count of verified impressions for male viewers aged 65-74.	dimension
audience.data.male_age_75_99_impressions	audience.data.male_age_75_99_impressions	The total count of verified impressions for male viewers aged 75-99.	dimension
brand.data.has_retail_location	brand.data.has_retail_location	Indicates whether the brand has physical retail store locations.	dimension
brand.data.id	brand.data.id	The unique identifier for the advertised brand.	metric
brand.data.is_consumer_packaged_goods	brand.data.is_consumer_packaged_goods	Indicates whether the brand is classified as a Consumer Packaged Goods (CPG) brand.	dimension
brand.data.is_direct_to_consumer	brand.data.is_direct_to_consumer	Indicates whether the brand operates as a direct-to-consumer (DTC) brand.	dimension
brand.data.name	brand.data.name	The primary name of the advertised brand.	dimension
brand.data.parent_id	brand.data.parent_id	The unique identifier for the parent company of the brand.	dimension
brand.data.parent_name	brand.data.parent_name	The name of the parent company of the brand.	dimension
conversion.data.incremental	conversion.data.incremental	The incremental conversions attributed to TV advertising.	metric
conversion.data.matched.data.rate	conversion.data.matched.data.rate	The conversion rate for users who were matched to have seen an ad.	dimension
conversion.data.matched.data.rate_sov	conversion.data.matched.data.rate_sov	The Share of Voice (SOV) for the conversion rate among users who were matched to have been exposed to the advertisement.	metric
conversion.data.matched.data.sov	conversion.data.matched.data.sov	The Share of Voice (SOV) for conversions among users who were matched to have been exposed to the advertisement.	metric
conversion.data.matched.data.total	conversion.data.matched.data.total	The total number of conversions attributed to matched users.	dimension
conversion.data.ott.data.matched.data.rate	conversion.data.ott.data.matched.data.rate	The conversion rate for OTT (Over-The-Top) matched users.	dimension
conversion.data.ott.data.matched.data.total	conversion.data.ott.data.matched.data.total	The total number of conversions for OTT (Over-The-Top) matched users.	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.rate_exposed	conversion.data.rate_exposed	The conversion rate for users who were exposed to the advertisement.	metric
conversion.data.rate_sov	conversion.data.rate_sov	The Share of Voice (SOV) for the overall conversion rate, indicating an ad’s percentage of total conversion rates within its category or market.	metric
conversion.data.rate_unexposed	conversion.data.rate_unexposed	The conversion rate for users who were not exposed to the advertisement.	metric
conversion.data.sov	conversion.data.sov	The Share of Voice (SOV) for overall conversions, indicating an ad’s percentage of total conversions within its category or market.	metric
conversion.data.total	conversion.data.total	The total number of conversions attributed to TV advertising.	metric
conversion.data.tv_population.data.rate	conversion.data.tv_population.data.rate	The conversion rate among the TV viewing population exposed to ads.	dimension
conversion.data.tv_population.data.total	conversion.data.tv_population.data.total	The total number of conversions attributed to the TV viewing population.	dimension
conversion_type	conversion_type	The type of conversion being tracked and reported, used to categorize specific user actions following ad exposure.	dimension
creative.data.airing_date_first_et	creative.data.airing_date_first_et	The airing datetime (local to EST/EDT) of the first airing of this specific creative.	dimension
creative.data.airing_date_first_pt	creative.data.airing_date_first_pt	The airing datetime (local to PST/PDT) of the first airing of this specific creative.	dimension
creative.data.airing_date_last_et	creative.data.airing_date_last_et	The airing datetime (local to EST/EDT) of the last airing of this specific creative.	dimension
creative.data.airing_date_last_pt	creative.data.airing_date_last_pt	The airing datetime (local to PST/PDT) of the last airing of this specific creative.	dimension
creative.data.description	creative.data.description	A summary or description of the creative that aired.	dimension
creative.data.duration	creative.data.duration	The running time of the creative measured in seconds.	metric
creative.data.equivalized_unit	creative.data.equivalized_unit	The number of equivalized units for this creative, where one unit equals 30 seconds.	dimension
creative.data.id	creative.data.id	The unique identifier for the specific spot variation that aired.	metric
creative.data.isci_code	creative.data.isci_code	The client-supplied ISCI code for the creative, if available.	dimension
creative.data.language	creative.data.language	The language of the creative, such as English or Spanish.	dimension
creative.data.lifetime_airings_count	creative.data.lifetime_airings_count	The cumulative count of airings for this specific creative over its lifetime.	metric
creative.data.lifetime_spend_estimated	creative.data.lifetime_spend_estimated	The estimated cumulative spend for this specific creative over its lifetime.	metric
creative.data.spot_id	creative.data.spot_id	The identifier of the common spot grouping under which this and other creative variations are grouped.	dimension
creative.data.title	creative.data.title	The name of the specific spot variation.	dimension
creative.data.title_custom	creative.data.title_custom	A client-supplied custom title for the creative, if provided.	dimension
creative.data.title_short	creative.data.title_short	A shortened naming convention of the specific spot variation.	dimension
creative.data.type	creative.data.type	The type of ad, such as Commercial, Show Promo, or Movie Trailer.	dimension
date.data.date	date.data.date	The specific date associated with the reported data, typically in YYYY-MM-DD format.	dimension
date_est	date_est	The date associated with the data, reported in Eastern Time (ET).	dimension
day_of_week.data.id	day_of_week.data.id	A numeric representation of the day of the week when the airing occurred.	dimension
day_of_week.data.name	day_of_week.data.name	The name of the day of the week when the airing occurred.	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
episode.data.id	episode.data.id	The unique identifier for the TV episode, linking to schedule data and on-demand video catalogs.	dimension
episode.data.is_new	episode.data.is_new	Indicates whether the show episode is new or a rerun.	dimension
episode.data.title	episode.data.title	The title of the TV episode during which the ad airing occurred.	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
impressions.data.ott	impressions.data.ott	The total number of impressions delivered through Over-The-Top (OTT) advertising.	metric
industry.data.id	industry.data.id	The unique identifier for the industry.	metric
industry.data.name	industry.data.name	The category under which the advertised brand and product fall, based on iSpot taxonomy.	dimension
industry.data.parent_id	industry.data.parent_id	The unique identifier associated with the parent industry.	dimension
industry.data.parent_name	industry.data.parent_name	The first-tier category under which the brand and product advertised fall, based on iSpot taxonomy.	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.data.airing_date_first_et	spot.data.airing_date_first_et	The airing datetime (local to EST/EDT) of the first recorded airing of this spot.	dimension
spot.data.airing_date_first_pt	spot.data.airing_date_first_pt	The airing datetime (local to PST/PDT) of the first recorded airing of this spot.	dimension
spot.data.airing_date_last_et	spot.data.airing_date_last_et	The airing datetime (local to EST/EDT) of the last recorded airing of this spot.	dimension
spot.data.airing_date_last_pt	spot.data.airing_date_last_pt	The airing datetime (local to PST/PDT) of the last recorded airing of this spot.	dimension
spot.data.cobrands	spot.data.cobrands	Other brands that were featured in this spot.	dimension
spot.data.description	spot.data.description	A summary of what takes place in the spot.	dimension
spot.data.engagement_industry_avg	spot.data.engagement_industry_avg	The average engagement across all brands within this brand’s primary industry, useful for benchmarking.	metric
spot.data.engagement_industry_med	spot.data.engagement_industry_med	The median engagement across all brands within this brand’s primary industry, useful for benchmarking.	metric
spot.data.engagement_score	spot.data.engagement_score	A lifetime rating based on the volume of digital activity (video, social, search) triggered by the spot campaign, divided by estimated TV spend and compared to other national TV campaigns.	dimension
spot.data.engagement_score_stars	spot.data.engagement_score_stars	A star rating out of 5 based on the ad’s engagement score.	dimension
spot.data.events	spot.data.events	The name of a larger event during which this spot occurred, such as a holiday or sporting event.	dimension
spot.data.hash	spot.data.hash	A unique hash identifier for this spot.	dimension
spot.data.id	spot.data.id	The unique identifier for the spot/advertisement.	metric
spot.data.language	spot.data.language	Describes the language the spot is in, such as English or Spanish.	dimension
spot.data.lifetime_spend_estimated	spot.data.lifetime_spend_estimated	The estimated cumulative spend of this spot over its lifetime, represented by an average media value for national linear TV.	metric
spot.data.movie_genres	spot.data.movie_genres	For movie-related spots, the genres of the movie (e.g., Action & Adventure, Comedy, Drama).	dimension
spot.data.movie_rating	spot.data.movie_rating	For movie-related spots, the movie rating (e.g., G, PG, PG-13, R, NC-17).	dimension
spot.data.movie_release_date	spot.data.movie_release_date	For movie-related spots, the release date of the movie in theaters.	dimension
spot.data.phone	spot.data.phone	The phone number associated with the brand featured in the spot.	dimension
spot.data.product_categories	spot.data.product_categories	A general category of the product(s) associated with this spot, based on iSpot taxonomy.	dimension
spot.data.products	spot.data.products	The name of the product(s) associated with this spot.	dimension
spot.data.sub_type	spot.data.sub_type	A more granular categorization within the primary spot type, based on iSpot taxonomy.	dimension
spot.data.title	spot.data.title	The name of the spot.	dimension
spot.data.title_short	spot.data.title_short	A shortened name of the spot.	dimension
spot.data.type	spot.data.type	Describes the type of spot: Commercial, Show Promo, Movie Trailer, Infomercial, PSA, or Network Movie Promo.	dimension
spot.data.url	spot.data.url	URLs to relevant external sites like IMDB, Rotten Tomatoes, or Edmunds.	dimension
sub_genre.data.id	sub_genre.data.id	The unique identifier for the sub-genre of the show, series, or movie during which the airing occurred.	metric
sub_genre.data.name	sub_genre.data.name	The name of the sub-genre of the show, series, or movie during which the airing occurred.	dimension