Criteo

Explore the interactive ERD

Table & Field Reference

call_to_action

Column	Type	Keys
`_fivetran_id`	String	PK
`creative_id`	Long	FK
`text`	String
`type`	String

html_tag

Column	Type	Keys
`_fivetran_id`	String	PK
`creative_id`	Long	FK
`height`	Int
`html_tag`	String
`width`	Int

audience

Column	Type	Keys
`id`	Long	PK
`advertiser_id`	Long	FK
`created_at`	Instant
`description`	String
`name`	String
`updated_at`	Instant

image

Column	Type	Keys
`_fivetran_id`	String	PK
`image_set_id`	String	FK
`shape`	String
`url`	String

image_url

Column	Type	Keys
`_fivetran_id`	String	PK
`creative_id`	Long	FK
`url`	String

adset_statistics_hourly_report

Column	Type	Keys
`_fivetran_id`	String	PK
`adset_id`	Long	FK
`advertiser_id`	Long	FK
`adset_name`	String
`advertiser_all_value`	Double
`advertiser_cost`	Double
`advertiser_value`	Double
`app_installs`	Int
`audience`	Double
`average_cart_all_client_attribution`	Double
`average_cart_all_pc_1_d`	Double
`average_cart_all_pc_30_d`	Double
`average_cart_all_pc_30_d_pv_24_h`	Double
`average_cart_all_pc_7_d`	Double
`average_cart_all_pv_24_h`	Double
`average_cart_client_attribution`	Double
`average_cart_pc_1_d`	Double
`average_cart_pc_30_d`	Double
`average_cart_pc_30_d_pv_24_h`	Double
`average_cart_pc_7_d`	Double
`average_cart_pv_24_h`	Double
`bounce_rate`	Double
`category_id`	Long
`category_name`	String
`click_through_rate`	Double
`clicks`	Int
`conversion_rate_all_client_attribution`	Double
`conversion_rate_all_pc_1_d`	Double
`conversion_rate_all_pc_30_d`	Double
`conversion_rate_all_pc_30_d_pv_24_h`	Double
`conversion_rate_all_pc_7_d`	Double
`conversion_rate_all_pv_24_h`	Double
`conversion_rate_client_attribution`	Double
`conversion_rate_pc_1_d`	Double
`conversion_rate_pc_30_d`	Double
`conversion_rate_pc_30_d_pv_24_h`	Double
`conversion_rate_pc_7_d`	Double
`conversion_rate_pv_24_h`	Double
`cost_of_advertiser_value`	Double
`cost_of_advertiser_value_all`	Double
`cost_per_install`	Double
`cost_per_order_all_client_attribution`	Double
`cost_per_order_all_pc_1_d`	Double
`cost_per_order_all_pc_30_d`	Double
`cost_per_order_all_pc_30_d_pv_24_h`	Double
`cost_per_order_all_pc_7_d`	Double
`cost_per_order_all_pv_24_h`	Double
`cost_per_order_client_attribution`	Double
`cost_per_order_pc_1_d`	Double
`cost_per_order_pc_30_d`	Double
`cost_per_order_pc_30_d_pv_24_h`	Double
`cost_per_order_pc_7_d`	Double
`cost_per_order_pv_24_h`	Double
`cost_per_visit`	Double
`cpc`	Double
`currency`	String
`date`	Instant
`displays`	Int
`ecos_all_client_attribution`	Double
`ecos_all_pc_1_d`	Double
`ecos_all_pc_30_d`	Double
`ecos_all_pc_30_d_pv_24_h`	Double
`ecos_all_pc_7_d`	Double
`ecos_all_pv_24_h`	Double
`ecos_client_attribution`	Double
`ecos_pc_1_d`	Double
`ecos_pc_30_d`	Double
`ecos_pc_30_d_pv_24_h`	Double
`ecos_pc_7_d`	Double
`ecos_pv_24_h`	Double
`ecpm`	Double
`exposed_users`	Double
`install_rate`	Double
`non_viewable_displays`	Int
`omnichannel_revenue_all_pc_30_d`	Double
`omnichannel_revenue_all_pv_24_h`	Double
`omnichannel_revenue_client_attribution`	Double
`omnichannel_revenue_pc_30_d`	Double
`omnichannel_revenue_pv_24_h`	Double
`omnichannel_roas_all_pc_30_d`	Double
`omnichannel_roas_all_pv_24_h`	Double
`omnichannel_roas_client_attribution`	Double
`omnichannel_roas_pc_30_d`	Double
`omnichannel_roas_pv_24_h`	Double
`omnichannel_sales_all_pc_30_d`	Int
`omnichannel_sales_all_pv_24_h`	Int
`omnichannel_sales_pc_30_d`	Int
`omnichannel_sales_pv_24_h`	Int
`omnichannelsales_client_attribution`	Int
`overall_competition_win`	Double
`post_install_conversion_rate`	Double
`post_install_cost_of_sale`	Double
`post_install_cost_per_order`	Double
`post_install_order_value`	Double
`post_install_roas`	Double
`post_install_sales`	Int
`potential_displays`	Long
`qualified_visits`	Int
`reach`	Double
`revenue_generated_all_client_attribution`	Double
`revenue_generated_all_pc_1_d`	Double
`revenue_generated_all_pc_30_d`	Double
`revenue_generated_all_pc_30_d_pv_24_h`	Double
`revenue_generated_all_pc_7_d`	Double
`revenue_generated_all_pv_24_h`	Double
`revenue_generated_client_attribution`	Double
`revenue_generated_offline_pc_30_d`	Double
`revenue_generated_offline_pv_24_h`	Double
`revenue_generated_pc_1_d`	Double
`revenue_generated_pc_30_d`	Double
`revenue_generated_pc_30_d_pv_24_h`	Double
`revenue_generated_pc_7_d`	Double
`revenue_generated_pv_24_h`	Double
`roas_all_client_attribution`	Double
`roas_all_pc_1_d`	Double
`roas_all_pc_30_d`	Double
`roas_all_pc_30_d_pv_24_h`	Double
`roas_all_pc_7_d`	Double
`roas_all_pv_24_h`	Double
`roas_client_attribution`	Double
`roas_offline_pc_30_d`	Double
`roas_offline_pv_24_h`	Double
`roas_pc_1_d`	Double
`roas_pc_30_d`	Double
`roas_pc_30_d_pv_24_h`	Double
`roas_pc_7_d`	Double
`roas_pv_24_h`	Double
`sales_all_client_attribution`	Int
`sales_all_pc_1_d`	Int
`sales_all_pc_30_d`	Int
`sales_all_pc_30_d_pv_24_h`	Int
`sales_all_pc_7_d`	Int
`sales_all_pv_24_h`	Int
`sales_client_attribution`	Int
`sales_offline_pc_30_d`	Int
`sales_offline_pv_24_h`	Int
`sales_pc_1_d`	Int
`sales_pc_30_d`	Int
`sales_pc_30_d_pv_24_h`	Int
`sales_pc_7_d`	Int
`sales_pv_24_h`	Int
`untrackable_displays`	Int
`viewable_displays`	Int
`visits`	Int

