Power BI

Power BI allows you to easily monitor and visualize your MailChimp data.

Developer
Microsoft
Last Updated
June 2015
Rating

5

The Power BI content pack pulls data from your MailChimp account and generates a dashboard, a set of reports and a dataset to allow you to explore your data. Use MailChimp’s analytics to quickly identify trends within your campaigns, reports, and individual subscribers. Find out who your most engaged subscribers are, which countries open the most campaigns, or how trends have changed over time. Power BI lets users drill down into their MailChimp data without any coding knowledge, and automatic data updates help you make the most informed decisions possible.

Support

Website

This description was submitted by the integration’s developer. MailChimp lists available integrations for customer convenience only, and we don’t endorse or guarantee these services or products.

Reviews

Power BI

6/01/2016

Thanks for all of your feedback. We've been working over the last few months to add features to both the Power BI Desktop connector and the web-based content pack. The new content pack (which was released today) contains 17 data tables in an enhanced data model, along with improved reports and dashboard. Head over to https://app.powerbi.com/groups/me/getdata/services/mailchimp to get the latest version.

The Desktop connector (which will be available in the next release of Power BI Desktop at the end of June) contains the same 17 tables, in addition to two functions that advanced users can use to query the MailChimp API directly. Give it a shot and let us know what you think!

Lasse

5/18/2016

Not quite there yet, I would say. The content pack for Power BI Service is okay, but it lacks some fundamentals. For example, I'd like to show the development of the members count of lists over time, but it doesn't seem to be possible just yet. Also, the location data is not compatible with Power BI's built-in maps. For example, the regions in Germany are displayed as DE_TH, DE_RP etc., which leads Power BI to think these are in Africa and America. Otherwise, it sure is a great idea to integrate Mailchimp into Power BI! Hope the "beta" status of the connector will change over time.

Power BI

6/01/2016

Hi Lasse, Thanks for your feedback. The newly updated content pack allows you to see 100 days of history of changes to any list's member count. After you have instantiated a new version of the content pack from https://app.powerbi.com/groups/me/getdata/services/mailchimp, check out the column chart in the lower right corner of the List Overview report page. You can see results compiled for all of your lists, or select a particular list in the slicer on the left side of the page.

Martin

5/10/2016

We are using the PowerBU Content Pack for MailChimp but having an issue trying to use the Unique Campaign measures. In particular the calculated UniqeOpens only seems to show unique open percentage for all the campaigns in my account whereas I want to be able to show the unique open percentage for a particular campaign. Is there someone that can help me where I may go wrong please.

As always, thank you for your help and a great tool. we love MailChimp.

Best,

Martin

Power BI

6/01/2016

Hi Martin, We've updated the content pack's handling of unique measures in a way that should make more sense. Go ahead and instantiate a new content pack at https://app.powerbi.com/groups/me/getdata/services/mailchimp. You can find unique opens on the Campaign Overview report page. Simply select a campaign in the list on the left to see the unique measures in a gray box on the right.

Josh

4/26/2016

I second what the other reviewer said. In PowerBI desktop I currently only have 5 tables to work with, but online there is at least double that. It is still in Beta so they are working on it but the desktop integration is all but useless until they get the integration a bit more mature.

Power BI

6/01/2016

Hi Josh, An updated version of the Power BI Desktop connector will be coming at the end of June, which will allow access to 17 data tables. Thanks for giving the Beta connector a try!

Splitsville

12/15/2015

Getting there. Not sure if it's a MailChimp thing or if it's a Microsoft thing, but there's a huge difference in usable data between the PowerBI desktop vs. the web version. Web has some pretty nice data features built into it, though not exactly what I need, but desktop offers very different data to work with. Big discrepancy.

Desktop version also doesn't allow for nearly the same data shaping customization as other integrated apps do, like Google Analytics for example. One day this will be awesome, just not quite there yet.

Power BI

6/01/2016

Hi Splitsville, We've been working to add features to both the Desktop and web offerings to enhance the usefulness and bring them closer to parity. The improved web content pack was just released today, you should check it out at https://app.powerbi.com/groups/me/getdata/services/mailchimp and see if any of the improvements help your use case. The new Desktop connector will be included with the end-of-June release of Power BI Desktop so be sure to check that out too!