# Kevel schema ERD

Table and field reference for the Fivetran Kevel connector.

## Table & Field Reference

### advertiser

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created | Unknown |  |
| freq_cap_type | Unknown |  |
| is_active | Unknown |  |
| is_deleted | Unknown |  |
| last_modified | Unknown |  |
| title | Unknown |  |
| version | Unknown |  |

### flight

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| campaign_id | Unknown | FK |
| can_passback | Unknown |  |
| cap_type | Unknown |  |
| created | Unknown |  |
| daily_cap_amount | Unknown |  |
| daily_cap_amount_decimal | Unknown |  |
| delivery_status | Unknown |  |
| dont_affect_parent_freq_cap | Unknown |  |
| end_date | Unknown |  |
| end_date_iso | Unknown |  |
| freq_cap | Unknown |  |
| freq_cap_duration | Unknown |  |
| freq_cap_type | Unknown |  |
| geo_distance_targeting | Unknown |  |
| goal_type | Unknown |  |
| impressions | Unknown |  |
| is_active | Unknown |  |
| is_companion | Unknown |  |
| is_deleted | Unknown |  |
| is_full_speed | Unknown |  |
| is_no_duplicates | Unknown |  |
| is_tracking_conversions | Unknown |  |
| is_unlimited | Unknown |  |
| last_modified | Unknown |  |
| name | Unknown |  |
| option_type | Unknown |  |
| price | Unknown |  |
| priority_id | Unknown |  |
| rate_type | Unknown |  |
| require_strict_location | Unknown |  |
| start_date | Unknown |  |
| start_date_iso | Unknown |  |
| time_zone | Unknown |  |
| version | Unknown |  |

### ad_type

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| height | Unknown |  |
| name | Unknown |  |
| width | Unknown |  |

### channel_ad_type

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| channel_id | Unknown | PK, FK |
| type | Unknown |  |

### channel

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| commission | Unknown |  |
| cpm | Unknown |  |
| created | Unknown |  |
| custom_targeting | Unknown |  |
| engine | Unknown |  |
| is_deleted | Unknown |  |
| last_modified | Unknown |  |
| title | Unknown |  |
| version | Unknown |  |

### creative

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| ad_type_id | Unknown | FK |
| advertiser_id | Unknown | FK |
| alt | Unknown |  |
| body | Unknown |  |
| image_link | Unknown |  |
| image_name | Unknown |  |
| is_active | Unknown |  |
| is_deleted | Unknown |  |
| is_html_js | Unknown |  |
| is_network_ad | Unknown |  |
| is_no_track | Unknown |  |
| is_sync | Unknown |  |
| metadata | Unknown |  |
| script_body | Unknown |  |
| title | Unknown |  |
| url | Unknown |  |

### site

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| is_deleted | Unknown |  |
| publisher_account_id | Unknown |  |
| title | Unknown |  |
| url | Unknown |  |

### zone

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| site_id | Unknown | FK |
| is_deleted | Unknown |  |
| name | Unknown |  |

### campaign

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| advertiser_id | Unknown | FK |
| cap_type | Unknown |  |
| created | Unknown |  |
| daily_cap_amount | Unknown |  |
| flights | Json |  |
| freq_cap | Unknown |  |
| freq_cap_duration | Unknown |  |
| freq_cap_type | Unknown |  |
| is_active | Unknown |  |
| is_archived | Unknown |  |
| is_deleted | Unknown |  |
| last_modified | Unknown |  |
| life_time_cap_amount | Unknown |  |
| name | Unknown |  |
| price | Unknown |  |
| salesperson_id | Unknown |  |
| start_date | Unknown |  |
| start_date_iso | Unknown |  |
| version | Unknown |  |

### report_group

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| report_id | Unknown | PK, FK |
| groups | Unknown |  |

