blog post

How to connect Mailchimp to Looker Studio : How-to, templates and metrics...

Florian Cabirol
September 11, 2024
How to connect Mailchimp to Looker Studio : How-to, templates and metrics...

Quick steps to create a Mailchimp report with Google Sheets:

You can easiliy create a Mailchimp report following this step :

  1. Get informations from the data integration from our Mailchimp connector.
  2. Create a source on catchr.io.
  3. Download our Google Sheets extensions.
  4. Configure and run your request
If you need more informations, you can follow the tutorial.

How to install Google Sheets Catchr Add-on.

To start exporting your Mailchimp data to Google Sheets, you need to install the Catchr add-on. You currently have two options :

Option A: Via the marketplace:

  1. Visit the Catchr Add-on page on the Google Workspace Marketplace and click "Install."
  2. Grant the necessary permissions for the add-on.
  3. Upon successful installation, open a Google Sheets to proceed.
Connect Google Sheet to Facebook Ads
Install Catchr Google Sheets Add-on

Option B: Directly within a Google Sheets:

  1. Open a new Google Sheets.
  2. In the top menu, click "Extensions", then hover over "Add-ons" and select "Get add-ons."
  3. Search for "Catchr" and choose "Catchr - data connector."
  4. Click "Install" and grant the required permissions.
  5. Close the installation pop-up when completed.
  6. Start using the Catchr add-on.
Install Catchr Add-on for Google Sheets
Install Catchr Add-on for Google Sheets

Once you have installed the add-on, you can start making requests.

The tutorial

Quick steps to create a Mailchimp report with Looker Studio:

You can easiliy create a Mailchimp report following this step :

  1. Get informations from the data integration from our Mailchimp connector.
  2. Create a datasource and new report on Looker Studio.
  3. Choose your metrics and dimensions.
  4. Use charts with your metrics and dimensions.
If you need more informations, you can follow the tutorial. You can also find a template for Mailchimp at the end of the page.

The tutorial

Quick steps to create a Mailchimp report with PowerBI:

You can easiliy create a Mailchimp report following this step :

  1. Get informations from the data integration from our Mailchimp connector.
  2. Create a source on catchr.io.
  3. Configure your request on the PowerBI request manager.
  4. Copy the given URL in PowerBI
If you need more informations, you can follow the tutorial. You can also find a template for Mailchimp at the end of the page.

The tutorial

Understanding your marketing data is crucial to driving successful campaigns. This tutorial will guide you through the process of connecting your Mailchimp account to Looker Studio, formerly Google Data Studio. By the end, you’ll be able to transform your Mailchimp data into insightful, customizable reports and dashboards, allowing you to make data-driven decisions for your marketing strategies.

How to connect your Mailchimp account to Looker Studio

Create an Account on Looker Studio

To embark on your journey with Looker Studio, if you're new, you'll initiate by setting up an account. As Looker Studio is part of the Google family, all you need to do is link your existing Google account.

Creating Looker Studio Account

Connect Mailchimp to Looker Studio

Follow this detailed guide with ease to bridge your Mailchimp data with Looker Studio:

  • Navigate to your Looker Studio dashboard and initiate a new project by clicking on "Create"
Looker Studio Dashboard - Create Button
  • Proceed to select "Report."
Looker Studio - Select Report
  • In the data sources gallery, find the Catchr Mailchimp data connector by searching for it.
Looker Studio - Catchr Mailchimp Data Connector

Step-by-step guide on the authorization step:

If this is your virgin expedition in authorizing this connector:

Prepare to grant authorization both to Looker Studio and Catchr with the following instructions:

  • Consent is required for the Looker Studio community connector to operate properly.
Looker Studio Authorization Request
  • Choose the Google Account you wish to sync.
Looker Studio - Select Google Account
  • Carefully review the necessary permissions for Looker Studio, then scroll to continue.
Looker Studio Permissions
  • Confer access to finalize the authorization.
Looker Studio - Grant Access

