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	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	dimension
airing.data.id	airing.data.id	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	dimension
airings.data.spend_estimated	airings.data.spend_estimated	metric
audience.data.female_age_18_20_impressions	audience.data.female_age_18_20_impressions	dimension
audience.data.female_age_25_29_impressions	audience.data.female_age_25_29_impressions	dimension
audience.data.female_age_30_34_impressions	audience.data.female_age_30_34_impressions	dimension
audience.data.female_age_35_39_impressions	audience.data.female_age_35_39_impressions	dimension
audience.data.female_age_45_49_impressions	audience.data.female_age_45_49_impressions	dimension
audience.data.female_age_50_54_impressions	audience.data.female_age_50_54_impressions	dimension
audience.data.female_age_60_64_impressions	audience.data.female_age_60_64_impressions	dimension
audience.data.female_age_75_99_impressions	audience.data.female_age_75_99_impressions	dimension
audience.data.gender_female_impressions	audience.data.gender_female_impressions	dimension
audience.data.gender_male_impressions	audience.data.gender_male_impressions	dimension
audience.data.igrp	audience.data.igrp	metric
audience.data.impressions	audience.data.impressions	metric
audience.data.impressions_cpm	audience.data.impressions_cpm	metric
audience.data.impressions_national_c3	audience.data.impressions_national_c3	metric
audience.data.impressions_national_c30	audience.data.impressions_national_c30	dimension
audience.data.impressions_national_c7	audience.data.impressions_national_c7	metric
audience.data.impressions_national_linear	audience.data.impressions_national_linear	metric
audience.data.impressions_national_live	audience.data.impressions_national_live	metric
audience.data.impressions_raw	audience.data.impressions_raw	metric
audience.data.male_age_18_20_impressions	audience.data.male_age_18_20_impressions	dimension
audience.data.male_age_21_24_impressions	audience.data.male_age_21_24_impressions	dimension
audience.data.male_age_25_29_impressions	audience.data.male_age_25_29_impressions	dimension
audience.data.male_age_30_34_impressions	audience.data.male_age_30_34_impressions	dimension
audience.data.male_age_35_39_impressions	audience.data.male_age_35_39_impressions	dimension
audience.data.male_age_40_44_impressions	audience.data.male_age_40_44_impressions	dimension
audience.data.male_age_45_49_impressions	audience.data.male_age_45_49_impressions	dimension
audience.data.male_age_50_54_impressions	audience.data.male_age_50_54_impressions	dimension
audience.data.male_age_55_59_impressions	audience.data.male_age_55_59_impressions	dimension
audience.data.male_age_60_64_impressions	audience.data.male_age_60_64_impressions	dimension
audience.data.male_age_65_74_impressions	audience.data.male_age_65_74_impressions	dimension
audience.data.male_age_75_99_impressions	audience.data.male_age_75_99_impressions	dimension
brand	brand	dimension
brand.data.has_retail_location	brand.data.has_retail_location	dimension
brand.data.id	brand.data.id	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	dimension
brand.data.parent_id	brand.data.parent_id	dimension
brand.data.parent_name	brand.data.parent_name	dimension
creative.data	creative.data	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	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	dimension
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
date.data.date	date.data.date	dimension
date_est	date_est	dimension
day_of_week.data.id	day_of_week.data.id	dimension
day_of_week.data.name	day_of_week.data.name	dimension
day_part.data.description	day_part.data.description	dimension
day_part.data.display_id	day_part.data.display_id	dimension
day_part.data.id	day_part.data.id	metric
day_part.data.name	day_part.data.name	dimension
dma.data.id	dma.data.id	metric
episode.data.id	episode.data.id	dimension
episode.data.is_new	episode.data.is_new	dimension
episode.data.title	episode.data.title	dimension
genre.data.id	genre.data.id	metric
genre.data.name	genre.data.name	dimension
industry.data.id	industry.data.id	metric
industry.data.name	industry.data.name	dimension
industry.data.parent_id	industry.data.parent_id	dimension
industry.data.parent_name	industry.data.parent_name	dimension
network.data.id	network.data.id	metric
show.data.id	show.data.id	dimension
show.data.name	show.data.name	dimension
show.data.type	show.data.type	dimension
spot	spot	dimension
spot.data	spot.data	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	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	dimension
spot.data.title_short	spot.data.title_short	dimension
spot.data.type	spot.data.type	dimension
spot.data.url	spot.data.url	dimension
sub_genre.data.id	sub_genre.data.id	metric
sub_genre.data.name	sub_genre.data.name	dimension