AutomationStats
Get All Automation Stats
View-Specific Information
Select
The following is an example to query the AutomationStats view:
SELECT * FROM AutomationStats
Columns
| Name | Type | References | Description |
| Id | String | This is the ID of the Automation you are requesting stats for. | |
| Aggregation | String | This describes the time unit to which the stat is rolled up. It is based on the aggregated_by parameter included in the request. It can be 'total' or the date (in YYYY-MM-DD format) the stats are for. | |
| StepId | String | This is the ID of the step if the stats were requested to be grouped by step_id. | |
| BounceDrops | Integer | BounceDrops | |
| Bounces | Integer | Bounces | |
| Clicks | Integer | Clicks | |
| Delivered | Integer | Delivered | |
| InvalidEmails | Integer | InvalidEmails | |
| Opens | Integer | Opens | |
| Requests | Integer | Requests | |
| SpamReportDrops | Integer | SpamReportDrops | |
| SpamReports | Integer | SpamReports | |
| UniqueClicks | Integer | UniqueClicks | |
| UniqueOpens | Integer | UniqueOpens | |
| Unsubscribes | Integer | Unsubscribes |