--- 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-05-06T11:47:17Z published: 2026-05-06T13:26:01Z --- > ## 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](/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](/v1/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](/v1/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.](/v1/docs/how-to-connect-to-data-sources-from-supermetrics-hub) You can also connect to Mailchimp from these destinations: - Google Sheets: [How to log in to a Supermetrics data source in Google Sheets](/v1/docs/how-to-connect-to-a-supermetrics-data-source-in-google-sheets) - Data Studio: [How to connect data sources to Looker Studio](/v1/docs/how-to-connect-data-sources-to-looker-studio-formerly-data-studio) - Excel: [How to connect data sources to Excel with Supermetrics](/v1/docs/how-to-connect-data-sources-to-excel-with-supermetrics) - Power BI: [How to create your first Supermetrics query for Power BI](/v1/docs/how-to-create-your-first-supermetrics-query-for-power-bi) - The Supermetrics API: [How to use the Query Manager](/v1/docs/how-to-use-the-query-manager) - Data warehouse and cloud storage (Hub): [How to create a transfer](/v1/docs/how-to-create-a-transfer) - BigQuery (marketplace): [How to create a BigQuery (marketplace) transfer](/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 in Google Sheets, Looker Studio, Excel, or Power BI](/v1/docs/how-to-reauthenticate-a-data-source-connection-in-google-sheets-looker-studio-excel-power-bi-and-supermetrics-hub) - [How to reauthenticate a data source in data warehouse, API, or cloud storage platform](/v1/docs/how-to-reauthenticate-a-data-source-connection-in-data-warehouse-destinations-or-the-supermetrics-api) - [How to manage data source connections on the Supermetrics Hub](/v1/docs/how-to-manage-data-source-connections-on-supermetrics-hub)