RTB House

Explore the interactive ERD

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