JDBC Driver for Google Analytics

Build 22.0.8509


Retrieves Event data.

Table Specific Information


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.


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.


SELECT ステートメントのWHERE 句では、疑似列フィールドを使用して、データソースから返されるタプルを詳細に制御することができます。

Name Type Description
PropertyId String Property ID value to be used when querying this table.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8509