Looker Studio templates

Instagram Mailchimp template for Looker Studio

Get a clear view of your Mailchimp campaign performance with this Looker Studio template. Track emails sent, open rates, clicks, bounces, and unsubscribes across multiple campaigns and lists. Analyze top-performing domains, subscriber activity, and link engagement to optimize deliverability, improve audience targeting, and maximize conversions. Gain a comprehensive view of your email marketing efforts and make data-driven decisions for better results.

Connectors used in this template:
No items found.
How the template can help

Questions you can answer with this template

Campaign performance

  • How many emails have been sent in my Mailchimp campaigns?
  • What is the open rate and click rate for each campaign?
  • How many bounces (soft and hard) have been recorded?
  • How many recipients have unsubscribed from my emails?

Subscriber activity

  • How many new subscribers have been added to my lists?
  • What is the total number of active subscribers?
  • When was the last subscribe and unsubscribe date for my lists?
  • How many contacts have been marked as cleaned?

Engagement and interactions

  • How many unique opens and clicks have my emails received?
  • What is the click-to-open rate for my campaigns?
  • Which links in my emails received the most clicks?
  • How does engagement vary by send time and date?

Domain and location insights

  • Which email domains (Gmail, Yahoo, etc.) generate the most opens and clicks?
  • What percentage of my audience is opening emails from specific domains?
  • Which countries and regions show the highest email engagement?
  • Are there geographic trends in email open rates and clicks?

List performance

  • What is the open and click rate for my email lists?
  • How many emails have been sent per list over time?
  • How do list engagement rates compare across different campaigns?
  • What is the bounce rate for each subscriber list?

Time-based trends

  • How does email engagement fluctuate throughout the day?
  • What are the best times to send emails based on past performance?
  • How does email engagement change over weeks and months?
  • Are there specific days that generate higher open and click rates?
Done in a snap

How to use the template

  1. Connect your Mailchimp user in your Reporting Ninja account.
  2. Start creating a Looker Studio data source by clicking on the button ‘Get the template’ below.
  3. Authenticate your account by clicking on ‘Authorize’.
  4. Enter the token your can find the Looker Studio area in your Reporting Ninja account.
  5. Choose an account. The account and the blue check mark next to ‘Use report template for new reports’ must be selected. Other parameters are optional.
  6. Once you’re happy, click on ‘Connect’ in the top-right.
  7. The next page will display all available dimensions and metrics.
  8. Click 'Create report'. After this, the template will fetch all your data in the report, ready for you to derive insights!

Related templates

No items found.