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
-
Domain change from .co.uk to .com - do you add .com to the referral exclusion in GA?
Hi Mozzers, Just wanted to double check that when a website domain changes from .co.uk to .com - do you add .com to the referral exclusion in GA? Do you also keep the .co.uk version in the list too? I have updated the property settings to .com Thanks Anthony
Reporting & Analytics | | Tone_Agency0 -
Help Blocking Crawlers. Huge Spike in "Direct Visits" with 96% Bounce Rate & Low Pages/Visit.
Hello, I'm hoping one of you search geniuses can help me. We have a successful client who started seeing a HUGE spike in direct visits as reported by Google Analytics. This traffic now represents approximately 70% of all website traffic. These "direct visits" have a bounce rate of 96%+ and only 1-2 pages/visit. This is skewing our analytics in a big way and rendering them pretty much useless. I suspect this is some sort of crawler activity but we have no access to the server log files to verify this or identify the culprit. The client's site is on a GoDaddy Managed WordPress hosting account. The way I see it, there are a couple of possibilities.
Reporting & Analytics | | EricFish
1.) Our client's competitors are scraping the site on a regular basis to stay on top of site modifications, keyword emphasis, etc. It seems like whenever we make meaningful changes to the site, one of their competitors does a knock-off a few days later. Hmmm. 2.) Our client's competitors have this crawler hitting the site thousands of times a day to raise bounce rates and decrease the average time on site, which could like have an negative impact on SEO. Correct me if I'm wrong but I don't believe Google is going to reward sites with 90% bounce rates, 1-2 pages/visit and an 18 second average time on site. The bottom line is that we need to identify these bogus "direct visits" and find a way to block them. I've seen several WordPress plugins that claim to help with this but I certainly don't want to block valid crawlers, especially Google, from accessing the site. If someone out there could please weigh in on this and help us resolve the issue, I'd really appreciate it. Heck, I'll even name my third-born after you. Thanks for your help. Eric0 -
Changes to cookies, August 24 or 25? (organic search not being cookied?)
Hi folks. We've seen a precipitous change in the referral data that we're able to gather from cookies. Specifically: On August 24 or 25, traffic to our site that was cookied as coming from organic search dropped by ~25%, and traffic coming in with no referrer data at all (i.e., it appears to be "direct") rose by roughly the same amount. As far as we can see, we haven't changed anything in our systems that would have caused this (we're not just mis-reading the cookie info), so I'm looking for external reasons. Has anyone else seen this? Or have any ideas why it would happen?
Reporting & Analytics | | RobM4160 -
How to put structured data on your site?
HI All, I Would like to know your views on structured data on your site. What are the qualities and point that should keep in mind when we talking about the "structured data on your site". how we can apply structured data. How we use data highlighter for the website which don't have any events. your thoughts please.
Reporting & Analytics | | lucidsoftech
thanks0 -
Having issues with pivot tables in GA
For the past three days, I've been trying to use pivot tables on a couple of reports, most importantly I'm trying to use a pivot table on the All Pages report. I'd like to pull it for a year so I can see what our traffic sources are for top pages. I keep getting an error in Google Analytics that says, "Resource is Not Available. Please Try Again Later." See attached image. I've condensed my date range to a month, just in case a year's data was too much and I still get the error. I'm unable to use pivot tables in ANY report, without getting this message. Is anyone else having issues?EgZ25
Reporting & Analytics | | Aggie1 -
What's the best enterprise analytic solution for a website with 100+ Million Visits/Month
Hi Guys, I'm looking for an enterprise solution for my companies website that currently gets 100+ Million visits a month? We use the free version of Google Analytic but the sampling levels we get are just too small. We have the budget to get something substantial -- the question is what solution should we go with? Thanks, Nicolas
Reporting & Analytics | | Nicolas_Seattle0 -
Analytics tagging parameters effect on site SEO
One of the effective tools used in analytics tagging is the use of analytics parameters that starts with '?' or '#'. Example on site tagging: Main link: www.domainname.com./category/sub-category/ www.domainname.com./category/sub-category/?lid=topnav www.domainname.com./category/sub-category/?lid=sidenav All three links link to the same landing page, with an extra parameter. Using email or campaign tagging: www.domainname.com./category/sub-category/ www.domainname.com./category/sub-category/?utm_source=launch&utm_medium=email&utm_term=html&utm_content=getscoop&utm_campaign=hwdyrwm2012 With that we create many tagged links based on the campaign internal strategy. How do these effect indexing, and link juice? How do thy effect SEO in general?
Reporting & Analytics | | RAPPLA0 -
IP address and GA
Our company is based in Noida, and in GA, i can see few visits from New Delhi. Both these cities are nearby. ( In India ) Our hosting is in US. When a visitor comes to site, does visit is based on IP address of the user's system ? Our company has taken hosting from Noida. Does that means that visits from New Delhi are Genuine and NOT from our company ? My apologies, if i am not clear...
Reporting & Analytics | | seoug_20050