To keep your Mailchimp data from different accounts separate in your reports, connect each Mailchimp account with its own login.
If you've authenticated with Mailchimp login credentials that have access to multiple Mailchimp accounts, future data refreshes in Supermetrics may show mixed-up data from any of the accounts that you have access to. Resolve account issues by setting up a separate connection for each account.
The best practice is to assign unique email addresses to each business account. This means you should log in with a different email address for each business account. To add a new connection to your data destination, follow these steps in this guide.
Instructions
AI chats and Supermetrics MCP
On the Supermetrics Hub, go to Data sources under Connect.
Select the Mailchimp data source.
Click Add new connection.
Now that you have multiple Mailchimp accounts, in your AI tool, specify the account to use by name in your prompt.
Google Sheets and Excel
Connect to Mailchimp from the Supermetrics sidebar in Google Sheets or Excel.
Under Data source, click the chevron next to the data source's name.
Click Add connection.
Data Studio (formerly Looker Studio)
Follow these instructions to add a new user.
Power BI
Go to the Power BI query list on the Supermetrics Hub.
Select a Mailchimp query.
In the sidebar, click New connection.
The Supermetrics API
On the Supermetrics Hub, go to API queries under Manage.
Select the Mailchimp data source.
Click Add new connection.