# Taboola schema ERD

Table and field reference for the Fivetran Taboola connector.

## Table & Field Reference

### campaign

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| account_id | Long | PK, FK |
| approval_state | String |  |
| bid_strategy | String |  |
| branding_text | String |  |
| campaign_item_type | String |  |
| campaign_profile | String |  |
| cpa_goal | Double |  |
| cpc | Double |  |
| daily_ad_delivery_model | String |  |
| daily_cap | Double |  |
| end_date | LocalDate |  |
| end_date_in_utc | String |  |
| is_active | Boolean |  |
| is_spend_guard_active | String |  |
| learning_state | String |  |
| marketing_objective | String |  |
| min_expected_conversions_for_cpa_goal | String |  |
| name | String |  |
| pricing_model | String |  |
| roas_goal | Double |  |
| safety_rating | String |  |
| spending_limit | Double |  |
| spending_limit_model | String |  |
| spent | Double |  |
| start_date | LocalDate |  |
| start_date_in_utc | String |  |
| status | String |  |
| target_cpa | Double |  |
| tracking_code | String |  |
| traffic_allocation_ab_test_end_date | LocalDate |  |
| traffic_allocation_mode | String |  |
| type | String |  |

### content_provider_platform_report

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| account_id | Long | FK |
| content_provider_id | Long | FK |
| campaigns_num | Int |  |
| clicks | Int |  |
| content_provider | String |  |
| content_provider_name | String |  |
| conversions_value | Double |  |
| cpa | Double |  |
| cpa_actions_num | Int |  |
| cpa_actions_num_from_clicks | Int |  |
| cpa_actions_num_from_views | Int |  |
| cpa_clicks | Double |  |
| cpa_conversion_rate | Double |  |
| cpa_conversion_rate_clicks | Double |  |
| cpa_conversion_rate_views | Double |  |
| cpa_views | Double |  |
| cpc | Double |  |
| cpm | Double |  |
| ctr | Double |  |
| currency | String |  |
| date | LocalDate |  |
| impressions | Long |  |
| platform | String |  |
| roas | Double |  |
| spent | Double |  |
| timezone | String |  |
| vcpm | Double |  |
| vctr | Double |  |
| visible_impressions | Int |  |

### targeting_sub_country

| Column | Type | Keys |
| --- | --- | --- |
| index | Int | PK |
| campaign_id | Long | PK, FK |
| type | String |  |
| value | String |  |

### group

| Column | Type | Keys |
| --- | --- | --- |
| index | Int | PK |
| account_id | Long | PK, FK |
| id | String |  |

### platform_report

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| campaign_id | Long | FK |
| clicks | Int |  |
| conversions_value | Double |  |
| cpa | Double |  |
| cpa_actions_num | Int |  |
| cpa_actions_num_from_clicks | Int |  |
| cpa_actions_num_from_views | Int |  |
| cpa_clicks | Double |  |
| cpa_conversion_rate | Double |  |
| cpa_conversion_rate_clicks | Double |  |
| cpa_conversion_rate_views | Double |  |
| cpa_views | Double |  |
| cpc | Double |  |
| cpm | Double |  |
| ctr | Double |  |
| currency | String |  |
| date | LocalDate |  |
| impressions | Long |  |
| platform | String |  |
| platform_name | String |  |
| roas | Double |  |
| spent | Double |  |
| timezone | String |  |
| vcpm | Double |  |
| vctr | Double |  |
| visible_impressions | Int |  |

### targeting_platform

| Column | Type | Keys |
| --- | --- | --- |
| index | Int | PK |
| campaign_id | Long | PK, FK |
| type | String |  |
| value | String |  |

### targeting_publisher

| Column | Type | Keys |
| --- | --- | --- |
| index | Int | PK |
| campaign_id | Long | PK, FK |
| type | String |  |
| value | String |  |

### top_campaign_content_report

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| campaign_id | Long | FK |
| item | Long | FK |
| actions | Double |  |
| actions_num_from_clicks | Int |  |
| actions_num_from_views | Int |  |
| clicks | Int |  |
| conversions_value | Double |  |
| cpa | Double |  |
| cpa_clicks | Double |  |
| cpa_views | Double |  |
| cpc | Double |  |
| cpm | Double |  |
| create_time | LocalDateTime |  |
| ctr | Double |  |
| currency | String |  |
| cvr | Double |  |
| cvr_clicks | Double |  |
| cvr_views | Double |  |
| date | LocalDate |  |
| description | String |  |
| impressions | Long |  |
| item_name | String |  |
| learning_display_status | String |  |
| old_item_version_id | String |  |
| roas | Double |  |
| spent | Double |  |
| thumbnail_url | String |  |
| timezone | String |  |
| url | String |  |
| vcpm | Double |  |
| vctr | Double |  |
| visible_impressions | Int |  |

### publisher_bid_modifier

| Column | Type | Keys |
| --- | --- | --- |
| index | Int | PK |
| campaign_id | Long | PK, FK |
| cpc_modification | Double |  |
| target | String |  |

### targeting_os

| Column | Type | Keys |
| --- | --- | --- |
| index | Int | PK |
| campaign_id | Long | PK, FK |
| os_family | String |  |
| sub_categories | String |  |
| type | String |  |

### targeting_contextual

| Column | Type | Keys |
| --- | --- | --- |
| index | Int | PK |
| campaign_id | Long | PK, FK |
| type | String |  |
| value | String |  |

### campaign_item

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| campaign_id | Long | FK |
| approval_state | String |  |
| cta_type | String |  |
| is_active | Boolean |  |
| status | String |  |
| thumbnail_url | String |  |
| title | String |  |
| type | String |  |
| url | String |  |

