Tech
Retrieves Tech data.
Table Specific Information
Select
Retrieves data for Tech report. At least one metric must be specified in the query. In the query you can also specify up to nine dimensions.
The following is an example query:
SELECT Conversions, EngagementRate, EventCount FROM Tech
Columns
| Name | Type | Dimension | DefaultMetric | DefaultDimension | Description |
| Date | Date | True | The date of the session formatted as YYYYMMDD. | ||
| Year | Integer | True | The year of the session. A four-digit year from 2005 to the current year. | ||
| Month | Integer | True | The month of the session. An integer from 01 to 12. | ||
| Week | Integer | True | The week of the session. A number from 01 to 53. Each week starts on Sunday. | ||
| Day | Integer | True | The day of the month. A number from 01 to 31. | ||
| Hour | Integer | True | An hour of the day ranging from 00-23 in the timezone configured for the account. This value is also corrected for daylight savings time. | ||
| AppVersion | String | True | Version of the app. | ||
| Browser | String | True | True | Browser used to engage with the site. | |
| DeviceCategory | String | True | Type of device used to engage with the site/app: Desktop, Tablet, or Mobile. | ||
| DeviceModel | String | True | Model of the device used to engage with the site/app. | ||
| OperatingSystem | String | True | Operating systems used by visitors to the app or website. | ||
| OperatingSystemVersion | String | True | Version of the operating systems used by visitors to the app or website. | ||
| OperatingSystemWithVersion | String | True | Operating system name and version. | ||
| Platform | String | True | Platform for the app or site (Android, iOS, Web). | ||
| ScreenResolution | String | True | Resolution of the screen used to engage with the site/app. | ||
| Conversions | Integer | False | True | The count of conversion 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. | |
| StartDate | String | Start date for fetching Analytics data. Either a date string or a relative date (e.g., today, yesterday, or #daysAgo). | |||
| EndDate | String | End date for fetching Analytics data. Either a date string or a relative date (e.g., today, yesterday, or #daysAgo). | |||
| Dimensions | String | A comma-separated list of dimensions to retrieve in addition to the columns defined in the schema. Set to empty string to retrieve no dimensions. | |||
| Metrics | String | A comma-separated list of metrics to retrieve in addition to the columns defined in the schema. |
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. |