Events
Retrieves Event data.
Table Specific Information
Select
Retrieves data for Events 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 4 dimensions compared to the standard 9 for the standard report API.
The following is an example query:
SELECT EventCount, Platform FROM Events
As 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 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 | 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 will work when connection property ReportType=reports; | ||
PageTitle | String | True | The web page titles used on your site. This will work when connection property ReportType=reports; | ||
EventCount | Integer | False | True | Number of times an individual event was triggered. | |
Conversions | Integer | 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. |