Analytics for Mailchimp

Analytics for Mailchimp is a Power BI app that connects to your Mailchimp account and analyzes the performance of your campaigns. An active Mailchimp account is needed to import the data. You can explore the various pages on the left sidebar to analyze different aspects of your campaign, including campaign performance, subscriber growth rate, tagged audiences, unsubscription reasons, member analytics, and much more. The app enables interactive views on crucial email marketing KPIs such as open rates, CTR (Clickthrough Rate), and CTOR (Click-to-Open Rate).

The app can act as a Mailchimp connector. Its dataset can be available from new Power BI reports and Excel workbooks. You can even build a composite model that connects to the dataset and brings additional data sources into the same Power BI report.

What's New

• A new 30-day trial without refresh limits: During the trial, you can load all your Mailchimp data (unlike the previous version which had loaded limited data only). You automatically get a 30-day trial after you start refreshing the app. No need to enter any email address. When the trial is over, you can subscribe to one of the paid subscriptions and activate the app.
• New page: Subscriber Growth Rates. The new page provides you audience growth rates with month-over-month and year-over-year calculations and improved calendar table that includes weeks.
• Faster refresh time for key tables.
• Improved filtering logic: In the previous version, you needed to apply fixed dates to load data. In this version, you can load all data or keep the data fresh by selecting how many months to load.
• Improved normalized contacts with custom fields for Job Title, Company, Address fields, Age, and Gender.

Additional features:

• Email Activity page and measures: The lowest grain of email activity is available with the resolution of active contacts and the campaigns they opened including the count of opens, clicks, and bounces per active contact and campaign.
• Member Analysis: Analyze audience by members' open rates, CTR, and 5-star rating.
• Members: A page for export scenarios: All members including the merged fields: company, job title, gender, age, and activity fields count of opens, open rate, count of clicks, and click rate (CTR).
• Members - Decomposition Tree: A page for member analysis using a decomposition tree.
• High customizations using Power BI: The report can be edited in Power BI service, or get connected live from another report in Power BI Desktop, and Excel.

We respect your privacy; while we do not access your Mailchimp API key or collect personal data, we do gather minimal account-related information to ensure smooth trial activation and subscription management. This includes your Mailchimp account name, ID, subscriber count, and the name of your mailchimp user.