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 |
dimension |
|
aired_at_pt_date |
aired_at_pt_date |
dimension |
|
airing.data.aired_at_et |
airing.data.aired_at_et |
dimension |
|
airing.data.aired_at_pt |
airing.data.aired_at_pt |
dimension |
|
airing.data.dma |
airing.data.dma |
The Designated Market Area (DMA) where the ad airing occurred. |
dimension |
airing.data.id |
airing.data.id |
A unique identifier for the specific ad airing. |
metric |
airing.data.media_value |
airing.data.media_value |
metric |
|
airing.data.pod |
airing.data.pod |
metric |
|
airing.data.pod_order |
airing.data.pod_order |
metric |
|
airing.data.pod_position |
airing.data.pod_position |
dimension |
|
airing.data.pod_position_abmyz |
airing.data.pod_position_abmyz |
dimension |
|
airing.data.pod_position_fml |
airing.data.pod_position_fml |
dimension |
|
airing.data.spend_estimated |
airing.data.spend_estimated |
metric |
|
airing.data.type |
airing.data.type |
The type of ad airing, such as National or Local. |
dimension |
audience.data.female_age_18_20_impressions |
audience.data.female_age_18_20_impressions |
Impressions for the female audience in the 18 to 20 age group. |
dimension |
audience.data.female_age_25_29_impressions |
audience.data.female_age_25_29_impressions |
Impressions for the female audience in the 25 to 29 age group. |
dimension |
audience.data.female_age_30_34_impressions |
audience.data.female_age_30_34_impressions |
Impressions for the female audience in the 30 to 34 age group. |
dimension |
audience.data.female_age_35_39_impressions |
audience.data.female_age_35_39_impressions |
Impressions for the female audience in the 35 to 39 age group. |
dimension |
audience.data.female_age_45_49_impressions |
audience.data.female_age_45_49_impressions |
Impressions for the female audience in the 45 to 49 age group. |
dimension |
audience.data.female_age_50_54_impressions |
audience.data.female_age_50_54_impressions |
Impressions for the female audience in the 50 to 54 age group. |
dimension |
audience.data.female_age_60_64_impressions |
audience.data.female_age_60_64_impressions |
Impressions for the female audience in the 60 to 64 age group. |
dimension |
audience.data.female_age_75_99_impressions |
audience.data.female_age_75_99_impressions |
Impressions for the female audience in the 75 to 99 age group. |
dimension |
audience.data.gender_female_impressions |
audience.data.gender_female_impressions |
Total impressions attributed to the female gender group. |
dimension |
audience.data.gender_male_impressions |
audience.data.gender_male_impressions |
Total impressions attributed to the male gender group. |
dimension |
audience.data.igrp |
audience.data.igrp |
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. |
metric |
audience.data.impressions |
audience.data.impressions |
Total audience impressions delivered. |
metric |
audience.data.impressions_local_sov |
audience.data.impressions_local_sov |
The share of voice for local audience impressions. |
metric |
audience.data.impressions_national_c3 |
audience.data.impressions_national_c3 |
The count of national impressions that occurred post-live broadcast up to 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 from 4 days after airing up to 7 days after the original airing. |
metric |
audience.data.impressions_national_linear |
audience.data.impressions_national_linear |
Impressions for a national spot viewed either live during its original broadcast or time-shifted via DVR. |
metric |
audience.data.impressions_national_linear_sov |
audience.data.impressions_national_linear_sov |
The share of voice for national linear audience impressions. |
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 for national live audience impressions. |
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 for raw, unfiltered audience impressions. |
metric |
audience.data.impressions_sov |
audience.data.impressions_sov |
The overall share of voice for total audience impressions. |
metric |
audience.data.impressions_vod_sov |
audience.data.impressions_vod_sov |
The share of voice for Video On Demand (VOD) impressions. |
metric |
audience.data.male_age_18_20_impressions |
audience.data.male_age_18_20_impressions |
Impressions for the male audience in the 18 to 20 age group. |
dimension |
audience.data.male_age_21_24_impressions |
audience.data.male_age_21_24_impressions |
Impressions for the male audience in the 21 to 24 age group. |
dimension |
audience.data.male_age_25_29_impressions |
audience.data.male_age_25_29_impressions |
Impressions for the male audience in the 25 to 29 age group. |
dimension |
audience.data.male_age_30_34_impressions |
audience.data.male_age_30_34_impressions |
Impressions for the male audience in the 30 to 34 age group. |
dimension |
audience.data.male_age_35_39_impressions |
audience.data.male_age_35_39_impressions |
Impressions for the male audience in the 35 to 39 age group. |
dimension |
audience.data.male_age_40_44_impressions |
audience.data.male_age_40_44_impressions |
Impressions for the male audience in the 40 to 44 age group. |
dimension |
audience.data.male_age_45_49_impressions |
audience.data.male_age_45_49_impressions |
Impressions for the male audience in the 45 to 49 age group. |
dimension |
audience.data.male_age_50_54_impressions |
audience.data.male_age_50_54_impressions |
Impressions for the male audience in the 50 to 54 age group. |
dimension |
audience.data.male_age_55_59_impressions |
audience.data.male_age_55_59_impressions |
Impressions for the male audience in the 55 to 59 age group. |
dimension |
audience.data.male_age_60_64_impressions |
audience.data.male_age_60_64_impressions |
Impressions for the male audience in the 60 to 64 age group. |
dimension |
audience.data.male_age_65_74_impressions |
audience.data.male_age_65_74_impressions |
Impressions for the male audience in the 65 to 74 age group. |
dimension |
audience.data.male_age_75_99_impressions |
audience.data.male_age_75_99_impressions |
Impressions for the male audience in the 75 to 99 age group. |
dimension |
brand.data.has_retail_location |
brand.data.has_retail_location |
dimension |
|
brand.data.id |
brand.data.id |
A unique identifier for the brand associated with the ad. |
metric |
brand.data.is_consumer_packaged_goods |
brand.data.is_consumer_packaged_goods |
dimension |
|
brand.data.is_direct_to_consumer |
brand.data.is_direct_to_consumer |
dimension |
|
brand.data.name |
brand.data.name |
The name of the brand associated with the ad. |
dimension |
brand.data.parent_id |
brand.data.parent_id |
A 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 |
metric |
|
conversion.data.matched.data.rate |
conversion.data.matched.data.rate |
The conversion rate for users who were matched to have seen an ad. |
metric |
conversion.data.matched.data.rate_sov |
conversion.data.matched.data.rate_sov |
The share of voice for the conversion rate, calculated from conversion events attributed to TV impressions matched to a Vizio device. |
metric |
conversion.data.matched.data.sov |
conversion.data.matched.data.sov |
The share of voice for total conversion events attributed to TV impressions matched to a Vizio device. |
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 of conversions, representing the ratio of conversion events to TV impressions extrapolated to US households. This field is primarily available for older API clients. |
metric |
conversion.data.rate_exposed |
conversion.data.rate_exposed |
The conversion rate among the audience exposed to the ad. |
metric |
conversion.data.rate_sov |
conversion.data.rate_sov |
The share of voice for the overall conversion rate. |
metric |
conversion.data.rate_unexposed |
conversion.data.rate_unexposed |
metric |
|
conversion.data.sov |
conversion.data.sov |
The share of voice for the total number of conversion events. |
metric |
conversion.data.total |
conversion.data.total |
The total number of conversion events attributed to TV impressions extrapolated to US households. This field is primarily available for older API clients. |
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 |
conversion_type |
conversion_type |
The specific type of conversion, used as a filter or descriptor for conversion data. Examples include ‘WEB’ or ‘APP’. |
dimension |
creative.data.airing_date_first_et |
creative.data.airing_date_first_et |
dimension |
|
creative.data.airing_date_first_pt |
creative.data.airing_date_first_pt |
dimension |
|
creative.data.airing_date_last_et |
creative.data.airing_date_last_et |
dimension |
|
creative.data.airing_date_last_pt |
creative.data.airing_date_last_pt |
dimension |
|
creative.data.description |
creative.data.description |
dimension |
|
creative.data.duration |
creative.data.duration |
metric |
|
creative.data.equivalized_unit |
creative.data.equivalized_unit |
dimension |
|
creative.data.id |
creative.data.id |
A unique identifier for the ad creative. |
metric |
creative.data.isci_code |
creative.data.isci_code |
dimension |
|
creative.data.language |
creative.data.language |
dimension |
|
creative.data.lifetime_airings_count |
creative.data.lifetime_airings_count |
metric |
|
creative.data.lifetime_spend_estimated |
creative.data.lifetime_spend_estimated |
metric |
|
creative.data.spot_id |
creative.data.spot_id |
metric |
|
creative.data.title |
creative.data.title |
dimension |
|
creative.data.title_custom |
creative.data.title_custom |
dimension |
|
creative.data.title_short |
creative.data.title_short |
dimension |
|
creative.data.type |
creative.data.type |
dimension |
|
impressions.data.ott |
impressions.data.ott |
The total number of impressions delivered through Over-The-Top (OTT) advertising. |
metric |
lift_percent |
lift_percent |
The percentage lift in a specific metric (e.g., conversions) attributed to ad exposure. |
metric |
network.data.id |
network.data.id |
A unique identifier for the TV network where the ad aired. |
metric |
publisher.data.id |
publisher.data.id |
A unique identifier for the publisher of the ad. |
metric |
publisher.data.name |
publisher.data.name |
The name of the publisher of the ad. |
dimension |
spot.data.airing_date_first_et |
spot.data.airing_date_first_et |
dimension |
|
spot.data.airing_date_first_pt |
spot.data.airing_date_first_pt |
dimension |
|
spot.data.airing_date_last_et |
spot.data.airing_date_last_et |
dimension |
|
spot.data.airing_date_last_pt |
spot.data.airing_date_last_pt |
dimension |
|
spot.data.cobrands |
spot.data.cobrands |
dimension |
|
spot.data.description |
spot.data.description |
dimension |
|
spot.data.engagement_industry_avg |
spot.data.engagement_industry_avg |
dimension |
|
spot.data.engagement_industry_med |
spot.data.engagement_industry_med |
dimension |
|
spot.data.engagement_score |
spot.data.engagement_score |
dimension |
|
spot.data.engagement_score_stars |
spot.data.engagement_score_stars |
dimension |
|
spot.data.events |
spot.data.events |
dimension |
|
spot.data.hash |
spot.data.hash |
dimension |
|
spot.data.id |
spot.data.id |
A unique identifier for the ad spot. |
metric |
spot.data.language |
spot.data.language |
dimension |
|
spot.data.lifetime_spend_estimated |
spot.data.lifetime_spend_estimated |
metric |
|
spot.data.movie_genres |
spot.data.movie_genres |
dimension |
|
spot.data.movie_rating |
spot.data.movie_rating |
dimension |
|
spot.data.movie_release_date |
spot.data.movie_release_date |
dimension |
|
spot.data.phone |
spot.data.phone |
dimension |
|
spot.data.product_categories |
spot.data.product_categories |
dimension |
|
spot.data.products |
spot.data.products |
dimension |
|
spot.data.sub_type |
spot.data.sub_type |
dimension |
|
spot.data.title |
spot.data.title |
The title of the ad spot. |
dimension |
spot.data.title_short |
spot.data.title_short |
dimension |
|
spot.data.type |
spot.data.type |
dimension |
|
spot.data.url |
spot.data.url |
dimension |