Tuesday, 14 June 2016

Google Analytics Measures formulas in Tableau

http://kb.tableau.com/articles/knowledgebase/useful-ga-measures

Group Measures NameTableau FormulaVersion
AdSenseAdSense CTR[AdSense Ads Clicks]/[AdSense Page Impressions]8.2 and later
AdSenseAdSense eCPM[AdSense Revenue]/[AdSense Page Impressions]*0.0018.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.0018.2 and later
Site Speed Avg.Avg. Document Interactive Time (sec)([Document Interactive Time (ms)] / [DOM Latency Metrics Sample])*0.0018.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