Power BI Connector for Google Analytics

Build 23.0.8839

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 propertyReportType=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 Integer False True The count of conversion events

Pseudo-Columns

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

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

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8839