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! :)
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.
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'.
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.
Data Type | Semantic Type | Source |
integer | metric | ga:users |
Description: The total number of users for the requested time period.
Data Type | Semantic Type | Source |
integer | metric | ga:newUsers |
Description: The number of sessions marked as a user's first sessions
Data Type | Semantic Type | Source |
percent | metric | ga:percentNewSessions |
Description: The percentage of sessions by users who had never visited the property before.
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.
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.
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.
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.
Data Type | Semantic Type | Source |
integer | metric | ga:sessions |
Description: The total number of sessions.
Data Type | Semantic Type | Source |
integer | metric | ga:bounces |
Description: The total number of single page (or single interaction hit) sessions for the property.
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).
Data Type | Semantic Type | Source |
time | metric | ga:sessionDuration |
Description: Total duration (in seconds) of users' sessions.
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.
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).
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).
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).
Data Type | Semantic Type | Source |
string | dimension | ga:sourceMedium |
Description: Combined values of ga:source and ga:medium.
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).
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).
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.
Data Type | Semantic Type | Source |
string | dimension | ga:clientID |
Description: Obfuscated cookieID
Data Type | Semantic Type | Source |
string | dimension | ga:adDistributionNetwork |
Description: The network (Content, Search, Search partners, etc.) used to deliver the ads.
Data Type | Semantic Type | Source |
string | dimension | ga:adGroup |
Description: The name of the AdWords ad group.
Data Type | Semantic Type | Source |
float | metric | ga:transactionsPerUser |
Description: Total number of transactions divided by total number of users.
Data Type | Semantic Type | Source |
float | metric | ga:totalRefunds |
Description: Number of refunds that have been issued (Enhanced Ecommerce).
Data Type | Semantic Type | Source |
float | metric | ga:sessionsPerUser |
Description: The total number of sessions divided by the total number of users.
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.
Data Type | Semantic Type | Source |
currency | metric | ga:refundAmount |
Description: Currency amount refunded for a transaction (Enhanced Ecommerce).
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
Data Type | Semantic Type | Source |
string | dimension | ga:userGender |
Description: Gender of users.
Data Type | Semantic Type | Source |
string | dimension | ga:isoYearIsoWeek |
Description:Combined values of ga:isoYear and ga:isoWeek.
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.
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.
Data Type | Semantic Type | Source |
string | dimension | ga:yearWeek |
Description: Combined values of ga:year and ga:week.
Data Type | Semantic Type | Source |
string | dimension | ga:yearMonth |
Description: Combined values of ga:year and ga:month.
Data Type | Semantic Type | Source |
string | dimension | ga:customVarValueXX |
Description: The value for the requested custom variable.
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.
Data Type | Semantic Type | Source |
string | dimension | ga:customVarValueXX |
Description: The value for the requested custom variable.
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.
Data Type | Semantic Type | Source |
currency | metric | ga:itemRevenue |
Description: The total revenue from purchased product items.
Data Type | Semantic Type | Source |
currency | metric | ga:revenuePerItem |
Description: The average revenue per item.
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.
Data Type | Semantic Type | Source |
currency | metric | ga:totalValue |
Description: Total value for the property (including total revenue and total goal value).
Data Type | Semantic Type | Source |
currency | metric | ga:transactionTax |
Description: Total tax for the transaction.
Data Type | Semantic Type | Source |
currency | metric | ga:transactionShipping |
Description: The total cost of shipping.
Data Type | Semantic Type | Source |
currency | metric | ga:transactionRevenue |
Description: The total sale revenue (excluding shipping and tax) of the 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.
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.
Data Type | Semantic Type | Source |
currency | metric | ga:eventValue |
Description: Total value of events for the profile.
Data Type | Semantic Type | Source |
currency | metric | ga:uniqueEvents |
Description: The number of unique events. Events in different sessions are counted as separate events.
Data Type | Semantic Type | Source |
integer | metric | ga:transactionRevenue |
Description: The number of exits from the property.
Data Type | Semantic Type | Source |
integer | metric | ga:avgTimeOnPage |
Description: The average time users spent viewing this page or a set of pages.
Data Type | Semantic Type | Source |
integer | metric | ga:pageviews |
Description: The total number of pageviews for the property.
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.
Data Type | Semantic Type | Source |
string | dimension | ga:city |
Description: Users' city, derived from their IP addresses or Geographical IDs
Data Type | Semantic Type | Source |
string | dimension | ga:country |
Description: Users' country, derived from their IP addresses or Geographical IDs.
Data Type | Semantic Type | Source |
string | dimension | ga:deviceCategory |
Description: The type of device: desktop, tablet, or mobile.
Data Type | Semantic Type | Source |
string | dimension | ga:operatingSystem |
Description: Users' operating system, for example, Windows, Linux, Macintosh, or iOS.
Data Type | Semantic Type | Source |
string | dimension | ga:browser |
Description: The name of users' browsers, for example, Internet Explorer or Firefox.
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.
Data Type | Semantic Type | Source |
percent | metric | ga:goalXXConversionRate |
Description: Percentage of sessions resulting in a conversion to the requested goal number.
Data Type | Semantic Type | Source |
percent | metric | ga:goalXXConversionRate |
Description: Percentage of sessions resulting in a conversion to the requested goal number.
Data Type | Semantic Type | Source |
currency | metric | ga:goalXXValue |
Description: The total numeric value for the requested goal number.
Data Type | Semantic Type | Source |
integer | metric | ga:goalXXCompletions |
Description: The total number of completions for the requested goal number.
Data Type | Semantic Type | Source |
integer | metric | ga:goalXXStarts |
Description: The total number of starts for the requested goal number.
Data Type | Semantic Type | Source |
percent | metric | ga:goalXXConversionRate |
Description: Percentage of sessions resulting in a conversion to the requested goal number.
Data Type | Semantic Type | Source |
percent | metric | ga:goalXXConversionRate |
Description: Percentage of sessions resulting in a conversion to the requested goal number.