delivery_limitations_environment

Column	Type	Keys
`_fivetran_id`	String	PK
`adset_id`	Long	FK
`name`	String

audience_adset

Column	Type	Keys
`ad_set_id`	Long	PKFK
`audience_id`	Long	PKFK

geolocation_country

Column	Type	Keys
`_fivetran_id`	String	PK
`adset_id`	Long	FK
`name`	String

image_set

Column	Type	Keys
`_fivetran_id`	String	PK
`creative_id`	Long	FK
`headline_text`	String

Column	Type	Keys
`id`	Long	PK
`ad_set_id`	Long	FK
`creative_id`	Long	FK
`description`	String
`end_date`	Instant
`name`	String
`start_date`	Instant

campaign

Column	Type	Keys
`id`	Long	PK
`advertiser_id`	Long	FK
`name`	String
`objective`	String
`spend_limit_amount`	Double
`spend_limit_renewal`	String
`spend_limit_type`	String

ad_statistics_daily_report

Column	Type	Keys
`_fivetran_id`	String	PK
`advertiser_id`	Long	FK
`ad_id`	Long
`ad_name`	String
`advertiser_all_value`	Double
`advertiser_cost`	Double
`advertiser_value`	Double
`app_installs`	Int
`audience`	Double
`average_cart_all_client_attribution`	Double
`average_cart_all_pc_1_d`	Double
`average_cart_all_pc_30_d`	Double
`average_cart_all_pc_30_d_pv_24_h`	Double
`average_cart_all_pc_7_d`	Double
`average_cart_all_pv_24_h`	Double
`average_cart_client_attribution`	Double
`average_cart_pc_1_d`	Double
`average_cart_pc_30_d`	Double
`average_cart_pc_30_d_pv_24_h`	Double
`average_cart_pc_7_d`	Double
`average_cart_pv_24_h`	Double
`bounce_rate`	Double
`click_through_rate`	Double
`clicks`	Int
`conversion_rate_all_client_attribution`	Double
`conversion_rate_all_pc_1_d`	Double
`conversion_rate_all_pc_30_d`	Double
`conversion_rate_all_pc_30_d_pv_24_h`	Double
`conversion_rate_all_pc_7_d`	Double
`conversion_rate_all_pv_24_h`	Double
`conversion_rate_client_attribution`	Double
`conversion_rate_pc_1_d`	Double
`conversion_rate_pc_30_d`	Double
`conversion_rate_pc_30_d_pv_24_h`	Double
`conversion_rate_pc_7_d`	Double
`conversion_rate_pv_24_h`	Double
`cost_of_advertiser_value`	Double
`cost_of_advertiser_value_all`	Double
`cost_per_install`	Double
`cost_per_order_all_client_attribution`	Double
`cost_per_order_all_pc_1_d`	Double
`cost_per_order_all_pc_30_d`	Double
`cost_per_order_all_pc_30_d_pv_24_h`	Double
`cost_per_order_all_pc_7_d`	Double
`cost_per_order_all_pv_24_h`	Double
`cost_per_order_client_attribution`	Double
`cost_per_order_pc_1_d`	Double
`cost_per_order_pc_30_d`	Double
`cost_per_order_pc_30_d_pv_24_h`	Double
`cost_per_order_pc_7_d`	Double
`cost_per_order_pv_24_h`	Double
`cost_per_visit`	Double
`cpc`	Double
`currency`	String
`day`	LocalDate
`displays`	Int
`ecos_all_client_attribution`	Double
`ecos_all_pc_1_d`	Double
`ecos_all_pc_30_d`	Double
`ecos_all_pc_30_d_pv_24_h`	Double
`ecos_all_pc_7_d`	Double
`ecos_all_pv_24_h`	Double
`ecos_client_attribution`	Double
`ecos_pc_1_d`	Double
`ecos_pc_30_d`	Double
`ecos_pc_30_d_pv_24_h`	Double
`ecos_pc_7_d`	Double
`ecos_pv_24_h`	Double
`ecpm`	Double
`exposed_users`	Double
`install_rate`	Double
`non_viewable_displays`	Int
`omnichannel_revenue_all_pc_30_d`	Double
`omnichannel_revenue_all_pv_24_h`	Double
`omnichannel_revenue_client_attribution`	Double
`omnichannel_revenue_pc_30_d`	Double
`omnichannel_revenue_pv_24_h`	Double
`omnichannel_roas_all_pc_30_d`	Double
`omnichannel_roas_all_pv_24_h`	Double
`omnichannel_roas_client_attribution`	Double
`omnichannel_roas_pc_30_d`	Double
`omnichannel_roas_pv_24_h`	Double
`omnichannel_sales_all_pc_30_d`	Int
`omnichannel_sales_all_pv_24_h`	Int
`omnichannel_sales_pc_30_d`	Int
`omnichannel_sales_pv_24_h`	Int
`omnichannelsales_client_attribution`	Int
`overall_competition_win`	Double
`post_install_conversion_rate`	Double
`post_install_cost_of_sale`	Double
`post_install_cost_per_order`	Double
`post_install_order_value`	Double
`post_install_roas`	Double
`post_install_sales`	Int
`potential_displays`	Long
`qualified_visits`	Int
`reach`	Double
`revenue_generated_all_client_attribution`	Double
`revenue_generated_all_pc_1_d`	Double
`revenue_generated_all_pc_30_d`	Double
`revenue_generated_all_pc_30_d_pv_24_h`	Double
`revenue_generated_all_pc_7_d`	Double
`revenue_generated_all_pv_24_h`	Double
`revenue_generated_client_attribution`	Double
`revenue_generated_offline_pc_30_d`	Double
`revenue_generated_offline_pv_24_h`	Double
`revenue_generated_pc_1_d`	Double
`revenue_generated_pc_30_d`	Double
`revenue_generated_pc_30_d_pv_24_h`	Double
`revenue_generated_pc_7_d`	Double
`revenue_generated_pv_24_h`	Double
`roas_all_client_attribution`	Double
`roas_all_pc_1_d`	Double
`roas_all_pc_30_d`	Double
`roas_all_pc_30_d_pv_24_h`	Double
`roas_all_pc_7_d`	Double
`roas_all_pv_24_h`	Double
`roas_client_attribution`	Double
`roas_offline_pc_30_d`	Double
`roas_offline_pv_24_h`	Double
`roas_pc_1_d`	Double
`roas_pc_30_d`	Double
`roas_pc_30_d_pv_24_h`	Double
`roas_pc_7_d`	Double
`roas_pv_24_h`	Double
`sales_all_client_attribution`	Int
`sales_all_pc_1_d`	Int
`sales_all_pc_30_d`	Int
`sales_all_pc_30_d_pv_24_h`	Int
`sales_all_pc_7_d`	Int
`sales_all_pv_24_h`	Int
`sales_client_attribution`	Int
`sales_offline_pc_30_d`	Int
`sales_offline_pv_24_h`	Int
`sales_pc_1_d`	Int
`sales_pc_30_d`	Int
`sales_pc_30_d_pv_24_h`	Int
`sales_pc_7_d`	Int
`sales_pv_24_h`	Int
`untrackable_displays`	Int
`viewable_displays`	Int
`visits`	Int

