Adding the data source
Requirements
To generate the API Key you need a Standard or Premium account
Instructions
1) Login to your Mandrill account (Mailchimp Transactional)
2) Navigate to the settings, look for the API Keys section and click on “New API Key”
3) Fill in a description for your API Key, for example “Kondado”, leave the other options unchecked and then click on “Create API Key”
4) Now just copy the value of the “Key” that will appear:
6) In the data source, in “Name” give a name for your data source and in “API Key” copy the value obtained in step (4)
Now just click on SAVE and to start receiving data from Mandrill in the Data Warehouse or Data Lake
Pipeline
Summary
Relationship Chart
Email Activity
Field |
Type |
|
__kdd_rowkey
|
text
|
[en] Replication key for that row [generated by Kondado]
|
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
|
|