### report_record_detail

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| grouping_ad_type_id | Unknown | FK |
| grouping_brand_id | Unknown | FK |
| grouping_campaign_id | Unknown | FK |
| grouping_channel_id | Unknown | FK |
| grouping_creative_id | Unknown | FK |
| grouping_option_id | Unknown | FK |
| grouping_priority_id | Unknown | FK |
| grouping_site_id | Unknown | FK |
| grouping_zone_id | Unknown | FK |
| index | Unknown | FK |
| report_id | Unknown | FK |
| _title | Unknown |  |
| bot_filtering_disabled_requests | Unknown |  |
| clicks | Unknown |  |
| ctr | Unknown |  |
| date | Unknown |  |
| date_type | Unknown |  |
| decision_requests | Unknown |  |
| details | Json |  |
| duplicate_impression_bucket_clicks | Unknown |  |
| duplicate_ip_bucket_clicks | Unknown |  |
| ecpm | Unknown |  |
| events | Json |  |
| fill_rate | Unknown |  |
| first_date | Unknown |  |
| gmv | Unknown |  |
| grouping_ad_id | Unknown |  |
| grouping_ad_type | Unknown |  |
| grouping_advertised_os | Unknown |  |
| grouping_advertiser | Unknown |  |
| grouping_brand_name | Unknown |  |
| grouping_browser | Unknown |  |
| grouping_browser_major_version | Unknown |  |
| grouping_browser_minor_version | Unknown |  |
| grouping_campaign | Unknown |  |
| grouping_channel | Unknown |  |
| grouping_city | Unknown |  |
| grouping_country_code | Unknown |  |
| grouping_creative | Unknown |  |
| grouping_date | Unknown |  |
| grouping_date_type | Unknown |  |
| grouping_flight | Unknown |  |
| grouping_form_factor | Unknown |  |
| grouping_keyword | Unknown |  |
| grouping_metro_code | Unknown |  |
| grouping_model_name | Unknown |  |
| grouping_os_major_version | Unknown |  |
| grouping_os_minor_version | Unknown |  |
| grouping_price | Unknown |  |
| grouping_priority | Unknown |  |
| grouping_product_brand_id | Unknown |  |
| grouping_product_brand_name | Unknown |  |
| grouping_product_main_category_id | Unknown |  |
| grouping_product_main_category_name | Unknown |  |
| grouping_product_merchant_id | Unknown |  |
| grouping_product_merchant_name | Unknown |  |
| grouping_product_sku_id | Unknown |  |
| grouping_product_sku_name | Unknown |  |
| grouping_publisher_account | Unknown |  |
| grouping_publisher_account_id | Unknown |  |
| grouping_rate_type_id | Unknown |  |
| grouping_region | Unknown |  |
| grouping_site | Unknown |  |
| grouping_zone | Unknown |  |
| impressions | Unknown |  |
| invalid_ua_bucket_clicks | Unknown |  |
| invalid_ua_impressions | Unknown |  |
| invalid_user_agent_requests | Unknown |  |
| last_date | Unknown |  |
| passback_requests | Unknown |  |
| raw_bucket_clicks | Unknown |  |
| requests | Unknown |  |
| revenue | Unknown |  |
| roas | Unknown |  |
| rtb_bid_requests | Unknown |  |
| rtb_matched_requests | Unknown |  |
| rtb_requests | Unknown |  |
| suspicious_bucket_clicks | Unknown |  |
| test_bucket_clicks | Unknown |  |
| title | Unknown |  |
| true_revenue | Unknown |  |
| unfiltered_impressions | Unknown |  |
| unique_bucket_clicks | Unknown |  |
| unique_ctr | Unknown |  |
| valid_user_agent_requests | Unknown |  |