campaign_statistics_daily_report

Column	Type	Keys
`_fivetran_id`	String	PK
`advertiser_id`	Long	FK
`advertiser_all_value`	Double
`advertiser_cost`	Double
`advertiser_value`	Double
`app_installs`	Int
`audience`	Double
`average_cart_all_client_attribution`	Double
`average_cart_all_pc_1_d`	Double
`average_cart_all_pc_30_d`	Double
`average_cart_all_pc_30_d_pv_24_h`	Double
`average_cart_all_pc_7_d`	Double
`average_cart_all_pv_24_h`	Double
`average_cart_client_attribution`	Double
`average_cart_pc_1_d`	Double
`average_cart_pc_30_d`	Double
`average_cart_pc_30_d_pv_24_h`	Double
`average_cart_pc_7_d`	Double
`average_cart_pv_24_h`	Double
`bounce_rate`	Double
`campaign_id`	Long
`campaign_name`	String
`click_through_rate`	Double
`clicks`	Int
`conversion_rate_all_client_attribution`	Double
`conversion_rate_all_pc_1_d`	Double
`conversion_rate_all_pc_30_d`	Double
`conversion_rate_all_pc_30_d_pv_24_h`	Double
`conversion_rate_all_pc_7_d`	Double
`conversion_rate_all_pv_24_h`	Double
`conversion_rate_client_attribution`	Double
`conversion_rate_pc_1_d`	Double
`conversion_rate_pc_30_d`	Double
`conversion_rate_pc_30_d_pv_24_h`	Double
`conversion_rate_pc_7_d`	Double
`conversion_rate_pv_24_h`	Double
`cost_of_advertiser_value`	Double
`cost_of_advertiser_value_all`	Double
`cost_per_install`	Double
`cost_per_order_all_client_attribution`	Double
`cost_per_order_all_pc_1_d`	Double
`cost_per_order_all_pc_30_d`	Double
`cost_per_order_all_pc_30_d_pv_24_h`	Double
`cost_per_order_all_pc_7_d`	Double
`cost_per_order_all_pv_24_h`	Double
`cost_per_order_client_attribution`	Double
`cost_per_order_pc_1_d`	Double
`cost_per_order_pc_30_d`	Double
`cost_per_order_pc_30_d_pv_24_h`	Double
`cost_per_order_pc_7_d`	Double
`cost_per_order_pv_24_h`	Double
`cost_per_visit`	Double
`cpc`	Double
`currency`	String
`day`	LocalDate
`displays`	Int
`ecos_all_client_attribution`	Double
`ecos_all_pc_1_d`	Double
`ecos_all_pc_30_d`	Double
`ecos_all_pc_30_d_pv_24_h`	Double
`ecos_all_pc_7_d`	Double
`ecos_all_pv_24_h`	Double
`ecos_client_attribution`	Double
`ecos_pc_1_d`	Double
`ecos_pc_30_d`	Double
`ecos_pc_30_d_pv_24_h`	Double
`ecos_pc_7_d`	Double
`ecos_pv_24_h`	Double
`ecpm`	Double
`exposed_users`	Double
`install_rate`	Double
`non_viewable_displays`	Int
`omnichannel_revenue_all_pc_30_d`	Double
`omnichannel_revenue_all_pv_24_h`	Double
`omnichannel_revenue_client_attribution`	Double
`omnichannel_revenue_pc_30_d`	Double
`omnichannel_revenue_pv_24_h`	Double
`omnichannel_roas_all_pc_30_d`	Double
`omnichannel_roas_all_pv_24_h`	Double
`omnichannel_roas_client_attribution`	Double
`omnichannel_roas_pc_30_d`	Double
`omnichannel_roas_pv_24_h`	Double
`omnichannel_sales_all_pc_30_d`	Int
`omnichannel_sales_all_pv_24_h`	Int
`omnichannel_sales_pc_30_d`	Int
`omnichannel_sales_pv_24_h`	Int
`omnichannelsales_client_attribution`	Int
`overall_competition_win`	Double
`post_install_conversion_rate`	Double
`post_install_cost_of_sale`	Double
`post_install_cost_per_order`	Double
`post_install_order_value`	Double
`post_install_roas`	Double
`post_install_sales`	Int
`potential_displays`	Long
`qualified_visits`	Int
`reach`	Double
`revenue_generated_all_client_attribution`	Double
`revenue_generated_all_pc_1_d`	Double
`revenue_generated_all_pc_30_d`	Double
`revenue_generated_all_pc_30_d_pv_24_h`	Double
`revenue_generated_all_pc_7_d`	Double
`revenue_generated_all_pv_24_h`	Double
`revenue_generated_client_attribution`	Double
`revenue_generated_offline_pc_30_d`	Double
`revenue_generated_offline_pv_24_h`	Double
`revenue_generated_pc_1_d`	Double
`revenue_generated_pc_30_d`	Double
`revenue_generated_pc_30_d_pv_24_h`	Double
`revenue_generated_pc_7_d`	Double
`revenue_generated_pv_24_h`	Double
`roas_all_client_attribution`	Double
`roas_all_pc_1_d`	Double
`roas_all_pc_30_d`	Double
`roas_all_pc_30_d_pv_24_h`	Double
`roas_all_pc_7_d`	Double
`roas_all_pv_24_h`	Double
`roas_client_attribution`	Double
`roas_offline_pc_30_d`	Double
`roas_offline_pv_24_h`	Double
`roas_pc_1_d`	Double
`roas_pc_30_d`	Double
`roas_pc_30_d_pv_24_h`	Double
`roas_pc_7_d`	Double
`roas_pv_24_h`	Double
`sales_all_client_attribution`	Int
`sales_all_pc_1_d`	Int
`sales_all_pc_30_d`	Int
`sales_all_pc_30_d_pv_24_h`	Int
`sales_all_pc_7_d`	Int
`sales_all_pv_24_h`	Int
`sales_client_attribution`	Int
`sales_offline_pc_30_d`	Int
`sales_offline_pv_24_h`	Int
`sales_pc_1_d`	Int
`sales_pc_30_d`	Int
`sales_pc_30_d_pv_24_h`	Int
`sales_pc_7_d`	Int
`sales_pv_24_h`	Int
`untrackable_displays`	Int
`viewable_displays`	Int
`visits`	Int

