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.
aired_at_et_dateDimension
The date an ad airing occurred, in Eastern Time (ET).
aired_at_pt_dateDimension
The date an ad airing occurred, in Pacific Time (PT).
airing.data.aired_at_etDimension
The airing time (local in EST/EDT) of the advertisement.
airing.data.aired_at_ptDimension
The airing time (local in PST/PDT) of the advertisement.
airing.data.dmaDimension
The Designated Market Area (DMA) where the ad airing occurred.
airing.data.idMetric
A unique identifier for the specific ad airing.
airing.data.media_valueMetric
Estimated media value of in-network promotions.
airing.data.podMetric
The pod/commercial block within a show, starting at 1. Within a 60-minute show, there are typically 5-7 pods, each with multiple airings.
airing.data.pod_orderMetric
The numerical placement of the advertisement within its commercial pod.
airing.data.pod_positionDimension
The placement of the advertisement within its commercial pod, represented by First, Middle, or Last.
airing.data.pod_position_abmyzDimension
The detailed placement of the advertisement within its commercial pod, represented by A (first), B (second), M (middle), Y (second to last), Z (last).
airing.data.pod_position_fmlDimension
The placement of the advertisement within its commercial pod, represented by First, Middle, or Last.
airing.data.spend_estimatedMetric
The estimated spend for a single advertisement airing.
airing.data.typeDimension
The type of ad airing, such as National or Local.
airings.data.spend_estimatedMetric
The estimated spend for a single ad airing.
attention.data.avg_percent_viewed_sumDimension
The average percentage of a spot that is played across a TV device. This indicates how much of an ad was consumed.
attention.data.completedDimension
The change in Attention Index for the lifetime of the ad, indicating wear. It is calculated daily and reported as None, Light, Medium, and Heavy.
attention.data.indexDimension
A comparison of your ad's Interruption Rate against its specific media placement. It is measured on a scale of 0 to 200, where 100 is the average.
attention.data.scoreDimension
Measures the propensity of consumers to interrupt a spot play on TV, represented by the Average View Rate (AVR).
attention.data.score_avgDimension
The average attention score for a given context or grouping of ads.
audience.data.female_age_18_20_impressionsDimension
Impressions for the female audience in the 18 to 20 age group.
audience.data.female_age_25_29_impressionsDimension
Impressions for the female audience in the 25 to 29 age group.
audience.data.female_age_30_34_impressionsDimension
Impressions for the female audience in the 30 to 34 age group.
audience.data.female_age_35_39_impressionsDimension
Impressions for the female audience in the 35 to 39 age group.
audience.data.female_age_45_49_impressionsDimension
Impressions for the female audience in the 45 to 49 age group.
audience.data.female_age_50_54_impressionsDimension
Impressions for the female audience in the 50 to 54 age group.
audience.data.female_age_60_64_impressionsDimension
Impressions for the female audience in the 60 to 64 age group.
audience.data.female_age_75_99_impressionsDimension
Impressions for the female audience in the 75 to 99 age group.
audience.data.gender_female_impressionsDimension
Total impressions attributed to the female gender group.
audience.data.gender_male_impressionsDimension
Total impressions attributed to the male gender group.
audience.data.igrpMetric
The iGRP (iSpot Gross Ratings Point) is a calculation equivalent to the TV industry standard Gross Ratings Point, representing total impressions relative to the total TV household population size.
audience.data.impressionsMetric
Total audience impressions delivered.
audience.data.impressions_cpmMetric
The Cost Per Thousand (CPM) impressions, calculated based on total impressions and estimated spend.
audience.data.impressions_lifetimeMetric
The total count of verified ad plays (impressions) of a spot on a TV screen for at least 3 seconds, accumulated over the lifetime of the creative.
audience.data.impressions_national_c3Metric
The count of national impressions that occurred post-live broadcast up to 3 days after the original airing.
audience.data.impressions_national_c30Dimension
National commercial impressions for an advertisement, measured within 30 days of live viewing (C30 metric).
audience.data.impressions_national_c7Metric
The count of national impressions that occurred from 4 days after airing up to 7 days after the original airing.
audience.data.impressions_national_linearMetric
Impressions for a national spot viewed either live during its original broadcast or time-shifted via DVR.
audience.data.impressions_national_linear_sovMetric
The share of voice for national linear audience impressions.
audience.data.impressions_national_liveMetric
National audience impressions for live viewing.
audience.data.impressions_national_live_sovMetric
The share of voice for national live audience impressions.
audience.data.impressions_rawMetric
Raw, unfiltered audience impressions.
audience.data.impressions_raw_sovMetric
The share of voice for raw, unfiltered audience impressions.
audience.data.impressions_sovMetric
The overall share of voice for total audience impressions.
audience.data.impressions_startDimension
The start date from which audience impressions data is collected or reported.
audience.data.male_age_18_20_impressionsDimension
Impressions for the male audience in the 18 to 20 age group.
audience.data.male_age_21_24_impressionsDimension
Impressions for the male audience in the 21 to 24 age group.
audience.data.male_age_25_29_impressionsDimension
Impressions for the male audience in the 25 to 29 age group.
audience.data.male_age_30_34_impressionsDimension
Impressions for the male audience in the 30 to 34 age group.
audience.data.male_age_35_39_impressionsDimension
Impressions for the male audience in the 35 to 39 age group.
audience.data.male_age_40_44_impressionsDimension
Impressions for the male audience in the 40 to 44 age group.
audience.data.male_age_45_49_impressionsDimension
Impressions for the male audience in the 45 to 49 age group.
audience.data.male_age_50_54_impressionsDimension
Impressions for the male audience in the 50 to 54 age group.
audience.data.male_age_55_59_impressionsDimension
Impressions for the male audience in the 55 to 59 age group.
audience.data.male_age_60_64_impressionsDimension
Impressions for the male audience in the 60 to 64 age group.
audience.data.male_age_65_74_impressionsDimension
Impressions for the male audience in the 65 to 74 age group.
audience.data.male_age_75_99_impressionsDimension
Impressions for the male audience in the 75 to 99 age group.
brand.data.has_retail_locationDimension
Indicates whether the brand has physical retail store locations.
brand.data.idMetric
A unique identifier for the brand associated with the ad.
brand.data.is_consumer_packaged_goodsDimension
Indicates whether the brand is classified as a Consumer Packaged Goods (CPG) brand.
brand.data.is_direct_to_consumerDimension
Indicates whether the brand operates as a direct-to-consumer (DTC) brand.
brand.data.nameDimension
The name of the brand associated with the ad.
brand.data.parent_idDimension
A unique identifier for the parent company of the brand.
brand.data.parent_nameDimension
The name of the parent company of the brand.
conversion.data.incrementalMetric
The incremental conversions attributed to TV advertising, representing additional conversions generated by TV exposure. This relates to the 'Conversions' and 'Lift' metrics.
conversion.data.matched.data.rateMetric
The conversion rate for users who were matched to have seen an ad.
conversion.data.matched.data.rate_sovMetric
The share of voice for the conversion rate, calculated from conversion events attributed to TV impressions matched to a Vizio device.
conversion.data.matched.data.sovMetric
The share of voice for total conversion events attributed to TV impressions matched to a Vizio device.
conversion.data.matched.data.totalMetric
The total number of conversions attributed to matched users.
conversion.data.ott.data.matched.data.rateDimension
The conversion rate for OTT (Over-The-Top) matched users.
conversion.data.ott.data.matched.data.totalDimension
The total number of conversions for OTT (Over-The-Top) matched users.
conversion.data.rateMetric
The rate of conversions, representing the ratio of conversion events to TV impressions extrapolated to US households. This field is primarily available for older API clients.
conversion.data.rate_exposedMetric
The conversion rate among users who were exposed to the advertisement. This is used in 'Lift' reporting to compare conversion rates.
conversion.data.rate_sovMetric
The share of voice for the overall conversion rate.
conversion.data.rate_unexposedMetric
The conversion rate among users who were not exposed to the advertisement. This is used in 'Lift' reporting to compare conversion rates.
conversion.data.sovMetric
The share of voice for the total number of conversion events.
conversion.data.totalMetric
The total number of conversion events attributed to TV impressions extrapolated to US households. This field is primarily available for older API clients.
conversion.data.tv_population.data.rateMetric
The conversion rate among the TV viewing population exposed to ads.
conversion.data.tv_population.data.totalMetric
The total number of conversions attributed to the TV viewing population.
conversion_typeDimension
The specific type of conversion, used as a filter or descriptor for conversion data. Examples include 'WEB' or 'APP'.
creative.data.airing_date_first_etDimension
The date and time (ET) of the first airing for this creative. This is inferred from similar spot-level date fields.
creative.data.airing_date_first_ptDimension
The date and time (PT) of the first airing for this creative. This is inferred from similar spot-level date fields.
creative.data.airing_date_last_etDimension
The date and time (ET) of the last airing for this creative. This is inferred from similar spot-level date fields.
creative.data.airing_date_last_ptDimension
The date and time (PT) of the last airing for this creative. This is inferred from similar spot-level date fields.
creative.data.descriptionDimension
A summary or description of the specific creative that aired.
creative.data.durationMetric
The running time of the creative, measured in seconds.
creative.data.equivalized_unitDimension
Represents the number of 30-second units for the creative (e.g., 15 sec = 0.5, 30 sec = 1, 60 sec = 2), calculated by dividing the creative's duration by 30.
creative.data.idMetric
A unique identifier for the ad creative.
creative.data.isci_codeDimension
The client-supplied ISCI (International Standard Commercial Identifier) code for the creative, if available.
creative.data.languageDimension
Describes the language of the creative, such as English or Spanish.
creative.data.lifetime_airings_countMetric
The total number of times this creative has aired over its lifetime. This is inferred from the 'Airings' metric.
creative.data.lifetime_spend_estimatedMetric
The estimated total spend for all airings of this creative over its lifetime. This is inferred from 'estimated spend' metrics.
creative.data.spot_idMetric
The unique identifier for the specific spot variation that aired.
creative.data.titleDimension
The official title of the creative. This is inferred from 'spot_title'.
creative.data.title_customDimension
A custom title for the creative supplied by the client, if provided.
creative.data.title_shortDimension
A shortened version of the creative's title. This is inferred from 'spot_title_short'.
creative.data.typeDimension
The type of ad, such as Commercial, Show Promo, or Movie Trailer.
date.data.dateDimension
The calendar date for which the data is reported, in YYYY-MM-DD format.
date_estDimension
The date for which the data is reported, in Eastern Standard Time (EST) or Eastern Daylight Time (EDT).
impressions.data.ottMetric
The total number of impressions delivered through Over-The-Top (OTT) advertising.
lift_percentMetric
The percentage lift in a specific metric (e.g., conversions) attributed to ad exposure.
linear.data.brand.data.has_imageDimension
Indicates whether the brand associated with linear TV advertising has an image available.
linear.data.brand.data.has_retail_locationDimension
Indicates whether the brand associated with linear TV advertising has physical retail store locations.
linear.data.brand.data.idMetric
The unique identifier for the brand being advertised in linear TV.
linear.data.brand.data.imageDimension
The image associated with the brand in linear TV advertising.
linear.data.brand.data.is_consumer_packaged_goodsDimension
Indicates whether the brand associated with linear TV advertising is classified as a Consumer Packaged Goods (CPG) brand.
linear.data.brand.data.is_direct_to_consumerDimension
Indicates whether the brand associated with linear TV advertising operates as a direct-to-consumer (DTC) brand.
linear.data.brand.data.nameDimension
The primary name of the brand being advertised in linear TV.
linear.data.brand.data.parent_idDimension
The unique identifier associated with the parent company of the brand in linear TV advertising.
linear.data.brand.data.parent_nameDimension
The name of the parent company of the brand in linear TV advertising.
linear.data.brand.data.slugDimension
A URL-friendly identifier for the brand in linear TV advertising.
linear.data.conversion.data.incrementalMetric
The estimated difference between the daily exposed and unexposed devices, expressed as a count, for linear TV conversions.
linear.data.conversion.data.matched.data.incrementalMetric
The estimated incremental conversions for linear TV based on matched devices.
linear.data.conversion.data.matched.data.rate_exposedMetric
The conversion rate for matched linear TV devices that were exposed to an ad.
linear.data.conversion.data.matched.data.rate_unexposedMetric
The conversion rate for matched linear TV devices that were not exposed to an ad.
linear.data.conversion.data.rate_exposedMetric
The Conversion Rate of the sample of TV devices that saw at least one ad by the given advertiser within 7 days of the selected date range for linear TV.
linear.data.conversion.data.rate_unexposedMetric
The Conversion Rate of the sample of TV devices that did not see an ad by the given advertiser within 7 days of the selected date range for linear TV.
linear.data.devices_exposedMetric
The sample of TV devices that saw at least one ad by the given advertiser within 7 days of the selected date range, for linear TV.
linear.data.devices_unexposedMetric
The sample of TV devices that did not see an ad by the given advertiser within 7 days of the selected date range, for linear TV.
linear.data.lift_percentMetric
The estimated percentage difference between the daily exposed and unexposed conversion rates for linear TV.
linear.data.qualified_daysMetric
The number of days with qualified data included in the overall lift calculation for linear TV conversions.
linear.data.standard_errorMetric
The average standard error around the lift estimate, calculated as part of the weighted logistic regression for linear TV conversions.
linear.data.standard_error_maxMetric
The maximum standard error around the lift estimate, calculated as part of the weighted logistic regression for linear TV conversions.
linear.data.standard_error_minMetric
The minimum standard error around the lift estimate, calculated as part of the weighted logistic regression for linear TV conversions.
network.data.idMetric
A unique identifier for the TV network where the ad aired.
ott.data.brand.data.has_imageDimension
Indicates whether the brand associated with OTT advertising has an image available.
ott.data.brand.data.has_retail_locationDimension
Indicates whether the brand associated with OTT advertising has physical retail store locations.
ott.data.brand.data.idMetric
The unique identifier for the brand being advertised in OTT.
ott.data.brand.data.imageDimension
The image associated with the brand in OTT advertising.
ott.data.brand.data.is_consumer_packaged_goodsDimension
Indicates whether the brand associated with OTT advertising is classified as a Consumer Packaged Goods (CPG) brand.
ott.data.brand.data.is_direct_to_consumerDimension
Indicates whether the brand associated with OTT advertising operates as a direct-to-consumer (DTC) brand.
ott.data.brand.data.nameDimension
The primary name of the brand being advertised in OTT.
ott.data.brand.data.parent_idDimension
The unique identifier associated with the parent company of the brand in OTT advertising.
ott.data.brand.data.parent_nameDimension
The name of the parent company of the brand in OTT advertising.
ott.data.brand.data.slugDimension
A URL-friendly identifier for the brand in OTT advertising.
ott.data.conversion.data.incrementalMetric
The estimated difference between the daily exposed and unexposed devices, expressed as a count, for OTT conversions.
ott.data.conversion.data.matched.data.incrementalMetric
The estimated incremental conversions for OTT based on matched devices.
ott.data.conversion.data.matched.data.rate_exposedMetric
The conversion rate for matched OTT devices that were exposed to an ad.
ott.data.conversion.data.matched.data.rate_unexposedMetric
The conversion rate for matched OTT devices that were not exposed to an ad.
ott.data.conversion.data.rate_exposedMetric
The Conversion Rate of the sample of TV devices that saw at least one ad by the given advertiser within 7 days of the selected date range for OTT.
ott.data.conversion.data.rate_unexposedMetric
The Conversion Rate of the sample of TV devices that did not see an ad by the given advertiser within 7 days of the selected date range for OTT.
ott.data.devices_exposedMetric
The sample of TV devices that saw at least one ad by the given advertiser within 7 days of the selected date range, for OTT.
ott.data.devices_unexposedMetric
The sample of TV devices that did not see an ad by the given advertiser within 7 days of the selected date range, for OTT.
ott.data.lift_percentMetric
The estimated percentage difference between the daily exposed and unexposed conversion rates for OTT.
ott.data.qualified_daysMetric
The number of days with qualified data included in the overall lift calculation for OTT conversions.
ott.data.standard_errorMetric
The average standard error around the lift estimate, calculated as part of the weighted logistic regression for OTT conversions.
ott.data.standard_error_maxMetric
The maximum standard error around the lift estimate, calculated as part of the weighted logistic regression for OTT conversions.
ott.data.standard_error_minMetric
The minimum standard error around the lift estimate, calculated as part of the weighted logistic regression for OTT conversions.
publisher.data.idMetric
A unique identifier for the publisher of the ad.
publisher.data.nameDimension
The name of the publisher of the ad.
spot.data.airing_date_first_etDimension
The date and time (ET) of the first airing of this spot. This is inferred from similar spot-level date fields.
spot.data.airing_date_first_ptDimension
The date and time (PT) of the first airing of this spot. This is inferred from similar spot-level date fields.
spot.data.airing_date_last_etDimension
The date and time (ET) of the last airing of this spot. This is inferred from similar spot-level date fields.
spot.data.airing_date_last_ptDimension
The airing datetime (local to PST/PDT) of the last airing of this spot.
spot.data.cobrandsDimension
Other brands that were featured in this specific ad spot.
spot.data.descriptionDimension
A summary of what takes place in the ad spot.
spot.data.engagement_industry_avgDimension
The average engagement score across all brands within the spot's primary industry. This is inferred from 'median engagement'.
spot.data.engagement_industry_medDimension
The median engagement across all brands within this brand's primary industry, useful for benchmarking purposes.
spot.data.engagement_scoreDimension
The lifetime rating of a spot, measuring the volume of digital activity (video, social, search) triggered by the spot campaign, divided by the estimated TV spend.
spot.data.engagement_score_starsDimension
A score out of 5 stars based on the ad's engagement score.
spot.data.eventsDimension
The name of a larger event during which this ad spot occurred (e.g., holiday, sporting event).
spot.data.hashDimension
A unique hash to identify this specific ad spot.
spot.data.idMetric
A unique identifier for the ad spot.
spot.data.languageDimension
Describes the language the ad spot is in, such as English or Spanish.
spot.data.lifetime_spend_estimatedMetric
The estimated total spend for this advertisement spot over its lifetime. This is inferred from 'estimated spend' metrics.
spot.data.movie_genresDimension
For movie trailers, the genres of the movie advertised (e.g., Action & Adventure, Comedy, Drama).
spot.data.movie_ratingDimension
For movie trailers, the rating of the movie (e.g., G, PG, PG-13, R, NC-17).
spot.data.movie_release_dateDimension
For movie trailers, the theatrical release date of the movie, if applicable.
spot.data.phoneDimension
The phone number associated with the brand in the ad.
spot.data.product_categoriesDimension
A general category of the product(s) associated with this ad spot, based on iSpot taxonomy.
spot.data.productsDimension
The name of the product(s) associated with this ad spot.
spot.data.sub_typeDimension
A more granular categorization within the primary ad spot type, based on iSpot taxonomy.
spot.data.titleDimension
The title of the ad spot.
spot.data.title_shortDimension
A shortened name of the ad spot.
spot.data.typeDimension
Describes the type of ad spot: Commercial, Show Promo, Movie Trailer, Infomercial, PSA, or Network Movie Promo.
spot.data.urlDimension
The default URL to the iSpot creative page for the ad, which can also direct to other sites like IMDB or Rotten Tomatoes.
view_completion.data.avg_indexMetric
The average Attention Index value for a given page or level of granularity, providing context for ad performance.
view_completion.data.indexMetric
A comparison of your ad's Interruption Rate against its specific media placement. It is measured on a scale of 0 to 200, where 100 is the average.
view_completion.data.rateMetric
The expected completion rate for ads running in the same media placement context.
view_completion.data.rate_interruptionMetric
The percentage of devices present at the beginning of an ad that did not complete watching the ad, measured on a scale from 0 to 100%.