Are you using our Mailchimp connector, but you don't really know how it works? Don't worry, we are going to explain to you how this integration works and its basics to get the most out of it.

With the connector of Mailchimp, you can pull all data related to your email campaign, such as email campaign details, industry, and date. You will be able to store all your data in a report and see which campaign has worked best.

1. Query types available for Mailchimp data source.
You have three types of queries available when using the Mailchimp connector. You must select an "Account" inside of Dataslayer Sidebard to use:
Automation
Lists
Campaigns

2. You can select all "Accounts" in one click.
If you have many campaigns in Mailchimp you can select all at once instead of going one by one. To do this, in the "Accounts" field you must click on the type of automation you want in your query and all of them will be added.



3. Schedule your reports to update automatically.
Following the steps in these FAQs you will learn how to schedule an automatic update of your query in Google Sheets or report in Looker Studio

4. By choosing the date dimension using this connector, you will get the creation date of the campaign, list ,or automation.
You would obtain the data of the emails that have some change in their metrics in that date range.

Example of queries

These are some of the most typical queries you can make with our Mailchimp connector:

Open rate queries

Open rate
Metrics
Open rate
Industry open rate
Dimensions
Campaign ID

Number of members on your mailing list queries

Members on your mailing lists
Metrics
Member count
Dimensions
List name

Emails sent, opened, and clicked per campaign queries

Emails sent, opened, and clicked per campaign
Metrics
Email sent
Unique opens
Total clicks
Dimensions
Campaign name

As always, please contact us via our live chat on our website or via email if you still have doubts or questions. We are happy to help!

Updated on: 29/02/2024