adset_transaction_report

Column	Type	Keys
`_fivetran_id`	String	PK
`advertiser_id`	Long	FK
`adset_name`	String
`advertiser_name`	String
`amount`	Double
`attributed_transaction`	Boolean
`cross_device_transaction`	String
`currency`	String
`event_date`	Instant
`event_type`	String
`transaction_date`	Instant
`transaction_id`	String

creative

Column	Type	Keys
`id`	Long	PK
`advertiser_id`	Long	FK
`adaptive_background_color`	String
`adaptive_cta_background_color`	String
`adaptive_cta_text_color`	String
`adaptive_description_font`	String
`adaptive_description_text`	String
`adaptive_headline_font`	String
`adaptive_headline_text`	String
`adaptive_image_display`	String
`adaptive_landing_page_url`	String
`adaptive_logo_area_and_title_color`	String
`adaptive_text_1_color`	String
`adaptive_text_2_color`	String
`author`	String
`dataset_id`	String
`description`	String
`dynamic_body_text_color`	String
`dynamic_creative_background_color`	String
`dynamic_prices_color`	String
`dynamic_primary_font`	String
`dynamic_product_image_display`	String
`format`	String
`image_landing_page_url`	String
`name`	String
`status`	String

advertiser

Column	Type	Keys
`advertiser_id`	Long	PK
`advertiser_name`	String

