ActiveUsers
A base view that retrieves Active Users data.
Table Specific Information
Select
Retrieves data for ActiveUsers report. At least one metric must be specified in the query. This endpoint uses the realtime report API endpoint to get more up to date data than the standard reporting endpoint. The realtime reporting API supports a maximum of four dimensions compared to the standard nine for the standard report API.
The following is an example query:
SELECT ActiveUsers, Platform FROM ActiveUsers
Columns
| Name | Type | Dimension | DefaultMetric | DefaultDimension | Description |
| AppVersion | String | True | The app's versionName (Android) or short bundle version (iOS). | ||
| City | String | True | The city from which the user activity originated. | ||
| Country | String | True | The country from which the user activity originated. | ||
| DeviceCategory | String | True | The type of device: Desktop, Tablet, or Mobile. | ||
| Platform | String | True | True | The platform on which your app or website ran. | |
| AudienceName | String | True | The given name of an Audience. | ||
| UnifiedScreenName | String | True | The page title (web) or screen name (app) on which the event was logged. | ||
| ActiveUsers | Integer | False | True | The total number of active users. | |
| AudienceId | Long | True | The numeric identifier of an Audience. | ||
| AudienceResourceName | String | True | The resource name of this audience. | ||
| CityId | Integer | True | The geographic ID of the city from which the user activity originated, derived from their IP address. | ||
| CountryId | String | True | The geographic ID of the country from which the user activity originated, derived from their IP address. | ||
| MinutesAgo | Integer | True | The number of minutes ago that an event was collected. 00 is the current minute, and 01 means the previous minute. | ||
| StreamId | Long | True | The numeric data stream identifier for your app or website. | ||
| StreamName | String | True | The data stream name for your app or website. | ||
| EventName | String | True | The name of the event |
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. |