# RTB House schema ERD

Table and field reference for the Fivetran RTB House connector.

## Table & Field Reference

### win_rate_stat

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| advertiser_data_id | Unknown | FK |
| day | Unknown |  |
| total | Unknown |  |
| won | Unknown |  |

### rtb_summary_stat_post_view

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| advertiser_data_id | Unknown | FK |
| campaign_cost | Unknown |  |
| clicks_count | Unknown |  |
| conversions_count | Unknown |  |
| conversions_value | Unknown |  |
| cr | Unknown |  |
| ctr | Unknown |  |
| day | Unknown |  |
| device_type | Unknown |  |
| imps_count | Unknown |  |
| subcampaign | Unknown |  |
| subcampaign_hash | Unknown |  |

### rtb_summary_stat_all_post

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| advertiser_data_id | Unknown | FK |
| campaign_cost | Unknown |  |
| clicks_count | Unknown |  |
| conversions_count | Unknown |  |
| conversions_value | Unknown |  |
| cr | Unknown |  |
| ctr | Unknown |  |
| day | Unknown |  |
| device_type | Unknown |  |
| imps_count | Unknown |  |
| subcampaign | Unknown |  |
| subcampaign_hash | Unknown |  |

### rtb_stat_all_post

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| advertiser_data_id | Unknown | FK |
| campaign_cost | Unknown |  |
| clicks_count | Unknown |  |
| conversions_count | Unknown |  |
| conversions_value | Unknown |  |
| cr | Unknown |  |
| creative | Unknown |  |
| creative_created_at | Unknown |  |
| creative_height | Unknown |  |
| creative_labels | Json |  |
| creative_name | Unknown |  |
| creative_offers_number | Unknown |  |
| creative_status | Unknown |  |
| creative_type | Unknown |  |
| creative_updated_at | Unknown |  |
| creative_width | Unknown |  |
| ctr | Unknown |  |
| day | Unknown |  |
| device_type | Unknown |  |
| imps_count | Unknown |  |
| month | Unknown |  |
| quarter | Unknown |  |
| subcampaign | Unknown |  |
| subcampaign_hash | Unknown |  |
| user_segment | Unknown |  |
| week | Unknown |  |
| year | Unknown |  |

### billing

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| advertiser_data_id | Unknown | FK |
| balance | Unknown |  |
| credit | Unknown |  |
| day | Unknown |  |
| debit | Unknown |  |
| operation | Unknown |  |
| position | Unknown |  |
| record_number | Unknown |  |

### offer

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| advertiser_data_id | Unknown | FK |
| category_name | Unknown |  |
| currency | Unknown |  |
| full_name | Unknown |  |
| identifier | Unknown |  |
| image_details | Json |  |
| name | Unknown |  |
| price | Unknown |  |
| status | Unknown |  |
| updated_at | Unknown |  |
| url | Unknown |  |
| custom_property_** |  |  |

### rtb_stat_branding

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| advertiser_data_id | Unknown | FK |
| campaign_cost | Unknown |  |
| clicks_count | Unknown |  |
| creative | Unknown |  |
| creative_created_at | Unknown |  |
| creative_height | Unknown |  |
| creative_labels | Json |  |
| creative_name | Unknown |  |
| creative_offers_number | Unknown |  |
| creative_status | Unknown |  |
| creative_type | Unknown |  |
| creative_updated_at | Unknown |  |
| creative_width | Unknown |  |
| ctr | Unknown |  |
| day | Unknown |  |
| device_type | Unknown |  |
| imps_count | Unknown |  |
| month | Unknown |  |
| quarter | Unknown |  |
| subcampaign | Unknown |  |
| subcampaign_hash | Unknown |  |
| user_segment | Unknown |  |
| week | Unknown |  |
| year | Unknown |  |

### conversion_all_post_click

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| advertiser_data_id | Unknown | FK |
| class | Unknown |  |
| commission_value | Unknown |  |
| cookie_hash | Unknown |  |
| hash | Unknown |  |
| identifier | Unknown |  |
| last_click_time | Unknown |  |
| last_impression_time | Unknown |  |
| time | Unknown |  |
| value | Unknown |  |

### rtb_stat_attributed

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| advertiser_data_id | Unknown | FK |
| campaign_cost | Unknown |  |
| clicks_count | Unknown |  |
| conversions_count | Unknown |  |
| conversions_value | Unknown |  |
| cr | Unknown |  |
| creative | Unknown |  |
| creative_created_at | Unknown |  |
| creative_height | Unknown |  |
| creative_labels | Json |  |
| creative_name | Unknown |  |
| creative_offers_number | Unknown |  |
| creative_status | Unknown |  |
| creative_type | Unknown |  |
| creative_updated_at | Unknown |  |
| creative_width | Unknown |  |
| ctr | Unknown |  |
| day | Unknown |  |
| device_type | Unknown |  |
| imps_count | Unknown |  |
| month | Unknown |  |
| quarter | Unknown |  |
| subcampaign | Unknown |  |
| subcampaign_hash | Unknown |  |
| user_segment | Unknown |  |
| week | Unknown |  |
| year | Unknown |  |

