SingleSendsStats
Get all Single Sends statistics.
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 | The ID of the Single Send you require stats for. | |
| ABvariation | String | The A/B variation of the Single Send statistic 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 statistic returned. If the group_by parameter doesn't include ab_phase in the request, then the value is 'all'. | |
| Aggregation | String | The time unit to which the statistic 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 statistics are for. | |
| BounceDrops | Integer | The number of dropped messages due to previous bounces. | |
| Bounces | Integer | The number of email messages that bounced (not delivered to recipients). | |
| Clicks | Integer | The total number of times links in the email were clicked. | |
| Delivered | Integer | The total number of messages successfully delivered to recipient inboxes. | |
| InvalidEmails | Integer | The number of email addresses that were invalid or did not exist. | |
| Opens | Integer | The total number of times the email was opened. | |
| Requests | Integer | The total number of email send requests made for the Single Send campaign. | |
| SpamReportDrops | Integer | The number of messages not sent because recipients previously marked your emails as spam. | |
| SpamReports | Integer | The number of times recipients reported the email as spam. | |
| UniqueClicks | Integer | The number of unique recipients who clicked at least one link in the email. | |
| UniqueOpens | Integer | The number of unique recipients who opened the email at least once. | |
| Unsubscribes | Integer | The number of recipients who unsubscribed using the unsubscribe link in the email. |