Chat with your Mandrill data

AI to analyze Mandrill data with Claude and ChatGPT

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
You
What was our Mandrill delivery success rate last week?
Mandrill Delivery
Your delivery rate reached 98.7% across 12,450 transactional emails sent last week.
Via Kondado MCP
You
Which email template had the highest open rate this month?
Template Performance
The "order_confirmation" template achieved a 34.2% open rate, outperforming others by 8%.
Via Kondado MCP
You
How many emails bounced yesterday compared to the day before?
Bounce Tracking
Bounces decreased to 23 emails yesterday, down from 47 the previous day.
Via Kondado MCP
You
What is the total click volume from welcome emails this quarter?
Engagement Metrics
Welcome emails generated 1,247 clicks this quarter with a 12.3% click-through rate.
Via Kondado MCP
Works in Claude, ChatGPT and any MCP client

AI to Analyze Mandrill Data with Claude and ChatGPT

Ask Claude, ChatGPT, or any MCP client about your Mandrill transactional email performance using natural language chat. Query delivery rates, open trends, or template effectiveness without writing SQL or navigating complex dashboards. Discover which email templates drive the highest engagement and compare campaign periods instantly through conversational analysis.

Kondado exposes Mandrill data through an MCP server, enabling Claude, ChatGPT, and other MCP clients to query two pipelines, Email Activity and Message Templates, containing 22 fields total. The same replicated data also powers ready dashboard templates in Power BI and Looker Studio for visual monitoring.

Marketing analysts and e-commerce managers benefit from immediate answers about bounce rates, click-through performance, and revenue attribution from transactional emails. Operations teams can investigate delivery failures and compare template performance across customer segments without technical assistance. Finance professionals track email volume trends and associated costs by simply asking questions in chat. This read-only analytical access transforms how business users interact with Mandrill metrics.

I prefer ready dashboards

Dashboard templates in Power BI and Looker Studio, connected to your Mandrill data by Kondado in minutes.

View Mandrill dashboards →

I want to ask the AI

Claude, ChatGPT and other MCP clients query your Mandrill data in natural language.

View MCP setup →

The pipelines below contain all Mandrill data available for AI analysis and dashboard reporting. Query the Email Activity pipeline to examine delivery status, open rates, and click metrics across your transactional messages. Analyze the Message Templates pipeline to compare template_slug performance and identify which configurations drive higher engagement. Cross-reference both pipelines to correlate specific template designs with delivery success rates and recipient behavior patterns. Combining Email Activity with Message Templates enables you to uncover whether certain template structures improve deliverability or drive higher click-through rates across customer segments. Automated updates on a configurable schedule ensure your AI chat responses reflect the latest email performance data and recent delivery events.

How to connect Mandrill to Claude, ChatGPT and other AI clients

MCP is an open standard. Add the Kondado server to the connections of Claude (Web or Desktop), ChatGPT, or any other MCP client you use, and authorize via OAuth at app.kondado.com.br. Setup through the UI, no code.

Kondado MCP server: https://mcp.kondado.io/mcp
Detailed guide: Claude Detailed guide: ChatGPT
AI vocabulary

Mandrill tables and metrics available via Kondado

Each item below is something Claude, ChatGPT or another MCP client already knows how to query — no schema setup, no manual mapping.

2
Tables
22
Fields
∞
Ad-hoc questions
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.
Full docs on the wiki → Connect Mandrill now →

How to connect and use AI with your data

In 3 steps: connect on Kondado, pick dashboard or chat, analyze.

1
Connect Mandrill Data Source

Visit app.kondado.com.br to add Mandrill as a data source, select a 'Via Kondado' destination, and configure your replication schedule. This makes your email activity and template data available for both AI querying and the dashboard templates.

2
Add MCP Server in Claude or ChatGPT

In Claude Web or Desktop, or within ChatGPT, access the connection settings to add the Kondado MCP server and complete the OAuth authorization. Both clients use the same GUI-based setup process with no command line tools required.

3
Query Data and Open Dashboards

Ask natural language questions about Mandrill metrics directly in the chat interface for immediate analysis. For visual recurring monitoring, open the ready Power BI or Looker Studio dashboard templates included with your data.

Other connectors with AI via MCP

Same Kondado data, in chat through Claude, ChatGPT and other MCP clients.

CRM and Sales

ActiveCampaign ActiveCampaign
Bitrix24 CRM Bitrix24 CRM
Exact Sales Exact Sales
Hubspot Hubspot
Infusionsoft (Keap) Infusionsoft (Keap)
Meetime Meetime
NectarCRM NectarCRM
Pipedrive Pipedrive
PipeRun PipeRun
Ploomes Ploomes
RDStation CRM RDStation CRM
Salesforce Salesforce

Marketing and Automation

Google Ads Google Ads
E-goi E-goi
Google Search Console Google Search Console
Hi Platform Hi Platform
Huggy Huggy
Linkedin Linkedin
MailChimp MailChimp
Mautic Mautic
Pushwoosh Pushwoosh
RDStation RDStation
Salesforce Marketing Cloud (Exact Target) Salesforce Marketing Cloud (Exact Target)
SenseData SenseData
Taboola Taboola
Twilio Twilio
WordPress WordPress

