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. | ||
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 | 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. | ||
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 | |
ViewsPerUser | Decimal | False | True | Average number of screens viewed by each user. | |
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
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
Name | Type | Description |
PropertyId | String | Property ID value to be used when querying this table. |
Last updated