# Criteo schema ERD

Table and field reference for the Fivetran Criteo connector.

## 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 | PK, FK |
| audience_id | Long | PK, FK |

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

### ad

| 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 | PK, FK |
| 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 |  |

## Relationships

- call_to_action(creative_id) → creative(id)
- html_tag(creative_id) → creative(id)
- audience(advertiser_id) → advertiser(advertiser_id)
- image(image_set_id) → image_set(_fivetran_id)
- image_url(creative_id) → creative(id)
- adset_statistics_hourly_report(adset_id) → adset(id)
- adset_statistics_hourly_report(advertiser_id) → advertiser(advertiser_id)
- delivery_limitations_environment(adset_id) → adset(id)
- audience_adset(audience_id) → audience(id)
- audience_adset(ad_set_id) → adset(id)
- geolocation_country(adset_id) → adset(id)
- image_set(creative_id) → creative(id)
- ad(creative_id) → creative(id)
- ad(ad_set_id) → adset(id)
- campaign(advertiser_id) → advertiser(advertiser_id)
- ad_statistics_daily_report(advertiser_id) → advertiser(advertiser_id)
- campaign_statistics_daily_report(advertiser_id) → advertiser(advertiser_id)
- adset_transaction_report(advertiser_id) → advertiser(advertiser_id)
- creative(advertiser_id) → advertiser(advertiser_id)
- adset(advertiser_id) → advertiser(advertiser_id)
- adset(campaign_id) → campaign(id)
- geolocation_subdivision(adset_id) → adset(id)
- geolocation_zip_code(adset_id) → adset(id)
- layout(creative_id) → creative(id)
- delivery_limitations_operation_system(adset_id) → adset(id)
- video(creative_id) → creative(id)
- adset_statistics_report(adset_id) → adset(id)
- adset_statistics_report(advertiser_id) → advertiser(advertiser_id)
- log_level_report(advertiser_id) → advertiser(advertiser_id)
- placement_report(adset_id) → adset(id)
- delivery_limitations_device(adset_id) → adset(id)
- logo(creative_id) → creative(id)