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
-
Bounce Rate: what is it EXACTLY?
Hi everyone: we all know the term 'Bounce Rate'. I'd like to think i have a good idea of what BR is....but some things are not really clear to me. Time to call in the experts. Question #1: What EXACTLY will stop Google from considering the visit as a bounce? As discussed not too long ago in this topic https://moz.com/community/q/will-this-fix-my-bounce-rate
Reporting & Analytics | | BasKierkels
Ruben wrote: "..what it basically means is that someone clicks on your SERP, and then clicks back to google? But, it doesn't matter if they spent 10 minutes on your page or 10 seconds" Jessica Conflitti wrote a reply in which she basically said that it might be a good idea to have visitors click to a different page OR a PDF-file. That's where my confusion has been for some time now: Clicking on a PDF-document, an image in the page that opens with Fancybox, a link to a different domain? Or can it only be a different URL on the same domain? The way i would expect it to be:
Pages contain the GA-tracking code. So am i right by thinking that Google needs to have the same GA-tracking code to be loaded twice? Because only at that point will they have two datapoints. And only then will they be able to tell that the visitor hasn't left. By clicking a PDF-document - as described by Jessica - you wouldn't load the GA-code twice. So I would expect that clicking a PDF does not make a difference for the BR. Don't get me wrong: i like the article but it is this detail that throws me off. IF Google can read or capture these clicks, what other elements can be used to reduce bounce rate? Clicking on a YouTube-video embedded in the page? I'm asking this because i want to get this right. Question #2: how much weight does BR have on Time on Page, Engagement, etc? We know Google is taking a lot of things into consideration when calculating the value of a URL or domain. So how much should we care for BR if we know the Time on Page is good and a large percentage of people are frequently returning? How about your experiences or knowledge on that? Really looking forward to your replies and help on clearing this topic for me. And perhaps some other readers as well! Bas0 -
Free Media Site / High Traffic / Low Engagement / Strategies and Questions
Hi, Imagine a site "mediapalooza dot com" where the only thing you do there is view free media. Yet Google Analytics is showing the average view of a media page is about a minute; where the average length of media is 20 - 90 minutes. And imagine that most of this media is "classic" and that it is generally not available elsewhere. Note also that the site ranks terribly in Google, despite having decent Domain Authority (in the high 30's), Page Authority in the mid 40's and a great site and otherwise quite active international user base with page views in the tens of thousands per month. Is it possible that GA is not tracking engagement (time on site) correctly? Even accounting for the imperfect method of GA that measures "next key pressed" as a way to terminate the page as a way to measure time on page, our stats are truly abysmal, in the tenths of a percentage point of time measured when compared with actual time we think the pages are being used. If so, will getting engagement tracking to more accurately measure time on specif pages and site signal Google that this site is actually more important than current ranking indicates? There's lots of discussion about "dwell time" as this relates to ranking, and I'm postulating that if we can show Google that we have extremely good engagement instead of the super low stats that we are reporting now, then we might get a boost in ranking. Am I crazy? Has anyone got any data that proves or disproves this theory? as I write this out, I detect many issues - let's have a discussion on what else might be happening here. We already know that low engagement = low ranking. Will fixing GA to show true engagement have any noticeable impact on ranking? Can't wait to see what the MOZZERS think of this!
Reporting & Analytics | | seo_plus0 -
% 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 -
Improving Search Click through Rate
We are having a problem on our website with click through rates. We are getting between 100-150k impressions through search but we are only getting between 500-1000 clicks to the site. What strategies have you used in the past to help improve your click through rates? Thanks!
Reporting & Analytics | | pdangermond2 -
Question about setting up Google Webmaster on Network Solutions?
I'm trying to set myself up as a Webmaster on my company's site. We use Network Solutions. I am following Google's directions on how to do this. However, I am a bit wary. Here are the directions. Underlined is the part I am having trouble with: Log in to your account for howlatthemoon.com at www.networksolutions.com by clicking theManage Account icon. In the left navigation bar, open the nsWebAddress (Domains) menu by clicking the **+ **icon. Click Manage Domain Names. On the Domain Details page for the domain you're using, select the Designated DNS radio button (to the right of Change domain to point to) and click the Apply Changes button. If you've previously modified your advanced DNS settings, click Edit (to the right ofDomain currently points to). Under the Advanced DNS Manager heading, click Manage Advanced DNS Records. Under the Text (TXT Records) heading, click Add/Edit. In the Host field, enter @. Leave the TTL field set to the default value. In the Text field, copy and paste the following unique security token:
Reporting & Analytics | | howlusa
(security token removed for obvious reasons) Click Continue. Review your changes and click Save Changes. When you've done saving the TXT record, click the Verify button below on this page. There is already a host of @ (None). The text for it reads: v=spf1 include:_spf.google.com ~all I called Network Solutions and the guy I was speaking with told me to delete it and replace it with my Google Webmasters code. However, I think this is setting up our email. Do I just add the Webmasters in and have two hosts of @ (None)? Thanks!0 -
When i first add my url to seomoz then i had a general report of all the faults my website had in SEO and suggestions where can i find it now , i cant find it ?!
when i first add my url to seomoz then i had a general report of all the faults my website had in SEO and suggestions where can i find it now , i cant find it ?!
Reporting & Analytics | | fireproductsuk0 -
High bounce rate from Google Shopping
Hi Mozzers, I'm carrying out some analysis on our eCommerce site and the bounce rate from Google Shopping is well above the site average at 60%. Our shopping feed is submitted to Google every morning so we know that images and prices are up-to-date which would obviously cause a high bounce rate. Any ideas on what might cause this? Is it normal for Google Shopping to produce a high bounce rate? Cheers guys!
Reporting & Analytics | | Confetti_Wedding0 -
Google Analytics session update question
Hello, With reference to seomoz blog post - http://www.seomoz.org/blog/panda-24-and-analytics-session-update-rolled-out-simultaneously#jtc151292 , i would like clarification about the following - User searches Google for "Product Name" and clicks on your AdWords advertisement. User leaves site and searches a few more times, click on competition and comparing prices and features. User ultimately decides to with your product, Googles "Your Brand + Product Name", clicks your organic listing, and buys the product. This whole process takes less than 30 minutes. "Your Brand + Product Name" will appear in your organic keyword report with 1 visit. My question is whether "Product Name" will also appear in organic keyword report with 1 visit if the visitor is not signed in. ( as search won't be encrypted ) Thanks
Reporting & Analytics | | seoug_20100