Category Archives: MailChimp

List Reports

list-reportsUse this Analytics Edge wizard to get reports on your MailChimp contact lists.

Select the type of report desired, and enter a list ID (or click the right button to pop up a listing of contacts lists to choose from).

Depending on the report selected, additional options and selections may be necessary or optionally offered.

 

 

Lists

listsUse this Analytics Edge wizard to get information about all MailChimp contact lists, or about an individual list.

Additional selection criteria is offered depending on the options you choose.

Campaigns

campaignsUse this Analytics Edge wizard to get information about all MailChimp campaigns, or about an individual campaign.

Depending on your selections, additional criteria may be available.

Campaign Reports

campaign-reportsUse this Analytics Edge wizard to get reports for a selected MailChimp campaign.

Enter the campaign ID, or click the right button to pop up a list of available campaigns.

Depending on your selections, additional criteria may be available.

Automations

automationsUse this Analytics Edge wizard to get a listing of the MailChimp Automations running in your account.

You can request a list of all Automations, or enter a workflow ID to get a specific one.

Campaign Overview Report

Core Add-in, MailChimp Connector
MailChimpCampaignOverviewReportReport on the most recent MailChimp campaign with this free workbook. You don’t have to struggle to recreate the online reports, we’ve done all the work for you! View the key campaign metrics along with list and industry averages. It also includes a  24-hour performance chart displaying opens and clicks.

Simple refresh in Excel is made possible by the Analytics Edge Core Add-inand the MailChimp Connector. Download your free trial today!

Download the workbook: MailChimpCampaignOverviewReport-1-31.xlsx

Recent Campaign Comparison

Core Add-in, MailChimp Connector
MailChimpRecentCampaignsComparisonThis free MailChimp report compares the performance of the last 3 campaigns, showing key metrics along with industry averages. It also includes a side-by-side chart displaying the 24-hour open and click performance of each campaign.

Simple refresh in Excel is made possible by the Analytics Edge Core Add-in and the MailChimp Connector. Download your free trial today!

Download the workbook: MailChimpRecentCampaignsComparison-1-31.xlsx

Activity for the Latest MailChimp Campaign

With the MailChimp Connector, Analytics Edge lets you automate more than just a data download – it lets you create a finished report that you can refresh with just a click. In this article, we’ll show how one click can get you a subscriber activity report for the most recent MailChimp campaign. No configuration needed – it’s all automatic!

mailchimp-activity014

 

Continue reading

Custom MailChimp Multi-Campaign Reports

A flurry of interest in the Analytics Edge MailChimp connector over the past few weeks has made me realize that most of the email marketing automation examples I have posted have focused on the Constant Contact connector. While all of it can be just as easily applied to MailChimp, there are a few differences in the products and how the connectors work. The automation potential is the same.

mailchimp-reports

A common challenge is producing multi-campaign summary reports. This type of report is actually really easy with the Analytics Edge Core Add-in; the process goes like this:

1. create an Analytics Edge macro that gets the campaigns of interest. It could be driven by a date range, specific keywords in the name, the segment it was sent to, or just dump the whole lot to a spreadsheet and let you manually edit it.

2. create an Analytics Edge repeating macro that steps through that list and grabs the metrics for each of the selected campaigns, merging them into a summary report as it does.

This process is demonstrated in the free Branded Agency Report. Note that these reports are very easy for me to produce with Analytics Edge, so if you have a custom reporting challenge, don’t be afraid to ask: I can usually deliver a proof-of-concept in no time.

 

* MailChimp Help

menuThe MailChimp Connector for Analytics Edge makes it easy to download your MailChimp campaign and list information into Microsoft Excel.

Start by opening the Accounts wizard to establish an Account to use.

NOTE: v3.0 of the connector uses a completely new authentication mechanism. If you used v2.x, you MUST replace all of your existing accounts with new entries (delete the old, add a new one).

 

 

 

 

Accounts

accountsUse this Analytics Edge wizard to log into your MailChimp account. This authorizes the Analytics Edge MailChimp connector for access to your account data.

Add Account – enter a reference name to identify the account you are using. The reference name does not have to be the same as the MailChimp account name.

Make Default – if you have more than one MailChimp account, you can make one of them the default account at any time. Queries can be configured to use the default account, so you can run the same macro with different accounts by changing the default instead of modifying every query in the macro.

Delete Account – deletes the selected account from the list.