Useful GA Measures

Version 2

    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.

     

    GroupMeasures 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
    AdWordsCost 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
    EcommercePer Visit Value[Revenue] / [Visits]8.0 – 8.2
    EcommercePer 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 TrackingEvents per Visit with Event[Total Events] / [Visits with Event]8.0 – 8.2
    Event TrackingEvents 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 ConversionsAbandoned 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 SearchSearch 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 TrackingEntrances/Pageviews[Entrances] / [Pageviews]8.0 and later
    Page TrackingEntrance 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 TrackingPages/Visit[Pageviews] / [Visits]8.0 – 8.2
    Page TrackingPages/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