TransactionalSenders
Get Transactional Senders.
Table Specific Information
Only SELECT is supported for TransactionalSenders.
Select
The add-in 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 add-in.
- 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. |