TransactionalSenders
Get Transactional Senders.
Table Specific Information
Only SELECT is supported for TransactionalSenders.
Select
The driver will use the Mailchimp API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client-side within the driver.
- Address supports the '=' operator.
SELECT * FROM TransactionalSenders WHERE Address = '[email protected]'
Columns
| Name | Type | Description |
| Address | String | The sender's email address. |
| CreatedAt | Datetime | The date and time that the sender was first seen by Mandrill as a UTC date string in YYYY-MM-DD HH:MM:SS format |
| Sent | Integer | The total number of messages sent by this sender. |
| HardBounces | Integer | The total number of hard bounces by messages by this sender. |
| SoftBounces | Integer | The total number of soft bounces by messages by this sender. |
| Rejects | Integer | The total number of rejected messages by this sender. |
| Complaints | Integer | The total number of spam complaints received for messages by this sender. |
| Unsubs | Integer | The total number of unsubscribe requests received for messages by this sender. |
| Opens | Integer | The total number of times messages by this sender have been opened. |
| Clicks | Integer | The total number of times tracked URLs in messages by this sender have been clicked. |
| UniqueOpens | Integer | The number of unique opens for emails sent for this sender. |
| UniqueClicks | Integer | The number of unique clicks for emails sent for this sender. |