# Criteo Retail Media schema ERD

Table and field reference for the Fivetran Criteo Retail Media connector.

## Table & Field Reference

### line_item

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| account_id | Unknown | FK |
| attribute_budget | Unknown |  |
| attribute_budget_remaining | Unknown |  |
| attribute_budget_spent | Unknown |  |
| attribute_campaign_id | Unknown |  |
| attribute_created_at | Unknown |  |
| attribute_end_date | Unknown |  |
| attribute_name | Unknown |  |
| attribute_start_date | Unknown |  |
| attribute_status | Unknown |  |
| attribute_target_retailer_id | Unknown |  |
| attribute_type | Unknown |  |
| attribute_updated_at | Unknown |  |
| type | Unknown |  |

### balance

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| account_id | Unknown | FK |
| attribute_balance_type | Unknown |  |
| attribute_created_at | Unknown |  |
| attribute_deposited | Unknown |  |
| attribute_end_date | Unknown |  |
| attribute_memo | Unknown |  |
| attribute_name | Unknown |  |
| attribute_po_number | Unknown |  |
| attribute_private_market_billing_type | Unknown |  |
| attribute_remaining | Unknown |  |
| attribute_sales_force_id | Unknown |  |
| attribute_spend_type | Unknown |  |
| attribute_spent | Unknown |  |
| attribute_start_date | Unknown |  |
| attribute_status | Unknown |  |
| attribute_updated_at | Unknown |  |
| type | Unknown |  |

### keyword_rank

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| keyword_id | Unknown | PK, FK |
| line_item_id | Unknown | PK, FK |
| rank | Unknown |  |

### keyword_negative_broad

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| keyword_id | Unknown | PK, FK |
| line_item_id | Unknown | PK, FK |
| negative_broad | Unknown |  |

### keyword_negative_exact

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| keyword_id | Unknown | PK, FK |
| line_item_id | Unknown | PK, FK |
| negative_exact | Unknown |  |

### keyword_positive_exact

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| keyword_id | Unknown | PK, FK |
| line_item_id | Unknown | PK, FK |
| positive_exact | Unknown |  |

### keyword

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| line_item_id | Unknown | PK, FK |
| keyword_bid | Unknown |  |
| keyword_created_at | Unknown |  |
| keyword_match_type | Unknown |  |
| keyword_review_state | Unknown |  |
| keyword_updated_at | Unknown |  |
| type | Unknown |  |

### brand

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| account_id | Unknown | FK |
| attribute_name | Unknown |  |
| type | Unknown |  |

### retailer_campaign_eligibility

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| retailer_id | Unknown | PK, FK |
| campaign_eligibility | Unknown |  |

### retailer

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| account_id | Unknown | FK |
| attribute_name | Unknown |  |
| type | Unknown |  |

### balance_campaign

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| balance_id | Unknown | FK |
| type | Unknown |  |

### retailer_v_2026_campaign_availability

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| account_id | Unknown | PK, FK |
| retailer_id | Unknown | PK, FK |
| buy_type | Unknown |  |
| campaign_type | Unknown |  |
| is_available | Unknown |  |
| valid_combinations | Json |  |

### retailer_v_2026

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| account_id | Unknown | PK, FK |
| attribute_name | Unknown |  |
| type | Unknown |  |

### campaign_promote_brand

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| campaign_id | Unknown | PK, FK |
| promoted_brand_id | Unknown |  |

### campaign_drawable_balance

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| campaign_id | Unknown | PK, FK |
| drawable_balance_id | Unknown |  |

### campaign

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| attribute_account_id | Unknown | FK |
| attribute_budget | Unknown |  |
| attribute_budget_remaining | Unknown |  |
| attribute_budget_spent | Unknown |  |
| attribute_click_attribution_scope | Unknown |  |
| attribute_click_attribution_window | Unknown |  |
| attribute_company_name | Unknown |  |
| attribute_created_at | Unknown |  |
| attribute_daily_pacing | Unknown |  |
| attribute_end_date | Unknown |  |
| attribute_is_auto_daily_pacing | Unknown |  |
| attribute_monthly_pacing | Unknown |  |
| attribute_name | Unknown |  |
| attribute_retailer_id | Unknown |  |
| attribute_start_date | Unknown |  |
| attribute_status | Unknown |  |
| attribute_type | Unknown |  |
| attribute_updated_at | Unknown |  |
| attribute_view_attribution_scope | Unknown |  |
| attribute_view_attribution_window | Unknown |  |
| type | Unknown |  |

