TechScreenResolutionReport
A predefined view that retrieves Tech Screen Resolution data.
Select
The server uses the Google Analytics API to process WHERE clause conditions built with the following columns and operators:
- PropertyId supports the following operator: =
- ScreenResolution supports the following operator: =
- Date supports the following operators: =,>=,<=,<,>
For example, the following queries are processed server-side:
SELECT * FROM TechScreenResolutionReport WHERE PropertyId = 342020667 SELECT * FROM TechScreenResolutionReport WHERE ScreenResolution = '1920x1080' SELECT * FROM TechScreenResolutionReport WHERE Date = '01/05/2023' SELECT * FROM TechScreenResolutionReport WHERE PropertyId = 342020667 AND ScreenResolution = '1920x1080' AND Date = '01/05/2023' SELECT * FROM TechScreenResolutionReport WHERE Date >= '01/01/2022' AND <= '01/05/2023' SELECT * FROM TechScreenResolutionReport WHERE Date >= '01/01/2022' SELECT * FROM TechScreenResolutionReport WHERE Date <= '01/01/2022' SELECT * FROM TechScreenResolutionReport WHERE Date > '01/01/2022' SELECT * FROM TechScreenResolutionReport WHERE Date < '01/01/2022'The rest of the filter is executed client-side in the server.
Columns
| Name | Type | Dimension | DefaultMetric | DefaultDimension | Description |
| ScreenResolution | String | True | True | Resolution of the screen used to engage with the site/app. | |
| Date | Date | True | True | The date of the session formatted as YYYYMMDD. | |
| KeyEvents | Decimal | False | True | The count of key events. | |
| EngagementRate | Decimal | False | True | The percentage of engaged sessions. | |
| EngagedSessions | Integer | False | True | The number of sessions that lasted longer than 10 seconds, or had a conversion event, or had 2 or more screen views. | |
| EventCount | Integer | False | True | The count of events. | |
| NewUsers | Integer | False | True | The number of users who interacted with the site or launched the app for the first time. | |
| TotalRevenue | Integer | False | True | The sum of revenue from purchases, subscriptions, and advertising. | |
| TotalUsers | Integer | False | True | The total number of users. |
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 |
| PropertyId | String | Property ID value to be used when querying this table. |