JDBC Driver for SendGrid

Build 22.0.8462

StatsByMailboxProvider

Query Mailbox Provider Statistics 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 StatsByMailboxProvider

SELECT * FROM StatsByMailboxProvider WHERE Date > '2016-01-01' AND Date < '2016-03-30'

To query Mailbox Provider Statistics by name.

SELECT * FROM StatsByMailboxProvider WHERE Name='Microsoft Outlook Live'

Columns

Name Type References Description
Type String The type of the statistic. Avaible values (categorie, device, client, mailbox_provider, browser, subuser)
Name String The name of the statistic.
Date Date The time the global 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 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.
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.
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.

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