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. On the Hub, you can also share an 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.
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.
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.
Incompatible fields
You might encounter this error when pulling data from Mailchimp in Supermetrics with either Google Sheets or Looker Studio:
- Incompatible fields: IllegalDimensionMetricCombinationException
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:
- 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.
- Select the Mailchimp data source on the Supermetrics Hub or in the data destination.
- If prompted, choose to make this connection shared or private.
- Click Start.
- Log in to Mailchimp.
- Select an account, and click Allow.
- 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.
You can also connect to Mailchimp from these destinations:
- Google Sheets: How to log in to a Supermetrics data source in Google Sheets
- Looker Studio: How to connect data sources to Looker Studio
- Excel: How to connect data sources to Excel with Supermetrics
- Power BI: How to create your first Supermetrics query for Power BI
- The Supermetrics API: How to use the Query Manager
- Data warehouse and cloud storage (Hub): How to create a transfer
- BigQuery (marketplace): How to create a BigQuery (marketplace) transfer
More resources
- Mailchimp report building guide
- Mailchimp: Permissions troubleshooting guide
- About incompatible fields errors in Mailchimp
- How to reauthenticate a data source in Google Sheets, Looker Studio, Excel, or Power BI
- How to reauthenticate a data source in data warehouse, API, or cloud storage platform
- How to manage data source connections on the Supermetrics Hub