Your Google Account is now authorized for Looker Studio use. Next, empower the Looker Studio connector for Mailchimp data retrieval from Catchr.

  • Click on the subsequent 'Authorize' button beneath 'Mailchimp requires authorization to connect your data to Looker Studio'.
Mailchimp Authorization Request
  • A prompt will appear detailing steps to authorize Catchr's connection to your Mailchimp account – follow through for setup completion.
Authorizing Catchr Connection
  • After a brief loading period, you'll return to the previous page. Scroll down to proceed.
Looker Studio - Loading Completion
  • Select the Mailchimp account you desire Catchr to access and click on "Add" to finalize the connection setup. If the "Add" button eludes you, check for "Create Report" or "Report" typically located at the top right corner.
Looker Studio - Add Mailchimp Account

With these steps concluded, your Mailchimp account is now in sync with Looker Studio, harnessing the power of data visualization for your marketing campaigns.

Unleashing the Power of Mailchimp Metrics in Looker Studio

Once you've linked Mailchimp to Looker Studio, a myriad of metrics are at your disposal, offering sophisticated insights into your marketing efforts. Visualize the performance of your campaigns down to the granular level - from open rates to e-commerce transactions.

Here's how you can leverage the interplay of Mailchimp and Looker Studio:

  • Campaign Analysis: Use "Campaign Id" and "Campaign Title" metrics for identifying top-performing initiatives and drill down into factors that led to success with "Unique Opens" and "Clicks Total".
  • Engagement Tracking: Metrics like "Open Rate" and "Click Rate" help gauge subscriber engagement, while "Industry Open Rate" and "Industry Click Rate" provide a benchmark to measure against your peers.
  • Subscriber Behavior: Understand how different segments react by examining "A - Last Open" vs. "B - Last Open" in A/B testing campaigns.
  • Sales Correlation: The E-commerce metrics such as "Total Orders" and "Total Revenue" can reveal the direct impact of email marketing on sales figures for more ROI-focused analysis.

These and more metrics are outlined in detail at Catchr's Mailchimp Metrics listing, which serves as a comprehensive guide for your data-driven journey.

By unlocking the power of your data and tailoring it to your business needs, Looker Studio becomes an indispensable tool in your marketing toolkit, enabling strategic decisions powered by real-time data.

Empower your Marketing data analysis
Discover +50 connectors to import your Marketing data into your favorite dashboard tool! Unlock instant data integration with Catchr's no-code feature – no IT team required!
Start your free trial!

All your marketing data on Looker Studio

Build Looker Studio dashboard with your different marketing data and track all the essential KPIs.

Start your free trial!
Keep an eye on your data

Connect your Mailchimp data to Google Sheets thanks to Catchr's no code connector!

Start your free trial!
Need a clearer view of your marketing data?
Unlock your free Looker Studio dashboard template for from a collection of +50 stunning designs. Elevate your data visualization!
Get it for free
Need a clearer view of your marketing data?
Unlock your free Power BI dashboard template from a collection of stunning designs. Elevate your data visualization!
Get it for free
Need a clearer view of your marketing data?
No items found.
No items found.
Need a clearer view of your marketing data?

Unlock your free Template Mailchimp - Campaign Overview dashboard template for Looker Studio from a collection of +50 stunning designs. Elevate your data visualization!

Get it for free

Bonus : Your free Template Mailchimp - Campaign Overview Template

In this Mailchimp template, you will find all the metrics and dimensions you would need to get a better view of your data.

If you need more templates, you could look at our looker studio template gallery.

No items found.

In this Mailchimp template, you will find all the metrics and dimensions you would need to get a better view of your data thank to our integrations.

If you need more templates, you could look at our PowerBI template gallery.

Unlock Insights with Style!

Transform your marketing data into stunning dashboards.

Integrate, visualize, and impress with Catchr's seamless dashboards. Elevate your data game now!
Build your first report
14 days free-trial - No credit card required 🎉

More blog post about Mailchimp