Magento Business Intelligence Help Center

Expected Google Analytics data

After you've connected a Google Analytics integration, you can interact with your GA metrics immediately in the Visual Report Builder. When you enter the Visual Report Builder, if you click Add a Metric, a series of metrics from your GA profile(s) will appear in a drop-down immediately beneath the metrics in your data warehouse. 

The Google Analytics integration is live -- this means that the Report Builder requests data from Google Analytics immediately when you add a metric to your report. It also means that the metrics you can access are defined exactly as they are in GA, and that these values aren't warehoused in your Magento BI account -- only displayed visually in your reports. 

Google Analytics integrations in Magento BI utilize the GA Core Reporting API, and support the following metrics and dimensions [Note: In order to avoid unexpected or nonsensical results, confirm that any dimensions you use are compatible with the metric(s) you use in the Report Builder. You can check here]:

Supported Metrics

Magento BI Display Name GA Name / Formula
Page Views ga:pageviews
Total Time Spent On Page ga:timeOnPage
Bounces (One Page Visits) ga:bounces
Entrances ga:entrances
Exits ga:exits
Unique Pageviews ga:uniquePageviews
Ad Clicks ga:adClicks
Ad Cost ga:adCost
Cost per Click (CPC) ga:CPC
Cost per Thousand Impressions (CPM) ga:CPM
Click-Through Rate (CTR) ga:CTR
Impressions ga:impressions
Product Revenue ga:itemRevenue
Products Purchased ga:itemQuantity
Revenue ga:transactionRevenue
Transactions ga:transactions
Shipping Revenue ga:transactionShipping
Tax Revenue ga:transactionTax
Unique Purchases ga:uniquePurchases
Pageviews After Internal Search ga:searchDepth
Visit Duration After Internal Search ga:searchDuration
Exits After Internal Search ga:searchExits
Internal Search Refinements ga:searchRefinements
Unique Users Using Internal Search ga:searchUniques
Bounce Rate ga:visitBounceRate
Average Time on Page ga:avgTimeOnPage
Average Session Length ga:avgSessionDuration
All Goals Conversion Rate ga:goalConversionRateAll
Total Events ga:totalEvents
Unique Events ga:uniqueEvents
Event Value ga:eventValue
Average Domain Lookup Time ga:avgDomainLookupTime
Average Page Download Time ga:avgPageDownloadTime
Average Page Load Time ga:avgPageLoadTime
Transactions Per Visit ga:transactionsPerVisit
Sessions ga:sessions
Users ga:users
New Users ga:newUsers
Sessions Where Internal Search Used ga:searchSessions
Goal X Starts ga:goal...Starts
Goal X Completions ga:goal...Completions
Goal X Conversion Rate ga:goal...ConversionRate
Goal X Total Value ga:goal...Value
All Goal Starts ga:goalStartsAll
All Goal Completions ga:goalCompletionsAll
All Goals Conversion Rate ga:goalConversionRateAll
Total Goal Value ga:goal1ValueAll

Supported Dimensions

Magento BI Display Name GA Name / Formula Groupable?
Ad Content ga:adContent Yes
Ad Group ga:adGroup Yes
Matched Search Query ga:adMatchedQuery Yes
Placement Domain ga:adPlacementDomain Yes
Placement URL ga:adPlacementUrl Yes
Affiliation ga:affiliation Yes
Browser ga:browser Yes
Browser Version ga:browserVersion Yes
Campaign ga:campaign Yes
Continent ga:continent Yes
Custom Variable 2 ga:customVarValue2 Yes
Custom Variable 3 ga:customVarValue3 Yes
Custom Variable 4 ga:customVarValue4 Yes
Custom Variable 5 ga:customVarValue5 Yes
Date ga:date No
Day ga:day No
Days Since Last Session ga:daysSinceLastSession Yes
Days Since Referring Campagin ga:daysToTransaction Yes
Device Category ga:deviceCategory Yes
Custom Dimension 10 ga:dimension10 Yes
Custom Dimension 12 ga:dimension12 Yes
Custom Dimension 13 ga:dimension13 Yes
Custom Dimension 18 ga:dimension18 Yes
Custom Dimension 2 ga:dimension2 Yes
Custom Dimension 20 ga:dimension20 Yes
Custom Dimension 3 ga:dimension3 Yes
Custom Dimension 4 ga:dimension4 Yes
Custom Dimension 5 ga:dimension5 Yes
Custom Dimension 8 ga:dimension8 Yes
Custom Dimension 9 ga:dimension9 Yes
Event Action ga:eventAction Yes
Event Category ga:eventCategory Yes
Event Label ga:eventLabel Yes
Exit Page Path ga:exitPagePath Yes
Flash Version Supported ga:flashVersion Yes
Hour ga:hour No
In-Market Segment ga:interestInMarketCategory Yes
Language ga:language Yes
Longitude ga:longitude No
Medium ga:medium Yes
Metro ga:metro Yes
Mobile Device Branding ga:mobileDeviceBranding Yes
Mobile Device Info ga:mobileDeviceInfo Yes
Month ga:month No
Operating System ga:operatingSystem Yes
Operating System Version ga:operatingSystemVersion Yes
Pages Viewed per Session ga:pageDepth Yes
Page Path ga:pagePath Yes
Product Category ga:productCategory Yes
Product Name ga:productName Yes
Referral URL ga:referralPath No
Region (State) ga:region Yes
Screen Colors ga:screenColors Yes
Screen Resolution ga:screenResolution Yes
Internal Search Category ga:searchCategory Yes
Internal Search Refined Keyword(s) ga:searchKeywordRefinement Yes
Internal Search Used? ga:searchUsed Yes
Second Page Path ga:secondPagePath Yes
Source ga:source Yes
Sub-Continent ga:subContinent Yes
Transaction ID ga:transactionId Yes
Custom (User Defined) Value ga:userDefinedValue Yes
Year ga:year No
Was this article helpful?
0 out of 0 found this helpful

Comments

Powered by Zendesk