Mandrill

Creating the data source

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

Click to expand

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:

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.

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

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