# Outbrain schema ERD

Table and field reference for the Fivetran Outbrain connector.

## Table & Field Reference

### section_report

| Column | Type | Keys |
| --- | --- | --- |
| day | LocalDate | PK |
| campaign_id | String | PK, FK |
| section_id | String | PK, FK |
| 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 |  |

### geolocation

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| code | String |  |
| geo_type | String |  |
| name | String |  |

### campaign_history

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

### interest

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| can_be_targeted | Boolean |  |
| name | String |  |
| reach_estimation_count | Int |  |

### bid_cpc_by_section_history

| Column | Type | Keys |
| --- | --- | --- |
| last_modified | Instant | PK |
| campaign_id | String | PK, FK |
| campaign_last_modified | Instant | PK, FK |
| section_id | String | PK, FK |
| cpc_adjustment | Float |  |
| creation_time | Instant |  |

### promoted_link_history

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| last_modified | Instant | PK |
| campaign_id | String | FK |
| campaign_last_modified | Instant | FK |
| image_meta_data_id | String | FK |
| approval_status | String |  |
| approval_status_is_editable | Boolean |  |
| archived | Boolean |  |
| base_url | String |  |
| cached_image_url | String |  |
| call_to_action_type | String |  |
| call_to_action_value | String |  |
| cpc_adjustment | Float |  |
| creation_time | Instant |  |
| creative_format | String |  |
| description | String |  |
| document_id | String |  |
| document_language | String |  |
| enabled | Boolean |  |
| section_name | String |  |
| site_name | String |  |
| status_reason | String |  |
| text | String |  |
| title | String |  |
| url | String |  |

### publisher

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| name | String |  |
| url | String |  |

### conversion_tracking_history

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| last_modified | Instant | PK |
| marketer_id | String | FK |
| marketer_last_modified | Instant | FK |
| conversion_window | Int |  |
| creation_time | Instant |  |
| enabled | Boolean |  |
| include_in_conversions | Boolean |  |
| name | String |  |
| order_currency | String |  |
| order_value | Float |  |
| tracking_status | String |  |
| type | String |  |
| url | String |  |

### marketer_history

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| last_modified | Instant | PK |
| creation_time | Instant |  |
| enabled | Boolean |  |
| name | String |  |

### promoted_link_report

| Column | Type | Keys |
| --- | --- | --- |
| day | LocalDate | PK |
| promoted_link_id | String | PK, FK |
| 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 |  |

### image_metadata

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| original_image_url | String |  |
| play_mode | String |  |
| requested_image_url | String |  |
| stream | String |  |
| thumbnail_url | String |  |
| type | String |  |

### section

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| publisher_id | String | FK |
| name | String |  |
| url | String |  |

### budget_history

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| last_modified | Instant | PK |
| marketer_id | String | FK |
| marketer_last_modified | Instant | FK |
| amount | Float |  |
| amount_remaining | Float |  |
| amount_spent | Float |  |
| creation_time | Instant |  |
| currency | String |  |
| daily_target | Float |  |
| end_date | LocalDate |  |
| maximum_amount | Float |  |
| name | String |  |
| pacing | String |  |
| run_forever | Boolean |  |
| start_date | LocalDate |  |
| type | String |  |

### targeting_interest

| Column | Type | Keys |
| --- | --- | --- |
| campaign_id | String | PK, FK |
| campaign_last_modified | Instant | PK, FK |
| interest_id | String | PK, FK |
| match_op | String |  |

### crop_point

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| image_metadata_id | String | FK |
| h | Int |  |
| ratio | String |  |
| w | Int |  |
| x | Int |  |
| y | Int |  |

### geolocation_report

| Column | Type | Keys |
| --- | --- | --- |
| day | LocalDate | PK |
| geolocation_id | String | PK, FK |
| 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 |  |

### publisher_report

| Column | Type | Keys |
| --- | --- | --- |
| day | LocalDate | PK |
| campaign_id | String | PK, FK |
| publisher_id | String | PK, FK |
| 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 |  |

