Mailchimp Looker Studio Template Summary
Students: 50+ | Customizable
You’re already using Mailchimp like a champ, but you’re still spending too much time digging for data insights to communicate to your team. Your time is valuable. You should be able to visualize your data in one place. This Mailchimp Google Looker Studio template exists to make your life easier.
It allows you to:
- Visualize your Mailchimp and Google Analytics data around your organization’s email campaigns
- Find insights faster
- Create compelling reports for executive teams
Because you have better things to do with your time, like start a podcast. Or perfect your comedy routine that’s so bad it’s good. Or take a break. You deserve it.
Page 1: Individual Email Performance
Page 1 of this Mailchimp Looker Studio template gives you a performance overview of each individual email campaign sent. This includes send date, day of the week, subject line, number of recipients, open rate, click rate, and unsubscribe rate.
It’s also easy to customize. You’ve worked hard enough to get here. It’s time to kick back and let your results shine. You can adjust the date range, as well as toggle between your email lists if you have more than one.
Use this page to ask and answer questions such as:
- What subject lines get the most opens?
- Which segment and/or email type gets the most opens?
- Which segment and/or email type gets the most clicks?
Page 2: Trends in Email Performance
Page 2 of the Mailchimp Looker Studio template calls out broader trends by outlining email performance by Mailchimp list. This includes recipients, average open rate, average click rate, and average unsubscribe rate, as well as email performance by day of the week. Think minimal effort for maximum insights.
Use this page to ask and answer questions such as:
- Which list gets the most opens?
- Which list gets the most clicks?
- Which list sees the highest unsubscribe rate?
- What days of the week get the most opens?
Page 3: Email Performance On-site
Page 3 of the Mailchimp Looker Studio template pulls in additional data from Google Analytics. This extra dollop of data is here to help you understand how traffic from your emails performs on your website in comparison to other traffic channels. It pulls in information about the number of sessions, bounce rate, and goal conversion rate.
Use this page to ask and answer questions such as:
- What is the monthly rate of email signups?
- Which landing pages capture the most email signups?
- Which traffic sources drive the most email signups?
Prerequisites
You’ll need a Google Account to link your data to our Mailchimp Looker Studio template and should use the same account across Google Sheets, Google Looker Studio, and Google Analytics (if applicable). Manager access is required to download all reports in Mailchimp.