Mailchimp Data Connector User Guide

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

  1. List Growth - The list growth report can show monthly data, not daily.
  2. List Performance - Beginning on the day you connected.
  3. Geo Breakouts - By country, region, and city.
  4. Breakdowns - For Regular and Classic Automation campaigns.
  5. Unsubscribe data - Broken down by counts and reason.
  6. Landing Pages - By list name, not campaign.
  7. Complete List of Fields.

API Limitations

  1. Reporting by Day - All data is "lifetime" so sends, opens, and clicks cannot be reported by day.
  2. Reporting by email address and links - Reporting by email address and by link clicked in email is not available due to Mailchimp API limits.
  3. 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.
  4. Journeys - Mailchimp's API does not support reporting customer Journeys.
  5. Automations - The Mailchimp connector only supports classic automations.
  6. 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.
  7. Realtime data - Realtime data is not available.
  8. 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.




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.
    Submit a ticket

      • Related Articles

      • 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 ...

      • Criteo Data Connector User Guide

        This guide will walk you through the process of connecting your Criteo account to Power My Analytics and creating reports using the data. Criteo is a powerful advertising platform specializing in retargeting, customer acquisition, and personalized ...

      • BigCommerce Data Connector User Guide

        Are you looking to streamline your BigCommerce data analysis and reporting? Power My Analytics' BigCommerce connector automates the collection and integration of your e-commerce data, saving you time and providing deeper insights into your online ...

      • PayPal Data Connector User Guide

        PayPal is a widely used payment processing platform, and integrating its data into your analytics workflow can provide valuable insights into your business performance. This guide will walk you through the process of setting up PayPal as a data ...

      • SharpSpring Data Connector User Guide

        SharpSpring is a powerful marketing automation and customer relationship management platform that helps businesses streamline their marketing efforts and manage leads effectively. This guide will walk you through the process of connecting SharpSpring ...