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.
If any date within the specified range has statistical data, the API will include that data in the resultset and return 0 for other dates. If no dates have non-zero stats within the specified date range, the API will return an empty result set.
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. |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
| Name | Type | Description | |
| AccountId | String | The ID of the account. | |
| SubuserUsername | String | The username of the subuser. |