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
-
Page Speed or Site Speed which one does Google considered a ranking signal
I've read many threads online which proves that website speed is a ranking factor. There's a friend whose website scores 44 (slow metric score) on Google Pagespeed Insights. Despite that his website is slow, he outranks me on Google search results. It confuses me that I optimized my website for speed, but my competitor's slow site outperforms me. On Six9ja.com, I did amazing work by getting my target score which is 100 (fast metric score) on Google Pagespeed Insights. Coming to my Google search console tool, they have shown that some of my pages have average scores, while some have slow scores. Google search console tool proves me wrong that none of my pages are fast. Then where did the fast metrics went? Could it be because I added three Adsense Javascript code to all my blog posts? If so, that means that Adsense code is slowing website speed performance despite having an async tag. I tested my blog post speed and I understand that my page speed reduced by 48 due to the 3 Adsense javascript codes added to it. I got 62 (Average metric score). Now, my site speed is=100, then my page speed=62 Does this mean that Google considers page speed rather than site speed as a ranking factor? Screenshots: https://imgur.com/a/YSxSwOG **Regarding: **https://six9ja.com/
Reporting & Analytics | | Kingsmart1 -
What is the most effective way of selecting a top keyword per page on a site?
We are creating fresh content for outdated sites and I need to identify the most significant keyword per page for the content developers, What is the best way to do this?
Reporting & Analytics | | Sable_Group0 -
One big site for a loose theme or multiple sites for each specific theme?
Hi, Our company produces content related to one loose overall theme. Within that we write content and sell products on three specific sub-themes. Some of our customers cross over and have an interest in two or all three themes and others are only interested in one. At present we have one site covering reviews of products relating to all three sub-themes... ....and three other sites offering how-to guides and tutorials dedicated to each sub-theme. We do not have a lot of time to commit to SEO and so we are considering merging the content we have on all three subjects into the one site covering them all. Each of these sub-themes could have websites in their own right and my worry is that it will be harder to rank for these subject specific terms if the content is not on a site dedicated to that subject. But of course if they were all together then any links we build will be consolidated into one big site. Does anyone have any experience of this or have any advice on what the best thing to do would be? Thanks for your help!
Reporting & Analytics | | frantan0 -
Google Images referral visits fell off a cliff
As of 28-Jan, referral traffic from Google images (/imgres) to my domain has pretty much vaporized. Visits are down 85%. It's actually not a disaster because most of those visits were from poorly optimized alt tags that were resulting in low quality visits. The interesting thing is that visit duration is up 80% during the same period. So I'm asking this question out of curiosity more than anything. Is this likely an algorithm tweak? I can't think of any major changes on my end. There's only one other data point to mention but I don't see how they'd be connected. I did two PRWEB releases on 29-Jan and 30-Jan that resulted in a few hundred new no-follow links back to my site. 22b7k2.png
Reporting & Analytics | | JonDiPietro0 -
Where should I insert the code when I track an event on GA?
hi mozzers, I am trying to setup my first event to count the numbers of downloads of an infographic(pdf file) we just created on GA and after some research I figured that I should add this piece of code (below) but where exactly? <colgroup><col width="386"></colgroup>
Reporting & Analytics | | Ideas-Money-Art
| _gaq.push(['_trackevent', 'PDF', 'Download', 'name of file']); | Should I put it just in between _gaq.push(['_setDomainName', 'coit.com']); and _gaq.push(['_trackPageview']); ? Please provide details because I ve never done this before Thanks 🙂0 -
Multi-Site Analytics Dashboards?
Anyone have recommendations on a good multi-site analytics dashboard? I am managing roughly 20 sites right now, and am looking for a dashboard that provides basic info like # of visitors, search traffic, etc. for a couple dozen sites at a glance.
Reporting & Analytics | | TakeshiYoung0 -
Human Representation on a site
Hello Friends, thank you for helping in advance. My website http://www.FrontlineMobility.com gets a lot of traffic and with our Google Adwords campaigns we have very good click through rates(percentages from 1 percent to 4 percent). So I know that I am getting people to my site, but I can't get them to spend money. It seems like they get there ready to buy, but something turns them away at the last moment. My Partner feels like we should put more pictures of people on the site so that people feel like there is a face to our company. I am also in agreement with this, but I would also like to know if anything else is wrong with our site that perhaps maybe another set of eyes could perceive. Thank you again Moz friends. Justin Smith Frontline Mobility
Reporting & Analytics | | FrontlineMobility0 -
Site crawler hasn't crawled my site in 6 days!
On 4.23 i requested a site crawl. My site only has about 550 pages. So how can we get faster crawls?
Reporting & Analytics | | joemas990