# MNTN schema ERD

Table and field reference for the Fivetran MNTN connector.

## Table & Field Reference

### segment_info

| Column | Type | Keys |
| --- | --- | --- |
| day | Unknown | PK |
| segment_id | Unknown | PK, FK |
| description | Unknown |  |
| interest | Unknown |  |
| name | Unknown |  |

### advertiser

| Column | Type | Keys |
| --- | --- | --- |
| day | Unknown | PK |
| id | Unknown | PK |
| average_order_value | Unknown |  |
| average_page_views_per_visitor | Unknown |  |
| completed_view_rate | Unknown |  |
| completed_views | Unknown |  |
| conversion_attribution_percentage | Unknown |  |
| conversion_rate | Unknown |  |
| conversions | Unknown |  |
| cost_per_completed_view | Unknown |  |
| cost_per_visit | Unknown |  |
| cpa | Unknown |  |
| existing_site_visitors | Unknown |  |
| existing_users_reached | Unknown |  |
| frequency | Unknown |  |
| impression_conversion_rate | Unknown |  |
| impression_visit_rate | Unknown |  |
| impressions | Unknown |  |
| multi_touch_impressions | Unknown |  |
| multi_touch_spend | Unknown |  |
| name | Unknown |  |
| new_site_visitors | Unknown |  |
| new_users_reached | Unknown |  |
| order_value | Unknown |  |
| order_value_attribution_percentage | Unknown |  |
| page_views | Unknown |  |
| percentage_of_conversions | Unknown |  |
| percentage_of_order_value | Unknown |  |
| raw_average_order_value | Unknown |  |
| raw_conversion_rate | Unknown |  |
| raw_conversions | Unknown |  |
| raw_existing_site_visitors | Unknown |  |
| raw_new_site_visitors | Unknown |  |
| raw_order_value | Unknown |  |
| roas | Unknown |  |
| roi | Unknown |  |
| site_visitors | Unknown |  |
| spend | Unknown |  |
| tv_commercials_aired | Unknown |  |
| tv_spend | Unknown |  |
| user_conversion_rate | Unknown |  |
| user_visit_rate | Unknown |  |
| users_reached | Unknown |  |
| viewable_impression_rate | Unknown |  |
| viewable_impressions | Unknown |  |
| visit_conversion_rate | Unknown |  |
| visit_rate | Unknown |  |
| visits | Unknown |  |

### advertiser_info

| Column | Type | Keys |
| --- | --- | --- |
| day | Unknown | PK |
| advertiser_id | Unknown | PK, FK |
| contact_email | Unknown |  |
| contact_first_name | Unknown |  |
| contact_last_name | Unknown |  |
| contact_mobile_phone | Unknown |  |
| contact_office_phone | Unknown |  |
| create_time | Unknown |  |
| name | Unknown |  |
| time_zone | Unknown |  |

### analytics_by_country

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| average_order_value | Unknown |  |
| completed_view_rate | Unknown |  |
| completed_views | Unknown |  |
| conversion_rate | Unknown |  |
| conversions | Unknown |  |
| cost_per_visit | Unknown |  |
| cpa | Unknown |  |
| day | Unknown |  |
| existing_site_visitors | Unknown |  |
| existing_users_reached | Unknown |  |
| frequency | Unknown |  |
| impression_conversion_rate | Unknown |  |
| impression_visit_rate | Unknown |  |
| impressions | Unknown |  |
| iso_code | Unknown |  |
| multi_touch_impressions | Unknown |  |
| multi_touch_spend | Unknown |  |
| name | Unknown |  |
| new_site_visitors | Unknown |  |
| new_users_reached | Unknown |  |
| order_value | Unknown |  |
| roas | Unknown |  |
| roi | Unknown |  |
| site_visitors | Unknown |  |
| spend | Unknown |  |
| tv_commercials_aired | Unknown |  |
| tv_spend | Unknown |  |
| user_conversion_rate | Unknown |  |
| user_visit_rate | Unknown |  |
| users_reached | Unknown |  |
| viewable_impression_rate | Unknown |  |
| viewable_impressions | Unknown |  |
| visit_conversion_rate | Unknown |  |
| visit_rate | Unknown |  |
| visits | Unknown |  |

### creative_info

| Column | Type | Keys |
| --- | --- | --- |
| day | Unknown | PK |
| creative_id | Unknown | PK, FK |
| active | Unknown |  |
| click_url | Unknown |  |
| name | Unknown |  |

### ad_info

