Events
A base view that retrieves Event data
Table Specific Information
Select
Retrieves data for Events 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 EventCount, Platform FROM Events
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; | ||
| EventCount | Integer | False | True | Number of times an individual event was triggered | |
| Conversions | Decimal | False | True | The count of conversion events |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似列フィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description |
| PropertyId | String | Property ID value to be used when querying this table |