### segment_history

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| last_modified | Instant | PK |
| marketer_id | String | FK |
| marketer_last_modified | Instant | FK |
| archived | Boolean |  |
| availability_status | String |  |
| creation_time | Instant |  |
| description | String |  |
| enabled | Boolean |  |
| inactive_reason | String |  |
| membership_duration | Int |  |
| name | String |  |
| segment_type | String |  |
| size | Int |  |
| tracking_status | String |  |

### targeting_location

| Column | Type | Keys |
| --- | --- | --- |
| campaign_id | String | PK, FK |
| campaign_last_modified | Instant | PK, FK |
| geolocation_id | String | PK, FK |

### campaign_segment

| Column | Type | Keys |
| --- | --- | --- |
| campaign_id | String | PK, FK |
| campaign_last_modified | Instant | PK, FK |
| segment_id | String | PK, FK |
| status | String |  |

### campaign_conversion_report

| Column | Type | Keys |
| --- | --- | --- |
| day | LocalDate | PK |
| name | String | PK |
| platform | String | PK |
| campaign_id | String | PK, FK |
| average_value | Float |  |
| conversion_rate | Float |  |
| conversions | Float |  |
| cpa | Float |  |
| roas | Float |  |
| sum_value | Float |  |
| total_average_value | Float |  |
| total_conversions | Float |  |
| total_cpa | Float |  |
| total_roas | Float |  |
| total_sum_value | Float |  |
| view_average_value | Float |  |
| view_conversion_rate | Float |  |
| view_conversions | Float |  |
| view_sum_value | Float |  |

### campaign_report

| Column | Type | Keys |
| --- | --- | --- |
| day | LocalDate | PK |
| platform | String | PK |
| campaign_id | String | PK, FK |
| 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 |  |

### suffix_tracking_code_history

| Column | Type | Keys |
| --- | --- | --- |
| key | String | PK |
| campaign_id | String | PK, FK |
| campaign_last_modified | Instant | PK, FK |
| value | String |  |

## Relationships

- section_report(section_id) → section(id)
- section_report(campaign_id) → campaign_history(id)
- campaign_history(marketer_id) → marketer_history(id)
- campaign_history(marketer_last_modified) → marketer_history(id)
- campaign_history(budget_id) → budget_history(id)
- campaign_history(budget_last_modified) → budget_history(id)
- bid_cpc_by_section_history(section_id) → section(id)
- bid_cpc_by_section_history(campaign_id) → campaign_history(id)
- bid_cpc_by_section_history(campaign_last_modified) → campaign_history(id)
- promoted_link_history(campaign_id) → campaign_history(id)
- promoted_link_history(campaign_last_modified) → campaign_history(id)
- promoted_link_history(image_meta_data_id) → image_metadata(id)
- conversion_tracking_history(marketer_id) → marketer_history(id)
- conversion_tracking_history(marketer_last_modified) → marketer_history(id)
- promoted_link_report(promoted_link_id) → promoted_link_history(id)
- section(publisher_id) → publisher(id)
- budget_history(marketer_id) → marketer_history(id)
- budget_history(marketer_last_modified) → marketer_history(id)
- targeting_interest(interest_id) → interest(id)
- targeting_interest(campaign_id) → campaign_history(id)
- targeting_interest(campaign_last_modified) → campaign_history(id)
- crop_point(image_metadata_id) → image_metadata(id)
- geolocation_report(geolocation_id) → geolocation(id)
- publisher_report(campaign_id) → campaign_history(id)
- publisher_report(publisher_id) → publisher(id)
- segment_history(marketer_id) → marketer_history(id)
- segment_history(marketer_last_modified) → marketer_history(id)
- targeting_location(geolocation_id) → geolocation(id)
- targeting_location(campaign_id) → campaign_history(id)
- targeting_location(campaign_last_modified) → campaign_history(id)
- campaign_segment(segment_id) → segment_history(id)
- campaign_segment(campaign_id) → campaign_history(id)
- campaign_segment(campaign_last_modified) → campaign_history(id)
- campaign_conversion_report(campaign_id) → campaign_history(id)
- campaign_report(campaign_id) → campaign_history(id)
- suffix_tracking_code_history(campaign_last_modified) → campaign_history(id)
- suffix_tracking_code_history(campaign_id) → campaign_history(id)