SESSION_ANALYTICS_GOOGLE

Returns a report with the most common session metrics within a date range.

icon of Google Analytics (UA)Google Analytics (UA)
Not a big fan of functions?
Use the Actions Wizard to configure any action in Rows without functions.

Parameter List

Syntax
SESSION_ANALYTICS_GOOGLE(iddate_range
[page_path]
[dimensions]
[sort]
[filters]
[segments]
)
id

The unique view profile ID, i.e.: 108740273. From the LIST_ACCOUNTS_ANALYTICS_GOOGLE() function, the id can be found under profile object.

date_range

Date range, i.e.: ">2019", ">2019-11-01" or "[2010-01-01;2019-01-01]". See how to automate date ranges here.

[optional] page_path

The relative path of the page to filter the metrics (e.g. '/privacy')

[optional] dimensions

List of dimensions to query (e.g. ga:browser,ga:city). Supports up to 7 dimensions. Explore all the dimensions here.

Selected options:
ga:adContent
ga:appId
ga:appInstallerId
ga:appName
ga:appVersion
ga:browser
ga:browserSize
ga:browserVersion
ga:campaign
ga:campaignCode
ga:city
ga:cityId
ga:continent
ga:continentId
ga:country
ga:countryIsoCode
ga:dataSource
ga:date
ga:dateHour
ga:day
ga:dayOfWeekName
ga:daysSinceLastSession
ga:deviceCategory
ga:eventAction
ga:eventCategory
ga:eventLabel
ga:exitPagePath
ga:exitScreenName
ga:flashVersion
ga:fullReferrer
ga:hasSocialSourceReferral
ga:hostname
ga:hour
ga:javaEnabled
ga:keyword
ga:landingPagePath
ga:landingScreenName
ga:language
ga:latitude
ga:longitude
ga:medium
ga:metro
ga:metroId
ga:minute
ga:mobileDeviceBranding
ga:mobileDeviceInfo
ga:mobileDeviceMarketingName
ga:mobileDeviceModel
ga:mobileInputSelector
ga:month
ga:networkDomain
ga:networkLocation
ga:operatingSystem
ga:operatingSystemVersion
ga:pageDepth
ga:pagePath
ga:pagePathLevel1
ga:pagePathLevel2
ga:pagePathLevel3
ga:pagePathLevel4
ga:pageTitle
ga:previousPagePath
ga:referralPath
ga:region
ga:regionId
ga:regionIsoCode
ga:screenColors
ga:screenDepth
ga:screenName
ga:screenResolution
ga:searchAfterDestinationPage
ga:searchCategory
ga:searchDestinationPage
ga:searchKeyword
ga:searchKeywordRefinement
ga:searchStartPage
ga:searchUsed
ga:secondPagePath
ga:sessionCount
ga:sessionDurationBucket
ga:socialNetwork
ga:source
ga:sourceMedium
ga:sourcePropertyDisplayName
ga:sourcePropertyTrackingId
ga:subContinent
ga:subContinentCode
ga:userBucket
ga:userDefinedValue
ga:userTimingCategory
ga:userTimingLabel
ga:userTimingVariable
ga:userType
ga:week
ga:year
ga:yearMonth
ga:yearWeek
[optional] sort

A list of metrics and dimensions indicating the sorting order and its direction, (e.g. ga:country,ga:browser). Descending sort order is given by "-" prefix (e.g -ga:country).

[optional] filters

Dimensions or metrics on which to filter the returned data, followed by the filter expression. (e.g. ga:country==United States;ga:browser==Firefox).

[optional] segments

The Id of a built-in or custom Google Analytics segment (e.g. "gaid::-2") or specifying a segment using "users::" or "sessions::" (e.g. "users::condition::ga:browser==Chrome" to select users who used Chrome browser in at least one of their sessions or "sessions::condition::ga:browser==Chrome" to select sessions where the Chrome browser was used).

More details

You can find more details on how the dimensions, filters, sorting and segments here

Examples

SESSION_ANALYTICS_GOOGLE("ga:108740273", ">2020-01-01") returns all page metrics for given project id (e.g."ga:108740273") since ">2020-01-01".