Main Supported Columns for Google Analytics Connector

All ROIVENUE's supported metrics you can download about your customers. If you want to download more specific columns, please ask your Connector's Support.
We listed only the most used dimensions. You can explore all of them in this file.
ga_v3_columns.json
256KB
Code
Google Analytics Supported Columns
Note: If you don't find your column among our supported columns, feel free to ask us on [email protected], if we can't support other columns important for your business. Mostly the limitation isn't, because of us, but because with more columns, the complexity of the query begin to rise, but almost nothing is impossible! :)

User Type

Data Type
Semantic Type
Source
string
dimension
ga:userType
Description: A boolean, either New Visitor or Returning Visitor, indicating if the users are new or returning.

Count of Sessions

Data Type
Semantic Type
Source
string
dimension
ga:visitCount
Description: The session index for a user. Each session from a unique user will get its own incremental index starting from 1 for the first session. Subsequent sessions do not change previous session indices. For example, if a user has 4 sessions to the website, sessionCount for that user will have 4 distinct values of '1' through '4'.

Days Since Last Session

Data Type
Semantic Type
Source
string
dimension
ga:daysSinceLastSession
Description: The number of days elapsed since users last visited the property, used to calculate user loyalty.

Users

Data Type
Semantic Type
Source
integer
metric
ga:users
Description: The total number of users for the requested time period.

New Users

Data Type
Semantic Type
Source
integer
metric
ga:newUsers
Description: The number of sessions marked as a user's first sessions

Percentage of New Sessions

Data Type
Semantic Type
Source
percent
metric
ga:percentNewSessions
Description: The percentage of sessions by users who had never visited the property before.

1-Day Active Users

Data Type
Semantic Type
Source
integer
metric
ga:1dayUsers
Description: Total number of 1-day active users for each day in the requested time period. At least one of ga:nthDay, ga:date, or ga:day must be specified as a dimension to query this metric. For a given date, the returned value will be the total number of unique users for the 1-day period ending on the given date.

7-Day Active Users

Data Type
Semantic Type
Source
integer
metric
ga:7dayUsers
Description: Total number of 7-day active users for each day in the requested time period. At least one of ga:nthDay, ga:date, or ga:day must be specified as a dimension to query this metric. For a given date, the returned value will be the total number of unique users for the 7-day period ending on the given date.

14Day Active Users

Data Type
Semantic Type
Source
integer
metric
ga:14dayUsers
Description: Total number of 14-day active users for each day in the requested time period. At least one of ga:nthDay, ga:date, or ga:day must be specified as a dimension to query this metric. For a given date, the returned value will be the total number of unique users for the 14-day period ending on the given date.

Session Duration

Data Type
Semantic Type
Source
string
dimension
ga:sessionDurationBucket
Description: The length (returned as a string) of a session measured in seconds and reported in second increments.

Sessions

Data Type
Semantic Type
Source
integer
metric
ga:sessions
Description: The total number of sessions.

Bounces

Data Type
Semantic Type
Source
integer
metric
ga:bounces
Description: The total number of single page (or single interaction hit) sessions for the property.

Bounce Rate

Data Type
Semantic Type
Source
percent
integer
ga:bounceRate
Description: The percentage of single-page session (i.e., session in which the person left the property from the first page).

Session Duration

Data Type
Semantic Type
Source
time
metric
ga:sessionDuration
Description: Total duration (in seconds) of users' sessions.

Traffic Sources

Data Type
Semantic Type
Source
string
dimension
ga:referralPath
Description: The path of the referring URL (e.g., document.referrer). If someone places on their webpage a link to the property, this is the path of the page containing the referring link.

Campaign Name

Data Type
Semantic Type
Source
string
dimension
ga:campaign
Description: For manual campaign tracking, it is the value of the utm_campaign campaign tracking parameter. For AdWords autotagging, it is the name(s) of the online ad campaign(s) you use for the property. If you use neither, its value is (not set).

Source

Data Type
Semantic Type
Source
string
dimension
ga:source
Description: The source of referrals. For manual campaign tracking, it is the value of the utm_source campaign tracking parameter. For AdWords autotagging, it is google. If you use neither, it is the domain of the source (e.g., document.referrer) referring the users. It may also contain a port address. If users arrived without a referrer, its value is (direct).

Medium

Data Type
Semantic Type
Source
string
dimension
ga:medium
Description: The type of referrals. For manual campaign tracking, it is the value of the utm_medium campaign tracking parameter. For AdWords autotagging, it is cpc. If users came from a search engine detected by Google Analytics, it is organic. If the referrer is not a search engine, it is referral. If users came directly to the property and document.referrer is empty, its value is (none).

