This guide will walk you through how to authenticate or reauthenticate Mailchimp in Supermetrics for Google Sheets, Data Studio, and Excel, as well as data warehouse destinations like Google Cloud Storage, BigQuery, and the Supermetrics API.
Before you begin
To connect Supermetrics to Mailchimp, you need a Mailchimp user account with an Owner or Admin user role level. See Mailchimp’s documentation for instructions on how to grant access for a user 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 pulling data from multiple Mailchimp accounts.
- 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.
Incompatible fields
You might encounter this error when pulling data from Mailchimp in Supermetrics with either Google Sheets or Data Studio:
- Incompatible fields: IllegalDimensionMetricCombinationException
To fix this error, follow these steps.
Instructions
- Open a new Google Sheets file.
- Navigate to Extensions → Supermetrics → Launch to open the Supermetrics sidebar.
- Under Data source, select the data source.
- Click Start.
- Select an account.
- Click Allow.
- Under Select campaigns/lists, select your campaign/lists.
- Open the Supermetrics data source gallery.
- Navigate to Mailchimp and click Try.
- Click Authorize.
- If you're authenticating the data source for the first time, log in with the Google Account you use with Supermetrics. Click Allow.
- Click Authorize.
- Enter your credentials and click Log in.
- Select an account.
- Click Allow.
- Select the campaigns you'd like to include in your reporting.
- Select a query type.
- Scroll down to the bottom of the page. To create a report with our template, select Use report template for new reports. To create a blank report, deselect this option.
- Click Connect on the top right-hand side.
- Click Create report.
- Click Add to report.
Add or remove a user account in Data Studio
- Click the edit icon next to the data source's name in the Data Studio sidebar.
- At the top left of the connection pane, click Edit connection.
- Scroll down to Parameters.
- Browse team, account, and license management options in the section beginning "To add more/manage accounts..."
Connections
If you use Excel and no other Supermetrics products, you’ll be able to connect accounts to data sources and share these connections with your team. You can manage connections either within the add-in sidebar or via the Supermetrics Team Site. Learn more about shared connections.
Before you can authenticate the data source in Excel, you need to install the Supermetrics add-in.
- Open an Excel file.
- Click Data → Show Supermetrics.
- Under Data source, select Mailchimp.
- Choose to make this connection shared or private.
- Click Start.
- Select an account.
- Click Allow.
- Select the campaigns and lists you'd like to include in your reporting.
Explore our guides to set up data transfers to various destinations.
- BigQuery
- Data warehouses and cloud storage (Amazon S3, Google Cloud Storage, Snowflake, Azure Storage, or Azure Synapse)
- The Supermetrics API
Reauthenticate the data source
Troubleshooting
- If you encounter an authentication error such as “authentication failed”, “you need to reauthenticate” or similar, see this guide.
- If you encounter a permission error such as “user permission denied” or similar, follow this guide.