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_lifetime	audience.data.impressions_lifetime	The total count of verified impressions for an ad spot over its entire lifetime.	metric
audience.data.impressions_local_sov	audience.data.impressions_local_sov	The share of voice (SOV) based on local TV ad impressions.	dimension
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_linear_sov	audience.data.impressions_national_linear_sov	Share of Voice (SOV) for national linear TV ad 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	Share of Voice (SOV) for national live TV ad impressions, which includes views during live linear broadcast or same day via DVR/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	Share of Voice (SOV) based on the total raw panel count within a set of impressions.	metric
audience.data.impressions_sov	audience.data.impressions_sov	Share of Voice (SOV) based on total verified ad impressions.	metric
audience.data.impressions_vod_sov	audience.data.impressions_vod_sov	The share of voice (SOV) based on video-on-demand (VOD) ad 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.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 matched conversion rates, indicating the brand’s share of attributed conversions compared to competitors.	metric
conversion.data.matched.data.sov	conversion.data.matched.data.sov	The share of voice (SOV) for matched conversions, representing the brand’s share of total attributed conversions.	metric
conversion.data.matched.data.total	conversion.data.matched.data.total	The total number of conversions attributed to matched users.	metric
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).	dimension
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 overall share of voice (SOV) for conversion rates, reflecting the brand’s competitive standing in driving conversions.	dimension
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 overall share of voice (SOV) for conversions, representing the brand’s share of total conversions.	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.	metric
conversion.data.tv_population.data.total	conversion.data.tv_population.data.total	The total number of conversions attributed to the TV viewing population.	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 creative duration, where one unit equals 30 seconds. For example, a 15-second creative is 0.5 units, and a 60-second creative is 2 units.	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 for the creative, provided by the client.	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
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	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
linear.data.brand.data.has_image	linear.data.brand.data.has_image	Indicates whether the brand associated with linear TV advertising data has an image available.	dimension
linear.data.brand.data.has_retail_location	linear.data.brand.data.has_retail_location	Indicates whether the brand associated with linear TV advertising data has physical retail locations.	dimension
linear.data.brand.data.id	linear.data.brand.data.id	The unique identifier for the linear TV brand.	metric
linear.data.brand.data.image	linear.data.brand.data.image	The URL or identifier for the image associated with the brand in the context of linear TV advertising.	dimension
linear.data.brand.data.is_consumer_packaged_goods	linear.data.brand.data.is_consumer_packaged_goods	Indicates if the brand, in the context of linear TV advertising, is classified as a Consumer Packaged Goods (CPG) brand.	dimension
linear.data.brand.data.is_direct_to_consumer	linear.data.brand.data.is_direct_to_consumer	Indicates if the brand, in the context of linear TV advertising, operates with a Direct-to-Consumer (DTC) business model.	dimension
linear.data.brand.data.name	linear.data.brand.data.name	The name of the linear TV brand.	dimension
linear.data.brand.data.parent_id	linear.data.brand.data.parent_id	The unique identifier of the parent brand for the linear TV brand.	dimension
linear.data.brand.data.parent_name	linear.data.brand.data.parent_name	The name of the parent brand for the linear TV brand.	dimension
linear.data.brand.data.slug	linear.data.brand.data.slug	A URL-friendly identifier or slug for the brand associated with linear TV advertising data.	dimension
linear.data.conversion.data.incremental	linear.data.conversion.data.incremental	The incremental conversions attributed to linear TV advertising.	metric
linear.data.conversion.data.matched.data.incremental	linear.data.conversion.data.matched.data.incremental	The incremental conversions for users matched to have seen linear TV ads.	metric
linear.data.conversion.data.matched.data.rate_exposed	linear.data.conversion.data.matched.data.rate_exposed	The conversion rate for users exposed to linear TV ads who were matched.	metric
linear.data.conversion.data.matched.data.rate_unexposed	linear.data.conversion.data.matched.data.rate_unexposed	The conversion rate for users unexposed to linear TV ads who were matched.	metric
linear.data.conversion.data.rate_exposed	linear.data.conversion.data.rate_exposed	The conversion rate for users exposed to linear TV advertising.	metric
linear.data.conversion.data.rate_unexposed	linear.data.conversion.data.rate_unexposed	The conversion rate for users unexposed to linear TV advertising.	metric
linear.data.devices_exposed	linear.data.devices_exposed	The total number of unique devices that were exposed to linear TV advertisements.	metric
linear.data.devices_unexposed	linear.data.devices_unexposed	The total number of unique devices that were not exposed to linear TV advertisements, often used as a control group.	metric
linear.data.lift_percent	linear.data.lift_percent	The percentage lift in conversions attributed to linear TV advertising.	metric
linear.data.qualified_days	linear.data.qualified_days	The number of days during which linear TV advertising data met the minimum criteria for reliable measurement.	metric
linear.data.standard_error	linear.data.standard_error	The standard error of the measurement for linear TV advertising data, indicating the precision of the estimate.	metric
linear.data.standard_error_max	linear.data.standard_error_max	The maximum standard error observed for linear TV advertising data within the reporting period.	metric
linear.data.standard_error_min	linear.data.standard_error_min	The minimum standard error observed for linear TV advertising data within the reporting period.	metric
network.data.id	network.data.id	Unique identifier for the television network.	metric
ott.data.brand.data.has_image	ott.data.brand.data.has_image	Indicates whether the brand associated with OTT advertising data has an image available.	dimension
ott.data.brand.data.has_retail_location	ott.data.brand.data.has_retail_location	Indicates whether the brand associated with OTT advertising data has physical retail locations.	dimension
ott.data.brand.data.id	ott.data.brand.data.id	The unique identifier for the OTT brand.	metric
ott.data.brand.data.image	ott.data.brand.data.image	The URL or identifier for the image associated with the brand in the context of OTT advertising.	dimension
ott.data.brand.data.is_consumer_packaged_goods	ott.data.brand.data.is_consumer_packaged_goods	Indicates if the brand, in the context of OTT advertising, is classified as a Consumer Packaged Goods (CPG) brand.	dimension
ott.data.brand.data.is_direct_to_consumer	ott.data.brand.data.is_direct_to_consumer	Indicates if the brand, in the context of OTT advertising, operates with a Direct-to-Consumer (DTC) business model.	dimension
ott.data.brand.data.name	ott.data.brand.data.name	The name of the OTT brand.	dimension
ott.data.brand.data.parent_id	ott.data.brand.data.parent_id	The unique identifier of the parent brand for the OTT brand.	dimension
ott.data.brand.data.parent_name	ott.data.brand.data.parent_name	The name of the parent brand for the OTT brand.	dimension
ott.data.brand.data.slug	ott.data.brand.data.slug	A URL-friendly identifier or slug for the brand associated with OTT advertising data.	dimension
ott.data.conversion.data.incremental	ott.data.conversion.data.incremental	The incremental conversions attributed to OTT advertising.	metric
ott.data.conversion.data.matched.data.incremental	ott.data.conversion.data.matched.data.incremental	The incremental conversions for users matched to have seen OTT ads.	metric
ott.data.conversion.data.matched.data.rate_exposed	ott.data.conversion.data.matched.data.rate_exposed	The conversion rate for users exposed to OTT ads who were matched.	metric
ott.data.conversion.data.matched.data.rate_unexposed	ott.data.conversion.data.matched.data.rate_unexposed	The conversion rate for users unexposed to OTT ads who were matched.	metric
ott.data.conversion.data.rate_exposed	ott.data.conversion.data.rate_exposed	The conversion rate for users exposed to OTT advertising.	metric
ott.data.conversion.data.rate_unexposed	ott.data.conversion.data.rate_unexposed	The conversion rate for users unexposed to OTT advertising.	metric
ott.data.devices_exposed	ott.data.devices_exposed	The number of devices exposed to OTT advertisements.	metric
ott.data.devices_unexposed	ott.data.devices_unexposed	The number of devices not exposed to OTT advertisements.	metric
ott.data.lift_percent	ott.data.lift_percent	The percentage lift in conversions attributed to OTT advertising.	metric
ott.data.qualified_days	ott.data.qualified_days	The number of days during which Over-The-Top (OTT) advertising data met the minimum criteria for reliable measurement.	metric
ott.data.standard_error	ott.data.standard_error	The standard error of the measurement for Over-The-Top (OTT) advertising data, indicating the precision of the estimate.	metric
ott.data.standard_error_max	ott.data.standard_error_max	The maximum standard error observed for Over-The-Top (OTT) advertising data within the reporting period.	metric
ott.data.standard_error_min	ott.data.standard_error_min	The minimum standard error observed for Over-The-Top (OTT) advertising data within the reporting period.	metric
publisher.data.id	publisher.data.id	The unique identifier for the publisher.	metric
publisher.data.name	publisher.data.name	The name of the publisher.	dimension
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 other brands featured in the ad spot.	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 star rating (out of 5) representing the engagement score of the ad spot.	dimension
spot.data.events	spot.data.events	The name of a larger event, such as a holiday or sporting event, during which the ad spot occurred.	dimension
spot.data.hash	spot.data.hash	A unique hash identifier for the specific ad spot.	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	For movie-related ad spots, the genre(s) of the movie (e.g., Action & Adventure, Comedy, Drama).	dimension
spot.data.movie_rating	spot.data.movie_rating	For movie-related ad spots, the movie’s rating (e.g., G, PG, PG-13, R, NC-17).	dimension
spot.data.movie_release_date	spot.data.movie_release_date	For movie-related ad spots, the theatrical release date of the movie, if applicable.	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