Source/Medium

Data Type
Semantic Type
Source
string
dimension
ga:sourceMedium
Description: Combined values of ga:source and ga:medium.

Keyword

Data Type
Semantic Type
Source
string
dimension
ga:keyword
Description: For manual campaign tracking, it is the value of the utm_term campaign tracking parameter. For AdWords traffic, it contains the best matching targeting criteria. For the display network, where multiple targeting criteria could have caused the ad to show up, it returns the best matching targeting criteria as selected by Ads. This could be display_keyword, site placement, boomuserlist, user_interest, age, or gender. Otherwise its value is (not set).

Ad Content

Data Type
Semantic Type
Source
string
dimension
ga:adContent
Description: For manual campaign tracking, it is the value of the utm_content campaign tracking parameter. For AdWords autotagging, it is the first line of the text for the online Ad campaign. If you use mad libs for the AdWords content, it contains the keywords you provided for the mad libs keyword match. If you use none of the above, its value is (not set).

Organic Searches

Data Type
Semantic Type
Source
integer
metric
ga:organicSearches
Description: The number of organic searches happened in a session. This metric is search engine agnostic.

Client ID

Data Type
Semantic Type
Source
string
dimension
ga:clientID
Description: Obfuscated cookieID

Ad Distribution Network

Data Type
Semantic Type
Source
string
dimension
ga:adDistributionNetwork
Description: The network (Content, Search, Search partners, etc.) used to deliver the ads.

Ad Group

Data Type
Semantic Type
Source
string
dimension
ga:adGroup
Description: The name of the AdWords ad group.

Transactions per User

Data Type
Semantic Type
Source
float
metric
ga:transactionsPerUser
Description: Total number of transactions divided by total number of users.

Refunds

Data Type
Semantic Type
Source
float
metric
ga:totalRefunds
Description: Number of refunds that have been issued (Enhanced Ecommerce).

Number of Sessions per User

Data Type
Semantic Type
Source
float
metric
ga:sessionsPerUser
Description: The total number of sessions divided by the total number of users.

Revenue per User

Data Type
Semantic Type
Source
currency
metric
ga:revenuePerUser
Description: The total sale revenue (excluding shipping and tax) of the transaction divided by the total number of users.

Refund Amount

Data Type
Semantic Type
Source
currency
metric
ga:refundAmount
Description: Currency amount refunded for a transaction (Enhanced Ecommerce).

Product Revenue per Purchase

Data Type
Semantic Type
Source
currency
metric
ga:productRevenuePerPurchase
Description: Average product revenue per purchase (commonly used with Product Coupon Code) (ga:itemRevenue / ga:uniquePurchases) - (Enhanced Ecommerce).", "calculation": "ga:itemRevenue / ga:uniquePurchases

Gender of Users.

Data Type
Semantic Type
Source
string
dimension
ga:userGender
Description: Gender of users.

ISO Week of ISO Year

Data Type
Semantic Type
Source
string
dimension
ga:isoYearIsoWeek
Description:Combined values of ga:isoYear and ga:isoWeek.

ISO Year

Data Type
Semantic Type
Source
string
dimension
ga:isonYear
Description: The ISO year of the session. For details, see http://en.wikipedia.org/wiki/ISO_week_date. ga:isoYear should only be used with ga:isoWeek because ga:week represents Gregorian calendar.

ISO Week

Data Type
Semantic Type
Source
string
dimension
ga:isonWeek
Description: ISO week number, where each week starts on Monday. For details, see http://en.wikipedia.org/wiki/ISO_week_date. ga:isoWeek should only be used with ga:isoYear because ga:year represents Gregorian calendar.

Week of Year

Data Type
Semantic Type
Source
string
dimension
ga:yearWeek
Description: Combined values of ga:year and ga:week.

Month of Year

Data Type
Semantic Type
Source
string
dimension
ga:yearMonth
Description: Combined values of ga:year and ga:month.

Date Hour and Minute

Data Type
Semantic Type
Source
string
dimension
ga:customVarValueXX
Description: The value for the requested custom variable.

Custom Metric XX Value

Data Type
Semantic Type
Source
string
dimension
ga:metricXX
Description: The value of the requested custom metric, where XX refers to the number or index of the custom metric. Note that the data type of ga:metricXX can be INTEGER, CURRENCY, or TIME.

Custom Variable (Value XX)

Data Type
Semantic Type
Source
string
dimension
ga:customVarValueXX
Description: The value for the requested custom variable.

Custom Dimension XX

