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
-
PDF best practices: to get them indexed or not? Do they pass SEO value to the site?
All PDFs have landing pages, and the pages are already indexed. If we allow the PDFs to get indexed, then they'd be downloadable directly from google's results page and we would not get GA events. The PDFs info would somewhat overlap with the landing pages info. Also, if we ever need to move content, we'd now have to redirects the links to the PDFs. What are best practices in this area? To index or not? What do you / your clients do and why? Would a PDF indexed by google and downloaded directly via a link in the SER page pass SEO juice to the domain? What if it's on a subdomain, like when hosted by Pardot? (www1.example.com)
Reporting & Analytics | | hlwebdev1 -
Is GA Real-Time Locations Broken?
When I look at my real-time site traffic in GA, I'm seeing a lot of direct traffic from Montvale, NJ. However, when I go to the audience tab for today or any day in the past, Montvale doesn't even show up in the list of cities sending traffic. What am I missing here?
Reporting & Analytics | | jimbeaux_slice2 -
Complete loss of Organic visits within Google Analytics??
Hey guys, I have a pressing query that's really puzzled me! I've just been going through Google Analytics and noticed that there has been a complete drop off of all my organic visitors from May 7. All other traffic mediums are unaffected so there is no issue with the Analytics code recording visits. I haven't received any penalty and my rankings have actually improved in the last month. This is proper bizarre. Any ideas? MjLmL70.png
Reporting & Analytics | | Webrevolve0 -
Google Webmaster Tools During GA Transition?
I'm working with a client that is launching a new website. Google Webmaster Tools can just be disconnected, then reconnected to the new Google Analytics property, correct? Without any data loss in Webmaster Tools? Thanks! Becky
Reporting & Analytics | | Becky_Converge0 -
404 errors more than 1.8 lacs, Duplicate Content, Duplicate title, missing meta description increasing as site is based on regular ticket selling (CRM), kindly help
Sites error increasing i.e. 404 errors more than 1.8 lacs, Duplicate Content, Duplicate title, missing meta description increasing day by day as site is based on regular ticket selling (CRM), We have checked with webmasters for 404's, but it is not easy to delete 1.8 lac entries. How to resolve this issue for future. kindly help and suggest the solution.
Reporting & Analytics | | 1akal0 -
Increase in 'Googlebot-Image' visits in analytics
Hi, I noticed a substantial increase in 'Googlebot-Image' visits data under Technology>Browser & OS in Google analytics for a few clients. Is this a bug? Are there any known fixes apart from just adding a filter to exclude the data? Regards Niladri
Reporting & Analytics | | neildomain0 -
How would you measure the SEO success of new site launch?
It has been 12 months, and it is time for some serious SEO reality check up. I think we have done some really nice things (social integration, on page optimization etc) but we honestly could do a million time better on some other elements (anchor, text, link building etc...). Would love to hear from the community what would be the top 10 criteria you would use to judge the quality of the SEO work done for a new site during is first 12 months. PS: we are a very content rich over 1,500 new articles/post in our niche with 12 months - our site is migraine.com Thanks
Reporting & Analytics | | OlivierChateau0 -
Tracking Referring Sources - Google Analytics - Ecommerce
I need some help from anyone that has deal with this issue before.. We are currently running BigCommerce for the shopping cart on chinamist.com. We have enabled e-commerce tracking through Google Analytics and the revenue tracks perfectly. The only issue is that the referring sources are not tracking directly to the revenue being displayed - for the source, all analytics shows is (none). The assumption is that the tracking issue is a result of having a domain and subdomain.. but 'domain and subdomain' was selected when setting up the sites' advanced analytics script. Does anyone have any tips? We've run into a dead end here.. One final note, we're running an Adwords campaign which is showing conversions through the Adwords side of reporting. After integrating the Adwords and Analytics accounts, the analaytics account is still not showing revenue/conversions from Adwords as a source. Appreciate the feedback.
Reporting & Analytics | | Investis_Digital0
