TechPlatformDeviceCategoryReport
A predefined view that retrieves Tech platform device category data.
Select
The component uses the Google Analytics API to process WHERE clause conditions built with the following columns and operators:
- PropertyId supports the following operator: =
- Platform supports the following operator: =
- Date supports the following operator: =
- DeviceCategory supports the following operators: =,>=,<=,<,>
For example, the following queries are processed server-side:
SELECT * FROM TechPlatformDeviceCategoryReport WHERE PropertyId = 342020667 SELECT * FROM TechPlatformDeviceCategoryReport WHERE Platform = 'web' SELECT * FROM TechPlatformDeviceCategoryReport WHERE Date = '01/05/2023' SELECT * FROM TechPlatformDeviceCategoryReport WHERE PropertyId = 342020667 AND DeviceCategory = 'desktop' SELECT * FROM TechPlatformDeviceCategoryReport WHERE PropertyId = 342020667 AND Platform = 'web' SELECT * FROM TechPlatformDeviceCategoryReport WHERE Date >= '01/01/2022' AND <= '01/05/2023' SELECT * FROM TechPlatformDeviceCategoryReport WHERE Date >= '01/01/2022' SELECT * FROM TechPlatformDeviceCategoryReport WHERE Date <= '01/01/2022' SELECT * FROM TechPlatformDeviceCategoryReport WHERE Date > '01/01/2022' SELECT * FROM TechPlatformDeviceCategoryReport WHERE Date < '01/01/2022'The rest of the filter is executed client-side in the component.
Columns
Name | Type | Dimension | DefaultMetric | DefaultDimension | Description |
DeviceCategory | String | True | True | Type of device used to engage with the site/app: Desktop, Tablet, or Mobile. | |
Platform | String | True | True | Platform for the app or site (Android, iOS, Web). | |
Date | Date | True | True | The date of the session formatted as YYYYMMDD. | |
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 ten seconds, had a conversion event, or had two 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 | The Property Id value to be used when querying this table. |