Mandrill Connector
Intro
Mandrill is an email infrastructure service developed by MailChimp. Use Domo's Mandrill connector to view your email data within Domo. To learn more about the Mandrill API, visit their page (https://mandrillapp.com/api/docs/).
You connect to your Mandrill account in the Data Center. This topic discusses the fields and menus that are specific to the Mandrill connector user interface. General information for adding DataSets, setting update schedules, and editing DataSet information is discussed in Adding a DataSet Using a Data Connector.
Prerequisites
To connect to your Mandrill account and create a DataSet, you must have a Mandrill API key. To obtain an API key, do the following:
-
In MailChimp, open Mandrill.
-
Under Settings, click SMTP & API Info.
-
Click New API Key.
Connecting to Your Mandrill Account
This section enumerates the options in the Credentials and Details panes in the Mandrill Connector page. The components of the other panes in this page, Scheduling and Name & Describe Your DataSet, are universal across most connector types and are discussed in greater length in Adding a DataSet Using a Data Connector.
Credentials Pane
This pane contains fields for entering credentials to connect to your Mandrill account. The following table describes what is needed for each field:
Field |
Description |
---|---|
API Key |
Enter your Mandrill API key. For information about generating an API key, see "Prerequisites," above. |
Once you have entered valid Mandrill credentials, you can use the same account any time you go to create a new Mandrill DataSet. You can manage connector accounts in the Accounts tab in the Data Center. For more information about this tab, see Managing User Accounts for Connectors.
Details Pane
This pane contains a primary Reports menu, along with various other menus which may or may not appear depending on the report type you select.
Menu |
Description |
||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Report |
Select the Mandrill report you want to run. The following reports are available:
|
||||||||||||||||||||||||||||||||||||||||||||||||||
Query |
Enter search terms you want to return data for. For example: email:gmail.com |
||||||||||||||||||||||||||||||||||||||||||||||||||
Message ID |
Enter the message ID you want to retrieve data for. |
||||||||||||||||||||||||||||||||||||||||||||||||||
Tag |
Select the tag you want to retrieve data for. |
||||||||||||||||||||||||||||||||||||||||||||||||||
Sender Email Address |
Enter the email address of the sender you want to retrieve data for. |
||||||||||||||||||||||||||||||||||||||||||||||||||
URL |
Enter the URL you want to retrieve data for. |
||||||||||||||||||||||||||||||||||||||||||||||||||
Template Name |
Enter the name of the template you want to retrieve data for. |
||||||||||||||||||||||||||||||||||||||||||||||||||
Duration |
Select whether you want to pull data for a specific date or a date range. |
||||||||||||||||||||||||||||||||||||||||||||||||||
Report Date |
Select whether the report data is for a specific date or for a relative number of days back from today. |
||||||||||||||||||||||||||||||||||||||||||||||||||
Select Specific Date |
Select the date for the report. |
||||||||||||||||||||||||||||||||||||||||||||||||||
Days Back |
Enter the number of past days that should appear in the report. |
||||||||||||||||||||||||||||||||||||||||||||||||||
Start Date |
Specify whether the first date in your date range is a specific or relative date. You select the last date in your range in End Date. |
||||||||||||||||||||||||||||||||||||||||||||||||||
End Date |
Specify whether the second date in your date range is a specific or relative date. You select the first date in your range in Start Date. |
||||||||||||||||||||||||||||||||||||||||||||||||||
Select Specific Start Date |
Select the first date in your date range. |
||||||||||||||||||||||||||||||||||||||||||||||||||
Select Specific End Date |
Select the second date in your date range. |
||||||||||||||||||||||||||||||||||||||||||||||||||
Days Back to Start From |
Enter the number of the farthest day back that should be represented in the report. Combine with Days Back to End At to create a range of represented days. For example, if you entered 10 for Days Back to Start From and 5 for Days Back to End At, the report would contain data for 10 days ago up until 5 days ago. |
||||||||||||||||||||||||||||||||||||||||||||||||||
Days Back to End At |
Enter the number of the most recent day back that should be represented in the report. Combine with Days Back to Start From to create a range of represented days. For example, if you entered 10 for Days Back to Start From and 5 for Days Back to End At, the report would contain data for 10 days ago up until 5 days ago. |
Other Panes
For information about the remaining sections of the connector interface, including how to configure scheduling, retry, and update options, see Adding a DataSet Using a Data Connector.