Mailchimp data warehouse table groups

  • Updated on Dec 10, 2025
  • Published on Aug 12, 2025
Prev Next

Table: CAMPAIGN

auto_fb_post
Display name Auto post to FB
Description A list of Facebook page ids the campaign posts to automatically
Field type dimension
Data type string.text.json
auto_footer
Display name Auto footer
Description Automatically append Mailchimp' default footer to the campaign
Field type dimension
Data type bool
auto_tweet
Display name Auto tweet
Description Automatically tweet a link to the campaign archive page when the campaign is sent
Field type dimension
Data type bool
bounces_a
Display name AB test A bounces
Description Bounces for Campaign A
Field type metric
Data type int.number.value
bounces_b
Display name AB test B bounces
Description Bounces for Campaign B
Field type metric
Data type int.number.value
campaign_created_date
Display name Created
Description The date and time the campaign was created in ISO 8601 format
Field type dimension
Data type string.time.date
campaign_defaults
Display name Campaign defaults
Description Default values for campaigns created for the list
Field type dimension
Data type string.text.json
campaign_folder_name
Display name Folder name
Description The name of the campaign folder
Field type dimension
Data type string.text.value
campaign_id
Display name Campaign ID
Description A string that uniquely identifies the campaign
Field type dimension
Data type string.text.value
campaign_last_click
Display name Last click
Field type dimension
Data type string.time.date
campaign_last_open
Display name Last open
Description The date and time of the last open for this campaign in ISO 8601 format
Field type dimension
Data type string.time.date
campaign_last_sent_date
Display name Sent
Field type dimension
Data type string.time.date
campaign_name
Display name Campaign name
Field type dimension
Data type string.text.value
campaign_status
Display name Status
Description Current status of the campaign
Field type dimension
Data type string.text.value
campaign_type
Display name Campaign type
Description The type of the campaign, e.g. variate
Field type dimension
Data type string.text.value
date
Display name Date
Description Date, e.g. 2017-01-31
Field type dimension
Data type string.time.date
delivery_status_can_cancel
Display name Can be canceled
Description Whether a campaign send can be canceled
Field type dimension
Data type bool
delivery_status_enabled
Display name Status enabled
Description Whether Campaign Delivery Status is enabled for this account and campaign
Field type dimension
Data type bool
delivery_status_name
Display name Delivery status
Description Updates on campaigns in the process of sending
Field type dimension
Data type string.text.value
ecommerce_total_orders
Display name Total orders
Description The total orders for a campaign
Field type metric
Data type int.number.value
ecommerce_total_revenue
Display name Total revenue
Description The total revenue for a campaign
Field type metric
Data type float.currency.value
ecommerce_total_spent
Display name Total spent
Description The total amount the customer has spent
Field type metric
Data type float.currency.value
eepurl_clicks
Display name Clicks
Description The total number of clicks to the campaign's URL
Field type metric
Data type int.number.value
eepurl_first_click
Display name First click
Description The timestamp for the first click to the URL
Field type dimension
Data type string.time.date
eepurl_first_tweet
Display name First tweet
Description The day and time of the first recorded tweet with a link to the campaign
Field type dimension
Data type string.time.date
eepurl_last_click
Display name Last click
Description The timestamp for the last click to the URL
Field type dimension
Data type string.time.date
eepurl_last_tweet
Display name Last tweet
Description The day and time of the last recorded tweet with a link to the campaign
Field type dimension
Data type string.time.date
eepurl_reweets
Display name Retweets
Description The number of retweets that include a link to the campaign
Field type metric
Data type int.number.value
eepurl_tweets
Display name Twitter tweets
Description The number of tweets including a link to the campaign
Field type metric
Data type int.number.value
emails_cancelled
Display name Emails cancelled
Description The total number of emails canceled for this campaign
Field type metric
Data type int.number.value
emails_delivered
Display name Emails delivered
Description The total number of emails confirmed sent for this campaign so far
Field type metric
Data type float.number.value
emails_sent
Display name Emails sent
Description The total number of emails sent for this campaign
Field type metric
Data type int.number.value
facebook_likes
Display name Total Facebook likes
Description The number of Facebook likes for the campaign
Field type metric
Data type int.number.value
fb_comments
Display name Facebook comments on
Description Allows Facebook comments on the campaign
Field type dimension
Data type bool
forwards_a
Display name AB test A forwards
Description Forwards for Campaign A
Field type metric
Data type int.number.value
forwards_b
Display name AB test B forwards
Description Forwards for Campaign B
Field type metric
Data type int.number.value
forwards_count
Display name Forwards
Description The forwards and forward activity for the campaign
Field type metric
Data type int.number.value
forwards_opens
Display name Forward opens
Description How many times the forwarded campaign has been opened
Field type metric
Data type int.number.value
forwards_opens_a
Display name AB test A forward opens
Description Opens from forwards for Campaign A
Field type metric
Data type int.number.value
forwards_opens_b
Display name AB test B forward opens
Description Opens from forwards for Campaign B
Field type metric
Data type int.number.value
from_name
Display name From name
Description The 'from' name on the campaign (not an email address)
Field type dimension
Data type string.text.value
goal_tracking
Display name Goal tracking
Description Whether to enable Goal tracking
Field type dimension
Data type bool
hard_bounces
Display name Hard bounces
Description The total number of hard bounced email addresses
Field type metric
Data type int.number.value
industry_abuse_rate
Display name Industry abuse report rate
Description The industry abuse rate
Field type metric
Data type float.number.ratio
industry_bounce_rate
Display name Industry bounce rate
Description The industry bounce rate
Field type metric
Data type float.number.ratio
industry_click_rate
Display name Industry click rate
Description The industry click rate
Field type metric
Data type float.number.ratio
industry_open_rate
Display name Industry open rate
Description The industry open rate
Field type metric
Data type float.number.ratio
industry_unopen_rate
Display name Industry unopen rate
Description The industry unopened rate
Field type metric
Data type float.number.ratio
industry_unsub_rate
Display name Industry unsubscription rate
Description The industry unsubscribe rate
Field type metric
Data type float.number.ratio
inline_css
Display name Inline CSS
Description Automatically inline the CSS included with the campaign content
Field type dimension
Data type bool
last_open_a
Display name AB test A last open
Description The last open for Campaign A
Field type dimension
Data type string.time.date
last_open_b
Display name AB test B last open
Description The last open for Campaign B
Field type dimension
Data type string.time.date
list_email_type_option
Display name Multiple email formats
Description Whether the list supports multiple formats for emails
Field type dimension
Data type bool
list_id
Display name List ID
Description The unique id for the list
Field type dimension
Data type string.text.value
list_modules
Display name List modules
Description Any list-specific modules installed for the list
Field type dimension
Data type string.text.json
list_name
Display name List name
Description The name of the list
Field type dimension
Data type string.text.value
list_notify_on_subscribe
Display name Notify email on subscribe
Description The email address to send subscribe notifications to
Field type dimension
Data type string.text.email
list_notify_on_unsubscribe
Display name Notify email on unsubscribe
Description The email address to send unsubscribe notifications to
Field type dimension
Data type string.text.email
list_rating
Display name List rating
Description An auto-generated activity score for the list (0-5)
Field type dimension
Data type int.number.value
opens_a
Display name AB test A total opens
Description Opens for Campaign A
Field type metric
Data type int.number.value
opens_b
Display name AB test B total opens
Description Opens for Campaign B
Field type metric
Data type int.number.value
opens_total
Display name Total opens
Description The total number of opens for a campaign
Field type metric
Data type int.number.value
permission_reminder
Display name Permission reminder
Description The permission reminder for the list
Field type dimension
Data type string.text.value
recipient_likes
Display name Recipient Facebook likes
Description The number of recipients who liked the campaign on Facebook
Field type metric
Data type int.number.value
recipients_click_a
Display name AB test A clicks
Description Recipient Clicks for Campaign A
Field type metric
Data type int.number.value
recipients_click_b
Display name AB test B clicks
Description Recipient Clicks for Campaign B
Field type metric
Data type int.number.value
reply_to
Display name Reply to
Description The reply-to email address for the campaign
Field type dimension
Data type string.text.email
rss_feed_url
Display name Feed URL
Description The URL of the RSS feed
Field type dimension
Data type string.text.url
rss_frequency
Display name Frequency
Description The frequency of the RSS campaign
Field type dimension
Data type string.text.value
soft_bounces
Display name Soft bounces
Description The total number of soft bounced email addresses
Field type metric
Data type int.number.value
subject_line
Display name Subject line
Description The subject line of the campaign
Field type dimension
Data type string.text.value
subscribe_url_long
Display name Subscribe URL (long)
Description The full version of the list's subscribe form
Field type dimension
Data type string.text.url
subscribe_url_short
Display name Subscribe URL (short)
Description Mailchimp's EepURL shortened version of this list's subscribe form
Field type dimension
Data type string.text.url
syntax_errors
Display name Syntax errors
Description The total number of addresses that were syntax-related bounces
Field type metric
Data type int.number.value
template_id
Display name Template ID
Description The individual id for the template
Field type dimension
Data type string.text.value
timewarp
Display name Timewarp
Description An hourly breakdown of sends, opens, and clicks if a campaign is sent using timewarp
Field type dimension
Data type bool
to_name
Display name To name
Description The campaign's custom 'To' name
Field type dimension
Data type string.text.value
tracking_capsule
Display name Capsule tracking
Description Capsule tracking options for a campaign
Field type dimension
Data type bool
tracking_clicktale
Display name ClickTale tracking
Description The custom slug for ClickTale tracking
Field type dimension
Data type string.text.value
tracking_ecomm360
Display name eCommerce360 tracking
Description Whether to enable eCommerce360 tracking
Field type dimension
Data type bool
tracking_google_analytics
Display name Google Analytics tracking
Description The custom slug for Google Analytics tracking
Field type dimension
Data type string.text.value
tracking_html_clicks
Display name Tracking HTML clicks
Description Whether to track clicks in the HTML version of the campaign
Field type dimension
Data type bool
tracking_opens
Display name Tracking opens
Description Whether to track opens
Field type dimension
Data type bool
tracking_salesforce
Display name Salesforce tracking
Description Salesforce tracking options for a campaign
Field type dimension
Data type bool
tracking_text_clicks
Display name Tracking text clicks
Description Whether to track clicks in the plain-text version of the campaign
Field type dimension
Data type bool
unique_clicks
Display name Unique clicks
Description The total number of unique clicks for links across a campaign
Field type metric
Data type int.number.value
unique_likes
Display name Unique Facebook likes
Description The number of unique likes
Field type metric
Data type int.number.value
unique_opens
Display name Unique opens
Description The total number of unique opens
Field type metric
Data type int.number.value
unique_opens_a
Display name AB test A unique opens
Description Unique opens for Campaign A
Field type metric
Data type int.number.value
unique_opens_b
Display name AB test B unique opens
Description Unique opens for Campaign B
Field type metric
Data type int.number.value
unique_subscriber_clicks
Display name Unique subscriber clicks
Description The total number of subscribers who clicked on a campaign
Field type metric
Data type int.number.value
unsubscribes
Display name Unsubscribes
Description A list of members who unsubscribed from a campaign
Field type metric
Data type int.number.value