### target_keyword

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| line_item_id | Unknown | FK |
| keyword_additional_prop | Unknown |  |
| type | Unknown |  |

### account_country

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| account_id | Unknown | PK, FK |
| country | Unknown |  |

### account

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| attribute_company_name | Unknown |  |
| attribute_currency | Unknown |  |
| attribute_name | Unknown |  |
| attribute_parent_account_label | Unknown |  |
| attribute_subtype | Unknown |  |
| attribute_time_zone | Unknown |  |
| attribute_type | Unknown |  |
| type | Unknown |  |

### report_campaign

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| brand_id | Unknown | FK |
| id | Unknown | FK |
| retailer_id | Unknown | FK |
| adv_product_category | Unknown |  |
| adv_product_id | Unknown |  |
| adv_product_name | Unknown |  |
| assisted_sale | Unknown |  |
| assisted_unit | Unknown |  |
| attributed_order | Unknown |  |
| attributed_sale | Unknown |  |
| attributed_unit | Unknown |  |
| campaign_type_name | Unknown |  |
| clicks | Unknown |  |
| cpc | Unknown |  |
| cpm | Unknown |  |
| cpo | Unknown |  |
| ctr | Unknown |  |
| date | Unknown |  |
| environment | Unknown |  |
| frequency | Unknown |  |
| impressions | Unknown |  |
| keyword | Unknown |  |
| page_type_name | Unknown |  |
| roas | Unknown |  |
| sales_channel | Unknown |  |
| spend | Unknown |  |
| unique_visitor | Unknown |  |

### report_line_item

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| brand_id | Unknown | FK |
| id | Unknown | FK |
| line_item_id | Unknown | FK |
| retailer_id | Unknown | FK |
| adv_product_category | Unknown |  |
| adv_product_id | Unknown |  |
| adv_product_name | Unknown |  |
| assisted_sale | Unknown |  |
| assisted_unit | Unknown |  |
| attributed_order | Unknown |  |
| attributed_sale | Unknown |  |
| attributed_unit | Unknown |  |
| campaign_type_name | Unknown |  |
| clicks | Unknown |  |
| cpc | Unknown |  |
| cpm | Unknown |  |
| cpo | Unknown |  |
| ctr | Unknown |  |
| date | Unknown |  |
| environment | Unknown |  |
| frequency | Unknown |  |
| impressions | Unknown |  |
| keyword | Unknown |  |
| page_type_name | Unknown |  |
| roas | Unknown |  |
| sales_channel | Unknown |  |
| spend | Unknown |  |
| unique_visitor | Unknown |  |

## Relationships

- line_item(account_id) → account(id)
- balance(account_id) → account(id)
- keyword_rank(keyword_id) → keyword(id)
- keyword_rank(line_item_id) → keyword(line_item_id)
- keyword_negative_broad(keyword_id) → keyword(id)
- keyword_negative_broad(line_item_id) → keyword(line_item_id)
- keyword_negative_exact(keyword_id) → keyword(id)
- keyword_negative_exact(line_item_id) → keyword(line_item_id)
- keyword_positive_exact(keyword_id) → keyword(id)
- keyword_positive_exact(line_item_id) → keyword(line_item_id)
- keyword(line_item_id) → line_item(id)
- brand(account_id) → account(id)
- retailer_campaign_eligibility(retailer_id) → retailer(id)
- retailer(account_id) → account(id)
- balance_campaign(balance_id) → balance(id)
- retailer_v_2026_campaign_availability(retailer_id) → retailer_v_2026(id)
- retailer_v_2026_campaign_availability(account_id) → retailer_v_2026(account_id)
- retailer_v_2026(account_id) → account(id)
- campaign_promote_brand(campaign_id) → campaign(id)
- campaign_drawable_balance(campaign_id) → campaign(id)
- campaign(attribute_account_id) → account(id)
- target_keyword(line_item_id) → line_item(id)
- account_country(account_id) → account(id)
- report_campaign(retailer_id) → retailer(id)
- report_campaign(id) → campaign(id)
- report_campaign(brand_id) → brand(id)
- report_line_item(retailer_id) → retailer(id)
- report_line_item(id) → campaign(id)
- report_line_item(brand_id) → brand(id)
- report_line_item(line_item_id) → line_item(id)