Engagement
A base view that retrieves Engagement data
View-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 | ||
| KeyEvents | Decimal | False | True | The count of key 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 | Decimal | 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). |
Pseudocolumns
Pseudocolumn fields are used in the WHERE clause of SELECT statements and offer more granular control over the data returned from the data source.
| Name | Type | Description |
| PropertyId | String | Property ID value to be used when querying this table |
| CurrencyCode | String | A currency code in ISO4217 format, such as AED, USD, JPY. If the field is empty, the report uses the property's default currency. |