Table: LIST

contact
Display name Contact details
Description Contact information displayed in campaign footers
Field type dimension
Data type string.text.json
contact_address_1
Display name Address 1
Description The street address for the list contact
Field type dimension
Data type string.geo.street
contact_address_2
Display name Address 2
Description The street address for the list contact
Field type dimension
Data type string.geo.street
contact_city
Display name City
Description The city for the list contact
Field type dimension
Data type string.geo.city
contact_company
Display name Company
Description The company name for the list
Field type dimension
Data type string.text.value
contact_country
Display name Country
Description A two-character ISO 3166 country code
Field type dimension
Data type string.geo.country.twolettercode
contact_phone
Display name Phone
Description The phone number for the list contact
Field type dimension
Data type string.text.phone
contact_state
Display name State
Description The state for the list contact
Field type dimension
Data type string.geo.region
contact_zip
Display name Zip code
Description The postal or zip code for the list contact
Field type dimension
Data type string.geo.zip
date
Display name Date
Description Date, e.g. 2017-01-31
Field type dimension
Data type string.time.date
list_created_date
Display name List created
Description The date and time that the list was created in ISO 8601 format
Field type dimension
Data type string.time.date
list_email_type_option
Display name Multiple email formats
Description Whether the list supports multiple formats for emails
Field type dimension
Data type bool
list_id
Display name List ID
Description The unique id for the list
Field type dimension
Data type string.text.value
list_last_sub_date
Display name Last list subscribed
Field type dimension
Data type string.time.date
list_last_unsub_date
Display name Last list unsubscribed
Field type dimension
Data type string.time.date
list_modules
Display name List modules
Description Any list-specific modules installed for the list
Field type dimension
Data type string.text.json
list_name
Display name List name
Description The name of the list
Field type dimension
Data type string.text.value
list_notify_on_subscribe
Display name Notify email on subscribe
Description The email address to send subscribe notifications to
Field type dimension
Data type string.text.email
list_notify_on_unsubscribe
Display name Notify email on unsubscribe
Description The email address to send unsubscribe notifications to
Field type dimension
Data type string.text.email
list_open_rate
Display name List open rate
Description The average open rate per campaign for the list
Field type metric
Data type float.number.ratio
list_rating
Display name List rating
Description An auto-generated activity score for the list (0-5)
Field type dimension
Data type int.number.value
list_target_sub_rate
Display name Target subscription rate
Description The target number of subscriptions per month for the list to keep it growing
Field type metric
Data type float.number.ratio
list_unsubscribe_count
Display name Unsubscribes
Description The number of members who have unsubscribed from the list
Field type metric
Data type int.number.value
list_visibility
Display name List visibility
Description Whether the list is public or private
Field type dimension
Data type string.text.value
member_count
Display name Members
Description The number of active members in the list
Field type metric
Data type int.number.value
member_count_since_send
Display name Member count since last send
Description The number of active members in the list since the last campaign was sent
Field type metric
Data type int.number.value
permission_reminder
Display name Permission reminder
Description The permission reminder for the list
Field type dimension
Data type string.text.value
subscribe_url_long
Display name Subscribe URL (long)
Description The full version of the list's subscribe form
Field type dimension
Data type string.text.url
subscribe_url_short
Display name Subscribe URL (short)
Description Mailchimp's EepURL shortened version of this list's subscribe form
Field type dimension
Data type string.text.url
unsubscribe_count_since_send
Display name Unsubscribes since last send
Description The number of members who have unsubscribed since the last campaign was sent
Field type metric
Data type int.number.value