JDBC Driver for SendGrid

Build 22.0.8462

SubuserStats

Query Subuser Statistics in SendGrid.

View-Specific Information

Select

You can filter by SubuserName to retrieve stats of a specific subuser.

SELECT * FROM SubuserStats WHERE SubuserName = 'Example'

You can also filter by Date. Operators =, >=, <=, <, and > are supported for this column. If you do not specify one, a default span of the past 1 year is used.

SELECT * FROM SubuserStats WHERE SubuserName = 'News' AND Date > '2016-01-01' AND Date < '2016-01-30'

Columns

Name Type References Description
Id [KEY] String The Id of the subuser statistic.
SubuserName String The name of the subuser.
Date Datetime The time the subuser statistic was created.
Blocks Integer The number of emails that were not allowed to be delivered by ISPs.
Drops Integer The number of emails automatically dropped 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 that were clicked in the emails from this subuser.
Deferred Integer The number of emails temporarily refused by the receiving server.
Delivered Integer The number of emails from this subsuer that were 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 emails from this subuser were opened by recipients.
Processed Integer The number of emails pushed to SendGrid by this subuser.
Requests Integer The number of emails that you requested to send via SendGrid from this subuser.
SpamReportDrops Integer The number of emails automatically dropped because the emails were marked as spam by the recipients.
SpamReports Integer The number of emails from this subuser that were marked as spam by recipients.
UniqueClicks Integer The number of unique recipients who clicked on links in your emails from this subuser.
UniqueOpens Integer The number of unique recipients who opened your emails from this subuser.
UnsubscribeDrops Integer The number of emails from this subuser dropped by SendGrid because the recipients unsubscribed from your emails.
Unsubscribes Integer The number of recipients who unsubscribed from your emails from this subuser.
Name String The name of the statistic.
Type String The type of the statistic.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462