TransactionalSenders
Lists authorized senders configured in the Mailchimp Transactional account.
Table Specific Information
Only SELECT is supported for TransactionalSenders.
Select
The connector 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 connector.
- 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. |