MailChimp is one of our favorite email marketing providers. For a great price- automation, segmentation, great templates, ecommerce integrations, and more stole our marketing hearts.
In this post, we’re going to review your options for connecting MailChimp email stats with your Google Data Studio reports and dashboards.
MailChimp Google Data Studio Connectors
|Connector||Data Sources||Pricing||Read Review||Free Trial|
|35+ Data Sources||$39/Month||Read Review||Free Trial||facebook ads, google analytics, custom, adform, adobe analytics, adroll, amazon ads, bing ads, facebook insights, public data, google ads, adsense, my business, search console, google+, instagram insights, linkedin ads, mailchimp, company pages, pinterest, quora, reddit, search 360, semrush, stripe, tumblr, twitter, vimeo, yahoo, yandex metrica, youtube, criteo||@supermetrics|
Power My Analytics
|25+ Data Sources||$9.95 Per Source||Read Review||Free Trial||facebook ads, adroll, amazon, bing, constant contact, criteo, ebay, insights, google my business, instagram ads, instagram insights, instagram media insights, linkedin ads, linkedin company analytics, listrak, mailchimp, paypal, pinterest, shareasale, tripadvisor, twitter, walmart, yahoo||@powermyanalytics|
|18+ Data Sources||Free||Read Review||Free||google analytics, file upload, bigquery, campaign manager, cloud spanner, cloud sql for mysql, display & video 360, extract data, google ad manager 360, google ads, google analytics, google cloud storage, google sheets, mysql, postgresql, search ads 360, search console, youtube analytics, tv attibution|
|400+ Data Sources||$499/Month||Read Review||Demo Available||adobe analytics, adjust, salesforce, shopify, instagram ads, google ads, bing ads, doubleclick, facebook ads, linkedin, twitter, appnexus, criteo, mediamath, snapchat, tradedoubler, yahoo, adform, adroll, appsflyer, google analytics, has offers, perfect audience, performant, ebay, google search console, impact radius, listrak, mailchimp, outbrain, peperjam, propel media, quora, reddit, taboola, yandex, pinterest||@funnel|
|16+ Data Sources||Custom Solutions||Read Review||None Currently||facebook ads,||@tapclicks|
Choosing the Best MailChimp Data Connector for GDS
MailChimp has a decent API which is more complicated in practice than we expected for sure. That said though, integrating Google Data Studio with MailChimp and grabbing the most important stats (sends, opens, bounces, etc.) is pretty simple and a few connectors will do it for you. There are features and benefits of each so consider these things when choosing.
- Data Points: As we mentioned, the MailChimp API is a actually a series of about 4 APIs, each of which provides a different view of data. One focuses on campaign data, another on list data, a third on historical data, etc. Always good to trial a couple different connectors to see which easily provides the view you need.
- Roll-Up MailChimp Reporting: If your goal is to create a dashboard or dashboards which report from multiple MailChimp accounts (agency account or not), you’ll want to consider one of the MailChimp connectors which features data blending for sure. Otherwise, just about any connector listed will do.
- Direct Connection vs Data Warehousing: With some connectors, you connect directly to the MailChimp API in real time. This means that you’ll pull data from MailChimp each time your report loads. With others (typically paid connectors), the connector itself will warehouse your data. This is done sometimes to improve reporting features. In the case of MailChimp, the complication of the API is made simple by services like Power My Analytics who combine APIs to give you data you need in a more clear way.
Because the MailChimp API is a bit more complex than most other data sources, we recommend giving free trials with any of the mentioned services a try. Each is easy to connect and grab data so you’ll get a view of what each can do for you quickly.