Mailchimp Data Connector User Guide
The following article is a guide to automating reports with your Mailchimp connector. It includes information on available data as well as currently unavailable data and tips on how to get the most out of your Mailchimp reports. To begin creating reports with your Mailchimp connector, you will need at least one Mailchimp account as well as access to Looker Studio or Google Sheets.
Available Data
- List Growth - The list growth report can show monthly data, not daily.
- List Performance - Beginning on the day you connected.
- Geo Breakouts - By country, region, and city.
- Breakdowns - For Regular and Classic Automation campaigns.
- Unsubscribe data - Broken down by counts and reason.
- Landing Pages - By list name, not campaign.
- Complete List of Fields.
API Limitations
- Reporting by Day - All data is "lifetime" so sends, opens, and clicks cannot be reported by day.
- Reporting by email address and links - Reporting by email address and by link clicked in email is not available due to Mailchimp API limits.
- Backfilling historical data - Mailchimp's API does not support backfilling of historical data. All data will be warehoused beginning on the day you first create a report.
- Journeys - Mailchimp's API does not support reporting customer Journeys.
- Automations - The Mailchimp connector only supports classic automations.
- Summary rows - Creating a summary row for click rate or open rate will produce incorrect figures. This is because Mailchimp's API does not send summary values.
- Custom fields - Custom fields are not available.
Connection Requirements
An account with Admin or Owner access is required for a successful connection. To grant access to an account, go to Account and click Settings > Users. Click Invite A User.
Enter the user's email address and select the Admin role.
Tips And Tricks
Select date ranges that begin with the create date of the campaign to see reports on sends, opens, and clicks.
You can also use Looker Studio's Running Delta function to create a chart that shows sends over time.
Troubleshooting
Follow the instructions in our Basic Troubleshooting guide to get your reports working again.
Still having issues?
Send us a ticket and we will get back to you.
Related Articles
Taboola Data Connector User Guide
The following article is a guide to automating reports with your Taboola connector. It includes information on available data as well as currently unavailable data and tips on how to get the most out of your Taboola reports. To begin creating reports ...AdRoll Data Connector User Guide
The following is a guide to automating reports with your AdRoll connector. It includes information on available data as well as currently unavailable data and tips on how to get the most out of your AdRoll reports. To begin creating reports with your ...eBay Data Connector User Guide
The following is a guide to automating reports with your eBay Seller connector. It includes information on available data as well as currently unavailable data and tips on how to get the most out of your eBay Seller reports. To begin creating reports ...Quickbooks Data Connector User Guide
The following article is a guide for automating reports with your Quickbooks connector. It includes metrics available and things to know about the connector. To create a report, you will need access to at least one or more Quickbooks online accounts ...Stripe Data Connector User Guide
The following article is a guide to automating reports with your Stripe connector. It includes information on available data as well as currently unavailable data and tips on how to get the most out of your Stripe reports. To begin creating reports ...