SenderTimeSeries
Returns the recent history of a sender as a series of hourly statistics over the last 30 days. Filter on Address to target a specific sender; when Address is omitted, the driver returns history for every sender in the UserSenders view.
View-Specific Information
Select
The connector uses the Mailchimp API to return the hourly sending history for a sender over the last 30 days. Filter on the Address column to target a specific sender. When Address is omitted, the connector automatically retrieves the history for every sender returned by the UserSenders view.
| Column | Supported Operators |
| Address | = |
SELECT * FROM SenderTimeSeries
SELECT * FROM SenderTimeSeries WHERE Address = '[email protected]'
Columns
| Name | Type | Description |
| Address [KEY] | String | The email address of the sender to return history for. This value is required; when omitted the driver iterates every sender from the UserSenders view. |
| Time [KEY] | Datetime | The hour as a UTC date string in YYYY-MM-DD HH:MM:SS format. |
| Sent | Integer | The total number of messages sent by this sender during the hour. |
| HardBounces | Integer | The total number of hard bounces during the hour. |
| SoftBounces | Integer | The total number of soft bounces during the hour. |
| Rejects | Integer | The total number of rejected messages during the hour. |
| Complaints | Integer | The total number of spam complaints during the hour. |
| Opens | Integer | The total number of times messages were opened during the hour. |
| UniqueOpens | Integer | The number of unique opens during the hour. |
| Clicks | Integer | The total number of times tracked URLs were clicked during the hour. |
| UniqueClicks | Integer | The number of unique clicks during the hour. |