Mailchimp

Mailchimp is a marketing automation platform and email marketing service.

Sync Mailchimp data to Sourcetable

Build reports once. Connect to Mailchimp and start modeling from live data.

Popular Use Cases

Mailchimp connector Sourcetable connector
Get a list of all active Mailchimp subscribers
Mailchimp + Sourcetable
Mailchimp connector MySQL connector
Create a list of all Mailchimp subscribers who are also active users
Mailchimp + MySQL
Mailchimp connector Stripe connector
Create a list of all Mailchimp subscribers who are paying customers in Stripe
Mailchimp + Stripe
Mailchimp connector PostgreSQL connector
Analyze engagement numbers for users who are also Mailchimp subscribers
Mailchimp + PostgreSQL
Mailchimp connector Salesforce connector
Create a list of all Mailchimp subscribers who are also Salesforce sales leads
Mailchimp + Salesforce
Here's a sample of the Mailchimp data that will be available in your Sourcetable spreadsheets:
AUTOMATION

Emails that send to subscribers when triggered by a specific date, activity, or event.

AUTOMATION_EMAIL

Emails that send to subscribers when triggered by a specific date, activity, or event.

AUTOMATION_RECIPIENT
AUTOMATION_RECIPIENT_ACTIVITY

Member activity for a specific campaign including opens, clicks and bounces.

CAMPAIGN

Campaigns are how emails are sent to a Mailchimp list.

CAMPAIGN_RECIPIENT
CAMPAIGN_RECIPIENT_ACTIVITY

Campaign activity for a list members including opens, clicks, and bounces.

CAMPAIGN_VARIATE_COMBINATION
LIST

Mailchimp lists, also known as audiences, is where contacts are stored and managed.

MEMBER

Members of a specific Mailchimp list, including currently subscribed, unsubscribed, and bounced members.

SEGMENT

A segment is a section of a list that includes only those subscribers who share specific common field information. Tags are labels used to organize your contacts.

SEGMENT_MEMBER

List members in a saved segment.

UNSUBSCRIBE

Information about list members who unsubscribed from specific campaigns.