CUSTOM_ANALYTICS_GOOGLE

Get a report with custom Google Analytics metrics within a date range. Dimensions and filters are also available.

Websites
Companies
icon of Google AnalyticsGoogle Analytics
Not a big fan of functions?
Use the Actions Wizard to configure any action in Rows without functions.

Parameter List

Syntax
CUSTOM_ANALYTICS_GOOGLE(iddate_rangemetrics
[page_path]
[dimensions]
[sort]
[filters]
[segment]
)
id

The unique view profile ID. For example: 108740273. Use LIST_ACCOUNTS_ANALYTICS_GOOGLE() to find the ID.

date_range

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

metrics

One or more metrics. For example: "ga:sessions" or "ga:sessions,ga:bounces". Supports up to 10 metrics. See all metrics available in GA's documentation.

Selected options:
ga:1dayUsers
ga:7dayUsers
ga:14dayUsers
ga:28dayUsers
ga:30dayUsers
ga:avgDomContentLoadedTime
ga:avgDomInteractiveTime
ga:avgDomainLookupTime
ga:avgEventValue
ga:avgPageDownloadTime
ga:avgPageLoadTime
ga:avgRedirectionTime
ga:avgScreenviewDuration
ga:avgSearchDepth
ga:avgSearchDuration
ga:avgSearchResultViews
ga:avgServerConnectionTime
ga:avgServerResponseTime
ga:avgSessionDuration
ga:avgTimeOnPage
ga:bounceRate
ga:bounces
ga:domContentLoadedTime
ga:domInteractiveTime
ga:domLatencyMetricsSample
ga:domainLookupTime
ga:entranceRate
ga:entrances
ga:eventValue
ga:eventsPerSessionWithEvent
ga:exitRate
ga:exits
ga:newUsers
ga:organicSearches
ga:pageDownloadTime
ga:pageLoadSample
ga:pageLoadTime
ga:pageValue
ga:pageviews
ga:pageviewsPerSession
ga:percentNewSessions
ga:percentSearchRefinements
ga:percentSessionsWithSearch
ga:redirectionTime
ga:screenviews
ga:screenviewsPerSession
ga:searchDepth
ga:searchDuration
ga:searchExitRate
ga:searchExits
ga:searchRefinements
ga:searchResultViews
ga:searchUniques
ga:serverConnectionTime
ga:serverResponseTime
ga:sessionDuration
ga:sessions
ga:sessionsPerUser
ga:sessionsWithEvent
ga:socialInteractions
ga:socialInteractionsPerSession
ga:speedMetricsSample
ga:timeOnPage
ga:timeOnPage
ga:timeOnScreen
ga:transactionsPerSession
ga:transactionRevenue
ga:totalEvents
ga:uniqueDimensionCombinations
ga:uniqueEvents
ga:uniquePageviews
ga:uniqueScreenviews
ga:uniqueSocialInteractions
ga:userTimingLabel
ga:userTimingValue
ga:userTimingVariable
ga:users
[optional] page_path

The relative path of the page to filter the metrics. For example: "/privacy".

[optional] dimensions

One or more dimensions to query. For example: "ga:browser,ga:city". Supports up to 7 dimensions. See all metrics available in GA's documentation.

Selected options:
ga:adContent
ga:appId
ga:appInstallerId
ga:appName
ga:appVersion
ga:browser
ga:browserSize
ga:browserVersion
ga:campaign
ga:campaignCode
ga:channelGrouping
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

One or more metrics and dimensions indicating the sorting order and its direction. For example: "ga:country,ga:browser" or "-ga:country" (descending order).

[optional] filters

One or more metrics or dimensions to filter the returned data, followed by the filter expression. For example: "ga:country==United States;ga:browser==Firefox". For an OR condition, separate the statements with a ",". For an AND, use ";".

[optional] segment

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

CUSTOM_ANALYTICS_GOOGLE("ga:108740273", ">2020-01-01", "ga:pageValue,ga:exits,ga:newUsers") returns all results for the given metrics, for given project id (e.g."ga:108740273") since ">2020-01-01".