### report_record

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| report_id | Unknown | PK, FK |
| _title | Unknown |  |
| bot_filtering_disabled_requests | Unknown |  |
| clicks | Unknown |  |
| ctr | Unknown |  |
| date | Unknown |  |
| date_type | Unknown |  |
| decision_requests | Unknown |  |
| ecpm | Unknown |  |
| events | Json |  |
| fill_rate | Unknown |  |
| first_date | Unknown |  |
| gmv | Unknown |  |
| grouping | Unknown |  |
| impressions | Unknown |  |
| invalid_ua_impressions | Unknown |  |
| invalid_user_agent_requests | Unknown |  |
| last_date | Unknown |  |
| passback_requests | Unknown |  |
| raw_bucket_clicks | Unknown |  |
| requests | Unknown |  |
| revenue | Unknown |  |
| roas | Unknown |  |
| rtb_bid_requests | Unknown |  |
| rtb_matched_requests | Unknown |  |
| rtb_requests | Unknown |  |
| suspicious_bucket_clicks | Unknown |  |
| title | Unknown |  |
| true_revenue | Unknown |  |
| unfiltered_impressions | Unknown |  |
| unique_bucket_clicks | Unknown |  |
| unique_ctr | Unknown |  |
| valid_user_agent_requests | Unknown |  |

### report

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| critiera | Json |  |
| end_date | Unknown |  |
| end_date_iso | Unknown |  |
| is_total | Unknown |  |
| login_id | Unknown |  |
| option_records | Json |  |
| record_title | Unknown |  |
| result_report_id | Unknown |  |
| start_date | Unknown |  |
| start_date_iso | Unknown |  |
| status | Unknown |  |
| title | Unknown |  |
| total_bot_filtering_disabled_requests | Unknown |  |
| total_clicks | Unknown |  |
| total_ctr | Unknown |  |
| total_decision_requests | Unknown |  |
| total_duplicate_impression_bucket_clicks | Unknown |  |
| total_duplicate_ip_bucket_clicks | Unknown |  |
| total_ecpm | Unknown |  |
| total_fill_rate | Unknown |  |
| total_gmv | Unknown |  |
| total_impressions | Unknown |  |
| total_invalid_ua_bucket_clicks | Unknown |  |
| total_invalid_ua_impressions | Unknown |  |
| total_invalid_user_agent_requests | Unknown |  |
| total_passback_requests | Unknown |  |
| total_raw_bucket_clicks | Unknown |  |
| total_requests | Unknown |  |
| total_revenue | Unknown |  |
| total_roas | Unknown |  |
| total_rtb_bid_requests | Unknown |  |
| total_rtb_matched_requests | Unknown |  |
| total_rtb_requests | Unknown |  |
| total_supicious_bucket_clicks | Unknown |  |
| total_test_bucket_clicks | Unknown |  |
| total_true_revenue | Unknown |  |
| total_unfiltered_impressions | Unknown |  |
| total_unique_bucket_clicks | Unknown |  |
| total_unique_ctr | Unknown |  |
| total_valid_user_agent_requests | Unknown |  |

## Relationships

- flight(campaign_id) → campaign(id)
- channel_ad_type(channel_id) → channel(id)
- creative(ad_type_id) → ad_type(id)
- creative(advertiser_id) → advertiser(id)
- zone(site_id) → site(id)
- campaign(advertiser_id) → advertiser(id)
- report_group(report_id) → report(id)
- report_record_detail(grouping_ad_type_id) → ad_type(id)
- report_record_detail(grouping_channel_id) → channel(id)
- report_record_detail(grouping_campaign_id) → campaign(id)
- report_record_detail(grouping_zone_id) → zone(id)
- report_record_detail(grouping_option_id) → flight(id)
- report_record_detail(grouping_brand_id) → advertiser(id)
- report_record_detail(grouping_creative_id) → creative(id)
- report_record_detail(grouping_priority_id) → flight(priority_id)
- report_record_detail(grouping_site_id) → site(id)
- report_record_detail(report_id) → report_record(report_id)
- report_record_detail(index) → report_record(index)
- report_record(report_id) → report(id)