JDBC Driver for Google Analytics

Build 22.0.8509


Retrieves Active Users data.

Table Specific Information


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


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.


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