TemplateTimeSeries
Returns the recent history of a template as a series of hourly statistics over the last 30 days. Filter on Name to target a specific template; when Name is omitted, the driver returns history for every template in the Templates view.
View-Specific Information
Select
The connector uses the Mailchimp API to return the hourly usage history for a template over the last 30 days. Filter on the Name column to target a specific template. When Name is omitted, the connector automatically retrieves the history for every template returned by the Templates view.
| Column | Supported Operators |
| Name | = |
SELECT * FROM TemplateTimeSeries
SELECT * FROM TemplateTimeSeries WHERE Name = 'Example Template'
Columns
| Name | Type | Description |
| Name [KEY] | String | The name of the template to return history for. This value is required; when omitted the driver iterates every template from the Templates 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 using the template 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. |