KNOWLEDGE BASE

Useful GA Measures


Product(s): Tableau Desktop
Version(s): 9.0, 8.3, 8.2, 8.1, 8.0
Last Modified Date: 16 Aug 2016

Beginning with Tableau Desktop 8.0, you can connect directly to your Google Analytics (GA) data using the Google Analytics connector. When establishing a connection to your GA data, you can choose from a set of dimensions and measures that you will use to build your view. In addition to the fields available through the GA connection, you may also wish to use one or more of the GA measures listed below.

 

To use one of the GA measures listed below, create a custom calculation in your workbook that uses the formula listed in the Tableau Formula column of the table. Make sure to include the measures used by the formula in your GA connection.

Group Measures NameTableau FormulaVersion
AdSenseAdSense CTR

[AdSense Ads Clicks]/[AdSense Page Impressions]

8.2 and later
AdSenseAdSense eCPM

[AdSense Revenue]/[AdSense Page Impressions]*0.001

8.2 and later
AdWordsCPM[Cost] / ([Impressions] / 1000)8.0 and later
AdWordsCPC [Cost] / [Clicks]8.0 and later
AdWordsCTR[Clicks] / [Impressions]8.0 and later
AdWordsCost per Transaction [Cost] / [Transactions]8.0 and later
AdWordsCost per Goal [Cost] / [Goal Completions]8.0 and later
AdWords Cost per Conversion[Cost] / ([Transactions] + [Goal Completions])8.0 and later
AdWordsRPC ([Revenue] + [Goal Value]) / [Clicks]8.0 and later
AdWordsROI([Revenue] + [Goal Value] - [Cost]) / [Cost]8.0 and later
AdWordsMargin ([Revenue] + [Goal Value] - [Cost]) / ([Revenue] + [Goal Value])8.0 and later
App TrackingScreens / Sessions

[Screen Views]/[Visits]

8.2
App TrackingScreens / Sessions

[Screen Views]/[Sessions]

8.2.1 and later
EcommerceEcommerce Conversion Rate[Transactions] / [Visits]8.0 – 8.2
EcommerceEcommerce Conversion Rate[Transactions] / [Sessions]8.2.1 and later
EcommerceAvg. Value [Revenue] / [Transactions]8.0 and later
Ecommerce Per Visit Value [Revenue] / [Visits]8.0 – 8.2
Ecommerce Per Session Value [Revenue] / [Sessions]8.2.1 and later
EcommerceTotal Value[Revenue] + [Goal Value]8.0 and later
EcommerceRevenue per Item[Product Revenue] / [Quantity]8.0 and later
EcommerceItems per Purchase [Quantity] / [Unique Purchases]8.0 and later
Event TrackingAvg. Value [Event Value] / [Total Events]8.0 and later
Event Tracking Events per Visit with Event[Total Events] / [Visits with Event]8.0 – 8.2
Event Tracking Events per Session with Event[Total Events] / [Sessions with Event]8.2.1 and later
ExceptionsExceptions / Screen

[Exceptions]/[Screen Views]

8.2 and later
ExceptionsCrashes / Screen

[Fatal Exceptions]/[Screen Views]

8.2 and later
Goal ConversionsPer Visit Goal Value [Goal Value] / [Visits]8.0 – 8.2
Goal ConversionsPer Session Goal Value [Goal Value] / [Sessions]8.2.1 and later
Goal ConversionsGoal Conversion Rate [Goal Completions] / [Visits]8.0 – 8.2
Goal ConversionsGoal Conversion Rate [Goal Completions] / [Sessions]8.2.1 and later
Goal Conversions Abandoned Funnels [Goal Starts] - [Goal Completions]8.0 and later
Goal ConversionsTotal Abandonment Rate ([Goal Starts] - [Goal Completions]) / [Goal Starts]8.0 and later
Internal SearchAvg. Search Results Views [Search Result Views] / [Total Unique Searches]8.0 and later
Internal Search % Visits with Search[Visits with Search] / [Visits]8.0 – 8.2
Internal Search % Sessions with Search[Sessions with Search] / [Sessions]8.2.1 and later
Internal SearchAvg. Search Depth[Search Depth] / [Total Unique Searches]8.0 and later
Internal SearchAvg. Search Duration [Time after Search] / [Total Unique Searches]8.0 and later
Internal Search % Search Exits [Search Exits] / [Total Unique Searches]8.0 and later
Internal Search Search Goal Conversion Rate [Goal Completions] / [Total Unique Searches]8.0 and later
Internal SearchGoal Value per Search [Goal Value] / [Total Unique Searches]8.0 and later
OtherApp Views per Visit [App Views] / [Visits]8.0 – 8.2
OtherApp Views per Session [App Views] / [Sessions]8.2.1 and later
OtherAvg. Visit Duration [Visit Duration] / [Visits]8.0 – 8.2
OtherAvg. Session Duration [Session Duration] / [Sessions]8.2.1 and later
OtherActions per Social Visit [Social Actions / [Unique Social Actions]8.0 – 8.2
OtherActions per Social Session [Social Actions / [Unique Social Actions]8.2.1 and later
OtherAvg. User Timing (sec) [User Timing (ms)] / [User Timing Sample]8.0 and later
Other % New Visits[New Visits] / [Visits]8.0 – 8.2
Other % New Sessions[New Sessions] / [Sessions]8.2.1 and later
Page Tracking Entrances/Pageviews [Entrances] / [Pageviews]8.0 and later
Page Tracking Entrance Bounce Rate [Bounces] / [Entrances]8.0 and later
Page TrackingBounce Rate [Bounces] / [Visits]8.0 – 8.2
Page TrackingBounce Rate [Bounces] / [Sessions]8.2.1 and later
Page Tracking Pages/Visit [Pageviews] / [Visits]8.0 – 8.2
Page Tracking Pages/Session [Pageviews] / [Sessions]8.2.1 and later
Page TrackingAvg. Time on Page [Time on Page] / ([Pageviews] - [Exits])8.0 and later
Page Tracking % Exit [Exits] / [Pageviews]8.0 and later
Page TrackingAvg. Page Load Time ([Page Load Time] / [Page Load Sample]) * 0.0018.0 and later
Site Speed Avg.Avg. Document Content Loaded Time (sec)

([Document Content Loaded Time (ms)]/[DOM Latency Metrics Sample])*0.001

8.2 and later
Site Speed Avg.Avg. Document Interactive Time (sec)

([Document Interactive Time (ms)] / [DOM Latency Metrics Sample])*0.001

8.2 and later
Site Speed Avg.Domain Lookup Time ([Domain Lookup Time] / [Speed Metrics Count]) * 0.0018.0 and later
Site Speed Avg.Page Download Time ([Page Download Time] / [Speed Metrics Count]) * 0.0018.0 and later
Site Speed Avg. Redirection Time ([Redirection Time] / [Speed Metrics Count]) * 0.0018.0 and later
Site Speed Avg.Server Connection Time ([Server Connection Time] / [Speed Metrics Count]) * 0.0018.0 and later
Site Speed Avg.Server Response Time ([Server Response Time] / [Speed Metrics Count]) * 0.0018.0 and later

 

 

Alternate Search Terms:missing measures, google, bigquery, google analytics, cloud
Did this article resolve the issue?