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_date Dimension
The date an ad airing occurred, in Eastern Time (ET).
aired_at_pt_date Dimension
The date an ad airing occurred, in Pacific Time (PT).
airing.data.aired_at_et Dimension
The airing time (local in EST/EDT) of the advertisement.
airing.data.aired_at_pt Dimension
The airing time (local in PST/PDT) of the advertisement.
airing.data.dma Dimension
The Designated Market Area (DMA) where the ad airing occurred.
airing.data.id Metric
A unique identifier for the specific ad airing.
airing.data.media_value Metric
Estimated media value of in-network promotions.
airing.data.pod Metric
The commercial block within a show where the ad aired, starting at 1. Within a 60-minute show, there are typically 5-7 pods, each containing multiple airings.
airing.data.pod_order Metric
The numerical placement of the advertisement within its commercial pod.
airing.data.pod_position Dimension
The placement of the advertisement within its commercial pod, represented by First, Middle, or Last.
airing.data.pod_position_abmyz Dimension
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_fml Dimension
The placement of the advertisement within its commercial pod, represented by First, Middle, or Last.
airing.data.spend_estimated Metric
The estimated spend for a single advertisement airing.
airing.data.type Dimension
The type of ad airing, such as National or Local.
audience.data.female_age_18_20_impressions Dimension
Impressions for the female audience in the 18 to 20 age group.
audience.data.female_age_25_29_impressions Dimension
Impressions for the female audience in the 25 to 29 age group.
audience.data.female_age_30_34_impressions Dimension
Impressions for the female audience in the 30 to 34 age group.
audience.data.female_age_35_39_impressions Dimension
Impressions for the female audience in the 35 to 39 age group.
audience.data.female_age_45_49_impressions Dimension
Impressions for the female audience in the 45 to 49 age group.
audience.data.female_age_50_54_impressions Dimension
Impressions for the female audience in the 50 to 54 age group.
audience.data.female_age_60_64_impressions Dimension
Impressions for the female audience in the 60 to 64 age group.
audience.data.female_age_75_99_impressions Dimension
Impressions for the female audience in the 75 to 99 age group.
audience.data.gender_female_impressions Dimension
Total impressions attributed to the female gender group.
audience.data.gender_male_impressions Dimension
Total impressions attributed to the male gender group.
audience.data.igrp Metric
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.impressions Metric
Total audience impressions delivered.
audience.data.impressions_local_sov Metric
The share of voice for local audience impressions.
audience.data.impressions_national_c3 Metric
The count of national impressions that occurred post-live broadcast up to 3 days after the original airing.
audience.data.impressions_national_c30 Dimension
National commercial impressions for an advertisement, measured within 30 days of live viewing (C30 metric).
audience.data.impressions_national_c7 Metric
The count of national impressions that occurred from 4 days after airing up to 7 days after the original airing.
audience.data.impressions_national_linear Metric
Impressions for a national spot viewed either live during its original broadcast or time-shifted via DVR.
audience.data.impressions_national_linear_sov Metric
The share of voice for national linear audience impressions.
audience.data.impressions_national_live Metric
National audience impressions for live viewing.
audience.data.impressions_national_live_sov Metric
The share of voice for national live audience impressions.
audience.data.impressions_raw Metric
Raw, unfiltered audience impressions.
audience.data.impressions_raw_sov Metric
The share of voice for raw, unfiltered audience impressions.
audience.data.impressions_sov Metric
The overall share of voice for total audience impressions.
audience.data.impressions_vod_sov Metric
The share of voice for Video On Demand (VOD) impressions.
audience.data.male_age_18_20_impressions Dimension
Impressions for the male audience in the 18 to 20 age group.
audience.data.male_age_21_24_impressions Dimension
Impressions for the male audience in the 21 to 24 age group.
audience.data.male_age_25_29_impressions Dimension
Impressions for the male audience in the 25 to 29 age group.
audience.data.male_age_30_34_impressions Dimension
Impressions for the male audience in the 30 to 34 age group.
audience.data.male_age_35_39_impressions Dimension
Impressions for the male audience in the 35 to 39 age group.
audience.data.male_age_40_44_impressions Dimension
Impressions for the male audience in the 40 to 44 age group.
audience.data.male_age_45_49_impressions Dimension
Impressions for the male audience in the 45 to 49 age group.
audience.data.male_age_50_54_impressions Dimension
Impressions for the male audience in the 50 to 54 age group.
audience.data.male_age_55_59_impressions Dimension
Impressions for the male audience in the 55 to 59 age group.
audience.data.male_age_60_64_impressions Dimension
Impressions for the male audience in the 60 to 64 age group.
audience.data.male_age_65_74_impressions Dimension
Impressions for the male audience in the 65 to 74 age group.
audience.data.male_age_75_99_impressions Dimension
Impressions for the male audience in the 75 to 99 age group.
brand.data.id Metric
A unique identifier for the brand associated with the ad.
brand.data.name Dimension
The name of the brand associated with the ad.
brand.data.parent_id Dimension
A unique identifier for the parent company of the brand.
brand.data.parent_name Dimension
The name of the parent company of the brand.
conversion.data.incremental Metric
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.rate Metric
The conversion rate for users who were matched to have seen an ad.
conversion.data.matched.data.rate_sov Metric
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.sov Metric
The share of voice for total conversion events attributed to TV impressions matched to a Vizio device.
conversion.data.matched.data.total Metric
The total number of conversions attributed to matched users.
conversion.data.ott.data.matched.data.rate Dimension
The conversion rate for OTT (Over-The-Top) matched users.
conversion.data.ott.data.matched.data.total Dimension
The total number of conversions for OTT (Over-The-Top) matched users.
conversion.data.rate Metric
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_exposed Metric
The conversion rate among users who were exposed to the advertisement. This is used in 'Lift' reporting to compare conversion rates.
conversion.data.rate_sov Metric
The share of voice for the overall conversion rate.
conversion.data.rate_unexposed Metric
The conversion rate among users who were not exposed to the advertisement. This is used in 'Lift' reporting to compare conversion rates.
conversion.data.sov Metric
The share of voice for the total number of conversion events.
conversion.data.total Metric
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.rate Metric
The conversion rate among the TV viewing population exposed to ads.
conversion.data.tv_population.data.total Metric
The total number of conversions attributed to the TV viewing population.
conversion_type Dimension
The specific type of conversion, used as a filter or descriptor for conversion data. Examples include 'WEB' or 'APP'.
creative.data.airing_date_first_et Dimension
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_pt Dimension
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_et Dimension
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_pt Dimension
The date and time (PT) of the last airing for this creative. This is inferred from similar spot-level date fields.
creative.data.description Dimension
A textual description of the creative content.
creative.data.duration Metric
The running time of the creative, measured in seconds.
creative.data.id Metric
A unique identifier for the ad creative.
creative.data.language Dimension
The primary language of the creative content. This is inferred as a metadata attribute.
creative.data.lifetime_airings_count Metric
The total number of times this creative has aired over its lifetime. This is inferred from the 'Airings' metric.
creative.data.lifetime_spend_estimated Metric
The estimated total spend for all airings of this creative over its lifetime. This is inferred from 'estimated spend' metrics.
creative.data.spot_id Metric
The unique identifier for the specific spot variation that aired.
creative.data.title Dimension
The official title of the creative. This is inferred from 'spot_title'.
creative.data.title_short Dimension
A shortened version of the creative's title. This is inferred from 'spot_title_short'.
creative.data.type Dimension
The type or category of the creative (e.g., standard ad, promo). This is inferred as a creative attribute.
date.data.date Dimension
A specific date associated with the data point.
date_est Dimension
A specific date, in Eastern Standard Time (EST), associated with the data point.
impressions.data.ott Metric
The total number of impressions delivered through Over-The-Top (OTT) advertising.
lift_percent Metric
The percentage lift in a specific metric (e.g., conversions) attributed to ad exposure.
network.data.id Metric
A unique identifier for the TV network where the ad aired.
publisher.data.id Metric
A unique identifier for the publisher of the ad.
publisher.data.name Dimension
The name of the publisher of the ad.
spot.data.airing_date_first_et Dimension
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_pt Dimension
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_et Dimension
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_pt Dimension
The airing datetime (local to PST/PDT) of the last airing of this spot.
spot.data.description Dimension
A detailed description of the advertisement spot.
spot.data.engagement_industry_avg Dimension
The average engagement score across all brands within the spot's primary industry. This is inferred from 'median engagement'.
spot.data.engagement_industry_med Dimension
The median engagement across all brands within this brand's primary industry, useful for benchmarking purposes.
spot.data.engagement_score Dimension
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_stars Dimension
The engagement score represented in a star rating format. This is an inferred extension of the engagement score.
spot.data.id Metric
A unique identifier for the ad spot.
spot.data.language Dimension
The primary language of the advertisement spot. This is inferred from 'Metadata' attributes.
spot.data.lifetime_spend_estimated Metric
The estimated total spend for this advertisement spot over its lifetime. This is inferred from 'estimated spend' metrics.
spot.data.sub_type Dimension
A more granular classification of the spot's type (e.g., National, Local, Spot Cable).
spot.data.title Dimension
The title of the ad spot.
spot.data.title_short Dimension
A shortened version of the advertisement spot's title. This is a direct match to 'spot_title' and likely indicates a shortened form.
spot.data.type Dimension
The type or main category of the advertisement spot (e.g., National, Local, Spot Cable).