adset

Column	Type	Keys
`id`	Long	PK
`advertiser_id`	Long	FK
`campaign_id`	Long	FK
`attribution_configuration_lookback_window`	String
`attribution_configuration_method`	String
`bidding_bid_amount`	Double
`bidding_bid_strategy`	String
`bidding_cost_controller`	String
`budget_amount`	Double
`budget_delivery_smoothing`	String
`budget_delivery_week`	String
`budget_renewal`	String
`budget_strategy`	String
`dataset_id`	Long
`destination_environment`	String
`frequency_capping_frequency`	String
`frequency_capping_maximum_impressions`	Int
`frequency_capping_mode`	String
`geolocation_countries_operand`	String
`geolocation_subdivisions_operand`	String
`geolocation_zip_codes_operand`	String
`media_type`	String
`name`	String
`objective`	String
`schedule_activation_status`	String
`schedule_delivery_status`	String
`schedule_end_date`	Instant
`schedule_start_date`	Instant
`video_channel`	String

geolocation_subdivision

Column	Type	Keys
`_fivetran_id`	String	PK
`adset_id`	Long	FK
`name`	String

geolocation_zip_code

Column	Type	Keys
`_fivetran_id`	String	PK
`adset_id`	Long	FK
`name`	String

layout

Column	Type	Keys
`_fivetran_id`	String	PK
`creative_id`	Long	FK
`text`	String

