GlobalStats
Query the available Global Stats in SendGrid.
View-Specific Information
Select
You need to specify a time span to select from this table. If you do not specify one, a default span of the past 1 year is used. The Date column supports the >, <, =, <=, and >= operators.
SELECT * FROM GlobalStats
SELECT * FROM GlobalStats WHERE Date > '2016-01-01' AND Date < '2016-03-30'
Columns
Name | Type | References | Description |
Date | Date | The time the global statistic was created. | |
Blocks | Integer | The number of emails that were not allowed to be delivered by ISPs. | |
BounceDrops | Integer | The number of emails automatically dropped by SendGrid because they appear on one of the suppression lists. | |
Bounces | Integer | The number of emails that bounced instead of being delivered. | |
Clicks | Integer | The number of links clicked in your emails. | |
Deferred | Integer | The number of emails temporarily refused by the receiving server. | |
Delivered | Integer | The number of emails confirmed delivered. | |
InvalidEmails | Integer | The number of emails with a malformed address or reported as invalid by the receiving server. | |
Opens | Integer | The number of times your emails were opened by recipients. | |
Processed | Integer | The number of emails pushed to SendGrid. | |
Requests | Integer | The number of emails you requested to send via SendGrid. | |
SpamReportDrops | Integer | The number of emails automatically dropped because the emails were marked as spam by the recipients. | |
SpamReports | Integer | The number of emails marked as spam by recipients. | |
UniqueClicks | Integer | The number of unique recipients who clicked links in your emails. | |
UniqueOpens | Integer | The number of unique recipients who opened your emails. | |
UnsubscribeDrops | Integer | The number of emails globally dropped by SendGrid because the recipient unsubscribed from your emails. | |
Unsubscribes | Integer | The number of recipients who unsubscribed from your emails. |