Power BI Connector for Google Analytics

Build 23.0.8839

Engagement

A base view that retrieves Engagement data

Table Specific Information

Select

Retrieves data for Engagement report. At least one metric must be specified in the query. In the query you can also specify up to 9 dimensions. The following are example queries:

	SELECT NewUsers, TotalRevenue FROM Engagement

Columns

Name Type Dimension DefaultMetric DefaultDimension Description
Date Date True The date of the session formatted as YYYYMMDD
Year Integer True The year of the session. A four-digit year from 2005 to the current year.
Month Integer True The month of the session. A two digit integer from 01 to 12.
Week Integer True The week of the session. A two-digit number from 01 to 53. Each week starts on Sunday.
Day Integer True The day of the month. A two-digit number from 01 to 31.
DayOfWeekName String True The day of the week in English. This dimension has values of Sunday, Monday, etc.
IsoWeek Integer True ISO week number, where each week starts on Monday. Example values include 01, 02, 53.
IsoYear Integer True The ISO year of the event. Example values include 2022 2023.
IsoYearIsoWeek Integer True The combined values of isoWeek and isoYear. Example values include 201652 and 201701.
YearMonth Integer True The combined values of year and month. Example values include 202212 or 202301.
YearWeek Integer True The combined values of year and week. Example values include 202253 or 202301.
Hour Integer True A two-digit hour of the day ranging from 00-23 in the timezone configured for the account. This value is also corrected for daylight savings time.
ContentGroup String True A category that applies to items of published content
EventName String True The name of the event
UnifiedPageScreen String True The page path (web) or screen class (app) on which the event was logged
UnifiedScreenClass String True True The page title (web) or screen class (app) on which the event was logged
UnifiedScreenName String True The page title (web) or screen name (app) on which the event was logged
PagePath String True The portion of the URL between the hostname and query string for web
PageTitle String True The web page titles used on your site
Conversions Integer False True The count of conversion events
EngagedSessionsPerUser Decimal False True Average number of engaged sessions per user
EventCount Integer False True The count of events
EventCountPerUser Decimal False True Average number of events triggered by each user
NewUsers Integer False True The number of users who interacted with the site or launched the app for the first time
ScreenPageViews Integer False True The number of app screens or web pages the users viewed. Repeated views of a single page or screen are counted.
TotalRevenue Integer False True The sum of revenue from purchases, subscriptions, and advertising
TotalUsers Integer False True The number of distinct users who visited the site or app
userEngagementDuration Integer False True The total amount of time (in seconds) the website or app was in the foreground of users' device
ViewsPerUser Decimal False True Average number of screens viewed by each user
SessionsPerUser Decimal False False The average number of sessions per user (Sessions divided by Active Users).
StartDate String Start date for fetching Analytics data. Either a date string or a relative date (e.g., today, yesterday, or #daysAgo).
EndDate String End date for fetching Analytics data. Either a date string or a relative date (e.g., today, yesterday, or #daysAgo).
Dimensions String A comma-separated list of dimensions to retrieve in addition to the columns defined in the schema. Set to empty string to retrieve no dimensions.
Metrics String A comma-separated list of metrics to retrieve in addition to the columns defined in the schema

Pseudo-Columns

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

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

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