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
-
Making the change to GA4?
We have a few clients we routinely do SEO work for, and we have campaigns set up for them here. However, with the change to GA4, how is that going to impact those campaigns? How do we make that switch? Where do we go for that? And how do we set up future campaigns for GA4? Right now it looks like the only option is still for UA, but the switch happens in less than three months, which is a little unnerving.
Reporting & Analytics | | buckii_modernoffice0 -
Should Google Trends Match Organic Traffic to My Site?
When looking at Google Trends and my Organic Traffic (using GA) as percentages of their total yearly values I have a correlation of .47. This correlation doesn't seem right when you consider that Google Trends (which is showing relative search traffic data) should match up pretty strongly to your Organic Traffic. Any thoughts on what might be going on? Why isn't Google Trends correlating with Organic Traffic? Shouldn't they be pulling from the same data set? Thanks, Jacob
Reporting & Analytics | | jacob.young.cricut0 -
Help with GA Filters - IP Addresses
I'm having a hard time filtering out both of the IP addresses at our office. One is easy with regular expressions, but the other one does not seem to be working. Here are the two IP addresses: 2606:a000:4e2b:d500:61d9:9d4e:c539:ea86
Reporting & Analytics | | ReunionMarketing
174.99.90.148 I set up these two custom filters and neither worked for the longer IP address. 2606:a000:4e2b:d500:61d9:9d4e:c539:ea86|174.99.90.148
2606:a000:4e2b:d500:61d9:9d4e:c539:ea86|174.99.90.148 Would you please help steer me in the right direction? Thanks as always MOZ friends!0 -
Best to Leave Toxic Links or Remove/Disovow on Site with Low Number of Linking Domains
Our site has only 87 referring domains (with at least 7,100 incoming links). LinkDetox has identified 29% of our back links as being toxic and 14% as being questionable. Virtually all of these links derive from spammy sites. We never received a manual penalty, but ever since the first Penguin penalty in 2012 our search volume and ranking has dropped with some uneven recover in the last 3 years. By removing/disavowing toxic links are we risking that over optimized link text will be removed and that ranking will suffer as a result? Are we potentially shooting ourselves in the foot? Would we be better to spend a few months building quality links from reputable domains before removing disavowing bad links? Or toxic links (as defined by LinkDetox) so bad that it should be a priority to remove them immediately before taking any other step? Thanks, Alan
Reporting & Analytics | | Kingalan10 -
GA visitor number inconsistencies?
Hey Mozzers Recently a client of ours undertook a paid campaign using Taboola and have a vast difference between reported clicks and visitors reported by GA. On further investigation the _utm.gif event is sent to google-analytics.com 50% of the time and stat.g.doubleclick.net the remaining 50% of the time Is this likely to be the cause of the discrepancy and if so is it possible to resolve this without removing the remarketing tag (which seems to be responsible for stats.g.doublelclick.net). Many thanks Justin
Reporting & Analytics | | JustinTaylor880 -
Why would our client's site be receiving significant levels of organic traffic for a keyword they do not rank for?
We have a client that has received 100+ organic visits for the keyword 'airport transfers', yet the site does not rank in the top 100 search results for this keyword. We have checked that it is not untagged PPC traffic. Truly baffling. Can anybody help?
Reporting & Analytics | | mrdavidingram0 -
Time until duplicate penalty is lifted?
Hello, I recently discovered that half of the pages on my site, about 3,500 were not being indexed or were indexing very very slow and with a heavy weight on them. I discovered the problem in the "HTML Suggestions" within Google's Webmaster Tools. An example of my main issue. All 3 of these URL were showing 200 Status OK in Google. www.getrightmusic.com/mixtape/post/ludacris_1_21_gigawatts_back_to_the_first_time www.getrightmusic.com/mixtape/post/ludacris_1_21_gigawatts_back_to_the_first_time/ www.getrightmusic.com/mixtape/ludacris_1_21_gigawatts_back_to_the_first_time I added some code to the .htaccess in order to remove the trailing slashes across the board. I also properly set up my 404 redirects, which were not properly set up by my developer (when the site "relaunched" 6 months ago 😞 ) I then added the Canonical link rel tags on the site posts/entries. I'm hoping I followed all the correct steps in fixing the issue and now, I guess, I just have to wait until the penalty gets lifted? I'm also not %100 certain that I have been penalized. I'm just assuming based on the SERP ceiling I feel and the super slow or lack of indexing my content. Any insight, help or comments would be super helpful. Thank you. Jesse
Reporting & Analytics | | getrightmusic0 -
Creating a Filter in GA to track Parent Category
I don't know if the title makes sense, but here's my question... Our newspaper website has multiple categories like World, Sport, Entertainment etc. Now, a story, belonging to the entertainment section maybe published on the entertainment page but is likely to have a slot somewhere on the Home page as well as other pages. The same goes for stories in sport etc. However, the url displays the date folllowed by the post title and thats it, no category name. Now, a user may end up going to a detailed story that belongs to the entertainment section (from the home page or any other page) without actually having visited the entertainment page. However, for tracking purposes, we want to see how many hits we got on the entertainment page and any story belonging to that particular section. So, my question is how do I go about creating filters that can help me track category page and detail story hits as one? Or, should I ammend the url structure (keep in mind we are using wordpress for our news website) to include category after the date and would this solve my problem of tracking? I asked a similar question recently but maybe I did not explain myself clearly. Thanks!
Reporting & Analytics | | RishadShaikh590