Bounce Rate Question - The percent calculated does not add up
-
Hello All,
I'm attempting to see why organic search bounce rate has increased by 5% when compared to last year for a certain section of my website. I am using a custom segment to filter the specific pages I want to look at. Once the custom segment is set, I go to Acquisition - > Channels - > Organic. Then, I click the Landing Pages tab. Because we don't have keyword data anymore the only thing I can look at is the landing pages that contributed to the change in bounce. Finally, I set my date range and compare to the same date range as last year. Once I set the date range I am presented with a list of URLs and the percent change in bounce rate for each URL. This is where I get confused. If you look at the average bounce rate at the top of the column (example 1 attached) it does not add up with the data below it. If you export all of the data to excel, and then do an "Average" function in Excel, the data adds up to 17.29% instead of 35.04% for Sept. 2013. Why does this not add up? Isn't GA calculating the Average?
Also, I always notice several URLs with only 1 session per URL. Several of these 1 session URLs have a 100% bounce rate. Since the bounce rate at the top of the column (example1) is a reflection of the average bounce rate, wouldn't these 1 session URLs significantly distort my data?
I ultimately just want to see the pages that are contributing to the increased bounce rate when compared to last year. Having a hard time figuring this one out.
Thank you all,
Dave
-
Andy, Thank you so much. I had a feeling I was making this out to be something much harder than it actually was. Of course you can't average percentages. That explains everything. Thank you!
-
If I am reading the question correctly, then its more of a maths questions rather than an SEO question.
You simply can't average % as some figures have more weighting than others, pages with more page views will have a higher weighting to the total average %, than the pages with 1 page view and 100% bounce rate. So simply using the average formula in Excel wouldn't take into account the weighting and assume they all have equal weighting (which unless ever page had the exact same number of page views, isn't the case).
Here is probably a better explanation: http://www.ehow.co.uk/how_6437936_calculate-averages-percentages.html
Hope this is useful.
Thanks
Andy
Browse Questions
Explore more categories
-
Moz Tools
Chat with the community about the Moz tools.
-
SEO Tactics
Discuss the SEO process with fellow marketers
-
Community
Discuss industry events, jobs, and news!
-
Digital Marketing
Chat about tactics outside of SEO
-
Research & Trends
Dive into research and trends in the search industry.
-
Support
Connect on product support and feature requests.
Related Questions
-
Will adjusted bounce rate affect avg time on page?
I recently read Rob Beirne's piece on how and why to set up an adjusted bounce rate in Google Analytics (https://mza.bundledseo.com/blog/adjusted-bounce-rate). I am getting myself ready to talk to our site team about why we should set up an adjusted bounce rate and am anticipating some questions I'd like to be able to answer: 1. Will an adjusted bounce rate improve the accuracy of our avg time on page metrics? 2. Are we able to keep the unadjusted bounce rate in GA as well, so we can compare the two metrics if we ever need to? Does anyone know the answers to these questions? Any help would be much appreciated!
Reporting & Analytics | | seoisfun0 -
Why might my websites crawl rate....explode?
Hi Mozzers, I have a website with approx 110,000 pages. According to search console, Google will usually crawl, on average, anywhere between 500 - 1500 pages per day. However, lately the crawl rate seems to have increased rather drastically: 9/5/16 - 923
Reporting & Analytics | | Silkstream
9/6/16 - 946
9/7/16 - 848
9/8/16 - 11072
9/9/16 - 50923
9/10/16 - 60389
9/11/16 - 17170
9/12/16 - 79809 I was wondering if anyone could offer any insight into why may be happening and if I should be concerned?
Thanks in advance for all advice.0 -
Hi - I have a beginner question about organic search results dropping to zero
Really confused about a site I'm getting going on SEO with... I'm new to SEO, but I've found that the organic search results for princessdesign.co.uk have dropped to zero dramatically. I'm concerned that I've missed something and hope that somebody out there might be able to help? Any input greatly appreciated 🙂
Reporting & Analytics | | Gokart0 -
How to check bounce rate of mobile or ipad checkout steps? How to check Funnel for mobile or ipad?
Hello Guys, Is there any way to check bounce rate of mobile or ipad checkout steps till thankyou page? Also separate Funnel visualization for mobile or ipad? John
Reporting & Analytics | | varo0 -
A couple of [daft] analytics questions
Hello Mozzers, I have a couple of anaytics questions I wanted to ask. What does 'Not Set' refer to? I assume it is when the user has switched off cookies, but was wondering if this is correct or if there were other circumstances that would trigger this? When I look at my reverse goal paths, the same page is in path 1, 2 and 3... Are the pages refreshing? Thanks! Amelia
Reporting & Analytics | | CommT0 -
How do i add GA to my companies flashed based platform?
Hi, I work for a company were the service we offer is a flashed based trading platform. We are wanting to add GA to the platform to get an idea of how customers are using this. 1. Can this be done and produce relatively accurate results 2. How can it be done? Regards Ben
Reporting & Analytics | | benjmoz0 -
Google analytics question
Ok so in my traffic sources break down I have 3 sections: direct, organic, and referral. My question is under the referral tab I have recently noticed a new traffic source, my own website.... How is this possible? My top referring site is my own website.... Is this considered direct traffic or how is this being traced?
Reporting & Analytics | | jameswalkerson0 -
Embed elements on my page help decrease my bounce rate?
I've embed elements on my page (vídeos, presentations) and i was wondering if when someone uses them it counts for the bounce rate. Thanks!
Reporting & Analytics | | lnjaine0