: How are Google Analytic average column values calculated? (excel gives different results) How does excel calculate the site average values in the generic behaviour report page? (i.e. average site

How does excel calculate the site average values in the generic behaviour report page?

(i.e. average site bounce rate, %exit, time on page etc.)

The values I get in my manual Excel calculations of average values (using downloaded GA data) are different to the ones provided in the GA report.

Specifically the mean value I calculate for my bounce rate in Excel is 17.84% but Google Analytics tells me it's 53.10%

How can those numbers be so different?

The total number of pageviews for the site over the past month is ~ 7,400 so it's not a huge sample size, but it wouldn't seem to explain that sample size. Is Google doing some other kind of average, or silently filtering outliers?

Detailed Recreation added below

Set Google Analytics to a month.
Navigate to the Behaviour tab > Site content > All pages
Set sessions to all sessions

Google Analytics Average

The Google Analytics Average I'm using is the top of the bounce rate column on the main landing page. (Screenshot to identify it below.)

Excel Average

On the Google Analytics behaviour sheet I selected the maximum number of rows (Shown at the bottom of the report) and then exported it as an XLSX spreadsheet.

I got the excel mean average by using the AVERAGE formula on the bounce rate column. (Sum all the bounce rates and then divide by the total number)

10.02% popularity Vote Up Vote Down

: When a mod_rewrite redirect is in place, do absent s still cost more server time than present s? I have a series of webpages in which the <html> refers to: <img src="img1.png" [...]

@Gloria169

Posted in: #Css #Htaccess #Images #ModRewrite #PageSpeed

1 Comments

: Finding the Google+ post that links to my site This question is pretty similar to this: Finding the Facebook post or page that links to my site. Obviously this time I'm talking about Google+.

@Gloria169

Posted in: #Google #GooglePlus #Links #Url

1 Comments

: Should we have two copies of the same content or do a redirect? We are a web app for icons and we've got 2 versions of our app: Old one with icon URLs like http://icons8.com/icons/#!/73/home

@Gloria169

Posted in: #302Redirect #DuplicateContent #Google #Redirects

1 Comments

: Can multiple subdomains affect SEO results? The question is there is one site named: www.example.com. But the issue with site is it can open after entering whatever instead of www. e.g.: xxx.example.com

@Gloria169

Posted in: #Domains #Seo #Url

2 Comments

Login to post a comment!

2 Comments

Sorted by latest first Latest Oldest Best

@Sims2060225

Solved it! (or at least I think I did)

Bounce Rate: The percentage of times someone arrives, reads and then leaves. It's only applicable if you landed on the page.

I was downloading data for all my pages, however bounce rate is only applicable for landing pages. It's set to 0 for non-landing pages.

This means when I average bounce rate using all my pages, my average is driven down by a large number of 0's because not all my pages are landed on so they automatically have a bounce rate of 0.

By downloading data for the Landing Page report (428 rows as opposed to 1700), I get an average in Excel 59% compared to 53% in GA. This difference is far more reasonable and could be explained by how GA samples to calculate the bounce rate.

10% popularity Vote Up Vote Down

@Connie744

There are some numbers that don't make sense in your data.

Here's Bounce Rate data from my Analytics:

While the first row is "New Visitors" and the second "Returning Visitors".

By exporting this data set, I have the following results on Excel:

While the first row is "New Visitors", the second "Returning Visitors", the third the average coming from Analytics and the last is the Average done by Excel. As you can see the numbers vary a little bit but nothing serious and certainly not as you describe.

Also, by looking at the image you provided, do the Average calculation and the results are neither the 53.10% or the 17.84% but 32.73% (34.43 + 24.29 + 27.27 + 17.65 + 60 / 5).

Although the problem you report is not only related with Bounce Rate, take a look at this page from Google as it might give you insights on how it's calculated. support.google.com/analytics/answer/2525491?hl=en

10% popularity Vote Up Vote Down

Feed

: How are Google Analytic average column values calculated? (excel gives different results) How does excel calculate the site average values in the generic behaviour report page? (i.e. average site

More posts by @Gloria169

: When a mod_rewrite redirect is in place, do absent s still cost more server time than present s? I have a series of webpages in which the <html> refers to: <img src="img1.png" [...]

: Finding the Google+ post that links to my site This question is pretty similar to this: Finding the Facebook post or page that links to my site. Obviously this time I'm talking about Google+.

: Should we have two copies of the same content or do a redirect? We are a web app for icons and we've got 2 versions of our app: Old one with icon URLs like http://icons8.com/icons/#!/73/home

: Can multiple subdomains affect SEO results? The question is there is one site named: www.example.com. But the issue with site is it can open after entering whatever instead of www. e.g.: xxx.example.com

Login to post a comment!

2 Comments

Back to top | Use Dark Theme