Fivetran documentation

Search the docs

/

Criteo Retail Media

Explore the interactive ERD

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	PKFK
`line_item_id`	Unknown	PKFK
`rank`	Unknown

keyword_negative_broad

Column	Type	Keys
`index`	Unknown	PK
`keyword_id`	Unknown	PKFK
`line_item_id`	Unknown	PKFK
`negative_broad`	Unknown

keyword_negative_exact

Column	Type	Keys
`index`	Unknown	PK
`keyword_id`	Unknown	PKFK
`line_item_id`	Unknown	PKFK
`negative_exact`	Unknown

keyword_positive_exact

Column	Type	Keys
`index`	Unknown	PK
`keyword_id`	Unknown	PKFK
`line_item_id`	Unknown	PKFK
`positive_exact`	Unknown

keyword

Column	Type	Keys
`id`	Unknown	PK
`line_item_id`	Unknown	PKFK
`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	PKFK
`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	PKFK
`retailer_id`	Unknown	PKFK
`buy_type`	Unknown
`campaign_type`	Unknown
`is_available`	Unknown
`valid_combinations`	Json

retailer_v_2026

Column	Type	Keys
`id`	Unknown	PK
`account_id`	Unknown	PKFK
`attribute_name`	Unknown
`type`	Unknown

campaign_promote_brand

Column	Type	Keys
`index`	Unknown	PK
`campaign_id`	Unknown	PKFK
`promoted_brand_id`	Unknown

campaign_drawable_balance

Column	Type	Keys
`index`	Unknown	PK
`campaign_id`	Unknown	PKFK
`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	PKFK
`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