Mailchimp

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.

  1. Click on the Data tab at the top left of the global navigation. Then click on Connections in the Data Library section.
  2. Click on the blue Connect button and search for Mailchimp.
  3. Click on the Mailchimp logo.
  4. 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: Includes status, emails sent, recipients details, content type, opens information, settings and tracking details, and total revenue, among other details.
  • Get All of the Lists: Includes Name, contact details, campaign count and details, open and click rates, and average subscribe/unsubscribe rates, among other details.
  • Growth History: Includes List ID, Month, Existing, Imports, and Options.
  • List Activity: Includes day, emails sent, unique opens, recipient clicks, bounce information, subscribers/unsubscribers, among other details.
  • Campaign Top Open Locations: Includes country code, region, opens, and campaign ID.

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.

Was this article helpful?