### advertisers_with_hash_contact_person

| Column | Type | Keys |
| --- | --- | --- |
| login | Unknown | PK |
| advertisers_detail_id | Unknown | FK |
| email | Unknown |  |
| name | Unknown |  |

### advertisers_detail

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK, FK |
| country | Unknown |  |
| feed_identifier | Unknown |  |
| properties_maximal_cpc | Unknown |  |
| properties_minimal_cpc | Unknown |  |
| version | Unknown |  |

### client

| Column | Type | Keys |
| --- | --- | --- |
| company_name | Unknown | PK |
| advertiser_data_id | Unknown | PK, FK |
| city | Unknown |  |
| country | Unknown |  |
| email | Unknown |  |
| postal_code | Unknown |  |
| street_1 | Unknown |  |
| street_2 | Unknown |  |
| vat_number | Unknown |  |

### advertisers_rtb

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| advertiser_data_id | Unknown | FK |
| hidden | Unknown |  |
| text | Unknown |  |
| value | Unknown |  |

### advertiser_data

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_at | Unknown |  |
| currency | Unknown |  |
| features_enabled | Json |  |
| name | Unknown |  |
| properties_campaign_type | Unknown |  |
| properties_is_archived | Unknown |  |
| properties_permission | Json |  |
| status | Unknown |  |
| url | Unknown |  |

### top_in_apps_stat_click

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| advertiser_data_id | Unknown | FK |
| app_name | Unknown |  |
| value | Unknown |  |

### rtb_summary_stat_branding

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| advertiser_data_id | Unknown | FK |
| campaign_cost | Unknown |  |
| clicks_count | Unknown |  |
| ctr | Unknown |  |
| day | Unknown |  |
| device_type | Unknown |  |
| imps_count | Unknown |  |
| subcampaign | Unknown |  |
| subcampaign_hash | Unknown |  |

### conversion_attributed

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| advertiser_data_id | Unknown | FK |
| class | Unknown |  |
| commission_value | Unknown |  |
| cookie_hash | Unknown |  |
| hash | Unknown |  |
| identifier | Unknown |  |
| last_click_time | Unknown |  |
| last_impression_time | Unknown |  |
| time | Unknown |  |
| value | Unknown |  |

### users

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| count_convention | Unknown |  |
| email | Unknown |  |
| is_client_user | Unknown |  |
| is_demo_user | Unknown |  |
| is_force_logged_in | Unknown |  |
| is_mfa_enabled | Unknown |  |
| login | Unknown |  |
| mfa_suggest | Unknown |  |
| permission | Json |  |
| should_change_password | Unknown |  |

### creatives_preview

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| advertiser_data_id | Unknown | FK |
| rtb_creative_id | Unknown | FK |
| height | Unknown |  |
| offers_number | Unknown |  |
| preview_url | Unknown |  |
| width | Unknown |  |

### rtb_creative

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| advertiser_data_id | Unknown | PK, FK |
| status | Unknown |  |

### rate_card

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| advertiser_data_id | Unknown | FK |
| category_rate_card | Unknown |  |
| cpa_post_click_buyer | Unknown |  |
| cpa_post_click_shopper | Unknown |  |
| cpa_post_click_visitor | Unknown |  |
| cpa_post_view_buyer | Unknown |  |
| cpa_post_view_shopper | Unknown |  |
| cpa_post_view_visitor | Unknown |  |
| cpc_buyer | Unknown |  |
| cpc_shopper | Unknown |  |
| cpc_visitor | Unknown |  |
| cpm_buyer | Unknown |  |
| cpm_shopper | Unknown |  |
| cpm_visitor | Unknown |  |
| cps_post_click_buyer | Unknown |  |
| cps_post_click_shopper | Unknown |  |
| cps_post_click_visitor | Unknown |  |
| cps_post_view_buyer | Unknown |  |
| cps_post_view_shopper | Unknown |  |
| cps_post_view_visitor | Unknown |  |

### rtb_stat_post_view

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| advertiser_data_id | Unknown | FK |
| campaign_cost | Unknown |  |
| clicks_count | Unknown |  |
| conversions_count | Unknown |  |
| conversions_value | Unknown |  |
| cr | Unknown |  |
| creative | Unknown |  |
| creative_created_at | Unknown |  |
| creative_height | Unknown |  |
| creative_labels | Json |  |
| creative_name | Unknown |  |
| creative_offers_number | Unknown |  |
| creative_status | Unknown |  |
| creative_type | Unknown |  |
| creative_updated_at | Unknown |  |
| creative_width | Unknown |  |
| ctr | Unknown |  |
| day | Unknown |  |
| device_type | Unknown |  |
| imps_count | Unknown |  |
| month | Unknown |  |
| quarter | Unknown |  |
| subcampaign | Unknown |  |
| subcampaign_hash | Unknown |  |
| user_segment | Unknown |  |
| week | Unknown |  |
| year | Unknown |  |

### last_seen_tags_stat

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| advertiser_data_id | Unknown | FK |
| clicks_count | Json |  |
| imps_count | Json |  |
| last_tag_hour | Unknown |  |

