SingleSendsStats
Get All Single Sends Stats
View-Specific Information
Select
The connector uses the SendGrid API to process search criteria that refer to the Id column, while other filters are processed client side within the connector.
Get All Single Sends Stats
SELECT * FROM SingleSendsStats
Get Single Send Stats by ID
SELECT * FROM SingleSendsStats where id = '25723e10-669e-11ef-b50f-0e4b6974e9ad'
Columns
| Name | Type | References | Description |
| Id [KEY] | String | This is the ID of the Single Send you require stats for. | |
| ABvariation | String | This is the A/B variation of the Single Send stat returned. If the group_by parameter doesn't include ab_variation in the request, then the value is 'all'. | |
| ABphase | String | This is the A/B phase of the Single Send stat returned. If the group_by parameter doesn't include ab_phase in the request, then the value is 'all'. | |
| 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. | |
| 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 |