Data Type
Semantic Type
Source
string
dimension
ga:dimensionXX
Description: The value of the requested custom dimension, where XX refers to the number or index of the custom dimension.

Product Revenue

Data Type
Semantic Type
Source
currency
metric
ga:itemRevenue
Description: The total revenue from purchased product items.

Avg. Price

Data Type
Semantic Type
Source
currency
metric
ga:revenuePerItem
Description: The average revenue per item.

Quantity

Data Type
Semantic Type
Source
integer
metric
ga:itemQuantity
Description: Total number of items purchased. For example, if users purchase 2 frisbees and 5 tennis balls, this will be 7.

Total Value

Data Type
Semantic Type
Source
currency
metric
ga:totalValue
Description: Total value for the property (including total revenue and total goal value).

Tax

Data Type
Semantic Type
Source
currency
metric
ga:transactionTax
Description: Total tax for the transaction.

Shipping

Data Type
Semantic Type
Source
currency
metric
ga:transactionShipping
Description: The total cost of shipping.

Revenue

Data Type
Semantic Type
Source
currency
metric
ga:transactionRevenue
Description: The total sale revenue (excluding shipping and tax) of the transaction.

Sessions to Transaction

Data Type
Semantic Type
Source
string
dimension
ga:sessionsToTransaction
Description: The number of sessions between users' purchases and the related campaigns that lead to the purchases.

Transaction ID

Data Type
Semantic Type
Source
string
dimension
ga:transactionId
Description: The transaction ID, supplied by the ecommerce tracking method, for the purchase in the shopping cart.

Event Value

Data Type
Semantic Type
Source
currency
metric
ga:eventValue
Description: Total value of events for the profile.

Unique Events

Data Type
Semantic Type
Source
currency
metric
ga:uniqueEvents
Description: The number of unique events. Events in different sessions are counted as separate events.

Exits

Data Type
Semantic Type
Source
integer
metric
ga:transactionRevenue
Description: The number of exits from the property.

Avg. Time on Page

Data Type
Semantic Type
Source
integer
metric
ga:avgTimeOnPage
Description: The average time users spent viewing this page or a set of pages.

Pageviews

Data Type
Semantic Type
Source
integer
metric
ga:pageviews
Description: The total number of pageviews for the property.

Entrances

Data Type
Semantic Type
Source
integer
metric
ga:entrances
Description: The number of entrances to the property measured as the first pageview in a session, typically used with landingPagePath.

City

Data Type
Semantic Type
Source
string
dimension
ga:city
Description: Users' city, derived from their IP addresses or Geographical IDs

Country

Data Type
Semantic Type
Source
string
dimension
ga:country
Description: Users' country, derived from their IP addresses or Geographical IDs.

Platform or Device

Data Type
Semantic Type
Source
string
dimension
ga:deviceCategory
Description: The type of device: desktop, tablet, or mobile.

Operating System

Data Type
Semantic Type
Source
string
dimension
ga:operatingSystem
Description: Users' operating system, for example, Windows, Linux, Macintosh, or iOS.

Browser

Data Type
Semantic Type
Source
string
dimension
ga:browser
Description: The name of users' browsers, for example, Internet Explorer or Firefox.

Goal XX Abandoned Funnels

Data Type
Semantic Type
Source
integer
metric
ga:goalXXAbandons
Description: The number of times users started conversion activity on the requested goal number without actually completing it.

Goal XX Conversion Rate

Data Type
Semantic Type
Source
percent
metric
ga:goalXXConversionRate
Description: Percentage of sessions resulting in a conversion to the requested goal number.

Goal XX Conversion Rate

Data Type
Semantic Type
Source
percent
metric
ga:goalXXConversionRate
Description: Percentage of sessions resulting in a conversion to the requested goal number.

Goal XX Conversion Value

Data Type
Semantic Type
Source
currency
metric
ga:goalXXValue
Description: The total numeric value for the requested goal number.

Goal XX Completions

Data Type
Semantic Type
Source
integer
metric
ga:goalXXCompletions
Description: The total number of completions for the requested goal number.

Goal Starts

Data Type
Semantic Type
Source
integer
metric
ga:goalXXStarts
Description: The total number of starts for the requested goal number.

Goal XX Conversion Rate

Data Type
Semantic Type
Source
percent
metric
ga:goalXXConversionRate
Description: Percentage of sessions resulting in a conversion to the requested goal number.

Goal XX Conversion Rate

Data Type
Semantic Type
Source
percent
metric
ga:goalXXConversionRate
Description: Percentage of sessions resulting in a conversion to the requested goal number.