# Integral Ad Science schema ERD

Table and field reference for the Fivetran Integral Ad Science connector.

## Table & Field Reference

### team

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| name | Unknown |  |
| status | Unknown |  |

### placement

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK, FK |
| 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 | PK, FK |
| campaign | Unknown |  |
| total_imp | Unknown |  |

### report

| Column | Type | Keys |
| --- | --- | --- |
| date | Unknown | PK |
| team_id | Unknown | PK |
| campaign_id | Unknown | PK, FK |
| placement_id | Unknown | PK, FK |
| 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 |  |

## Relationships

- placement(id) → team(id)
- media_partner(id) → team(id)
- campaign(id) → team(id)
- report(campaign_id) → campaign(id)
- report(placement_id) → placement(id)
- report(id) → team(id)