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 |