Connect Mandrill to Looker: Dashboards in Minutes

Get started for free

No credit card required | 14 days | 10 million records | 30 pipelines

sso google logo
Sign up with Google
sso facebook logo
Sign up with Facebook
sso microsoft logo
Sign up with Microsoft
sso linkedin logo
Sign up with Linkedin

or sign up with your email

By signing up, you agree to Kondado’s Terms of service and Privacy policy

Mandrill
Looker

Visualize Mandrill Data in Looker with Kondado

Connecting your transactional email data to your business intelligence tool helps marketing teams track campaign performance without technical complexity. Kondado enables you to replicate data from Mandrill directly into Looker, giving you visual insights into email opens, clicks, and delivery status that drive better customer communication decisions and improve engagement strategies across your entire organization.

Kondado connects Mandrill to Looker without intermediate databases, allowing you to replicate Email Activity and Message Templates data on a configurable schedule ranging from every 5 minutes to daily, requiring no coding or technical setup.

With automated updates keeping your reports current, you can monitor delivery rates, analyze template performance, and optimize your transactional email strategy using Looker’s powerful visualization capabilities. This setup helps operations teams identify trends in customer engagement, troubleshoot delivery issues quickly, and make faster decisions based on accurate email metrics, improving overall marketing effectiveness without waiting for technical resources or dealing with complex setup processes.

Our prices start from $19 USD/month, and you can try Kondado for free for 14 days with no credit card required

When you combine Mandrill’s transactional email data with Looker’s visualization power, you unlock actionable insights into your customer communications. The Email Activity pipeline provides detailed records of message delivery, opens, and clicks, while the Message Templates pipeline reveals which template designs drive the highest engagement rates and conversion metrics.

Marketing teams can use these pipelines to build custom dashboards tracking delivery success rates, compare performance across different email templates, and identify optimal send times for maximum engagement. Operations managers gain visibility into bounce rates and spam complaints, enabling quick adjustments to maintain sender reputation and improve overall customer experience through better deliverability.

Try out all the features for free for 14 days

Mandrill data available in Looker

2
available pipelines
22
extractable fields

Available integrations

Integration Description
Email Activity Records of email activity including fields such as message_id, status, and metrics for opens and clicks.
Message Templates Messages with template information including message_id, template_slug, and metrics for opens and clicks.
Email Activity
Records of email activity including fields such as message_id, status, and metrics for opens and clicks.
Message Templates
Messages with template information including message_id, template_slug, and metrics for opens and clicks.

Try out all the features for free for 14 days

How to create Mandrill dashboards in Looker

Visualize your data automatically — no spreadsheet exports or custom scripts.

1
Connect Mandrill as data source

Add Mandrill to your Kondado account by entering your API key and selecting the Email Activity and Message Templates pipelines you want to replicate.

2
Select Looker destination

Choose Looker as your destination to receive the replicated Mandrill data, with the flexibility to also send information to Power BI or Google Sheets if your team uses multiple analytics tools.

3
Configure refresh and build dashboards

Set your preferred update frequency from 5 minutes to daily, then create custom dashboards in Looker to visualize email opens, clicks, and template performance metrics.

Access Mandrill data in Looker and combine it with dozens of other data sources

If the source you want is not listed, drop us a chat message. We love to add new sources!

Visualize Mandrill data in other BI tools

If the software you need is not listed, drop us a messagem. You can use almost every tool

Hundreds of data-driven companies trust Kondado
arezzo
brf
Contabilizei
dpz
Experian
grupo_soma
inpress
multilaser
olist
unimed
v4_company
yooper

Frequently Asked Questions (FAQ)

Answers about visualizing Mandrill data in Looker automatically

How do I connect my Mandrill account to Looker using Kondado?
Start by adding Mandrill as a data source in your Kondado account using your API credentials. Then select Looker as your destination and choose which pipelines you want to replicate, such as Email Activity or Message Templates.
Which Mandrill email metrics work best for tracking in Looker?
Focus on open rates, click-through rates, and delivery status from the Email Activity pipeline to measure engagement. The Message Templates pipeline helps you compare which template designs generate the highest customer interaction and conversion rates.
How frequently can I schedule Mandrill data updates in Looker?
You can configure automated updates to run every 5 minutes, 15 minutes, hourly, or daily depending on your reporting needs. This keeps your Looker dashboards current without manual refreshes or complex scheduling.
Can I create dashboards comparing email template performance in Looker?
Yes, using the Message Templates pipeline you can build visual comparisons showing which templates achieve better open rates and click metrics. This helps marketing teams identify winning designs and optimize underperforming templates.
How do I share Mandrill analytics reports with my marketing team?
Once your data flows into Looker, you can distribute insights through Looker Studio shared reports or export visualizations to Google Sheets for collaborative analysis. Team members access the same near-real-time metrics without needing Mandrill login credentials.
What types of email delivery KPIs should I monitor in Looker?
Track delivery rates, bounce rates, spam complaints, and rejection counts from your Email Activity data to maintain sender reputation. Monitoring these metrics helps operations teams quickly identify deliverability issues and ensure customers receive important transactional messages.
Do I need technical skills to build Mandrill dashboards in Looker?
No coding is required to set up the connection or create visualizations in Looker. Kondado handles the data replication automatically, so marketing and operations teams can focus on building charts and analyzing email performance without IT assistance.

Try out all the features for free for 14 days