Advertising and Media

Apple App Store Apple App Store
Bing Bing
Criteo Criteo
Facebook Facebook
Facebook Ads Facebook Ads
Google Play Store Google Play Store
Instagram Ads Instagram Ads
Meta Ads Meta Ads
Microsoft Ads Microsoft Ads
Microsoft Advertising Microsoft Advertising
Pinterest Ads Pinterest Ads
TikTok Ads TikTok Ads
X Ads X Ads
YouTube YouTube

E-commerce and Marketplaces

Bling! Bling!
Hotmart Hotmart
Loja Integrada Loja Integrada
Mercado Libre Mercado Libre
Nuvemshop (Tiendanube) Nuvemshop (Tiendanube)
Olist Tiny Olist Tiny
Omie Omie
Pagar.me Pagar.me
Shopify Shopify
Tiny ERP Tiny ERP
Tray Tray
VNDA VNDA
VTEX VTEX
Wake Commerce Wake Commerce

Financial and Payments

ASAAS ASAAS
ContaAzul ContaAzul
Fatura Simples Fatura Simples
Granatum Granatum
Superlogica Superlogica
Sympla Sympla

Support and Customer Service

55pbx 55pbx
api4com api4com
Blip (take) Blip (take)
Clockify Clockify
EADBOX EADBOX
Freshdesk Freshdesk
Movidesk Movidesk
Recruiterbox Recruiterbox
Stilingue Stilingue
Wootric Wootric
Zendesk Zendesk
Zendesk Chat (Zopim) Zendesk Chat (Zopim)

Databases

AWS CloudWatch Metrics AWS CloudWatch Metrics
Azure Table Storage Azure Table Storage
BigQuery BigQuery
InfluxDB v1 InfluxDB v1
MongoDB MongoDB
MySQL (& MariaDB) MySQL (& MariaDB)
Oracle Oracle
PostgreSQL PostgreSQL
SQLServer SQLServer
Webhook Webhook

Productivity and Collaboration

ClickUp ClickUp
Google Sheets Google Sheets
Jira Jira
monday.com monday.com
Notion Notion
Pipefy Pipefy
Tangerino Tangerino
Toggl Toggl
Trello Trello

Social Media

Instagram Instagram
TikTok Organic TikTok Organic

User Analytics

Google Analytics GA4 Google Analytics GA4
Mixpanel Mixpanel
Zeeng Zeeng

Storage and Transfer

Amazon S3 Amazon S3
FTP FTP
Google Cloud Storage Google Cloud Storage
See all AI connectors →

Related on Kondado

Frequently asked questions about AI

How ready dashboards and chat via Claude / ChatGPT work together with your data via Kondado.

What specific Mandrill metrics can I ask Claude or ChatGPT about in the chat? ▼
You can inquire about email delivery status, open rates, click-through rates, template performance comparisons, and message volume trends. The AI accesses both Email Activity and Message Templates pipelines to calculate metrics like bounce percentages and engagement ratios across different time periods.
How do I configure Claude or ChatGPT to access my Mandrill data through Kondado? ▼
Open your Claude Web or Desktop application, or ChatGPT interface, navigate to the MCP server connection settings, and add the Kondado MCP endpoint. Authorize the connection once via OAuth at app.kondado.com.br to grant read-only access to your replicated Mandrill data.
Does the AI have permission to send emails or modify my Mandrill account settings? ▼
No, the integration provides read-only analytical access for querying historical email performance and template data. The AI cannot execute actions on the source, send messages, or modify any configurations within your Mandrill account.
How frequently does the Mandrill data update for AI querying? ▼
Data replicates on a configurable schedule that you set when creating the pipeline, ensuring near-real-time freshness depending on your selected interval. This automated update cycle keeps your chat answers current without manual refreshes.
What dashboard templates are available for Mandrill data visualization? ▼
Kondado offers ready report templates in Power BI and Looker Studio that visualize the same Email Activity and Message Templates data available to the AI. These templates provide visual monitoring for recurring analysis while the AI chat handles ad-hoc investigative questions.
What is the difference between asking the AI about Mandrill data and opening a ready dashboard? ▼
The AI chat provides immediate, conversational answers to specific business questions with calculated metrics and comparisons on demand. Ready dashboards in Power BI or Looker Studio offer visual, recurring monitoring with fixed charts and graphs for scheduled review meetings.
Can I use other MCP clients besides Claude and ChatGPT to analyze Mandrill data? ▼
Yes, any MCP-compatible client can connect to the Kondado server to query your Mandrill pipelines, though Claude and ChatGPT are the most popular interfaces for business users. The setup process remains consistent across clients: add the server and authorize via OAuth.
Which roles within my company would benefit most from AI analysis of Mandrill data? ▼
Marketing analysts gain insights into template effectiveness and engagement trends, while e-commerce managers track transactional email performance related to orders. Operations teams monitor delivery health and bounce rates, and finance professionals analyze email volume and associated costs.

Try out all the features for free for 14 days