Mailchimp schema and ERD

24 tables

Loading diagram…

campaign

member

campaign

string

web_id

string

parent_campaign_id

string

type

string

create_time

date

archive_url

string

long_archive_url

string

status

string

emails_sent

long

campaign_ab_split_opt

campaign_id

string

split_test

string

pick_winner

string

wait_units

string

wait_time

int

split_size

int

from_name_a

string

from_name_b

string

reply_email_a

string

campaign_recipient

campaign_id

string

list_id

string

list_is_active

boolean

list_name

string

segment_text

string

recipient_count

long

segment_opts_saved_segment_id

string

segment_opts_prebuilt_segment_id

string

segment_opts_match

string

segment_opts_conditions

string

_weld_synced

date

campaign_report_summary

campaign_id

string

opens

long

unique_opens

long

open_rate

double

clicks

long

subscriber_clicks

long

click_rate

double

ecommerce_total_orders

long

ecommerce_total_spent

double

ecommerce_total_revenue

double

_weld_synced

date

campaign_rss_opt

campaign_id

string

feed_url

string

frequency

string

schedule_hour

int

schedule_daily_send_sunday

boolean

schedule_daily_send_monday

boolean

schedule_daily_send_tuesday

boolean

schedule_daily_send_wednesday

boolean

schedule_daily_send_thursday

boolean

campaign_setting

campaign_id

string

subject_line

string

preview_text

string

title

string

from_name

string

reply_to

string

use_conversation

boolean

to_name

string

folder_id

string

campaign_tracking

campaign_id

string

opens

boolean

html_clicks

boolean

text_clicks

boolean

ecomm_360

boolean

google_analytics

string

clicktale

string

_weld_synced

date

campaign_variate_setting

campaign_id

string

winning_combination_id

string

winning_campaign_id

string

winner_criteria

string

wait_time

int

test_size

int

subject_lines

string

send_times

string

from_names

string

reply_to_addresses

string

contents

string

_weld_synced

date

campaign_variate_setting_combination

string

campaign_id

string

subject_line

long

send_time

long

from_name

long

reply_to

long

content_description

long

recipients

long

_weld_synced

date

campaign_member_recipient

member_id

string

campaign_id

string

list_id

string

status

string

open_count

int

last_open

date

absplit_group

string

gmt_offset

double

_weld_synced

date

interest

string

list_id

string

category_id

string

name

string

subscriber_count

string

display_order

int

_weld_synced

date

interest_category

string

list_id

string

title

string

display_order

int

type

string

_weld_synced

date

list

string

web_id

string

name

string

contact_company

string

contact_address_1

string

contact_address_2

string

contact_city

string

contact_state

string

contact_zip

string

list_activity

list_id

string

day

date

emails_sent

long

unique_opens

long

recipient_clicks

long

hard_bounce

long

soft_bounce

long

subs

long

unsubs

long

other_adds

long

other_removes

long

_weld_synced

date

member

string

list_id

string

email_address

string

unique_email_id

string

contact_id

string

full_name

string

web_id

string

email_type

string

status

string

unsubscribe_reason

string

member_interest

interest_id

string

member_id

string

_weld_synced

date

member_last_note

member_id

string

note_id

string

created_at

date

created_by

string

note

string

_weld_synced

date

member_location

member_id

string

latitude

double

longitude

double

gmtoff

double

dstoff

double

country_code

string

timezone

string

region

string

_weld_synced

date

member_marketing_permission

member_id

string

index

int

marketing_permission_id

string

text

string

enabled

boolean

_weld_synced

date

member_tag

tag_id

string

member_id

string

_weld_synced

date

member_activity

list_id

string

member_id

string

campaign_id

string

action

string

timestamp

date

url

string

type

string

title

string

parent_campaign

string

_weld_synced

date

segment

string

list_id

string

name

string

member_count

long

type

string

created_at

date

updated_at

date

options_match

string

options_conditions

string

_weld_synced

date

segment_member

member_id

string

segment_id

string

list_id

string

_weld_synced

date

tag

string

name

string

_weld_synced

date