SingleSendsStats
Get All Single Sends Stats
View-Specific Information
Select
The add-in uses the SendGrid API to process search criteria that refer to the Id column, while other filters are processed client side within the add-in.
Get all Single Sends statistics:
SELECT * FROM SingleSendsStats
Get Single Send statistics 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 |