delivery_limitations_operation_system

Column	Type	Keys
`_fivetran_id`	String	PK
`adset_id`	Long	FK
`name`	String

video

Column	Type	Keys
`_fivetran_id`	String	PK
`creative_id`	Long	FK
`duration`	Double
`shape`	String
`url`	String

adset_statistics_report

Column	Type	Keys
`_fivetran_id`	String	PK
`adset_id`	Long	FK
`advertiser_id`	Long	FK
`adset_name`	String
`advertiser_all_value`	Double
`advertiser_cost`	Double
`advertiser_value`	Double
`app_installs`	Int
`audience`	Double
`average_cart_all_client_attribution`	Double
`average_cart_all_pc_1_d`	Double
`average_cart_all_pc_30_d`	Double
`average_cart_all_pc_30_d_pv_24_h`	Double
`average_cart_all_pc_7_d`	Double
`average_cart_all_pv_24_h`	Double
`average_cart_client_attribution`	Double
`average_cart_pc_1_d`	Double
`average_cart_pc_30_d`	Double
`average_cart_pc_30_d_pv_24_h`	Double
`average_cart_pc_7_d`	Double
`average_cart_pv_24_h`	Double
`bounce_rate`	Double
`category_id`	Long
`category_name`	String
`click_through_rate`	Double
`clicks`	Int
`conversion_rate_all_client_attribution`	Double
`conversion_rate_all_pc_1_d`	Double
`conversion_rate_all_pc_30_d`	Double
`conversion_rate_all_pc_30_d_pv_24_h`	Double
`conversion_rate_all_pc_7_d`	Double
`conversion_rate_all_pv_24_h`	Double
`conversion_rate_client_attribution`	Double
`conversion_rate_pc_1_d`	Double
`conversion_rate_pc_30_d`	Double
`conversion_rate_pc_30_d_pv_24_h`	Double
`conversion_rate_pc_7_d`	Double
`conversion_rate_pv_24_h`	Double
`cost_of_advertiser_value`	Double
`cost_of_advertiser_value_all`	Double
`cost_per_install`	Double
`cost_per_order_all_client_attribution`	Double
`cost_per_order_all_pc_1_d`	Double
`cost_per_order_all_pc_30_d`	Double
`cost_per_order_all_pc_30_d_pv_24_h`	Double
`cost_per_order_all_pc_7_d`	Double
`cost_per_order_all_pv_24_h`	Double
`cost_per_order_client_attribution`	Double
`cost_per_order_pc_1_d`	Double
`cost_per_order_pc_30_d`	Double
`cost_per_order_pc_30_d_pv_24_h`	Double
`cost_per_order_pc_7_d`	Double
`cost_per_order_pv_24_h`	Double
`cost_per_visit`	Double
`cpc`	Double
`currency`	String
`day`	LocalDate
`displays`	Int
`ecos_all_client_attribution`	Double
`ecos_all_pc_1_d`	Double
`ecos_all_pc_30_d`	Double
`ecos_all_pc_30_d_pv_24_h`	Double
`ecos_all_pc_7_d`	Double
`ecos_all_pv_24_h`	Double
`ecos_client_attribution`	Double
`ecos_pc_1_d`	Double
`ecos_pc_30_d`	Double
`ecos_pc_30_d_pv_24_h`	Double
`ecos_pc_7_d`	Double
`ecos_pv_24_h`	Double
`ecpm`	Double
`exposed_users`	Double
`install_rate`	Double
`non_viewable_displays`	Int
`omnichannel_revenue_all_pc_30_d`	Double
`omnichannel_revenue_all_pv_24_h`	Double
`omnichannel_revenue_client_attribution`	Double
`omnichannel_revenue_pc_30_d`	Double
`omnichannel_revenue_pv_24_h`	Double
`omnichannel_roas_all_pc_30_d`	Double
`omnichannel_roas_all_pv_24_h`	Double
`omnichannel_roas_client_attribution`	Double
`omnichannel_roas_pc_30_d`	Double
`omnichannel_roas_pv_24_h`	Double
`omnichannel_sales_all_pc_30_d`	Int
`omnichannel_sales_all_pv_24_h`	Int
`omnichannel_sales_pc_30_d`	Int
`omnichannel_sales_pv_24_h`	Int
`omnichannelsales_client_attribution`	Int
`overall_competition_win`	Double
`post_install_conversion_rate`	Double
`post_install_cost_of_sale`	Double
`post_install_cost_per_order`	Double
`post_install_order_value`	Double
`post_install_roas`	Double
`post_install_sales`	Int
`potential_displays`	Long
`qualified_visits`	Int
`reach`	Double
`revenue_generated_all_client_attribution`	Double
`revenue_generated_all_pc_1_d`	Double
`revenue_generated_all_pc_30_d`	Double
`revenue_generated_all_pc_30_d_pv_24_h`	Double
`revenue_generated_all_pc_7_d`	Double
`revenue_generated_all_pv_24_h`	Double
`revenue_generated_client_attribution`	Double
`revenue_generated_offline_pc_30_d`	Double
`revenue_generated_offline_pv_24_h`	Double
`revenue_generated_pc_1_d`	Double
`revenue_generated_pc_30_d`	Double
`revenue_generated_pc_30_d_pv_24_h`	Double
`revenue_generated_pc_7_d`	Double
`revenue_generated_pv_24_h`	Double
`roas_all_client_attribution`	Double
`roas_all_pc_1_d`	Double
`roas_all_pc_30_d`	Double
`roas_all_pc_30_d_pv_24_h`	Double
`roas_all_pc_7_d`	Double
`roas_all_pv_24_h`	Double
`roas_client_attribution`	Double
`roas_offline_pc_30_d`	Double
`roas_offline_pv_24_h`	Double
`roas_pc_1_d`	Double
`roas_pc_30_d`	Double
`roas_pc_30_d_pv_24_h`	Double
`roas_pc_7_d`	Double
`roas_pv_24_h`	Double
`sales_all_client_attribution`	Int
`sales_all_pc_1_d`	Int
`sales_all_pc_30_d`	Int
`sales_all_pc_30_d_pv_24_h`	Int
`sales_all_pc_7_d`	Int
`sales_all_pv_24_h`	Int
`sales_client_attribution`	Int
`sales_offline_pc_30_d`	Int
`sales_offline_pv_24_h`	Int
`sales_pc_1_d`	Int
`sales_pc_30_d`	Int
`sales_pc_30_d_pv_24_h`	Int
`sales_pc_7_d`	Int
`sales_pv_24_h`	Int
`untrackable_displays`	Int
`viewable_displays`	Int
`visits`	Int

