Mailchimp allows you to send marketing emails, automated messages, and targeted campaigns. With this integration, managing email engagement data is simple. Even more powerful, you can visualize it alongside other key marketing data, enabling you to be more agile and capitalize on opportunities. This article will give you an overview of the Mailchimp/Grow integration and what you can expect.
Data Warehouse
Mailchimp is on the Grow Data Warehouse, which we highly recommend you use. For more information about warehousing your data, visit the Data Warehouse Help Article.
Suggested Tables
The following suggested tables are available in Grow. These are toggled on by default when you sync your data for the first time.
- Campaign Folders
- Campaign Top Open Locations
-
Campaigns
- Campaigns (Formatted)
-
Email Activity
- Email Activity (Formatted)
- Growth History
-
Landing Pages
- Landing Pages (Formatted)
- List Activity
-
Lists
- Lists (Formatted)
-
Members
- Members (Formatted)
- Member Tags
-
Reports
- Reports (Formatted)
- Report Time Series
-
Stores
- Stores (Formatted)
Other Tables
These additional tables are available in Grow.
-
Automations
- Automations (Formatted)
-
Connected Sites
- Connected Sites (Formatted)
-
Conversations
- Conversations (Formatted)
-
Facebook Ads
- Facebooks Ads (Formatted)
- Files
- Verified Domains
Connecting to Mailchimp
Before starting, please collect your Mailchimp login information.
- Click on the Data tab at the top left of the global navigation.
- Click on Connections in the Data Library section.
- Click on the blue Connect button and search for Mailchimp.
- Click on the Mailchimp logo.
- A window will pop up to log in with your Mailchimp credentials. After entering your credentials you will see a green confirmation message that the connection has been made.
And that's it! You are good to go.
Endpoints
Below is a list of reports from Mailchimp and the fields associated with each one.
Get a List of Campaigns
- Status
- Emails sent
- Recipients details
- Content type
- Opens information
- Settings and tracking details
- Total revenue
- Other details
Get All of the Lists
- Name
- Contact details
- Campaign count and details
- Open and click rates
- Average subscribe/unsubscribe rates
- Other details
Growth History
- List ID
- Month
- Existing
- Imports
- Options
List Activity
- Day
- Emails sent
- Unique opens
- Recipient clicks
- Bounce information
- Subscribers/unsubscribers
- Other details
Campaign Top Open Locations
- Country code
- Region
- Opens
- Campaign ID
- Other details
FAQs + Tips and Tricks
Mailchimp API reporting issues
Mailchimp has a few reports that come back as 0, when there should be data. We have sent these to Mailchimp and they acknowledged that the issue is on their side and are fixing them.
Timezone Offset Might be Needed
Since Mailchimp deals with scheduled mailings, sometimes a timezone offset might be required to get your data to match up exactly with what Mailchimp displays in their admin charts. Grow has help articles for this.