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