# Wicked Reports schema ERD

Table and field reference for the Fivetran Wicked Reports connector.

## Table & Field Reference

### view

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| name | Unknown |  |

### contact

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| create_date | Unknown |  |
| email | Unknown |  |
| first_click_campaign | Unknown |  |
| first_click_content | Unknown |  |
| first_click_date | Unknown |  |
| first_click_medium | Unknown |  |
| first_click_source | Unknown |  |
| first_click_term | Unknown |  |
| first_name | Unknown |  |
| first_optin_campaign | Unknown |  |
| first_optin_content | Unknown |  |
| first_optin_date | Unknown |  |
| first_optin_medium | Unknown |  |
| first_optin_source | Unknown |  |
| first_optin_term | Unknown |  |
| from_date | String |  |
| last_name | Unknown |  |
| ltv | Unknown |  |
| reoptin_campaign | Unknown |  |
| reoptin_content | Unknown |  |
| reoptin_date | Unknown |  |
| reoptin_medium | Unknown |  |
| reoptin_source | Unknown |  |
| reoptin_term | Unknown |  |
| source_id | Unknown |  |
| source_system | Unknown |  |
| to_date | String |  |
| url_wicked | Unknown |  |

### order_product

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| order_id | Unknown | PK, FK |
| id | Unknown |  |
| name | Unknown |  |
| ppu | Unknown |  |
| quantity | Unknown |  |

### order_payment

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| order_id | Unknown | PK, FK |
| amount | Unknown |  |
| date | Unknown |  |
| status | Unknown |  |

### orders

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| contact_id | Unknown | FK |
| amount | Unknown |  |
| currency | Unknown |  |
| date | Unknown |  |
| first_click_campaign | Unknown |  |
| first_click_content | Unknown |  |
| first_click_date | Unknown |  |
| first_click_medium | Unknown |  |
| first_click_source | Unknown |  |
| first_click_term | Unknown |  |
| first_optin_campaign | Unknown |  |
| first_optin_content | Unknown |  |
| first_optin_date | Unknown |  |
| first_optin_medium | Unknown |  |
| first_optin_source | Unknown |  |
| first_optin_term | Unknown |  |
| last_click_campaign | Unknown |  |
| last_click_content | Unknown |  |
| last_click_date | Unknown |  |
| last_click_medium | Unknown |  |
| last_click_source | Unknown |  |
| last_click_term | Unknown |  |
| reoptin_campaign | Unknown |  |
| reoptin_content | Unknown |  |
| reoptin_date | Unknown |  |
| reoptin_medium | Unknown |  |
| reoptin_source | Unknown |  |
| reoptin_term | Unknown |  |
| source_id | Unknown |  |
| source_system | Unknown |  |
| subscription_id | Unknown |  |

### click

| Column | Type | Keys |
| --- | --- | --- |
| date | Unknown | PK |
| contact_id | Unknown | PK, FK |
| contact_source_id | Unknown |  |
| email | Unknown |  |
| is_first_click | Unknown |  |
| is_first_optin | Unknown |  |
| is_last_click | Unknown |  |
| is_re_optin | Unknown |  |
| source | Unknown |  |
| tracking_url | Unknown |  |
| utms_campaign | Unknown |  |
| utms_content | Unknown |  |
| utms_medium | Unknown |  |
| utms_source | Unknown |  |
| utms_term | Unknown |  |
| wicked_id | Unknown |  |
| wicked_source | Unknown |  |

