Sort referring sites by visit change over time comparison in GA
-
I can't believe I've never done this before, so I'm going to assume that I previously must have figured it out via excel, but I'm hoping there's an easier way.
So I want to compare the referring sites between April and May and see which have sent (specifically) less traffic.
The problem with doing a comparison in GA is that it only sorts by the highest traffic for May, when actually I want to see the largest negative change (by number, not percentage) between April and May.
Is there a way to do this via the dashboard or am I just going to have to play about in excel for 10 minutes?
-
Howdy Barry,
I know it's not exactly what you'r looking for, but I thought this might be of interest to you. Google Analytics Interface Navigation Slide 10.
-
The compare box gives me the comparison in the first place, but the only way it sorts the data is by number of visits for the latest date. I need to sort by largest decrease of visits between two dates and I can't see a way to do that.
I actually use Open Office 9 times out of 10, though I'm sure I can still do a macro, but I only really do it 4 or 5 times a year and doesn't take too long, so probably won't bother Thanks though
-
Hey Barry,
Will the 'compare check box' in the date selection not help? Also, when you do it in excel, consider recording it as a macro, so that you can just run that macro automatically every time you want the report. Does this help Barry?
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
-
Webmaster Tools equivalent to Change Default Address found in Analytics
Hello all! We're changing from http to https. In Google Analytics there is an option to change the default address so we keep our historical data. I can't find a similar option in Webmaster Tools though. Do you have to setup a new property or is there an option to change your current one? Thanks in advance!
Reporting & Analytics | | thegrbteam0 -
Domain Change Post Mortem
Hello, my company changed our domain 2 weeks ago and we are just starting to see traffic level back out, except for Organic. The site is on shopify so it made switching the domain pretty easy, as well as the 301 redirects (no url structure changes). We've taken all the proper steps with google/bing webmaster tools as well as monitoring 404's and 301 testing and don't see any red flags. Does anyone roughly know how long it takes for 301's to re-index and domain authority to start building back up for our new domain? Our old domain was about 13 years old and the new one was parked for quite awhile. p.s. I also noticed a lot of our traffic ending up as referral from our old url. I was able to wipe the sessions from analytics which cut it down, but will this persist for the foreseeable future? Thanks!
Reporting & Analytics | | SchoolhouseElectric0 -
Google Analytic - Avg load Time - Page Timing Sometimes Graph goes suddenly up why?
Hello All, I have attached the avg load time screenshot for my ecommerce site for 1 month. Screenshot is for Mobile site. If you check the graph then only one day graph gone very high. Now again I have attached that particular day graph too. My query is why graph gone high 1) Is it my site not performed well on particular one day on particular device for single visitor? because for desktop and tablet graph showing normal 2) so here if site restart or down then it can be a problem for desktop, tablet too right? Can anyone give me any clue? Z4hX1 IanuP
Reporting & Analytics | | pragnesh96390 -
Where to find "Keywords that Sent Organic Search Visits" in Google Analytics?
Hi everyone, Tried searching for this answer but couldn't find it. In the new analytics, I can see that there is a graph that shows the number of unique keywords that brought traffic to our site sorted by weeks. I can't seem to find this data in Google Analytics. I can only find the number of visits but not sorted by how many keywords, instead it is just # of visits from all of the keywords. Thanks in advance. SZ
Reporting & Analytics | | swzhai0 -
Google Search Bar Vs Address Bar To Determine Number Of Times the Domain Name Is Typed In..
Hello, I'm trying to get a rough estimate of how many times a domain name that we're interested in acquiring is typed in to the address bar. If the google keyword tool says for instance, that the exact match domain name is typed in 720 times, how many times it typed in to the address bar? example.com - 720 global searches Thanks!
Reporting & Analytics | | Optimize0 -
GA advanced segments - for how much volume keywords are sending per month
I am trying to follow the advice in this whiteboard friday video http://www.seomoz.org/blog/how-big-is-your-long-tail-whiteboard-friday of grouping keywords based on volume of traffic they send each month e.g. 100+, 50-99, 10-49, <10. I'm probably being super dumb, but how do I do this with advanced segments in GA? Thanks.
Reporting & Analytics | | KateV0 -
Free Online XMl Site Map Creators up sites over 1000 pages
Does anybody know of a XML site map creator that is free for websites over 1000 pages?
Reporting & Analytics | | AppleCapitalGroup0 -
Will Google start trimming 'stale' sites rank?
With the recent focus on Google to reduce rank of farms and low value sites, I am interested to get SEO view on if you think Google will start devaluing stale sites. I do find it a bit frustrating that in the top 5 for my main key phrase, there is one site that has NO content just an error and another blog that has not updated content in 2 years. How can blogs that do not blog be considered high enough value by Google to rank in the top 5? How can sites that just return 404 or 500 for ALL their pages be even considered a site let alone rank 2nd. I am interested so see others experiences and thoughts on 'user experience' clean ups by Google and why these types of sites get missed?
Reporting & Analytics | | oznappies0