Kevel

Explore the interactive ERD

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	PKFK
`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	PKFK
`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	PKFK
`_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