SingleSendsStats
Get all Single Sends statistics.
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 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. |