### funnel_vision_grid

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| view_id | Unknown | FK |
| average_order_value | Unknown |  |
| bottom_of_funnel_revenue | Unknown |  |
| bottom_of_funnel_sales | Unknown |  |
| bottom_of_funnel_wicked_attributed_revenue | Unknown |  |
| bottom_of_funnel_wicked_attributed_sales | Unknown |  |
| campaign | Unknown |  |
| channel | Unknown |  |
| clicks | Unknown |  |
| content | Unknown |  |
| cost_per_lead | Unknown |  |
| costs | Unknown |  |
| custom_conversions_0 | Unknown |  |
| custom_conversions_1 | Unknown |  |
| custom_conversions_2 | Unknown |  |
| custom_conversions_cost_per_0 | Unknown |  |
| custom_conversions_cost_per_1 | Unknown |  |
| custom_conversions_cost_per_2 | Unknown |  |
| customers | Unknown |  |
| dataset | Unknown |  |
| date | Unknown |  |
| facebook_cost_per_add_to_cart | Unknown |  |
| facebook_cost_per_outbound_click | Unknown |  |
| facebook_date_created | Unknown |  |
| facebook_impressions | Unknown |  |
| facebook_meta_add_to_cart | Unknown |  |
| facebook_meta_purchase_conversion | Unknown |  |
| facebook_meta_purchases | Unknown |  |
| facebook_outbound_clicks | Unknown |  |
| facebook_status | Unknown |  |
| facebook_view_through_conversions | Unknown |  |
| facebook_view_through_revenue | Unknown |  |
| facebook_website_add_to_cart | Unknown |  |
| facebook_website_purchase_conversion | Unknown |  |
| facebook_website_purchases | Unknown |  |
| grid_first_click_date | Unknown |  |
| grid_last_click_date | Unknown |  |
| leads | Unknown |  |
| medium | Unknown |  |
| middle_of_funnel_revenue | Unknown |  |
| middle_of_funnel_sales | Unknown |  |
| new_average_order_value | Unknown |  |
| new_customer_acquisition_cost | Unknown |  |
| new_customers | Unknown |  |
| new_leads | Unknown |  |
| new_revenue | Unknown |  |
| new_subscription_revenue | Unknown |  |
| new_subscription_sales | Unknown |  |
| new_visits | Unknown |  |
| re_engaged_leads | Unknown |  |
| recurring_subscription_revenue | Unknown |  |
| recurring_subscription_sales | Unknown |  |
| repeat_average_order_value | Unknown |  |
| repeat_customers | Unknown |  |
| repeat_revenue | Unknown |  |
| source | Unknown |  |
| term | Unknown |  |
| top_of_funnel_revenue | Unknown |  |
| top_of_funnel_sales | Unknown |  |
| wicked_attributed_revenue | Unknown |  |
| wicked_attributed_sales | Unknown |  |

### funnel_vision_summary

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| view_id | Unknown | FK |
| dataset | Unknown |  |
| date | Unknown |  |
| summary_attribution_coverage_percent | Unknown |  |
| summary_clicks | Unknown |  |
| summary_cost_per_lead | Unknown |  |
| summary_costs | Unknown |  |
| summary_customers | Unknown |  |
| summary_facebook_meta_purchase_conversion | Unknown |  |
| summary_facebook_meta_purchases | Unknown |  |
| summary_facebook_view_through_conversions | Unknown |  |
| summary_facebook_view_through_revenue | Unknown |  |
| summary_first_click_date | Unknown |  |
| summary_future_revenue | Unknown |  |
| summary_future_sales | Unknown |  |
| summary_last_click_date | Unknown |  |
| summary_last_click_revenue | Unknown |  |
| summary_last_click_sales | Unknown |  |
| summary_leads | Unknown |  |
| summary_new_customer_acquisition_cost | Unknown |  |
| summary_new_customers | Unknown |  |
| summary_new_leads | Unknown |  |
| summary_new_marketing_efficiency_ratio | Unknown |  |
| summary_new_marketing_efficiency_ratio_percent | Unknown |  |
| summary_new_sales_count | Unknown |  |
| summary_new_sales_revenue | Unknown |  |
| summary_new_subscription_revenue | Unknown |  |
| summary_new_subscription_sales | Unknown |  |
| summary_new_visits | Unknown |  |
| summary_non_subscription_revenue | Unknown |  |
| summary_non_subscription_sales | Unknown |  |
| summary_pre_wicked_revenue | Unknown |  |
| summary_pre_wicked_sales | Unknown |  |
| summary_re_engaged_leads | Unknown |  |
| summary_recurring_subscription_revenue | Unknown |  |
| summary_recurring_subscription_sales | Unknown |  |
| summary_repeat_customers | Unknown |  |
| summary_repeat_sales_count | Unknown |  |
| summary_repeat_sales_revenue | Unknown |  |
| summary_total_revenue | Unknown |  |
| summary_total_sales | Unknown |  |
| summary_totals_return_on_ad_spend | Unknown |  |
| summary_totals_return_on_investment | Unknown |  |
| summary_totals_revenue | Unknown |  |
| summary_totals_sales | Unknown |  |
| summary_unattributed_leads | Unknown |  |
| summary_unattributed_revenue | Unknown |  |
| summary_unattributed_sales | Unknown |  |
| summary_wicked_attributed_revenue | Unknown |  |
| summary_wicked_attributed_sales | Unknown |  |

## Relationships

- order_product(order_id) → orders(id)
- order_payment(order_id) → orders(id)
- orders(contact_id) → contact(id)
- click(contact_id) → contact(id)
- funnel_vision_grid(view_id) → view(id)
- funnel_vision_summary(view_id) → view(id)