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 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. |