| Column | Type | Keys |
| --- | --- | --- |
| day | Unknown | PK |
| creative_id | Unknown | PK, FK |
| active | Unknown |  |
| ad_code | Unknown |  |
| approved | Unknown |  |
| create_time | Unknown |  |
| height | Unknown |  |
| name | Unknown |  |
| status | Unknown |  |
| width | Unknown |  |

### analytics_by_state

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| average_order_value | Unknown |  |
| code | Unknown |  |
| completed_view_rate | Unknown |  |
| completed_views | Unknown |  |
| conversion_rate | Unknown |  |
| conversions | Unknown |  |
| cost_per_visit | Unknown |  |
| cpa | Unknown |  |
| day | Unknown |  |
| existing_site_visitors | Unknown |  |
| existing_users_reached | Unknown |  |
| frequency | Unknown |  |
| impression_conversion_rate | Unknown |  |
| impression_visit_rate | Unknown |  |
| impressions | Unknown |  |
| multi_touch_impressions | Unknown |  |
| multi_touch_spend | Unknown |  |
| name | Unknown |  |
| new_site_visitors | Unknown |  |
| new_users_reached | Unknown |  |
| order_value | Unknown |  |
| parent_code | Unknown |  |
| roas | Unknown |  |
| roi | Unknown |  |
| site_visitors | Unknown |  |
| spend | Unknown |  |
| tv_commercials_aired | Unknown |  |
| tv_spend | Unknown |  |
| unique_code | Unknown |  |
| user_conversion_rate | Unknown |  |
| user_visit_rate | Unknown |  |
| users_reached | Unknown |  |
| viewable_impression_rate | Unknown |  |
| viewable_impressions | Unknown |  |
| visit_conversion_rate | Unknown |  |
| visit_rate | Unknown |  |
| visits | Unknown |  |

### channel

| Column | Type | Keys |
| --- | --- | --- |
| day | Unknown | PK |
| id | Unknown | PK |
| average_order_value | Unknown |  |
| completed_view_rate | Unknown |  |
| completed_views | Unknown |  |
| conversion_rate | Unknown |  |
| conversions | Unknown |  |
| cost_per_completed_view | Unknown |  |
| cost_per_visit | Unknown |  |
| cpa | Unknown |  |
| existing_site_visitors | Unknown |  |
| existing_users_reached | Unknown |  |
| frequency | Unknown |  |
| impression_conversion_rate | Unknown |  |
| impression_visit_rate | Unknown |  |
| impressions | Unknown |  |
| multi_touch_impressions | Unknown |  |
| multi_touch_spend | Unknown |  |
| name | Unknown |  |
| new_site_visitors | Unknown |  |
| new_users_reached | Unknown |  |
| order_value | Unknown |  |
| roas | Unknown |  |
| roi | Unknown |  |
| site_visitors | Unknown |  |
| spend | Unknown |  |
| tv_commercials_aired | Unknown |  |
| tv_spend | Unknown |  |
| user_conversion_rate | Unknown |  |
| user_visit_rate | Unknown |  |
| users_reached | Unknown |  |
| viewable_impression_rate | Unknown |  |
| viewable_impressions | Unknown |  |
| visit_conversion_rate | Unknown |  |
| visit_rate | Unknown |  |
| visits | Unknown |  |

### analytics_by_city

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| average_order_value | Unknown |  |
| completed_view_rate | Unknown |  |
| completed_views | Unknown |  |
| conversion_rate | Unknown |  |
| conversions | Unknown |  |
| cost_per_visit | Unknown |  |
| cpa | Unknown |  |
| day | Unknown |  |
| existing_site_visitors | Unknown |  |
| existing_users_reached | Unknown |  |
| frequency | Unknown |  |
| impression_conversion_rate | Unknown |  |
| impression_visit_rate | Unknown |  |
| impressions | Unknown |  |
| multi_touch_impressions | Unknown |  |
| multi_touch_spend | Unknown |  |
| name | Unknown |  |
| new_site_visitors | Unknown |  |
| new_users_reached | Unknown |  |
| order_value | Unknown |  |
| roas | Unknown |  |
| roi | Unknown |  |
| site_visitors | Unknown |  |
| spend | Unknown |  |
| tv_commercials_aired | Unknown |  |
| tv_spend | Unknown |  |
| user_conversion_rate | Unknown |  |
| user_visit_rate | Unknown |  |
| users_reached | Unknown |  |
| viewable_impression_rate | Unknown |  |
| viewable_impressions | Unknown |  |
| visit_conversion_rate | Unknown |  |
| visit_rate | Unknown |  |
| visits | Unknown |  |

