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
-
Google analytics - Users by time of day for speicific country?
Is there any way in analytics where we can check Users by time of day for speicific country?
Reporting & Analytics | | BPLLC0 -
When Deployment done for my site in google analytic page views little bit affected
Hello Expert, For my ecommerce site every minute I have 500 visitors now when my development team do deployment like minor JS update where site restart not require then what I found is on website (front end) not able to find anything happen that means visitor not event realize page even refresh but in analytic real time it shows minor pageviews down. So can anyone guess here what happen actually in this case as per google? Thanks!
Reporting & Analytics | | micey1230 -
Pageview/Goal Data Errors In GA
**Background: ** We utilize a static .html page for our quote form. It is embedded on our WordPress site via iframe in a single location. The quote form code itself (within the quote form .html) is generated from our CRM, but contains no tracking code itself. The .html containing this code is tracked with embedded Analytics code to track our Goals. This code is tested and works properly, recording goal completions when our thank-you.html page is loaded within the iframe. To be clear, quote.html is the page the iframe loads, .com/quote-page is the WordPress page with the iframe, and thanks.html is the goal completion page. Google Analyticator plugin handles code insertion throughout the site. The .html pages have code manually inserted and neither are indexed by Google or linked to/accessible by any route other than .com/quote-page **Problems: ** 1. When I check Pageviews in GA, the quote.html page has many more hits than .com/quote-page. The disparity is 552 to 416. How is this possible when quote-page has to be loaded in order for quote.html to be loaded? Shouldn't they be similar? 2. Our completion page, thanks.html, is showing 142 pageviews and 133 unique pageviews. Our goals confirm 133 goal conversions. How are people seeing the thanks.html page again without it registering a goal? A backspace? Someone help me decipher this please! If you need any more details, let me know!
Reporting & Analytics | | kirmeliux0 -
Time to get reconsideratio n request?
Hi there, recently I have been getting failed reconsideration requests back within 7 days. The last one i submitted (third) is now 2 weeks and no message back. Does this mean do you think it's gone to the next stage of auditing? is it a good sign? Typically when failed I have always has that response within 7 days. I also noticed a slight improvement in rankings but no message back in webmaster tools. Does anyone have experience with this? if so does this sound about right? thanks guys.
Reporting & Analytics | | pauledwards0 -
Showing significant visit in google analytics
Hello Everyone, I was checking GA account of my site and I have found there are few keywords have significant number of visits in GA. These keywords not ranking even in hundred(google SERPs).I am not understanding from where these visitors coming .Please help me out. I am attaching screenshot of those keyword.Last but not least when i check source of these keywords source are google. Thanks aScZ8WT.png
Reporting & Analytics | | Alick3000 -
How do I connect GA to SEOMOZ if I do not have access to a GA account ?
I am not the owner of the account it is a clients and I need to connect my SEOMOZ to their GA account.. any ideas? Thanks in advance 🙂
Reporting & Analytics | | Andisue1 -
GA Subdomain Setup
Hi Mozzers, Can someone show me how to add a subdomain profile (sub.example.com) under the master profile (www.example.com) on Google Analytics. I am not sure on how to set it up. Thanks
Reporting & Analytics | | Ideas-Money-Art0 -
GA stopped tracking traffic, suddenly, why¿? :-/
2 days ago GA stopped receiving data. It only stopped for one account of all my projects. At this moment there are 5 persons navigating the site and these days there where numerous visitors as they contacted the support team thru the site. GA says that it's receiving the code, hw, I checked it twice. The tracking code is located below the footer, in the body. It was there for few years.... I also checked if there is some js conflict, negative. Is there something that could make the tracking to stop? Does anybody experienced similar problems¿? Should I be worried...¿? (and with SEOmoz server with issues not sure when will see new results.......) EDIT: In Web Master Tools I see results for indexing, with yesterday date, so I assume that the site crawling is ok and must be GA issue.
Reporting & Analytics | | MilosMilcom0