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 -
If website users don't accept GDPR cookie consent, does that prevent GA-GTM from tracking pageviews and any traffic from that user that would cause significant traffic decreases?
I've been doing a lot research on GDPR impact and implementation with GTM-GA for clients, but it's been 12 months since GDPR has gone live I haven't found anything on how GA traffic has been impacted if users don't accept cookie consent. However, I'm personally seeing GA accounts taking huge losses in traffic since implementing GDPR cookie solutions (because GTM/GA tags aren't firing until cookies are accepted). Is it common for websites to see significant decreases in traffic due to too many users not accepting cookie consent? Are there alternative solutions to avoid traffic loss like that and still maintain GDPR compliance? It seems to me that the industry underestimated how many people won't accept cookie consent. Most of the documentation and articles around GDPR's start (May 2018) didn't foresee or cover that aspect properly, everything seems to be technically focused with the assumption that if implemented properly most people would accept cookie consent, but I'm personally not seeing that trend and it's destroying GA data (lost traffic, minimal source attribution, inaccurate behavior data, etc). Thanks.
Reporting & Analytics | | Kickboard2 -
Huge Analytics discrepancy when I turned off Analytics Module & Turned on GA via GTM
Hello, I was running universal GA via a GA Drupal module. We setup Google Tag Manager and setup a GA tag to run through GTM. When we pushed the GTM container live our Real Time was at around 1900 and when we turned off the Drupal module the Real Time was reporting around 1100. After 24 hours the sessions for that day were about 100k lower than what they usually are. Any ideas Why the larger discrepancy? Any places that are obvious to look? *I didn't setup the original Drupal GA module, nor do I know who did. Thanks
Reporting & Analytics | | JJLWeber0 -
GA Event: to use this feature visit: EVENT-TRACKING.COM
Hi guys, Two days ago our Google Analytics Event tracker began to show this Event/Label, etc. I cannot find its source. Anybody knows what is this about? Thanks for your answers. Ana
Reporting & Analytics | | anagentile1 -
GA: How can non related kws show up in the organic report?
Hi mozzers, I have a site A: www.example.com (with its own branded kws) SiteB: subdomain.example.com Site A and B are related and belong to the same company. Site B was released a couple months ago. ISSUE: I have noticed branded kws from Site A showing up on Site B's GA which doesn't make any sense. I try to make searches in the SE with those kws and not a single search showed the Site B(subdomain). What is weird is that 2 months ago had a an issue with bounce rate on site B showing a 0% bounce rate, then I discovered that we had 2 GATC on site, removed the extra code and bounce was back to normal. Since then I have seen a rise of branded kws from Site A to Site B. Can someone help me here figuring out what is wrong? Thanks
Reporting & Analytics | | Ideas-Money-Art0 -
Can you link several sites together in Google Webmaster Tools?
I have a client saying that there is a way to link 3 separate websites (A website for each department of a company) in Google Webmaster tools to tell Google it's basically one site but really its 3. Or to tell Google it's the same company and all the sites are one. I have never heard of this & I don't see the point in making 3 separate small sites & "linking" them as one in Webmaster tools. Is there in fact a way? Am I out to lunch on what they might be referring to? I am recommending they create one larger authority site with a page on each department & earn links for each department page & provide informative unique content for each page. Thoughts? Thanks for the help!
Reporting & Analytics | | DCochrane0 -
When one of my sites returns a ranking that consistently reads "No Data", what does that say about the site?
I am getting "No Data" reads for some of my sites - I personally think it has to do with the site's construction - especially the landing page... I inherited this site to do SEO - it was not created with on site SEO in mind - please help if you can sites are: www.storagesanangelo.com www.storagemidland.com Should I get webmaster to remove the big map graphic and add text and pics instead... Sure appreciate brilliant thoughts - even about yetis and beer
Reporting & Analytics | | creativeguy0 -
Google is listing my site using IP also, is it normal?
https://www.google.com/search?sourceid=chrome&ie=UTF-8&q=site%3A50.97.XXX.XXX About 7,050 results (0.24 seconds) when we do list by domain we get : About 10,400,000 results (0.29 seconds) is it ok? would google smart enough to count IP address not as duplicate content?
Reporting & Analytics | | tpt.com0