--- title: "Mailchimp connection guide" slug: "mailchimp-connection-guide" description: "Connect your Mailchimp data to Supermetrics with our guide on permissions, query types, and connection instructions for seamless reporting." tags: ["Marketing automation"] updated: 2026-07-08T09:01:07Z published: 2026-07-08T09:01:07Z canonical: "docs.supermetrics.com/mailchimp-connection-guide" --- > ## Documentation Index > Fetch the complete documentation index at: https://docs.supermetrics.com/llms.txt > Use this file to discover all available pages before exploring further. # Mailchimp connection guide This guide contains all permissions and requirements for connecting your Mailchimp data to Supermetrics. You can connect to data sources from the [Data sources page on the Supermetrics Hub](https://hub.supermetrics.com/token-management). On the Hub, you can also [share an authentication link](https://docs.supermetrics.com/v1/docs/how-to-connect-to-data-sources-from-supermetrics-hub#share-authentication-link) to connect to a data source you don't have direct access to. After you connect to the data source on the Hub, you can use the data source connection in [all available destinations](/docs/mailchimp-connection-guide#connection-instructions). ## Required permissions To connect Supermetrics to Mailchimp, you need a Mailchimp user account with either of these user roles: - Owner - Admin [Learn how to grant access to a user account in Mailchimp's documentation](https://mailchimp.com/help/manage-user-levels-in-your-account/). ### Multi-account login It's not possible to log into Mailchimp in Supermetrics with multiple accounts. If you've authenticated with Mailchimp credentials that have access to multiple Mailchimp accounts, there's a risk that future refreshes will show unpredictable combinations of data from any of the accounts that the original account has access to. [Learn more about how to navigate multiple Mailchimp accounts.](/v1/docs/mailchimp-permissions-troubleshooting-guide) ### Incompatible fields You might encounter this error when pulling data from Mailchimp in Supermetrics with either Google Sheets or Data Studio: - `Incompatible fields: IllegalDimensionMetricCombinationException` [Learn how to fix this error](/v1/docs/about-incompatible-fields-or-dimensions-errors-in-mailchimp-queries). ## Query types Query types define what sort of metrics and dimensions are available. Set up your Mailchimp queries using any of the query types described below: ****Reference list: Mailchimp query types**** - **Automations**: Returns automations. Does not include customer journeys. - **Automation emails**: Returns individual emails in a classic automation workflow. - **Lists**: Returns Mailchimp lists, also known as "audience". - **Campaigns**: Returns campaigns from your Mailchimp account. - **List activity**: Returns daily aggregated activity stats for your list. For example, view unsubscribes, signups, total emails sent, opens, clicks, and more, for up to 180 days. - **List growth history**: Returns a summary of the month-by-month growth activity for a specific list. - **List locations**: Returns locations (countries) of subscriber lists. - **List members**: Returns members of a specific Mailchimp list, including currently subscribed, unsubscribed, and bounced members. ## Connection instructions When connecting to Mailchimp, you need to log in to Mailchimp and select the campaigns or lists to include in your reporting. 1. Select the Mailchimp data source [on the Supermetrics Hub](https://hub.supermetrics.com/token-management) or in the data destination. 2. If prompted, choose to make this connection [shared or private](https://docs.supermetrics.com/docs/about-shared-and-private-connections). 3. Click **Start**. 4. Log in to Mailchimp. 5. Select an account, and click **Allow**. 6. In your data destination, select the campaigns or lists you'd like to include in your reporting. See detailed instructions on [how to connect to a data source from the Supermetrics Hub](https://docs.supermetrics.com/docs/how-to-connect-to-data-sources-from-supermetrics-hub). You can also connect to Mailchimp from these destinations: - Google Sheets: [How to connect to a Supermetrics data source in Google Sheets](https://docs.supermetrics.com/docs/how-to-connect-to-a-supermetrics-data-source-in-google-sheets) - Data Studio: [How to connect data sources to Data Studio](/v1/docs/how-to-connect-data-sources-to-data-studio) - Excel: [How to connect data sources to Excel with Supermetrics](https://docs.supermetrics.com/docs/how-to-connect-data-sources-to-excel-with-supermetrics) - Power BI: [How to create your first Supermetrics query for Power BI](https://docs.supermetrics.com/docs/how-to-create-your-first-supermetrics-query-for-power-bi) - The Supermetrics API: [How to use the Query Manager](https://docs.supermetrics.com/docs/how-to-use-the-query-manager) - Data warehouse and cloud storage (Hub): [How to create a transfer](https://docs.supermetrics.com/docs/how-to-create-a-transfer) - BigQuery (marketplace): [How to create a BigQuery (marketplace) transfer](https://docs.supermetrics.com/v1/docs/how-to-create-a-bigquery-marketplace-transfer) ## More resources - [Mailchimp report building guide](/v1/docs/mailchimp-report-building-guide) - [Mailchimp: Permissions troubleshooting guide](/v1/docs/mailchimp-permissions-troubleshooting-guide) - [About incompatible fields errors in Mailchimp](/v1/docs/about-incompatible-fields-or-dimensions-errors-in-mailchimp-queries) - [How to reauthenticate a data source connection](/v1/docs/how-to-reauthenticate-a-data-source-connection) - [How to manage data source connections on the Supermetrics Hub](https://docs.supermetrics.com/docs/how-to-manage-data-source-connections-on-supermetrics-hub)