The DataHero Blog

MailChimp Analytics and Dashboards

September 25th, 2018

MailChimp is a longstanding leader in email marketing and marketing automation known for its easy to use platform for creating templated email marketing campaigns. Encompassing both MailChimp and Mandrill, for transactional email sends, it’s easy to see why MailChimp has become so widely used in the industry. While there are built-in MailChimp analytics, savvy email marketers know that you often need to dive further into the details of individual campaigns, subscriber lists, or tags in order to pull actionable insights from your data. That’s where DataHero’s direct connection to MailChimp and Mandrill provide a fast and easy to use platform to create custom charts, reports, and dashboards from your data for deeper MailChimp analytics.

As longstanding partners of MailChimp, we’re proud to offer a platform that helps our customers create insightful data visualizations of their email marketing data. In this post, we’ll walk you through how to go beyond the standard MailChimp reports to create charts, reports, and dashboards of your MailChimp data that you can share with teams and stakeholders using Datahero.

datahero-mailchimp-reporting

 

To begin, simply connect your MailChimp or Mandrill accounts by authenticating with your MailChimp credentials. Both MailChimp and Mandrill share the same MailChimp login credentials, so it’s easy to get connected, but you will have to separately authenticate and connect each service. Once you’ve connected, it’s as simple as clicking ‘IMPORT DATA’ and selecting the campaign or subscription list that you want to analyze and visualize.

 

datahero-mandrill-import

 

Once you’ve selected your dataset, DataHero will do all of the heavy lifting for you, including pulling in all of your data from MailChimp or Mandrill directly into a data warehouse, handling the ETL service, and providing automatic data classification to the columns in your data. After that, it’s as simple as creating a new chart to be able to drag and drop data attributes from your campaigns to visualize the results of your MailChimp data. You can pull multiple data attributes in to look at a combination of results across opens and clicks by date, for example. You can also filter your results to focus in just on a specific time frame or a specific Tag.

 

datahero-mandrill-chart

 

DataHero gives you both powerful functionality as well as drag-and-drop ease, so you can create powerful insights without the need for a data analyst or BI team – no coding or SQL queries required. There are also a variety of chart types and you can customize your charts and reports with your custom brand marks and color schemes for sharing with teams, clients, or stakeholders. Besides the direct sharing options, DataHero also allows you to embed your charts on 3rd party websites, blogs, and wikis so you can place dynamic, interactive data visualizations wherever you want.

 

datahero-mailchimp-large-chart

 

Another powerful feature is the ability to combine your datasets between MailChimp and Mandrill, as well as any of our 40+ 3rd party data connectors. Simply select a unique, shared primary key between your datasets (i.e. email address) and you’ll be able to combine datasets and create charts and reports across a combined set of data attributes.

 

datahero-mailchimp-mandrill-combine

 

Lastly, arrange and organize your charts into customized reports and dashboards that you can easily export to PDF, share by public link or by email, or control through role-based permissions. DataHero gives you the flexibility to take your email marketing data and create customized MailChimp analytics that go beyond the standard built-in functionality of the core platform.

 

datahero-mailchimp-dashboards

 

Best of all, it’s incredibly easy to get started. Simply sign up for a free 14 day trial of DataHero and you can begin getting faster, easier insights into your email marketing and marketing automation data and discover MailChimp analytics like never before.

 

Happy dashboarding!

 

By Alex Hsi

Create my Free DataHero Account

Get the fastest, easiest way to understand your data today.