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
Got a burning SEO question?
Subscribe to Moz Pro to gain full access to Q&A, answer questions, and ask your own.
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
-
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 -
% Change - Google analytics - how to calculate?
Hi All,
Reporting & Analytics | | JohnPalmer
I have two dates with two different numbers I want to calculate the "% Change" like google analytics, The numbers of June 2015 - 127,931 sessions
The numbers of June 2014 - 90914 sessions please tell me what is the %Change. Best. J0 -
How "Assisted Conversion value" is calculated on Google Analytics?
Hi guys, Can any of you tell me how the Assisted Conversion Value is calculated under Assist Interacion Analysis? For the channel Direct, we have Assited Conversions: 6 Assited Conversion Value: 451,59 Last Click or Direct Conversions: 10 Last Click or Direct Conversion Value: 786,54 Assisted/Last Click or Direct Conversions: 0,60 How the value 451,59 is calculated? Thanks. Regards
Reporting & Analytics | | footd0 -
Weird Analytics Question
Looking at a Google Analytics report for a client - Traffic Sources - Referrals - Landing Pages from one particular referrer. This one referral site is a large trade directory that links onto several deep pages of the site, but also links onto the homepage. Analytics is showing the one landing page as //index.html. That's 2 // - not one. If you click on the link, it's a 404. I've never seen this in Analytics before. I'm looking at the client's info on this trade directory site and I can't see a link that points to this 404. The majority of incoming traffic from this site is apparently coming to this //index.html page, so you'd think it would be coming from their main profile on the site. But it's not there. Also, if you had all this referral traffic coming to a 404, you'd expect a really high bounce rate, but it's not - it's average. The client also has a sister site also listed in this directory, and I'm not seeing this same issue in their Analytics. Is this just some weird glitch in Analytics?
Reporting & Analytics | | stevefidelity0 -
Our SEO is garbage. can someone answer a few questions for me?
I've seen our SEO drop to more or less the bottom of the barrel, and I don't have any answers yet as to why. SEOMoz is running it's crawl currently, and I have a few errors about duplicate titles and content, so I know I have some work cut out for me. But, why the sudden drop? The only change I made at the time was a change to our URL structure, but all links were 301'd to their new location. Does this still hurt SEO that terribly? Also, our robots.txt file is getting indexed and showing up as the first result at times. Very embarrassing. It's doing better than our other pages. 😞 I don't get what's happening here. Yrzu3,fkbYu
Reporting & Analytics | | stagl0 -
Bounce rates plummeted
In Google Analytics, my average bounce rates plummeted basically overnight. I went from a consistent average daily bounce rate of about 65% to an average daily bounce rate near 5%. My average number of visitors has stayed the same. I don't think there is any significant change I made to my site that may have caused this. Has anyone else had the same problem and know why it happened and how to fix it? Thanks in advance!
Reporting & Analytics | | Ericc220 -
Conversion rates by browser & OS - any feedback/experts/experience?
Hi, Ive been evaluating conversion rates by operating system and by browser for a client. Ive picked up significant and somewhat disturbing trends. As you'd expect the bulk of traffic is coming from a Windows/Internet Explorer combination. This is unfortunately one of the worst combinations (Windows/Firefox & Windows/Safari did worse. Chrome/Windows was significantly the best combination with Windows). Windows also performs much worse than Mac. E.g. Windows/Firefox performs worse than Mac/Firefox. Overall conversion rate for Mac is 7.07% compared to 5.69% Windows. This is based on hundreds of thousands of visits and equates to tens of thousands of dollars difference in revenue. Generally later versions of browsers perform better on both main operating systems e.g IE 9.0 converts at 6.33% compared to 8.0 at 5.80% on Windows and Firefox 4.01 on the Mac converts at 7.57% compared to 3.6.16 at 6.54% (although this dataset is smaller than Windows/IE). Page load speeds (recorded in the clients analytics) are significantly faster on Mac than Windows (as expected really). Being Windows/IE and specifically Windows IE8 represents the bulk of traffic should we be addressing this? Will any optimisation negatively affect better performing Mac/Browser combinations? Understanding that Mac users equate to 'better' converting visitors - what else could be done there? Anyone have thoughts or experience on optimising pages for improved conversion rates via IE and Windows? Thanks in advance, Andy
Reporting & Analytics | | AndyMacLean0 -
Does an internal link inside an iframe result in a bounce?
We built a landing page with a wufoo form. Inside the wufoo form is a link going to another page on our website. We are wondering if clicking on that link will result in a bounce since it is in an iframe. We are using google analytics.
Reporting & Analytics | | seozachz0