### marketing_objective

| Column | Type | Keys |
| --- | --- | --- |
| day | Unknown | PK |
| id | Unknown | PK |
| average_order_value | Unknown |  |
| completed_view_rate | Unknown |  |
| completed_views | Unknown |  |
| conversion_rate | Unknown |  |
| conversions | Unknown |  |
| cost_per_completed_view | Unknown |  |
| cost_per_visit | Unknown |  |
| cpa | Unknown |  |
| existing_site_visitors | Unknown |  |
| existing_users_reached | Unknown |  |
| frequency | Unknown |  |
| impression_conversion_rate | Unknown |  |
| impression_visit_rate | Unknown |  |
| impressions | Unknown |  |
| multi_touch_impressions | Unknown |  |
| multi_touch_spend | Unknown |  |
| name | Unknown |  |
| new_site_visitors | Unknown |  |
| new_users_reached | Unknown |  |
| order_value | Unknown |  |
| roas | Unknown |  |
| roi | Unknown |  |
| site_visitors | Unknown |  |
| spend | Unknown |  |
| tv_commercials_aired | Unknown |  |
| tv_spend | Unknown |  |
| user_conversion_rate | Unknown |  |
| user_visit_rate | Unknown |  |
| users_reached | Unknown |  |
| viewable_impression_rate | Unknown |  |
| viewable_impressions | Unknown |  |
| visit_conversion_rate | Unknown |  |
| visit_rate | Unknown |  |
| visits | Unknown |  |

### creative

| Column | Type | Keys |
| --- | --- | --- |
| day | Unknown | PK |
| id | Unknown | PK |
| average_order_value | Unknown |  |
| completed_view_rate | Unknown |  |
| completed_views | Unknown |  |
| conversion_rate | Unknown |  |
| conversions | Unknown |  |
| cost_per_completed_view | Unknown |  |
| cost_per_visit | Unknown |  |
| cpa | Unknown |  |
| existing_site_visitors | Unknown |  |
| existing_users_reached | Unknown |  |
| frequency | Unknown |  |
| impression_conversion_rate | Unknown |  |
| impression_visit_rate | Unknown |  |
| impressions | Unknown |  |
| multi_touch_impressions | Unknown |  |
| multi_touch_spend | Unknown |  |
| name | Unknown |  |
| new_site_visitors | Unknown |  |
| new_users_reached | Unknown |  |
| order_value | Unknown |  |
| roas | Unknown |  |
| roi | Unknown |  |
| site_visitors | Unknown |  |
| size | Unknown |  |
| spend | Unknown |  |
| tv_commercials_aired | Unknown |  |
| tv_spend | Unknown |  |
| user_conversion_rate | Unknown |  |
| user_visit_rate | Unknown |  |
| users_reached | Unknown |  |
| viewable_impression_rate | Unknown |  |
| viewable_impressions | Unknown |  |
| visit_conversion_rate | Unknown |  |
| visit_rate | Unknown |  |
| visits | Unknown |  |

### channel_info

| Column | Type | Keys |
| --- | --- | --- |
| day | Unknown | PK |
| channel_id | Unknown | PK, FK |
| name | Unknown |  |

### analytics_by_network

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| average_order_value | Unknown |  |
| completed_view_rate | Unknown |  |
| completed_views | Unknown |  |
| conversion_rate | Unknown |  |
| conversions | Unknown |  |
| cost_per_completed_view | Unknown |  |
| cost_per_visit | Unknown |  |
| cpa | Unknown |  |
| day | Unknown |  |
| existing_site_visitors | Unknown |  |
| existing_users_reached | Unknown |  |
| frequency | Unknown |  |
| impression_conversion_rate | Unknown |  |
| impression_visit_rate | Unknown |  |
| impressions | Unknown |  |
| multi_touch_impressions | Unknown |  |
| multi_touch_spend | Unknown |  |
| name | Unknown |  |
| new_site_visitors | Unknown |  |
| new_users_reached | Unknown |  |
| order_value | Unknown |  |
| roas | Unknown |  |
| roi | Unknown |  |
| site_visitors | Unknown |  |
| spend | Unknown |  |
| tv_commercials_aired | Unknown |  |
| tv_spend | Unknown |  |
| user_conversion_rate | Unknown |  |
| user_visit_rate | Unknown |  |
| users_reached | Unknown |  |
| viewable_impression_rate | Unknown |  |
| viewable_impressions | Unknown |  |
| visit_conversion_rate | Unknown |  |
| visit_rate | Unknown |  |
| visits | Unknown |  |

