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. For details, see http://en.wikipedia.org/wiki/ISO_week_date. Example values include 01, 02, 53. | ||
IsoYear | Integer | True | The ISO year of the event. For details, see http://en.wikipedia.org/wiki/ISO_week_date. 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 | Decimal | 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 | Bigint | 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). |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似列フィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
Name | Type | Description |
PropertyId | String | Property ID value to be used when querying this table |