Integral Ad Science

Explore the interactive ERD

Table & Field Reference

team

Column	Type	Keys
`id`	Unknown	PK
`name`	Unknown
`status`	Unknown

placement

Column	Type	Keys
`id`	Unknown	PKFK
`placement`	Unknown
`total_imp`	Unknown

media_partner

Column	Type	Keys
`partner_id`	Unknown	PK
`id`	Unknown	FK
`media_partner`	Unknown
`total_imp`	Unknown

campaign

Column	Type	Keys
`id`	Unknown	PKFK
`campaign`	Unknown
`total_imp`	Unknown

report

Column	Type	Keys
`date`	Unknown	PK
`team_id`	Unknown	PK
`campaign_id`	Unknown	PKFK
`placement_id`	Unknown	PKFK
`id`	Unknown	FK
`ad_distribution_measured_rate`	Unknown
`ad_distribution_net_measured_rate`	Unknown
`ad_distribution_net_unmeasured_rate`	Unknown
`ad_distribution_not_viewable_rate`	Unknown
`ad_distribution_unmeasured_rate`	Unknown
`ad_distribution_viewable_rate`	Unknown
`ad_server_placement_id`	Unknown
`adult_ads`	Unknown
`alcohol_ads`	Unknown
`auto_play_ads`	Unknown
`block_rate`	Unknown
`blocked_ads`	Unknown
`blocked_invalid_traffic`	Unknown
`blocking_status`	Unknown
`bots_ads`	Unknown
`bots_rate`	Unknown
`brand_safety_risk_`	Unknown
`brand_safety_risk_ads`	Unknown
`brand_suitability_fail_`	Unknown
`brand_suitability_failed_ads`	Unknown
`click_to_play_ads`	Unknown
`completed_ads`	Unknown
`completion_rate`	Unknown
`custom_keywords_exclusion_list_ads`	Unknown
`custom_keywords_exclusion_list_rate`	Unknown
`custom_url_app_exclusion_list_ads`	Unknown
`custom_url_exclusion_list_rate`	Unknown
`domain_spoofing_ads`	Unknown
`domain_spoofing_rate`	Unknown
`drugs_ads`	Unknown
`eligible_ads_for_invalid_traffic_detection`	Unknown
`eligible_ads_for_quality_impressions`	Unknown
`eligible_ads_for_viewability_measurement`	Unknown
`eligible_impressions_for_viewability`	Unknown
`eligible_rate_for_invalid_traffic_detection`	Unknown
`eligible_rate_for_quality_impressions`	Unknown
`fail_rate`	Unknown
`failed_ads`	Unknown
`failed_brand_safety_ads`	Unknown
`first_quartile_ads`	Unknown
`first_quartile_rate`	Unknown
`general_invalid_traffic_ads`	Unknown
`general_invalid_traffic_rate`	Unknown
`gross_eligible_ads`	Unknown
`gross_eligible_impressions`	Unknown
`gross_measured_ads`	Unknown
`gross_measured_impressions`	Unknown
`gross_measured_rate`	Unknown
`gross_measured_rate_impressions`	Unknown
`gross_unmeasured_ads`	Unknown
`gross_unmeasured_impressions`	Unknown
`gross_unmeasured_rate_impressions`	Unknown
`hate_speech_ads`	Unknown
`hidden_ads`	Unknown
`hidden_ads_rate`	Unknown
`illegal_downloads_ads`	Unknown
`impression_distribution_measured_rate`	Unknown
`impression_distribution_net_measured_rate`	Unknown
`impression_distribution_net_not_viewable_rate`	Unknown
`impression_distribution_net_unmeasured_rate`	Unknown
`impression_distribution_net_viewable_rate`	Unknown
`impression_distribution_not_viewable_rate`	Unknown
`impression_distribution_unmeasured_rate`	Unknown
`impression_distribution_viewable_rate`	Unknown
`incentivized_browsing_ads`	Unknown
`incentivized_browsing_rate`	Unknown
`invalid_traffic`	Unknown
`invalid_traffic_ads`	Unknown
`invalid_traffic_rate`	Unknown
`invisible_url_`	Unknown
`invisible_url_ads`	Unknown
`measured_ads`	Unknown
`measured_impressions`	Unknown
`measured_rate`	Unknown
`net_ad_distribution_not_viewable_rate`	Unknown
`net_ad_distribution_viewable_rate`	Unknown
`net_eligible_ads_for_viewability_measurement`	Unknown
`net_eligible_impressions_for_viewability_measurement`	Unknown
`net_impressions`	Unknown
`net_measured_ads`	Unknown
`net_measured_impressions`	Unknown
`net_measured_rate`	Unknown
`net_measured_rate_impressions`	Unknown
`net_not_viewable_ads`	Unknown
`net_not_viewable_impressions`	Unknown
`net_not_viewable_rate`	Unknown
`net_not_viewable_rate_impressions`	Unknown
`net_unmeasured_ads`	Unknown
`net_unmeasured_impressions`	Unknown
`net_unmeasured_rate`	Unknown
`net_unmeasured_rate_impressions`	Unknown
`net_viewable_impressions`	Unknown
`net_viewable_rate`	Unknown
`net_viewable_rate_impressions`	Unknown
`non_quality_ads`	Unknown
`non_quality_blocked_ads`	Unknown
`non_quality_failed_brand_safety`	Unknown
`non_quality_ivt`	Unknown
`non_quality_not_viewable`	Unknown
`non_quality_out_of_geo`	Unknown
`non_quality_rate`	Unknown
`not_viewable_ads`	Unknown
`not_viewable_impressions`	Unknown
`not_viewable_rate`	Unknown
`not_viewable_rate_impressions`	Unknown
`of_adult_ads`	Unknown
`of_alcohol_ads`	Unknown
`of_drugs_ads`	Unknown
`of_hate_speech_ads`	Unknown
`of_illegal_downloads_ads`	Unknown
`of_invalid_traffic_blocked`	Unknown
`of_invalid_traffic_unblocked`	Unknown
`of_offensive_language_ads`	Unknown
`of_violence`	Unknown
`offensive_language_ads`	Unknown
`out_of_geo_`	Unknown
`out_of_geo_ads`	Unknown
`pass_rate`	Unknown
`passed_ads`	Unknown
`placement_description`	Unknown
`proxy_server_ads`	Unknown
`proxy_servers_rate`	Unknown
`quality_impressions`	Unknown
`quality_impressions_rate`	Unknown
`reduced_value_inventory_ads`	Unknown
`reduced_value_inventory_rate`	Unknown
`second_quartile_ads`	Unknown
`second_quartile_rate`	Unknown
`see_through_ads`	Unknown
`see_through_rate`	Unknown
`sophisticated_invalid_traffic_ads`	Unknown
`sophisticated_invalid_traffic_rate`	Unknown
`target_language_mismatch_`	Unknown
`target_language_mismatch_ads`	Unknown
`third_quartile_ads`	Unknown
`third_quartile_rate`	Unknown
`total_eligible_ads_for_brand_safety`	Unknown
`total_net_impressions`	Unknown
`total_rendered_impressions`	Unknown
`total_tracked_ads`	Unknown
`unblocked_invalid_traffic`	Unknown
`unknown_player_state_ads`	Unknown
`unmeasured_ads`	Unknown
`unmeasured_impressions`	Unknown
`unmeasured_rate`	Unknown
`valid_traffic`	Unknown
`valid_traffic_rate`	Unknown
`valid_video_ads`	Unknown
`valid_viewable_video_ads`	Unknown
`viewable_completed_impressions`	Unknown
`viewable_completion_rate`	Unknown
`viewable_first_quartile_impressions`	Unknown
`viewable_first_quartile_rate`	Unknown
`viewable_impressions`	Unknown
`viewable_rate`	Unknown
`viewable_rate_impressions`	Unknown
`viewable_second_quartile_impressions`	Unknown
`viewable_second_quartile_rate`	Unknown
`viewable_third_quartile_impressions`	Unknown
`viewable_third_quartile_rate`	Unknown
`violence_ads`	Unknown