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