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 local airing date and time of the advertisement in Eastern Standard Time (EST) or Eastern Daylight Time (EDT).	dimension
airing.data.aired_at_pt	airing.data.aired_at_pt	The local airing date and time of the advertisement in Pacific Standard Time (PST) or Pacific Daylight Time (PDT).	dimension
airing.data.dma	airing.data.dma	The Designated Market Area (DMA) where the advertisement aired. DMAs are specific geographic television markets in the US.	dimension
airing.data.id	airing.data.id	The unique identifier for a specific TV advertisement airing.	metric
airing.data.media_value	airing.data.media_value	The estimated media value of in-network promotional airings.	metric
airing.data.pod	airing.data.pod	The commercial break or ‘pod’ within a TV show during which the advertisement aired.	metric
airing.data.pod_order	airing.data.pod_order	The numerical order of the advertisement within its commercial break (pod).	metric
airing.data.pod_position	airing.data.pod_position	The general position of the advertisement within its commercial break, such as ‘First’, ‘Middle’, or ‘Last’.	dimension
airing.data.pod_position_abmyz	airing.data.pod_position_abmyz	A detailed representation of the advertisement’s position within its commercial break, using codes like A (first), B (second), M (middle), Y (second to last), and Z (last).	dimension
airing.data.pod_position_fml	airing.data.pod_position_fml	The placement of the advertisement within its commercial break, 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, Spot Cable, National Satellite, or Regional.	dimension
airings.data.spend_estimated	airings.data.spend_estimated	The estimated spend for the ad airings.	metric
attention.data.avg_percent_viewed_sum	attention.data.avg_percent_viewed_sum	The sum of the average percentage of an ad that was viewed across all airings.	dimension
attention.data.completed	attention.data.completed	Indicates whether the ad was viewed to its completion.	dimension
attention.data.first_quartile	attention.data.first_quartile	The point in time or percentage when the first quartile (25%) of the ad was viewed.	dimension
attention.data.index	attention.data.index	A normalized index or score representing the level of attention an ad received.	dimension
attention.data.mid_point	attention.data.mid_point	The point in time or percentage when the mid-point (50%) of the ad was viewed.	dimension
attention.data.score	attention.data.score	A score quantifying the overall attention an ad garnered during its airing.	dimension
attention.data.score_avg	attention.data.score_avg	The average score representing the attention an ad received.	dimension
attention.data.started	attention.data.started	Indicates whether the viewing of the ad commenced.	dimension
attention.data.third_quartile	attention.data.third_quartile	The point in time or percentage when the third quartile (75%) of the ad was viewed.	dimension
attention.data.third_quartile_to_completed	attention.data.third_quartile_to_completed	The percentage of viewers who watched an ad from the third quartile mark through to completion.	dimension
audience.data.female_age_18_20_impressions	audience.data.female_age_18_20_impressions	The total number of verified impressions for females aged 18 to 20.	dimension
audience.data.female_age_25_29_impressions	audience.data.female_age_25_29_impressions	The total number of verified impressions for females aged 25 to 29.	dimension
audience.data.female_age_30_34_impressions	audience.data.female_age_30_34_impressions	The total number of verified impressions for females aged 30 to 34.	dimension
audience.data.female_age_35_39_impressions	audience.data.female_age_35_39_impressions	The total number of verified impressions for females aged 35 to 39.	dimension
audience.data.female_age_45_49_impressions	audience.data.female_age_45_49_impressions	The total number of verified impressions for females aged 45 to 49.	dimension
audience.data.female_age_50_54_impressions	audience.data.female_age_50_54_impressions	The total number of verified impressions for females aged 50 to 54.	dimension
audience.data.female_age_60_64_impressions	audience.data.female_age_60_64_impressions	The total number of verified impressions for females aged 60 to 64.	dimension
audience.data.female_age_75_99_impressions	audience.data.female_age_75_99_impressions	The total number of verified impressions for females aged 75 to 99.	dimension
audience.data.gender_female_impressions	audience.data.gender_female_impressions	The total number of verified impressions for the female audience.	dimension
audience.data.gender_male_impressions	audience.data.gender_male_impressions	The total number of verified impressions for the male audience.	dimension
audience.data.igrp	audience.data.igrp	iSpot’s Gross Ratings Point (iGRP), representing total impressions relative to the overall 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 Mille (CPM) for impressions, calculated based on total impressions and estimated advertising spend.	metric
audience.data.impressions_local_sov	audience.data.impressions_local_sov	The Share of Voice (SOV) representing impressions generated from local television advertising.	metric
audience.data.impressions_national_c3	audience.data.impressions_national_c3	The total count of national impressions that occurred from after the live broadcast until 3 days following 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 total count of national impressions that occurred from 4 days after the airing until 7 days following the original airing.	metric
audience.data.impressions_national_linear	audience.data.impressions_national_linear	The total number of impressions for national spots 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) representing impressions generated from national linear television advertising.	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) representing impressions generated from national live television advertising.	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) representing raw or unfiltered impressions.	metric
audience.data.impressions_sov	audience.data.impressions_sov	The overall Share of Voice (SOV) for impressions across all relevant advertising types.	metric
audience.data.impressions_start	audience.data.impressions_start	The count of impressions at the beginning of a reporting period or a starting point for impression measurement.	dimension
audience.data.impressions_vod_sov	audience.data.impressions_vod_sov	The Share of Voice (SOV) representing impressions generated from Video On Demand (VOD) advertising.	metric
audience.data.male_age_18_20_impressions	audience.data.male_age_18_20_impressions	The total number of verified impressions for males aged 18 to 20.	dimension
audience.data.male_age_21_24_impressions	audience.data.male_age_21_24_impressions	The total number of verified impressions for males aged 21 to 24.	dimension
audience.data.male_age_25_29_impressions	audience.data.male_age_25_29_impressions	The total number of verified impressions for males aged 25 to 29.	dimension
audience.data.male_age_30_34_impressions	audience.data.male_age_30_34_impressions	The total number of verified impressions for males aged 30 to 34.	dimension
audience.data.male_age_35_39_impressions	audience.data.male_age_35_39_impressions	The total number of verified impressions for males aged 35 to 39.	dimension
audience.data.male_age_40_44_impressions	audience.data.male_age_40_44_impressions	The total number of verified impressions for males aged 40 to 44.	dimension
audience.data.male_age_45_49_impressions	audience.data.male_age_45_49_impressions	The total number of verified impressions for males aged 45 to 49.	dimension
audience.data.male_age_50_54_impressions	audience.data.male_age_50_54_impressions	The total number of verified impressions for males aged 50 to 54.	dimension
audience.data.male_age_55_59_impressions	audience.data.male_age_55_59_impressions	The total number of verified impressions for males aged 55 to 59.	dimension
audience.data.male_age_60_64_impressions	audience.data.male_age_60_64_impressions	The total number of verified impressions for males aged 60 to 64.	dimension
audience.data.male_age_65_74_impressions	audience.data.male_age_65_74_impressions	The total number of verified impressions for males aged 65 to 74.	dimension
audience.data.male_age_75_99_impressions	audience.data.male_age_75_99_impressions	The total number of verified impressions for males aged 75 to 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) business.	dimension
brand.data.name	brand.data.name	The name of the primary brand being advertised.	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, based on iSpot’s taxonomy.	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 rate of conversions that have been directly attributed to specific TV advertising activities.	metric
conversion.data.matched.data.sov	conversion.data.matched.data.sov	The Share of Voice (SOV) for conversions that have been directly attributed to specific TV advertising activities.	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, reflecting the proportion of impressions that led to a desired action.	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, representing a brand’s share of digital actions attributed to TV ads.	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 event recorded (e.g., website visit, app install).	dimension
creative.data.airing_date_first_et	creative.data.airing_date_first_et	The local date and time in EST/EDT of the first airing of this specific creative.	dimension
creative.data.airing_date_first_pt	creative.data.airing_date_first_pt	The local date and time in PST/PDT of the first airing of this specific creative.	dimension
creative.data.airing_date_last_et	creative.data.airing_date_last_et	The local date and time in EST/EDT of the last airing of this specific creative.	dimension
creative.data.airing_date_last_pt	creative.data.airing_date_last_pt	The local date and time in PST/PDT of the last airing of this specific creative.	dimension
creative.data.description	creative.data.description	A summary or description of the advertisement 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 equivalized unit count for the creative, representing its duration in 30-second increments (e.g., 15 sec = 0.5, 30 sec = 1).	metric
creative.data.id	creative.data.id	The unique identifier for the specific variation of the advertisement creative that aired.	metric
creative.data.isci_code	creative.data.isci_code	The client-supplied Industry Standard Commercial Identifier (ISCI) code for the creative, if provided.	dimension
creative.data.language	creative.data.language	The language in which the advertisement creative is presented.	dimension
creative.data.lifetime_airings_count	creative.data.lifetime_airings_count	The total number of times this specific creative has aired over its lifetime.	dimension
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 for the common advertisement spot grouping that this creative variation belongs to.	dimension
creative.data.title	creative.data.title	The name of the specific spot variation.	dimension
creative.data.title_custom	creative.data.title_custom	A custom title for the creative, supplied by the client.	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 advertisement creative, such as Commercial, Show Promo, or Movie Trailer.	dimension
date.data.date	date.data.date	The specific date of the data record.	dimension
date_est	date_est	The date of the data record in Eastern Standard Time (EST) or Eastern Daylight Time (EDT).	dimension
day_of_week.data.id	day_of_week.data.id	A numeric identifier representing 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 (e.g., Monday, Tuesday) when the airing occurred.	dimension
day_part.data.description	day_part.data.description	A descriptive explanation of the broadcast day part (e.g., Morning, Primetime).	dimension
day_part.data.display_id	day_part.data.display_id	An identifier used for displaying the day part during which the airing occurred.	dimension
day_part.data.id	day_part.data.id	The unique identifier for the specific day part (e.g., Morning, Primetime, Fringe) during which the airing occurred.	metric
day_part.data.name	day_part.data.name	The name of the broadcast day part (e.g., Morning, Primetime) when the airing occurred.	dimension
episode.data.id	episode.data.id	The unique identifier for the TV episode during which the advertisement aired.	dimension
episode.data.is_new	episode.data.is_new	Indicates whether the TV episode is a new broadcast or a rerun.	dimension
episode.data.title	episode.data.title	The title of the TV episode during which the advertisement aired.	dimension
genre.data.id	genre.data.id	The unique identifier for the genre of the TV show in which the advertisement aired.	metric
genre.data.name	genre.data.name	The name of the genre for the TV show in which the advertisement aired.	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 category of the advertised brand and product.	metric
industry.data.name	industry.data.name	The name of the industry category that the advertised brand and product belong to, based on iSpot’s taxonomy.	dimension
industry.data.parent_id	industry.data.parent_id	The unique identifier for the parent industry category.	dimension
industry.data.parent_name	industry.data.parent_name	The name of the first-tier parent industry category for the advertised brand and product, based on iSpot’s taxonomy.	dimension
lift_percent	lift_percent	The percentage increase in conversion rate for exposed viewers compared to unexposed viewers.	metric
network	network	The TV network on which the advertisement was aired.	dimension
network.data	network.data	Data pertaining to the television network on which an advertisement aired, used for grouping or filtering reports.	dimension
network.data.id	network.data.id	Unique identifier for the television network.	metric
show.data.id	show.data.id	The unique identifier for the TV show during which the advertisement aired.	dimension
show.data.name	show.data.name	The name of the TV show during which the advertisement aired.	dimension
show.data.type	show.data.type	Indicates whether the TV show is a national broadcast or a syndicated program.	dimension
spot.data.airing_date_first_et	spot.data.airing_date_first_et	The local date and time in EST/EDT of the first airing of this specific advertisement spot.	dimension
spot.data.airing_date_first_pt	spot.data.airing_date_first_pt	The local date and time in PST/PDT of the first airing of this specific advertisement spot.	dimension
spot.data.airing_date_last_et	spot.data.airing_date_last_et	The local date and time in EST/EDT of the last airing of this specific advertisement spot.	dimension
spot.data.airing_date_last_pt	spot.data.airing_date_last_pt	The local date and time in PST/PDT of the last airing of this specific advertisement spot.	dimension
spot.data.cobrands	spot.data.cobrands	A list of other brands that were featured alongside the primary brand in this advertisement spot.	dimension
spot.data.description	spot.data.description	A summary or description of the content and events within the advertisement spot.	dimension
spot.data.engagement_industry_avg	spot.data.engagement_industry_avg	The average engagement score across all brands within the primary industry of the advertised brand, useful for benchmarking.	dimension
spot.data.engagement_industry_med	spot.data.engagement_industry_med	The median engagement score across all brands within the primary industry of the advertised brand, useful for benchmarking.	dimension
spot.data.engagement_score	spot.data.engagement_score	A lifetime rating for the advertisement spot, measuring digital activity (video, social, search) triggered by the campaign relative to estimated TV spend, compared to other national TV campaigns.	dimension
spot.data.engagement_score_stars	spot.data.engagement_score_stars	A star rating (out of 5) representing the engagement score of the advertisement spot.	dimension
spot.data.events	spot.data.events	The name of any larger event (e.g., holiday, sporting event) during which this advertisement spot aired.	dimension
spot.data.hash	spot.data.hash	A unique hash identifier for the advertisement spot.	dimension
spot.data.id	spot.data.id	The unique identifier for the advertisement spot.	metric
spot.data.language	spot.data.language	The language of the advertisement spot, such as English or Spanish.	dimension
spot.data.lifetime_spend_estimated	spot.data.lifetime_spend_estimated	The estimated cumulative spending for this advertisement spot over its entire lifetime, based on an average media value for national linear TV.	dimension
spot.data.movie_genres	spot.data.movie_genres	For movie advertisements, the genres to which the movie belongs.	dimension
spot.data.movie_rating	spot.data.movie_rating	For movie advertisements, the official rating of the movie (e.g., G, PG, R).	dimension
spot.data.movie_release_date	spot.data.movie_release_date	For movie advertisements, the theatrical release date of the movie.	dimension
spot.data.phone	spot.data.phone	The phone number associated with the advertised brand.	dimension
spot.data.product_categories	spot.data.product_categories	The general categories of the product(s) featured in this advertisement spot, based on iSpot’s taxonomy.	dimension
spot.data.products	spot.data.products	The names of the specific product(s) associated with this advertisement spot.	dimension
spot.data.sub_type	spot.data.sub_type	A more granular categorization of the advertisement spot within its primary type, based on iSpot’s taxonomy.	dimension
spot.data.title	spot.data.title	The main title or name of the advertisement spot.	dimension
spot.data.title_short	spot.data.title_short	A shortened title or name for the advertisement spot.	dimension
spot.data.type	spot.data.type	The type of advertisement spot, such as Commercial, Show Promo, Movie Trailer, Infomercial, PSA, or Network Movie Promo.	dimension
spot.data.url	spot.data.url	The default URL associated with the iSpot creative, which can link to external sites like IMDB or Rotten Tomatoes.	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 advertisement aired.	metric
sub_genre.data.name	sub_genre.data.name	The name of the sub-genre for the show, series, or movie during which the advertisement aired.	dimension