### campaign_info

| Column | Type | Keys |
| --- | --- | --- |
| day | Unknown | PK |
| campaign_id | Unknown | PK, FK |
| end_time | Unknown |  |
| flight_end_time | Unknown |  |
| flight_start_time | Unknown |  |
| name | Unknown |  |
| start_time | Unknown |  |
| status | Unknown |  |

### campaign_group

| Column | Type | Keys |
| --- | --- | --- |
| day | Unknown | PK |
| id | Unknown | PK |
| average_order_value | Unknown |  |
| completed_view_rate | Unknown |  |
| completed_views | Unknown |  |
| conversion_rate | Unknown |  |
| conversions | Unknown |  |
| cost_per_completed_view | Unknown |  |
| cost_per_visit | Unknown |  |
| cpa | Unknown |  |
| existing_site_visitors | Unknown |  |
| existing_users_reached | Unknown |  |
| frequency | Unknown |  |
| impression_conversion_rate | Unknown |  |
| impression_visit_rate | Unknown |  |
| impressions | Unknown |  |
| multi_touch_impressions | Unknown |  |
| multi_touch_spend | Unknown |  |
| name | Unknown |  |
| new_site_visitors | Unknown |  |
| new_users_reached | Unknown |  |
| order_value | Unknown |  |
| roas | Unknown |  |
| roi | Unknown |  |
| site_visitors | Unknown |  |
| spend | Unknown |  |
| tv_commercials_aired | Unknown |  |
| tv_spend | Unknown |  |
| user_conversion_rate | Unknown |  |
| user_visit_rate | Unknown |  |
| users_reached | Unknown |  |
| viewable_impression_rate | Unknown |  |
| viewable_impressions | Unknown |  |
| visit_conversion_rate | Unknown |  |
| visit_rate | Unknown |  |
| visits | Unknown |  |

### segment

| Column | Type | Keys |
| --- | --- | --- |
| day | Unknown | PK |
| id | Unknown | PK |
| name | Unknown | PK |
| average_order_value | Unknown |  |
| conversion_rate | Unknown |  |
| conversions | Unknown |  |
| cost_per_visit | Unknown |  |
| cpa | Unknown |  |
| existing_site_visitor | Unknown |  |
| existing_user_reached | Unknown |  |
| frequency | Unknown |  |
| impression_conversion_rate | Unknown |  |
| impression_visit_rate | Unknown |  |
| impressions | Unknown |  |
| multi_touch_impressions | Unknown |  |
| multi_touch_spend | Unknown |  |
| new_site_visitor | Unknown |  |
| new_user_reached | Unknown |  |
| order_value | Unknown |  |
| roas | Unknown |  |
| roi | Unknown |  |
| site_visitor | Unknown |  |
| spend | Unknown |  |
| tv_commercials_aired | Unknown |  |
| tv_spend | Unknown |  |
| user_conversion_rate | Unknown |  |
| user_visit_rate | Unknown |  |
| users_reached | Unknown |  |
| visit_conversion_rate | Unknown |  |
| visit_rate | Unknown |  |
| visits | Unknown |  |

### dma

| Column | Type | Keys |
| --- | --- | --- |
| day | Unknown | PK |
| id | Unknown | PK |
| average_order_value | Unknown |  |
| code | Unknown |  |
| completed_view_rate | Unknown |  |
| completed_views | Unknown |  |
| conversion_rate | Unknown |  |
| conversions | Unknown |  |
| cost_per_visit | Unknown |  |
| cpa | Unknown |  |
| existing_site_visitors | Unknown |  |
| existing_users_reached | Unknown |  |
| frequency | Unknown |  |
| impression_conversion_rate | Unknown |  |
| impression_visit_rate | Unknown |  |
| impressions | Unknown |  |
| multi_touch_impressions | Unknown |  |
| multi_touch_spend | Unknown |  |
| name | Unknown |  |
| new_site_visitors | Unknown |  |
| new_users_reached | Unknown |  |
| order_value | Unknown |  |
| roas | Unknown |  |
| roi | Unknown |  |
| site_visitors | Unknown |  |
| spend | Unknown |  |
| tv_commercials_aired | Unknown |  |
| tv_spend | Unknown |  |
| unique_code | Unknown |  |
| user_conversion_rate | Unknown |  |
| user_visit_rate | Unknown |  |
| users_reached | Unknown |  |
| viewable_impression_rate | Unknown |  |
| viewable_impressions | Unknown |  |
| visit_conversion_rate | Unknown |  |
| visit_rate | Unknown |  |
| visits | Unknown |  |

