iSpot.tv#
The table below gives information about all the data fields that you can import from iSpot.tv.
The fields that you can fetch in Adverity are updated regularly to reflect updates to data source APIs. As a result, the fields shown here may not be the same as the fields available in Adverity. If you notice a difference between this documentation and the fields you see in Adverity, please contact your Adverity account manager for more information.
To see the fields you can collect from another data source, go back to the Available fields in Adverity overview.
Field UI name |
Field API 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.mso |
airing.data.mso |
dimension |
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 |
attention.data.avg_percent_viewed_sum |
attention.data.avg_percent_viewed_sum |
dimension |
attention.data.completed |
attention.data.completed |
dimension |
attention.data.first_quartile |
attention.data.first_quartile |
dimension |
attention.data.index |
attention.data.index |
dimension |
attention.data.mid_point |
attention.data.mid_point |
dimension |
attention.data.score |
attention.data.score |
dimension |
attention.data.score_avg |
attention.data.score_avg |
dimension |
attention.data.started |
attention.data.started |
dimension |
attention.data.third_quartile |
attention.data.third_quartile |
dimension |
attention.data.third_quartile_to_completed |
attention.data.third_quartile_to_completed |
dimension |
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_local |
audience.data.impressions_local |
metric |
audience.data.impressions_local_sov |
audience.data.impressions_local_sov |
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_linear_sov |
audience.data.impressions_national_linear_sov |
metric |
audience.data.impressions_national_live |
audience.data.impressions_national_live |
metric |
audience.data.impressions_national_live_sov |
audience.data.impressions_national_live_sov |
metric |
audience.data.impressions_per_airing |
audience.data.impressions_per_airing |
metric |
audience.data.impressions_per_unit |
audience.data.impressions_per_unit |
metric |
audience.data.impressions_raw |
audience.data.impressions_raw |
metric |
audience.data.impressions_raw_sov |
audience.data.impressions_raw_sov |
metric |
audience.data.impressions_sov |
audience.data.impressions_sov |
metric |
audience.data.impressions_start |
audience.data.impressions_start |
dimension |
audience.data.impressions_unsupported |
audience.data.impressions_unsupported |
metric |
audience.data.impressions_vod |
audience.data.impressions_vod |
metric |
audience.data.impressions_vod_sov |
audience.data.impressions_vod_sov |
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.data.has_image |
brand.data.has_image |
dimension |
brand.data.has_retail_location |
brand.data.has_retail_location |
dimension |
brand.data.id |
brand.data.id |
metric |
brand.data.image |
brand.data.image |
dimension |
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 |
brand.data.slug |
brand.data.slug |
dimension |
conversion.data.matched.data.rate |
conversion.data.matched.data.rate |
metric |
conversion.data.matched.data.rate_sov |
conversion.data.matched.data.rate_sov |
metric |
conversion.data.matched.data.sov |
conversion.data.matched.data.sov |
metric |
conversion.data.matched.data.total |
conversion.data.matched.data.total |
metric |
conversion.data.rate |
conversion.data.rate |
metric |
conversion.data.rate_sov |
conversion.data.rate_sov |
metric |
conversion.data.sov |
conversion.data.sov |
metric |
conversion.data.total |
conversion.data.total |
metric |
conversion.data.tv_population.data.brands_count |
conversion.data.tv_population.data.brands_count |
dimension |
conversion.data.tv_population.data.creatives_count |
conversion.data.tv_population.data.creatives_count |
dimension |
conversion.data.tv_population.data.cumulative_impressions |
conversion.data.tv_population.data.cumulative_impressions |
dimension |
conversion.data.tv_population.data.cumulative_total |
conversion.data.tv_population.data.cumulative_total |
dimension |
conversion.data.tv_population.data.days_count |
conversion.data.tv_population.data.days_count |
dimension |
conversion.data.tv_population.data.episodes_count |
conversion.data.tv_population.data.episodes_count |
dimension |
conversion.data.tv_population.data.filter_key |
conversion.data.tv_population.data.filter_key |
dimension |
conversion.data.tv_population.data.incremental |
conversion.data.tv_population.data.incremental |
dimension |
conversion.data.tv_population.data.index |
conversion.data.tv_population.data.index |
dimension |
conversion.data.tv_population.data.industries_count |
conversion.data.tv_population.data.industries_count |
dimension |
conversion.data.tv_population.data.networks_count |
conversion.data.tv_population.data.networks_count |
dimension |
conversion.data.tv_population.data.optimal_frequency |
conversion.data.tv_population.data.optimal_frequency |
dimension |
conversion.data.tv_population.data.parent_brands_count |
conversion.data.tv_population.data.parent_brands_count |
dimension |
conversion.data.tv_population.data.percent |
conversion.data.tv_population.data.percent |
dimension |
conversion.data.tv_population.data.rate |
conversion.data.tv_population.data.rate |
metric |
conversion.data.tv_population.data.rate_exposed |
conversion.data.tv_population.data.rate_exposed |
dimension |
conversion.data.tv_population.data.rate_index |
conversion.data.tv_population.data.rate_index |
dimension |
conversion.data.tv_population.data.rate_sov |
conversion.data.tv_population.data.rate_sov |
metric |
conversion.data.tv_population.data.rate_unexposed |
conversion.data.tv_population.data.rate_unexposed |
dimension |
conversion.data.tv_population.data.report_date |
conversion.data.tv_population.data.report_date |
dimension |
conversion.data.tv_population.data.report_window |
conversion.data.tv_population.data.report_window |
dimension |
conversion.data.tv_population.data.schedules_count |
conversion.data.tv_population.data.schedules_count |
dimension |
conversion.data.tv_population.data.shows_count |
conversion.data.tv_population.data.shows_count |
dimension |
conversion.data.tv_population.data.site_id |
conversion.data.tv_population.data.site_id |
dimension |
conversion.data.tv_population.data.sov |
conversion.data.tv_population.data.sov |
metric |
conversion.data.tv_population.data.spots_count |
conversion.data.tv_population.data.spots_count |
dimension |
conversion.data.tv_population.data.total |
conversion.data.tv_population.data.total |
metric |
conversion.data.tv_population.data.total_matched |
conversion.data.tv_population.data.total_matched |
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.custom_id |
creative.data.custom_id |
dimension |
creative.data.description |
creative.data.description |
dimension |
creative.data.duration |
creative.data.duration |
metric |
creative.data.equivalized_unit |
creative.data.equivalized_unit |
metric |
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 |
dimension |
creative.data.lifetime_spend_estimated |
creative.data.lifetime_spend_estimated |
dimension |
creative.data.media_pod |
creative.data.media_pod |
dimension |
creative.data.slug |
creative.data.slug |
dimension |
creative.data.spot_id |
creative.data.spot_id |
dimension |
creative.data.thumb_id |
creative.data.thumb_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 |
creative.data.video_disabled |
creative.data.video_disabled |
metric |
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 |
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.brand_id |
network.data.brand_id |
dimension |
network.data.call_sign |
network.data.call_sign |
dimension |
network.data.id |
network.data.id |
metric |
network.data.language |
network.data.language |
dimension |
network.data.name |
network.data.name |
dimension |
show.data.id |
show.data.id |
dimension |
show.data.image |
show.data.image |
dimension |
show.data.impressions_national_c30 |
show.data.impressions_national_c30 |
dimension |
show.data.name |
show.data.name |
dimension |
show.data.start_date |
show.data.start_date |
dimension |
show.data.type |
show.data.type |
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.custom_id |
spot.data.custom_id |
dimension |
spot.data.default_image |
spot.data.default_image |
dimension |
spot.data.default_image_large |
spot.data.default_image_large |
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 |
dimension |
spot.data.media_pod |
spot.data.media_pod |
dimension |
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.slug |
spot.data.slug |
dimension |
spot.data.sub_type |
spot.data.sub_type |
dimension |
spot.data.thumb_id |
spot.data.thumb_id |
dimension |
spot.data.title |
spot.data.title |
dimension |
spot.data.title_custom |
spot.data.title_custom |
dimension |
spot.data.title_short |
spot.data.title_short |
dimension |
spot.data.type |
spot.data.type |
dimension |
spot.data.url |
spot.data.url |
dimension |
spot.data.video_disabled |
spot.data.video_disabled |
metric |
sub_genre.data.id |
sub_genre.data.id |
metric |
sub_genre.data.impressions_national_c30 |
sub_genre.data.impressions_national_c30 |
dimension |
sub_genre.data.name |
sub_genre.data.name |
dimension |
view_completion.data.avg_index |
view_completion.data.avg_index |
metric |
view_completion.data.index |
view_completion.data.index |
metric |
view_completion.data.rate |
view_completion.data.rate |
metric |
view_completion.data.rate_interruption |
view_completion.data.rate_interruption |
metric |
view_completion.data.rate_placement |
view_completion.data.rate_placement |
metric |
view_completion.data.rate_placement_interruption |
view_completion.data.rate_placement_interruption |
metric |