Sign up for free
Functions

AD_CAMPAIGNS_ANALYTICS_GOOGLE

Get metrics such as clicks, CPM, CPC, CTR, and impressions about your Ad campaigns by date.

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
AD_CAMPAIGNS_ANALYTICS_GOOGLE(id, date_range, 
[campaign]
, 
[metrics]
, 
[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]".

[optional] campaign

Name or ID of your compaign. For example: "Website Campaign".

[optional] metrics

Range of metrics to retrieve about the campaign. By default, it will return the most common metrics about the ad account. For example: "ga:adCost,ga:adClicks". For a complete list of possible metrics, see this Google documentation.

Selected options:
Ad clicks
Ad cost
CPM
CPC
CTR
Cost per transaction
Cost per goal conversion
Impressions
Cost per conversion
RPC
ROAS
[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: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

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".

[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).

Examples

AD_CAMPAIGNS_ANALYTICS_GOOGLE("ga:108740273", ">2020") returns default metrics about campaigns linked to the `ga:108740273` account since 2020.