MNTN

Explore the interactive ERD

Table & Field Reference

segment_info

Column	Type	Keys
`day`	Unknown	PK
`segment_id`	Unknown	PKFK
`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	PKFK
`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	PKFK
`active`	Unknown
`click_url`	Unknown
`name`	Unknown

ad_info

Column	Type	Keys
`day`	Unknown	PK
`creative_id`	Unknown	PKFK
`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	PKFK
`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	PKFK
`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	PKFK
`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	PKFK
`name`	Unknown

conversion

Column	Type	Keys
`order_id`	Unknown	PK
`publisher`	Unknown	PKFK
`conversion_point`	Unknown
`conversion_time`	Unknown
`currency`	Unknown
`event_time`	Unknown
`last_touch`	Unknown
`order_amount`	Unknown
`raw_domain`	Unknown
`sub_domain`	Unknown