Mailchimp Email Marketing
is a Power BI app that connects to your Mailchimp account and analyzes the performance of your campaigns. The app requires an active Mailchimp account and API Access Key to refresh automatically. You can explore the various pages on the left sidebar to analyze different aspects of your campaign, including a campaign view, tagged audiences, performance analysis, and unsubscription reasons. The app enables interactive view to 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 bring additional data sources into the same Power BI report.
- Audience Analysis page: Analyze audience and measure members' performance: open rates, CTR and 5-stars rating
- Members Merge Fields page: Analyze the number of members and their open rates by merge fields and export the data from the Maxtrix visual
The basic version of this app is free. It allows you to import your last 6 months of recently-created campaigns, up to 500 members per list, and up to 5 unsubscribers per campaign. To lift these limitations, you can subscribe for the Premium version here. The Premium subscription will allow you to import all historical data.
With both free and premium versions, the report layout can be edited, and the data can be imported or connected live via Excel and Power BI to build your own reporting tools from your Mailchimp data.