% Change - Google analytics - how to calculate?
-
Hi All,
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 sessionsplease tell me what is the %Change.
Best. J
-
(b - a) / a
So in your case:
a = 90,914
b = 127,931(127,931 - 90,914) / 90,914 = 0.40716501
Rendered as a percent, it's a 40.72% increase.
If you're doing % change on a number of pages, export the GA data to Excel, apply the formula there. I do this all the time with our merchant pages, and it's great for spotting trends if your business is even remotely seasonal.
However, if you're just doing single calculations on the fly and don't want to memorize the formula, there are tons of percent change calculators online. Most of them are boneheaded SEO, which is why I'm linking to the SERP and not to any particular calculator, but the numbers they spit out are sound.
-
Hi,
To calculate the percentage increase/decrease:
First: work out the difference (increase) between the two numbers you are comparing.
Increase = New Number - Original Number
Then: divide the increase by the original number and multiply the answer by 100.
% increase = Increase ÷ Original Number × 100.
If your answer is a negative number then this is a percentage decrease.
Thanks
-
what is the formula ?
-
Hi John,
If I understand your question correctly then answer is an increase of 40.72%.
Thanks
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
-
Google Analytics Landing Page Report Discrepancy
I have noticed that when I run a landing page report and use the advanced option so I can view only the landing pages that include a particular string in the URL, have noticed that I in the report, the graph at the top will say one thing, but the data below says something else. For example, the graph for one particular search shows 200 Impressions, but the info below says 700 impressions and 610 clicks. Anyone seen anything similar or have any ideas why? Thanks! Craig
Reporting & Analytics | | TheCraig0 -
Apple.com showing in Google Analytics "My Top Active Pages" - Why?
Hi Mozzers This has more than likely been asked before but my searches have left me empty handed so I have asked on here ( sorry! ) Please see attached screenshot, do you have any idea why apple.com is showing in my top pages? I'm just curious more than anything as this isn't the first time I've noticed it. Anybody know? Happy Friday people, cheers Jamie CiTCA5b.png
Reporting & Analytics | | SanjidaKazi1 -
How does switching to HTTPS effect Google Analytics?
We are looking at making our site HTTPS. We have been using the same Google Analytics account for years and I like having the historical data. All of our pages will be the same, we are just going to redirect from the http to https. Does anything need to be done with Google Analytics? What about other addons such as Optimizely, Crazy Egg, or Share this?
Reporting & Analytics | | EcommerceSite0 -
How to filter many cities from Google analytics
I need to filter hundreds of cities from my traffic reports. I've been told that adding them all in this format: |Knutsford|Ripon|Cheadle Hulme|Congleton| and using the 'matching reg/exp from the drop down should do it... Unfortunately that doesn't seem to be working as I can still see cities like London in the results.... Any ideas?
Reporting & Analytics | | david.smith.segarra0 -
Conversion via Paypal not showing order value in google analytics
Hello All, I have an e commerce site, when goal conversion happens by CC(credit card) I can see order value in e commerce tab in Google analytics but when conversion happens through paypal I always see order value zero. I want see order value for Pay pal also.Please help me out. Thanks
Reporting & Analytics | | Alick3000 -
Google Analytics is not showing me eCommerce Section Details for My Online eCommerce Website!
From Last few days we are not able to find any details from eCommerce section at Good Analytics account for our eCommerce website i.e order detail, Price e.t.c. Please any one can suggest proper solution for this query?
Reporting & Analytics | | yuvastyle0 -
Switching Google Analytics from Urchin to GA
I want to finally make the switch from Urchin to GA in Analytics, but the Google support page is no longer working (I realize I'm late to this so they likely took it down/moved it to where I can't find it). I've been searching on Google but can't find a straightforward guide to changing that won't disrupt my data. Anyone have a link to a working guide, or can you provide some guidance?
Reporting & Analytics | | Axios_Systems0 -
How do I best segment tablets on Google Analytics
I would like to find a way to best segment out my tablet traffic to measure performance; however I'm finding that there are road blocks. It doesn't seem that device operating systems or screen resolutions have clear cut differences in the tablet/mobile versions. Has anyone here found a good way to create a "tablet" segment in Google Analytics? Right now I'm having to lean on solely the ipad traffic to get indicators of tablet performance. Thanks!
Reporting & Analytics | | lvstrickland0