log_level_report

Column	Type	Keys
`_fivetran_id`	String	PK
`advertiser_id`	Long	FK
`ad_event_type`	String
`ad_format_name`	String
`adset_id`	Long
`adset_name`	String
`app_id`	String
`app_name`	String
`app_store`	String
`app_store_country`	String
`banner_id`	Long
`campaign_id`	Long
`campaign_name`	String
`category_id`	Long
`category_name`	String
`click_revenue_currency`	String
`click_revenue_local`	Double
`click_revenue_usd`	Double
`day`	LocalDate
`environment`	String
`event_timestamp`	Instant
`hour`	Int
`is_display_viewable`	Int
`marketplace_revenue_currency`	String
`marketplace_revenue_local`	Double
`marketplace_revenue_usd`	Double
`referrer`	String
`ua_device_family`	String
`ua_os_family`	String

placement_report

Column	Type	Keys
`day`	LocalDate	PK
`environment`	String	PK
`placement`	String	PK
`adset_id`	Long	PKFK
`clicks`	Int
`cos_pc_30_d`	Double
`cos_pv_1_d`	Double
`cost`	Double
`cpo_pc_30_d`	Double
`cpo_pv_1_d`	Double
`currency`	String
`cvr_pc_30_d`	Double
`cvr_pv_1_d`	Double
`displays`	Int
`revenue_pc_30_d`	Double
`revenue_pv_1_d`	Double
`roas_pc_30_d`	Double
`roas_pv_1_d`	Double
`sales_pc_30_d`	Int
`sales_pv_1_d`	Int

delivery_limitations_device

Column	Type	Keys
`_fivetran_id`	String	PK
`adset_id`	Long	FK
`name`	String

logo

Column	Type	Keys
`_fivetran_id`	String	PK
`creative_id`	Long	FK
`shape`	String
`type`	String
`url`	String