JDBC Driver for SendGrid

Build 22.0.8462

StatsByLocation

Query Location 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 StatsByLocation

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

To query Location Statistics by name.

SELECT * FROM StatsByLocation WHERE Name='US'

To query Location Statistics by type.

SELECT * FROM StatsByLocation WHERE Type='country'

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.
Clicks Integer The number of links clicked in your emails.
Opens Integer The number of times your emails were opened 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