Mandrill

Creating the data source

Requirements

To generate the API Key you need a Mailchimp Standard or Premium account

Instructions

Log in to your Mandrill account (Mailchimp Transactional) at mandrillapp.com
Navigate to settings, find the API Keys section and click "New API Key"
Enter a description for your API Key, for example "Kondado", leave the other options unchecked and click "Create API Key"
Now copy the "Key" value that will appear
Log in to Kondado, go to the add connectors section and select the Mandrill connector
In the connector, enter a name for your connector in "Name" and paste the value obtained in the previous step in "API Key"
Click SAVE to start receiving Mandrill data in your Data Warehouse or Data Lake

Pipelines

Relationship chart

Click to expand

Email activity

Replication type: Incremental with update window

Parameters:

Read start date (Savepoint): The initial email activity date (savepoint) for the data replication
Update window after publication (days): How many days previous to the savepoint the e-mails will still be considered to have their data replicated

Relationships:

message_id → Message Templates > message_id

Mandrill email activity records with per-message status, metrics, and details.

Campo	Tipo
_kdd_rowkey	text	[en] Replication key for that row [generated by Kondado]
message_id	text	[en] Unique message identifier in Mandrill. Use to JOIN with message templates table. Message Templates > > message_id
event_date	timestamp	[en] Date of the event
email_address	text	[en] The email address of the recipient
sender	text	[en] The email address of the sender
subject	text	[en] The message's subject line
status	text	[en] Sending status of this message Possible values: "sent", "bounced", or "rejected".
tags	text	[en] list of tags on this message
subaccount	text	[en] Subaccount of this message
opens	int	[en] How many times has this message been opened
clicks	int	[en] How many times has a link been clicked in this message
bounce_detail	text	[en] Additional information about the bounce reason when available.

Message Templates

Replication type: Incremental with update window

Parameters:

Update window (days): Number of days to look back for updates
Read start date (Savepoint): The initial date for reading message template data

Mandrill messages with template/slug info to enable JOINs with activity table.

Campo	Tipo
message_id	text	[en] Unique message identifier in Mandrill
template_slug	text	[en] Template slug used to send the message (if applicable)
email_address	text	[en] The email address of the recipient
subject	text	[en] The message subject line
sender	text	[en] The email address of the sender
status	text	[en] Sending status of this message
event_timestamp	timestamp	[en] Date and time of the event
tags	text	[en] List of tags on this message, comma-separated
opens	int	[en] How many times this message has been opened
clicks	int	[en] How many times a link has been clicked

Notes

Part of this documentation was automatically generated by AI and may contain errors. We recommend verifying critical information

Add Mandrill as a data source on Kondado

Connect your Mandrill transactional email data to Kondado by generating an API key and configuring the source.

1

Verify your Mandrill account type

Ensure you have a Standard or Premium Mandrill (Mailchimp Transactional) account, as these are required to generate an API key.

2

Generate a Mandrill API key

Log in to Mandrill, go to Settings > API Keys, click New API Key, name it (e.g., "Kondado"), leave other options unchecked, and click Create API Key.

3

Copy the API key value

After creation, copy the Key value that appears on screen — you'll need this to authenticate the connection.

4

Add Mandrill as a source in Kondado

Log in to Kondado, navigate to add data sources, and select the Mandrill connector. You can explore data integration options to understand how sources connect to destinations.

5

Configure and save the data source

Enter a Name for your source and paste the API Key from step 3, then click SAVE to start receiving data into your data warehouse or data lake.

6

Review available data and visualization options

Once connected, your Email Activity data will sync automatically. You can then explore pre-built Data Studio dashboards for Mandrill or other visualization tools to analyze email performance.

Frequently asked questions

What Mandrill account type do I need to connect to Kondado?▼

You need a Standard or Premium Mandrill (Mailchimp Transactional) account to generate the API Key required for the connection. Free or basic plans do not support API key generation.

Where do I find the API Keys section in Mandrill?▼

After logging in to your Mandrill account, navigate to Settings and look for the API Keys section. From there, you can click New API Key to create a key for Kondado.

What data does the Mandrill connector sync to Kondado?▼

The connector syncs Email Activity data, including fields such as event_date, email_address, sender, subject, status (sent/bounced/rejected), opens, clicks, tags, and subaccount.

Can I use Mandrill data with BI tools after connecting to Kondado?▼

Yes. Once Mandrill data is flowing to your data warehouse or data lake through Kondado, you can connect it to various BI and visualization tools. Kondado offers ready-made Data Studio dashboards for Mandrill and supports other data visualization options.

Do I need to check any options when creating the API key?▼

No. When creating the API key in Mandrill, simply fill in a description (e.g., "Kondado") and leave all other options unchecked, then click Create API Key.

Written by

Thassyo Pereira·Published 2023-07-20·Updated 2026-04-25