JDBC Driver for SendGrid

Build 22.0.8462

StatsByDevice

Query Device 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 StatsByDevice

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

To query Device Statistics by name.

SELECT * FROM StatsByDevice WHERE Name='Phone'

Columns

Name Type References Description
Type String The type of the statistic.
Name String The name of the statistic.
Date Date The time the global statistic was created.
Opens Integer The number of times your emails were opened by recipients.
UniqueOpens Integer The number of unique recipients who opened your emails.

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