### top_hosts_stat_click

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| advertiser_data_id | Unknown | FK |
| host | Unknown |  |
| value | Unknown |  |

### top_in_apps_stat_imps

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| advertiser_data_id | Unknown | FK |
| app_name | Unknown |  |
| value | Unknown |  |

### conversion_post_view

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| advertiser_data_id | Unknown | FK |
| class | Unknown |  |
| commission_value | Unknown |  |
| cookie_hash | Unknown |  |
| hash | Unknown |  |
| identifier | Unknown |  |
| last_click_time | Unknown |  |
| last_impression_time | Unknown |  |
| time | Unknown |  |
| value | Unknown |  |

### campaign

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| advertiser_data_id | Unknown | PK, FK |
| rate_card_id | Unknown | FK |
| budget_daily | Unknown |  |
| budget_monthly | Unknown |  |
| creative_id | Json |  |
| is_editable | Unknown |  |
| name | Unknown |  |
| status | Unknown |  |
| updated_at | Unknown |  |

### conversion_all

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| advertiser_data_id | Unknown | FK |
| class | Unknown |  |
| commission_value | Unknown |  |
| cookie_hash | Unknown |  |
| hash | Unknown |  |
| identifier | Unknown |  |
| last_click_time | Unknown |  |
| last_impression_time | Unknown |  |
| time | Unknown |  |
| value | Unknown |  |

### top_hosts_stat_imps

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| advertiser_data_id | Unknown | FK |
| host | Unknown |  |
| value | Unknown |  |

### offer_category

| Column | Type | Keys |
| --- | --- | --- |
| category_id | Unknown | PK |
| advertiser_data_id | Unknown | FK |
| active_offers_number | Unknown |  |
| identifier | Unknown |  |
| name | Unknown |  |

### rtb_stat_all_conversions

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| advertiser_data_id | Unknown | FK |
| campaign_cost | Unknown |  |
| clicks_count | Unknown |  |
| conversions_count | Unknown |  |
| conversions_value | Unknown |  |
| cr | Unknown |  |
| creative | Unknown |  |
| creative_created_at | Unknown |  |
| creative_height | Unknown |  |
| creative_labels | Unknown |  |
| creative_name | Unknown |  |
| creative_offers_number | Unknown |  |
| creative_status | Unknown |  |
| creative_type | Unknown |  |
| creative_updated_at | Unknown |  |
| creative_width | Unknown |  |
| ctr | Unknown |  |
| day | Unknown |  |
| device_type | Unknown |  |
| imps_count | Unknown |  |
| month | Unknown |  |
| quarter | Unknown |  |
| subcampaign | Unknown |  |
| subcampaign_hash | Unknown |  |
| user_segment | Unknown |  |
| week | Unknown |  |
| year | Unknown |  |

## Relationships

- win_rate_stat(advertiser_data_id) → advertiser_data(id)
- rtb_summary_stat_post_view(advertiser_data_id) → advertiser_data(id)
- rtb_summary_stat_all_post(advertiser_data_id) → advertiser_data(id)
- rtb_stat_all_post(advertiser_data_id) → advertiser_data(id)
- billing(advertiser_data_id) → advertiser_data(id)
- offer(advertiser_data_id) → advertiser_data(id)
- rtb_stat_branding(advertiser_data_id) → advertiser_data(id)
- conversion_all_post_click(advertiser_data_id) → advertiser_data(id)
- rtb_stat_attributed(advertiser_data_id) → advertiser_data(id)
- advertisers_with_hash_contact_person(advertisers_detail_id) → advertisers_detail(id)
- advertisers_detail(id) → advertiser_data(id)
- client(advertiser_data_id) → advertiser_data(id)
- advertisers_rtb(advertiser_data_id) → advertiser_data(id)
- top_in_apps_stat_click(advertiser_data_id) → advertiser_data(id)
- rtb_summary_stat_branding(advertiser_data_id) → advertiser_data(id)
- conversion_attributed(advertiser_data_id) → advertiser_data(id)
- creatives_preview(advertiser_data_id) → advertiser_data(id)
- creatives_preview(rtb_creative_id) → rtb_creative(id)
- rtb_creative(advertiser_data_id) → advertiser_data(id)
- rate_card(advertiser_data_id) → advertiser_data(id)
- rtb_stat_post_view(advertiser_data_id) → advertiser_data(id)
- last_seen_tags_stat(advertiser_data_id) → advertiser_data(id)
- top_hosts_stat_click(advertiser_data_id) → advertiser_data(id)
- top_in_apps_stat_imps(advertiser_data_id) → advertiser_data(id)
- conversion_post_view(advertiser_data_id) → advertiser_data(id)
- campaign(rate_card_id) → rate_card(id)
- campaign(advertiser_data_id) → advertiser_data(id)
- conversion_all(advertiser_data_id) → advertiser_data(id)
- top_hosts_stat_imps(advertiser_data_id) → advertiser_data(id)
- offer_category(advertiser_data_id) → advertiser_data(id)
- rtb_stat_all_conversions(advertiser_data_id) → advertiser_data(id)