Senders
Returns sending statistics for senders, including email metrics such as bounces, complaints, and clicks.
View-Specific Information
Select
The provider uses 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 provider.
| Column | Supported Operators |
| Address | = |
SELECT * FROM Senders 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. |