Mandrill is a transactional email API for MailChimp users. Segment makes it easy to get your data from Mandrill (and lots of other sources) into your Data Warehouse for advanced analysis.
Take your company’s analysis to the next level by having SQL access to all your Mandrill data alongside your customer event data in Redshift and Postgres.
With your Mandrill data in your warehouse, you’ll be able to analyze your email sent, email opened and email clicked in SQL. Even cooler, you’ll be able to join your Mandrill data with the Segment event data you’re already sending to your warehouse, so you can now do things like combining your email opens and clicks with website activity and analyzing them using your favorite business intelligence and sql querying tools.
Mandrill is a transactional email API for MailChimp users.. Visit Website
Take your company’s email analysis to the next level by adding Mandrill as a Source to Segment. We’ll automatically collect email events like
Opened and load them into your data warehouse.
From your workspace’s
Give the source a nickname and a schema name. The nickname will be used to designate the source in the Segment interface, and the schema name is the namespace you’ll be querying against in your warehouse. Both can be whatever you like, but we recommend sticking to something that reflects the source itself, like
Mandrillfor nickname and
mandrill_prodfor the schema name.
Note that you can add multiple instances if you have multiple Mandrill accounts. That’s why we allow you to customize the source’s nickname and schema name!
Copy the auto-generated Webhook URL and paste it into Mandrill’s Event Notification settings pane under Settings > Webhook.
Once you enable the webhook, you’re good to go! We’ll automatically create your collections based on which triggers you select. If any seem unnecessary for your analysis, feel free to leave them unchecked.
Finally, back in the Segment UI, press Next and then Finish to wrap up the setup flow.
The Mandrill source is comprised only of a streaming component which listens in real time for inbound webhooks from Mandrill’s Webhooks and batches the events to be uploaded on your next warehouse flush. These events are only ever appended to your warehouse. Since Mandrill is strictly used for transactional emails triggered directly by API calls, there are no “dimensional” concepts in their data model that would require any additional components.
Collections are the groupings of resources we pull from your source. In your warehouse, each collection gets its own table.
|Sent||Event||Message has been sent successfully|
|Bounced||Event||Message has hard bounced|
|Opened||Event||Recipient opened a message; will only occur when open tracking is enabled.|
|Marked As Spam||Event||Recipient marked a message as spam|
|Rejected||Event||Message was rejected|
|Delayed||Event||Message has been sent, but the receiving server has indicated mail is being delivered too quickly and Mandrill should slow down sending temporarily|
|Soft-Bounced||Event||Message has soft bounced|
|Clicked||Event||Recipient clicked a link in a message; will only occur when click tracking is enabled|
|Recipient Unsubscribes||Event||Recipient unsubscribed|