Use the Mailchimp data source connector to pull all data related to your email campaigns, including campaign details, industry, time, and A/B testing details. Store data in your chosen destination and create historical reports to see which campaigns have worked best.
Before you begin
Before you build reports, you need to connect the data source to Supermetrics.
Connection instructions: See our Mailchimp connection guide.
Available metrics and dimensions: Find the full list of fields in our Mailchimp field documentation.
Query types
In Looker Studio, you must select a query type when connecting to Mailchimp:
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 audiences.
Campaigns: Returns campaigns from your Mailchimp account.
List activity: Returns daily aggregated activity stats for your list, including unsubscribes, signups, total emails sent, opens, and clicks, for up to 180 days.
List growth history: Returns a month-by-month summary of growth activity for a specific list.
List locations: Returns the countries of your subscriber lists.
List members: Returns members of a specific Mailchimp list, including currently subscribed, unsubscribed, and bounced members.
Note
If you need to use multiple query types in your Looker Studio report, you will need to create separate connectors for each query type. Learn more about query types in Looker Studio.
Popular queries
These query configurations help you track key performance indicators and analyze trends. You can use these settings in any Supermetrics destination, such as Data Explorer, Dashboards, Google Sheets, Looker Studio, or data warehouse destinations.
Check email open rate this month
See the overall open rate for emails sent through your campaigns this month — a quick pulse check on whether your subject lines and send timing are resonating with recipients.
To fetch this data, use the following settings in your reporting or visualization tool:
Setting | Value |
|---|---|
Query type (Looker Studio) | Campaigns |
Date range | This month to date |
Metrics | Open rate |
Suggested visualization | Scorecard |
Understanding the data
Open rate: The number of unique opens divided by the total number of successful deliveries.
See active member counts across mailing lists
Fetch all your mailing lists with their current active member counts — useful for understanding audience size across segments and identifying lists that may need re-engagement efforts.
To fetch this data, use the following settings in your reporting or visualization tool:
Setting | Value |
|---|---|
Query type (Looker Studio) | List members |
Metrics | Member count |
Dimensions | List name |
Suggested visualization | Table |
Understanding the data
Member count: The number of active members currently in the list.
List name: The name of the Mailchimp list, used to compare member counts across lists.
Compare sends, opens, and clicks by campaign
See how many emails were sent, how many were uniquely opened, and how many were clicked for each campaign — useful for identifying which campaigns are driving the most engagement and where to focus optimization efforts.
To fetch this data, use the following settings in your reporting or visualization tool:
Setting | Value |
|---|---|
Query type (Looker Studio) | Campaigns |
Metrics | Emails sent, Unique opens, Total clicks |
Dimensions | Campaign name |
Suggested visualization | Table |
Understanding the data
Emails sent: The total number of emails sent for the campaign.
Unique opens: The total number of unique recipients who opened the email.
Total clicks: The total number of clicks recorded for the campaign.
Campaign name: The name of the campaign, used to compare performance across campaigns.
Troubleshooting
You might encounter an Incompatible fields: IllegalDimensionMetricCombinationException error when pulling data from Mailchimp in Google Sheets or Looker Studio. Follow these steps to resolve incompatible fields errors in Mailchimp queries.
More resources
See the Supermetrics blog for the most important email marketing metrics.
You might also be interested in: