Outbrain

Explore the interactive ERD

Column	Type	Keys
`day`	LocalDate	PK
`campaign_id`	String	PKFK
`section_id`	String	PKFK
`average_value`	Float
`clicks`	Int
`clicks_on_video`	Int
`conversion_rate`	Float
`conversions`	Int
`cpa`	Float
`cpm`	Float
`ctr`	Float
`ecpc`	Float
`impressions`	Int
`roas`	Float
`spend`	Float
`sum_value`	Float
`total_average_value`	Float
`total_conversions`	Int
`total_cpa`	Float
`total_roas`	Float
`total_sum_value`	Float
`video_active_completions`	Int
`video_active_completions_percentage`	Float
`video_avg_view_duration`	Float
`video_plays`	Int
`video_reached_completion`	Int
`video_reached_first_q`	Int
`video_reached_second_q`	Int
`video_reached_third_q`	Int
`view_average_value`	Float
`view_conversion_rate`	Float
`view_sum_value`	Float
`views_conversions`	Int

Column	Type	Keys
`id`	String	PK
`last_modified`	Instant	PK
`budget_id`	String	FK
`budget_last_modified`	Instant	FK
`marketer_id`	String	FK
`marketer_last_modified`	Instant	FK
`auto_archived`	Boolean
`auto_expiration_of_ads`	Int
`campaign_on_air`	Boolean
`content_type`	String
`cpc`	Float
`cpc_per_ad_enabled`	Boolean
`creation_time`	Instant
`enabled`	Boolean
`minimum_cpc`	Float
`name`	String
`on_air_reason`	String
`prefix_tracking_code`	String
`prefix_tracking_code_encode`	Boolean
`readonly`	Boolean
`start_hour`	Int
`targets_android`	Boolean
`targets_chrome`	Boolean
`targets_desktop`	Boolean
`targets_exclude_ad_block_users`	Boolean
`targets_firefox`	Boolean
`targets_in_app`	Boolean
`targets_include_cellular_network`	Boolean
`targets_internet_explorer`	Boolean
`targets_ios`	Boolean
`targets_mac_os`	Boolean
`targets_mobile`	Boolean
`targets_native_placements_enabled`	Boolean
`targets_opera`	Boolean
`targets_other_browser`	Boolean
`targets_other_os`	Boolean
`targets_safari`	Boolean
`targets_samsung`	Boolean
`targets_tablet`	Boolean
`targets_uc_browser`	Boolean
`targets_windows`	Boolean

Column	Type	Keys
`day`	LocalDate	PK
`promoted_link_id`	String	PKFK
`average_value`	Float
`clicks`	Int
`clicks_on_video`	Int
`conversion_rate`	Float
`conversions`	Int
`cpa`	Float
`cpm`	Float
`ctr`	Float
`ecpc`	Float
`impressions`	Int
`roas`	Float
`spend`	Float
`sum_value`	Float
`total_average_value`	Float
`total_conversions`	Int
`total_cpa`	Float
`total_roas`	Float
`total_sum_value`	Float
`video_active_completions`	Int
`video_active_completions_percentage`	Float
`video_avg_view_duration`	Float
`video_plays`	Int
`video_reached_completion`	Int
`video_reached_first_q`	Int
`video_reached_second_q`	Int
`video_reached_third_q`	Int
`view_average_value`	Float
`view_conversion_rate`	Float
`view_sum_value`	Float
`views_conversions`	Int

Column	Type	Keys
`day`	LocalDate	PK
`geolocation_id`	String	PKFK
`average_value`	Float
`clicks`	Int
`clicks_on_video`	Int
`conversion_rate`	Float
`conversions`	Int
`cpa`	Float
`cpm`	Float
`ctr`	Float
`ecpc`	Float
`impressions`	Int
`roas`	Float
`spend`	Float
`sum_value`	Float
`total_average_value`	Float
`total_conversions`	Int
`total_cpa`	Float
`total_roas`	Float
`total_sum_value`	Float
`video_active_completions`	Int
`video_active_completions_percentage`	Float
`video_avg_view_duration`	Float
`video_plays`	Int
`video_reached_completion`	Int
`video_reached_first_q`	Int
`video_reached_second_q`	Int
`video_reached_third_q`	Int
`view_average_value`	Float
`view_conversion_rate`	Float
`view_sum_value`	Float
`views_conversions`	Int

Column	Type	Keys
`day`	LocalDate	PK
`campaign_id`	String	PKFK
`publisher_id`	String	PKFK
`average_value`	Float
`clicks`	Int
`clicks_on_video`	Int
`conversion_rate`	Float
`conversions`	Int
`cpa`	Float
`cpm`	Float
`ctr`	Float
`ecpc`	Float
`impressions`	Int
`roas`	Float
`spend`	Float
`sum_value`	Float
`total_average_value`	Float
`total_conversions`	Int
`total_cpa`	Float
`total_roas`	Float
`total_sum_value`	Float
`video_active_completions`	Int
`video_active_completions_percentage`	Float
`video_avg_view_duration`	Float
`video_plays`	Int
`video_reached_completion`	Int
`video_reached_first_q`	Int
`video_reached_second_q`	Int
`video_reached_third_q`	Int
`view_average_value`	Float
`view_conversion_rate`	Float
`view_sum_value`	Float
`views_conversions`	Int

Column	Type	Keys
`day`	LocalDate	PK
`platform`	String	PK
`campaign_id`	String	PKFK
`average_value`	Float
`clicks`	Int
`clicks_on_video`	Int
`conversion_rate`	Float
`conversions`	Int
`cpa`	Float
`cpm`	Float
`ctr`	Float
`ecpc`	Float
`impressions`	Int
`roas`	Float
`spend`	Float
`sum_value`	Float
`total_average_value`	Float
`total_conversions`	Int
`total_cpa`	Float
`total_roas`	Float
`total_sum_value`	Float
`video_active_completions`	Int
`video_active_completions_percentage`	Float
`video_avg_view_duration`	Float
`video_plays`	Int
`video_reached_completion`	Int
`video_reached_first_q`	Int
`video_reached_second_q`	Int
`video_reached_third_q`	Int
`view_average_value`	Float
`view_conversion_rate`	Float
`view_sum_value`	Float
`views_conversions`	Int