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
-
Disabling Hubspot AMP plugin - impact on GA
Hello, all!
Reporting & Analytics | | SimpleSearch
What impact have you seen if you've used the Hubspot AMP plugin and then disabled it?
We saw a big jump in sessions, which is weird because GA was tracking AMP pages. I'm trying to wrap my head around why this is happening but my brain isn't working 🙂0 -
PDF best practices: to get them indexed or not? Do they pass SEO value to the site?
All PDFs have landing pages, and the pages are already indexed. If we allow the PDFs to get indexed, then they'd be downloadable directly from google's results page and we would not get GA events. The PDFs info would somewhat overlap with the landing pages info. Also, if we ever need to move content, we'd now have to redirects the links to the PDFs. What are best practices in this area? To index or not? What do you / your clients do and why? Would a PDF indexed by google and downloaded directly via a link in the SER page pass SEO juice to the domain? What if it's on a subdomain, like when hosted by Pardot? (www1.example.com)
Reporting & Analytics | | hlwebdev1 -
High bounce rates consistent with a login that takes you to a 3rd party site?
My firm has a credit union client whose bounce rates skyrocketed after implementing an online banking portal. Logging in to the online banking portal takes you to a 3rd party site. Would arriving at the site and immediately logging in be considered a bounce? And if so, would a high bounce rate actually correlate with a warm reception to their online banking tool?
Reporting & Analytics | | TheKatzMeow0 -
What's more accurate? GA queries data or Moz/SEMRush keyword data for rankings
What do you guys think? What's more accurate? GA queries data or Moz/SEMRush keyword data for rankings? Any thoughts appreciated.
Reporting & Analytics | | znotes0 -
Weird Math in GA Ecommerce Tracking
Hi everybody. I've recently discovered that I have a problem with the ecommerce tracking on a client's website. The client sells concert tickets at an average price of $10 per ticket. The custom ecommerce platform they use is kind of unusual; the same product often has different SKUs, but not always. This isn't associated with different seats, etc. In fact, I don't yet know why they've set it up that way. The problem that I'm facing is this: the data in Analytics is calculating the "average price" of a SKU item as the total price. If, for example, the actual average price for a SKU item is $10 and four of those SKU items were sold, Analytics will tell me the average price is $40. This means that the total revenue for that SKU shows up as $40 x 4 = $160. Needless to say, this is enormously skewing the data. Here's a screenshot. Note, it's the same product: http://screencast.com/t/JyLQkb3jzz6s The total revenue for ticket sales is way off because of this, and I'm not sure if it's a problem with the ecommerce tracking code in Analytics, or something that the ecomm platform is doing. Have any of you experienced anything like this, and if so is it a fix in Analytics? Thank you!
Reporting & Analytics | | newwhy0 -
Google Search Bar Vs Address Bar To Determine Number Of Times the Domain Name Is Typed In..
Hello, I'm trying to get a rough estimate of how many times a domain name that we're interested in acquiring is typed in to the address bar. If the google keyword tool says for instance, that the exact match domain name is typed in 720 times, how many times it typed in to the address bar? example.com - 720 global searches Thanks!
Reporting & Analytics | | Optimize0 -
Adwords Clicks correlating to Analytics Paid Visits
Would appreciate if anyone could clarify for me the correlation between 'clicks' in Google Adwords and visits for paid search in Google Analytics. Currently i see several thousand clicks a day in Adwords, yet our analytics account will only report a few hundred visits so i do not know which data set to use as the most reliable source for analysis. e.g 16th May. Analytics > TrafficSources > Sources > Search > Paid = 208 visits Adwords > All Campaigns, Total Clicks = 1153 i have found a few other questions asking the same thing here and here but dont feel they answer my question. We know our Adwords account is linked to our Analytics account as we got in touch with our PPC account manager originally about this and on reiew they found an error in our setup. Since then we know this is working as search terms and source are showing up and we have auto tagging enabled. Thanks, Tom.
Reporting & Analytics | | Sarbs0 -
How to see traffic for specific keywords in GA
Hell guys, What i want to achieve is to generate a list of specific keywords showing traffic for a certain periode of time. I also want so be able to compare this time period with historical data. I want a list as shown in: Traffic sources -> sources -> search -> organic. This shows a list of keywords generating traffic out of the organic search results. When you use a filter you can only use one word so it seems. I just want to create that list but with the specific keywords i choose to display. I tried advanced reports and advanced segments but that doesn't really give me what i want. The idea behind this whole thing is that i want to give my client an overview of the traffic received on the words we are optimizing for. this traffic has to be compared to the previous month so they can see clearly if there were changes. Thx !
Reporting & Analytics | | 5MMedia0