6 Replies Latest reply on Apr 26, 2015 10:30 PM by Santiago Tacoronte

    Avg Page Load Time Google Analytics

    Chloe Riordan

      Hi Forum-

       

      I am trying to bring in average page load time by month-- Using this link (http://kb.tableausoftware.com/articles/knowledgebase/useful-ga-measures) I used the calculated field: ([Page Load Time]/[Page Load Sample])*.001  --- and get 125.019 for May (based on GA the answer is 4.38 seconds)  I tried altering the formatting but I think I'm missing something here--

       

      Thanks!

        • 1. Avg Page Load Time Google Analytics
          Shawn Wallwork

          What do your two page fields look like? What sort of format are time and sample in?

           

          --Shawn

          • 2. Re: Avg Page Load Time Google Analytics
            Chloe Riordan

            They are all just in default number format-- the only thing I could think to change it to was a custom number format of something like 00:00---  but I've attached a screenshot of what it looks likePg load time.png

            • 3. Re: Avg Page Load Time Google Analytics
              Shawn Wallwork

              Time really isn't a Measure, so first you'll need to make it a dimension. And you'll also need to change the data type from number to date/time. I'm also not really sure your basic calculation can be done using the fields you have chosen. Google defines these two as:

               

              • Page Load Sample: The number of pageviews that were sampled to calculate the average page-load time.
              • Avg Page Load Time: The average amount of time (in seconds) it takes that page to load, from initiation of the pageview (e.g., click on a page link) to load completion in the browser.
              • Page-load time for a sample of pageviews on your site. You can view the data across different dimensions to see how quickly your pages loaded from a variety of perspectives (e.g., in different browsers, in different countries). No additional configuration is required to see this data. Data is available in the Overview and Page Timings reports.

               

              So I'm not sure you can divide Page Load Time or Avg Page Load Time by Sample size and get the same number Google is calculating for speed. (?) But if you want help setting it up, post a packaged workbook with a bit of sample data and I'll give you a hand.

               

              --Shawn

              1 of 1 people found this helpful
              • 4. Re: Avg Page Load Time Google Analytics
                Chloe Riordan

                Hey I figured it out-  it works fine the way I had it I just needed to change the measure values aggregation from SUM to AVG-- thanks for your help though! 

                • 5. Re: Avg Page Load Time Google Analytics
                  Bruce Segal

                  Chloe:

                   

                  Your current formula will be accurate if you just look at the "Page" field from GA. However if you aggregate single "Pages" into groups, say sections then you will not have an accurate number. You will get an average of averages as you change aggregations in your dimensions.

                   

                  You might want to modify your calculation to render a weighted average that will be accurate for all roll ups of your data.

                   

                  Here's what I use.

                   

                  (  Sum([Page Load Time])/ Sum ([Page Load Sample])  ) * .001

                  // Source: developers.google.com/analytics/devguides/reporting/core/dimsmets/sitespeed#ga:pageLoadTime

                   

                  Now the next thing I'm trying to figure out is why I can't get this formula to work using Pageviews instead of the field Page Load Sample, which is the count of pageviews GA used to calculate the average page load time.

                  • 6. Re: Avg Page Load Time Google Analytics
                    Santiago Tacoronte

                    Thanks Bruce, That seems to be the correct answer!