blog post

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

Florian Cabirol
November 21, 2023
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.

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

Import your Mailchimp emailing data to Google Sheet : How-to, metrics and more

Learn how to effortlessly integrate your Mailchimp campaign data into Google Sheets with our comprehensive tutorial, designed for marketing professionals looking to optimize their email marketing strategies. This guide covers the entire process, from connecting Mailchimp to Google Sheets via Catchr to visualizing and analyzing key metrics. Perfect for those who want to track campaign performance, subscriber engagement, and optimize send times for enhanced results. Unlock the potential of your email marketing data in Google Sheets for actionable insights and improved campaign outcomes.

Florian Cabirol

Explore your mailing Mailchimp KPI from PowerBI : How-to, templates and metrics

Master integrating Mailchimp with PowerBI for advanced marketing analytics in this guide, and transform your campaign data into actionable insights for strategic decision-making.

Florian Cabirol

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

Discover how your Mailchimp are performing and how to perform better with Looker Studio. Templates and metrics included !

Florian Cabirol

The Ultimate Mailchimp KPIs to Keep Track of Your Email Marketing Campaigns

Tracking Mailchimp KPIs is a remarkable way of optimizing your email marketing campaigns. Read this blog and discover the top KPIs for better engagement and higher ROI.

Florian Cabirol