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
-
Is it possible to set up one of the Goal Conversions on Google Analytics for a different site?
We are in the process of a website migration and need to set up the conversions for the new site. What is the most effective way of doing this?
Reporting & Analytics | | Sable_Group0 -
How Am I Linked to These Sites?
I was going through Google Analytics, specifically looking at the Channels under Acquisition. I found a number of sites that Google is giving credit as sources of traffic.
Reporting & Analytics | | TowerMarketing
When I went to the sites, however, and searched the page source for links to my site, I could not find any. My site is www.towermarketing.net. The sites being listed by GA are:
blackhawkhardware.com
musicas.baixar-musicas-gratis.com If anyone can tell me how Tower is getting traffic from these sites, and what I can do to fix it - because at this point I am considering them spam - I would appreciate it. Thanks!0 -
Tracking Social Interactions with GA and WordPress
Hi, One of the things I'm looking to do is to track clicks on my social follow buttons. I know I can try to add GA events for each button and go from there. But in order to simplify the process, I'm looking for a WP plugin that can help. Currently I've only come across AddThis and Share This as viable options, though Add This has very mixed reviews, and Share This isn't updated for WP 3.6.1. For my social shares at the end of blog posts I'm wondering the same thing about tracking shares. I've used AddThis in the past with success in tracking shares, but I wanted to see what other are doing or if there's a newer technique. The bottom line is that I want to try to see as much of the "social" as I can in GA. Thank you in advance!!
Reporting & Analytics | | Titan5520 -
How can I set up the time for a scheduled e-mail on analytics?
Hi there! It's important to me that the reports from GA arrives in an specific hour of the day. Does anyone know how to make the reports to come at 6am, for example? Thanks.
Reporting & Analytics | | ivan.precisodisso1 -
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 -
How are 301s reported in GA?
Does anyone have any insight on exactly how on-site 301s are reported in Google Analytics? My direct traffic seems to climb at the same rate as my organic with absolutely no off-line promotion. I have a suspicion that the 301s that I have built to re-coupe traffic being sent to old pages are being reported as direct. Any validity to this?
Reporting & Analytics | | NextGenEDU0 -
Can I implement Facebook insights to GA?
Hi, I would like to know if anyone knows of a function where I can implement my facebooks insights of my fanpage to my google Analytics account. I want to be able to manage all my tracking through one software (GA) so that it is easier for me to see the correlations. Thanks a bunch,
Reporting & Analytics | | wellbo
-Malte0 -
What is this referrer site?
Hi Guys....i keep seeing this in my analytics..can someone tell me what it is? 146w.bay146.mail.live.com thanks for your time
Reporting & Analytics | | nomad-2023230