Marketing: Analyze your email marketing performance using Mailchimp and ActiveCampaign

MailChimp allows you to improve your email marketing, offering the ability to send marketing emails and targeted campaigns. Power BI allows you to monitor and explore that data using the MailChimp APIs, offering a set of out-of-box content for your analytics. The dashboard, reports, and dataset curated for the MailChimp scenario allow you to easily access data such as Top Campaigns of Total Opens by Day of Week.

Connect to your Mailchimp or ActiveCampaign Email marketing services to Power BI and analyze the performance of your campaigns and audiences.

Sending out email campaigns by your business isn’t much help unless you can track and analyze your successes and failures and quickly adjust your messaging. While the best-of-breed email marketing services offer a good level of analytics and can track open and click rate data or offer color-coded charts and statistics, there is no better platform than Power BI to provide best-of-breed analytics capabilities to tune your email campaigns.

DataChant teamed up with DailyCookie to release two Power BI apps on AppSource to get you to the next level in understanding your email campaigns on Mailchimp and ActiveCampaign.

Mailchimp Email Marketing

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. In addition, the app enables the interactive view of crucial email marketing KPIs such as open rates, CTR (Clickthrough Rate), and CTOR (Click-to-Open Rate).

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 to the Premium version and 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.

Learn more about the app here.

ActiveCampaign Email Marketing

ActiveCampaign Email Marketing is a Power BI app that connects to your ActiveCampaign account and analyzes the performance of your campaigns. The app requires an active ActiveCampaign account and API Access Key to refresh automatically. Like the MailChimp app, 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. In addition, the app enables the interactive view of crucial email marketing KPIs such as open rates, CTR (Clickthrough Rate), and CTOR (Click-to-Open Rate).
This app was recognized by ActiveCampaign as an official app and is featured on their Apps & Integration portal here.

Learn more about the app here.