Query the available Global Stats in SendGrid.
You need to specify a time span to select from this table. If you do not specify a date range, a default range starting from 2016-01-01 till actual date will be used. The Date column supports the >, <, =, <=, and >= operators.
SELECT * FROM GlobalStats
SELECT * FROM GlobalStats WHERE Date > '2016-01-01' AND Date < '2016-03-30'
|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.|