Legend
🔑 = primary key
➤ = foreign key relation
⇱ = external link
member_id 🔑 ➤ MEMBER
segment_id 🔑 ➤ SEGMENT
list_id ➤ LIST
SEGMENT_MEMBER ⇱
id 🔑�beamer_address�contact_address_1�contact_address_2�contact_city�contact_company�contact_country�contact_state�contact_zip�date_created�default_from_email�default_from_name�default_language�default_subject�email_type_option�list_rating�name�notify_on_subscribe�notify_on_unsubscribe�permission_reminder�subscribe_url_long�subscribe_url_short�use_archive_bar�visibility
LIST ⇱
id 🔑
campaign_id 🔑 ➤ CAMPAIGN�content_description�from_name�recipients�reply_to�send_time�subject_line
CAMPAIGN_VARIATE_COMBINATION
campaign_id 🔑 ➤ CAMPAIGN
member_id 🔑 ➤ MEMBER
combination_id ➤ CAMPAIGN_VARIATE_COMBINATION�list_id ➤ LIST
CAMPAIGN_RECIPIENT
id 🔑
list_id 🔑 ➤ LIST�country_code�dstoff�email_address�email_client�email_type�gmtoff�ip_opt�ip_signup�language�last_changed�latitude�longitude�member_rating�status�timestamp_opt�timestamp_signup�timezone�unique_email_id�vip
web_idd�merge_*
MEMBER ⇱
id 🔑
list_id ➤ LIST
created_at�member_count�name�type�updated_at
SEGMENT ⇱
id 🔑
list_id ➤ LIST
segment_id ➤ SEGMENT
winning_campaign_id ➤ CAMPAIGN�winning_combination_id ➤ CAMPAIGN_VARIATE_COMBINATION
archive_url�authenticate�auto_footer�auto_tweet�clicktale�content_type�create_time�drag_and_drop�fb_comments�folder_id�from_name�google_analytics�inline_css
long_archive_url�reply_to�segment_text�send_time�status�subject_line�template_id�test_size�timewarp�title�to_name�track_ecomm_360�track_goals�track_html_clicks�track_opens�track_text_clicks�type�use_conversation�wait_time�winner_criteria
CAMPAIGN ⇱
action 🔑
campaign_id 🔑 ➤ CAMPAIGN
member_id 🔑 ➤ MEMBER�timestamp 🔑�combination_id ➤ CAMPAIGN_VARIATE_COMBINATION
list_id ➤ LIST�bounce_type�ip
url
CAMPAIGN_RECIPIENT_ACTIVITY ⇱
list_id 🔑 ➤ LIST
member_id 🔑 ➤ MEMBER
campaign_id ➤ CAMPAIGN / AUTOMATION_EMAIL�reason
timestamp
UNSUBSCRIBE ⇱
merge tag values are included as columns with “merge_” prepended.
Table only exists if using MailChimp Pro’s Multivariate Campaigns feature
id 🔑
list_id ➤ LIST�segment_id ➤ SEGMENT
create_time�segment_text�start_time�status�title�trigger_settings
AUTOMATION ⇱
id 🔑
automation_id ➤ AUTOMATION
archive_url�authenticate�auto_footer�auto_tweet�clicktale�content_type�create_time�delay_action�delay_action_description�delay_amount�delay_direction�delay_full_description�delay_type�drag_and_drop�fb_comments�folder_id�from_name�google_analytics�inline_css�position�reply_to�send_time�start_time�status�subject_line�template_id�timewarp�title�to_name�track_ecomm_360�track_goals�track_html_clicks�track_opens�track_text_clicks�use_conversation
AUTOMATION_EMAIL ⇱
automation_email_id 🔑 ➤ AUTOMATION_EMAIL
member_id 🔑 ➤ MEMBER�list_id ➤ LIST
AUTOMATION_RECIPIENT
action 🔑
automation_email_id 🔑➤ AUTOMATION_EMAIL
member_id 🔑 ➤ MEMBER�timestamp 🔑
list_id ➤ LIST
bounce_type�Ip
url
AUTOMATION_RECIPIENT_ACTIVITY ⇱
campaign_id contains foreign key references to the id field of both the Campaign and Automation Email tables. MailChimp’s API treats them as equivalent.
id 🔑
list_id ➤ LIST
name
TAGS ⇱
member_id 🔑 ➤ MEMBER
tag_id 🔑 ➤ TAG
TAG_MEMBER ⇱
id 🔑
list_id ➤ LIST
display_order
title�type�
INTEREST_CATEGORY ⇱
id 🔑
category_id ➤ INTEREST_CATEGORY
list_id ➤ LIST
display_order
name�subscriber_count
INTEREST ⇱
interest_id 🔑 ➤ INTEREST
member_id 🔑 ➤ MEMBER
INTEREST_MEMBER ⇱