KeyEvents
A base view that retrieves KeyEvents data
Table Specific Information
Select
Retrieves data for KeyEvents reports. At least one metric must be specified in the query. This endpoint uses the real-time report API endpoint to get more up-to-date data than the standard reporting endpoint. The real-time reporting API supports a maximum of four dimensions compared to nine for the standard report API.
The following is an example query:
SELECT KeyEvents, EventName FROM KeyEvents;
Since PagePath and PlatTitle dimensions are not available in the runRealReport endpoint, use the connection property ReportType = reports to leverage the result with these dimensions.
Columns
| Name | Type | Dimension | DefaultMetric | DefaultDimension | Description |
| AppVersion | String | True | The application'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 | 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 | ||
| EventName | String | True | True | The name of the event | |
| PagePath | String | True | The portion of the URL between the hostname and query string for web. This works when connection property ReportType=reports;. | ||
| PageTitle | String | True | The web page titles used on your site. This works when connection property ReportType=reports; | ||
| 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. | ||
| KeyEvents | String | False | True | The count of key events. |
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 |