### campaign_site_day_report

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| campaign_id | Long | FK |
| blocking_level | String |  |
| campaign_name | String |  |
| clicks | Int |  |
| conversions_value | Double |  |
| cpa | Double |  |
| cpa_actions_num | Int |  |
| cpa_actions_num_from_clicks | Int |  |
| cpa_actions_num_from_views | Int |  |
| cpa_clicks | Double |  |
| cpa_conversion_rate | Double |  |
| cpa_conversion_rate_clicks | Double |  |
| cpa_conversion_rate_views | Double |  |
| cpa_views | Double |  |
| cpc | Double |  |
| cpm | Double |  |
| ctr | Double |  |
| currency | String |  |
| date_time | Instant |  |
| impressions | Long |  |
| roas | Double |  |
| site | String |  |
| site_name | String |  |
| spent | Double |  |
| timezone | String |  |
| vcpm | Double |  |
| vctr | Double |  |
| visible_impressions | Int |  |

### country_report

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| campaign_id | Long | FK |
| clicks | Int |  |
| conversions_value | Double |  |
| country | String |  |
| country_name | String |  |
| cpa | Double |  |
| cpa_actions_num | Int |  |
| cpa_actions_num_from_clicks | Int |  |
| cpa_actions_num_from_views | Int |  |
| cpa_clicks | Double |  |
| cpa_conversion_rate | Double |  |
| cpa_conversion_rate_clicks | Double |  |
| cpa_conversion_rate_views | Double |  |
| cpa_views | Double |  |
| cpc | Double |  |
| cpm | Double |  |
| ctr | Double |  |
| currency | String |  |
| date | LocalDate |  |
| impressions | Long |  |
| roas | Double |  |
| spent | Double |  |
| timezone | String |  |
| vcpm | Double |  |
| vctr | Double |  |
| visible_impressions | Int |  |

### campaign_type

| Column | Type | Keys |
| --- | --- | --- |
| index | Int | PK |
| account_id | Long | PK, FK |
| type | String |  |

### account

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| account_id | String |  |
| country | String |  |
| currency | String |  |
| default_platform | String |  |
| is_active | Boolean |  |
| language | String |  |
| name | String |  |
| parent_network | String |  |
| timezone | String |  |
| type | String |  |

### comment

| Column | Type | Keys |
| --- | --- | --- |
| campaign_id | Long | PK |
| index | Int | PK |
| account_id | Long | PK, FK |
| comment | String |  |

### contained_account

| Column | Type | Keys |
| --- | --- | --- |
| index | Int | PK |
| account_id | Long | PK, FK |
| id | String |  |

### targeting_postal_code

| Column | Type | Keys |
| --- | --- | --- |
| index | Int | PK |
| campaign_id | Long | PK, FK |
| type | String |  |
| value | String |  |

### partner_type

| Column | Type | Keys |
| --- | --- | --- |
| index | Int | PK |
| account_id | Long | PK, FK |
| type | String |  |

### content_provider_country_report

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| account_id | Long | FK |
| content_provider_id | Long | FK |
| campaigns_num | Int |  |
| clicks | Int |  |
| content_provider | String |  |
| content_provider_name | String |  |
| conversions_value | Double |  |
| country_name | String |  |
| country_value | String |  |
| cpa | Double |  |
| cpa_actions_num | Int |  |
| cpa_actions_num_from_clicks | Int |  |
| cpa_actions_num_from_views | Int |  |
| cpa_clicks | Double |  |
| cpa_conversion_rate | Double |  |
| cpa_conversion_rate_clicks | Double |  |
| cpa_conversion_rate_views | Double |  |
| cpa_views | Double |  |
| cpc | Double |  |
| cpm | Double |  |
| ctr | Double |  |
| currency | String |  |
| date | LocalDate |  |
| impressions | Long |  |
| roas | Double |  |
| spent | Double |  |
| timezone | String |  |
| vcpm | Double |  |
| vctr | Double |  |
| visible_impressions | Int |  |

### targeting_country

| Column | Type | Keys |
| --- | --- | --- |
| index | Int | PK |
| campaign_id | Long | PK, FK |
| type | String |  |
| value | String |  |

### targeting_audience_segment

| Column | Type | Keys |
| --- | --- | --- |
| index | Int | PK |
| campaign_id | Long | PK, FK |
| state | String |  |
| value | String |  |

## Relationships

- campaign(account_id) → account(id)
- content_provider_platform_report(account_id) → account(id)
- content_provider_platform_report(content_provider_id) → account(id)
- targeting_sub_country(campaign_id) → campaign(id)
- group(account_id) → account(id)
- platform_report(campaign_id) → campaign(id)
- targeting_platform(campaign_id) → campaign(id)
- targeting_publisher(campaign_id) → campaign(id)
- top_campaign_content_report(item) → campaign_item(id)
- top_campaign_content_report(campaign_id) → campaign(id)
- publisher_bid_modifier(campaign_id) → campaign(id)
- targeting_os(campaign_id) → campaign(id)
- targeting_contextual(campaign_id) → campaign(id)
- campaign_item(campaign_id) → campaign(id)
- campaign_site_day_report(campaign_id) → campaign(id)
- country_report(campaign_id) → campaign(id)
- campaign_type(account_id) → account(id)
- comment(account_id) → account(id)
- contained_account(account_id) → account(id)
- targeting_postal_code(campaign_id) → campaign(id)
- partner_type(account_id) → account(id)
- content_provider_country_report(account_id) → account(id)
- content_provider_country_report(content_provider_id) → account(id)
- targeting_country(campaign_id) → campaign(id)
- targeting_audience_segment(campaign_id) → campaign(id)