TransactionalSenders
Lists authorized senders configured in the Mailchimp Transactional account.
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 email address of the sender associated with the transactional messages. |
| CreatedAt | Datetime | The Coordinated Universal Time (UTC) timestamp indicating when this sender was first detected by Mandrill, formatted as YYYY-MM-DD HH:MM:SS. |
| Sent | Integer | The total number of transactional messages that have been sent by this sender. |
| HardBounces | Integer | The total number of messages from this sender that resulted in hard bounces, indicating permanent delivery failures. |
| SoftBounces | Integer | The total number of messages from this sender that resulted in soft bounces, indicating temporary delivery issues. |
| Rejects | Integer | The total number of messages from this sender that were rejected by the system or receiving servers. |
| Complaints | Integer | The total number of spam complaints received for messages sent by this sender. |
| Unsubs | Integer | The total number of unsubscribe requests triggered by messages from this sender. |
| Opens | Integer | The total number of times messages sent by this sender have been opened. |
| Clicks | Integer | The total number of times tracked URLs within messages from this sender have been clicked. |
| UniqueOpens | Integer | The number of unique recipients who have opened at least one email sent by this sender. |
| UniqueClicks | Integer | The number of unique recipients who have clicked on at least one tracked URL in emails sent by this sender. |