### publisher

| Column | Type | Keys |
| --- | --- | --- |
| day | Unknown | PK |
| name | Unknown | PK |
| average_order_value | Unknown |  |
| completed_view_rate | Unknown |  |
| completed_views | Unknown |  |
| conversion_rate | Unknown |  |
| conversions | Unknown |  |
| cost_per_completed_view | Unknown |  |
| cost_per_visit | Unknown |  |
| cpa | Unknown |  |
| existing_site_visitors | Unknown |  |
| existing_users_reached | Unknown |  |
| frequency | Unknown |  |
| impression_conversion_rate | Unknown |  |
| impression_visit_rate | Unknown |  |
| impressions | Unknown |  |
| multi_touch_impressions | Unknown |  |
| multi_touch_spend | Unknown |  |
| new_site_visitors | Unknown |  |
| new_users_reached | Unknown |  |
| order_value | Unknown |  |
| roas | Unknown |  |
| roi | Unknown |  |
| site_visitors | Unknown |  |
| spend | Unknown |  |
| tv_commercials_aired | Unknown |  |
| tv_spend | Unknown |  |
| user_conversion_rate | Unknown |  |
| user_visit_rate | Unknown |  |
| users_reached | Unknown |  |
| viewable_impression_rate | Unknown |  |
| viewable_impressions | Unknown |  |
| visit_conversion_rate | Unknown |  |
| visit_rate | Unknown |  |
| visits | Unknown |  |

### dma_info

| Column | Type | Keys |
| --- | --- | --- |
| day | Unknown | PK |
| dma_id | Unknown | PK, FK |
| name | Unknown |  |

### creative_group

| Column | Type | Keys |
| --- | --- | --- |
| day | Unknown | PK |
| id | Unknown | PK |
| average_order_value | Unknown |  |
| completed_view_rate | Unknown |  |
| completed_views | Unknown |  |
| conversion_rate | Unknown |  |
| conversions | Unknown |  |
| cost_per_completed_view | Unknown |  |
| cost_per_visit | Unknown |  |
| cpa | Unknown |  |
| existing_site_visitors | Unknown |  |
| existing_users_reached | Unknown |  |
| frequency | Unknown |  |
| impression_conversion_rate | Unknown |  |
| impression_visit_rate | Unknown |  |
| impressions | Unknown |  |
| multi_touch_impressions | Unknown |  |
| multi_touch_spend | Unknown |  |
| name | Unknown |  |
| new_site_visitors | Unknown |  |
| new_users_reached | Unknown |  |
| order_value | Unknown |  |
| roas | Unknown |  |
| roi | Unknown |  |
| site_visitors | Unknown |  |
| spend | Unknown |  |
| tv_commercials_aired | Unknown |  |
| tv_spend | Unknown |  |
| user_conversion_rate | Unknown |  |
| user_visit_rate | Unknown |  |
| users_reached | Unknown |  |
| viewable_impression_rate | Unknown |  |
| viewable_impressions | Unknown |  |
| visit_conversion_rate | Unknown |  |
| visit_rate | Unknown |  |
| visits | Unknown |  |

### marketing_objective_info

| Column | Type | Keys |
| --- | --- | --- |
| day | Unknown | PK |
| marketing_id | Unknown | PK, FK |
| name | Unknown |  |

### conversion

| Column | Type | Keys |
| --- | --- | --- |
| order_id | Unknown | PK |
| publisher | Unknown | PK, FK |
| conversion_point | Unknown |  |
| conversion_time | Unknown |  |
| currency | Unknown |  |
| event_time | Unknown |  |
| last_touch | Unknown |  |
| order_amount | Unknown |  |
| raw_domain | Unknown |  |
| sub_domain | Unknown |  |

## Relationships

- segment_info(segment_id) → segment(id)
- advertiser_info(advertiser_id) → advertiser(id)
- creative_info(creative_id) → creative_group(id)
- ad_info(creative_id) → creative(id)
- channel_info(channel_id) → channel(id)
- campaign_info(campaign_id) → campaign_group(id)
- dma_info(dma_id) → dma(id)
- marketing_objective_info(marketing_id) → marketing_objective(id)
- conversion(publisher) → publisher(name)