Can you arrange Google Analytics source/medium traffic by percentage change?
-
I'm doing a year to year traffic audit for a client. I would like to analyze Google Analytics source/medium traffic by percent change. Is there a way to do this? Do I have to create a custom variable?
-
As most people here have said, the best way is to just do this work outside of GA. Custom variables have to track current site performance, so I don't believe there's a way to build a custom variable that looks at data as it's been recorded in GA in the past.
There are a lot of ways you can put the data together, but when I usually do is use Google's Compare option as you select the time period you're looking at. When you export the data to Excel, Google will create a separate row for every time period, like this:
Source / Medium | Date Range | Sessions .....
google / organic | Jan 13, 2015 - Feb 22, 2015 | 278,834 ...
google / organic | Jan 13, 2014 - Feb 22, 2014 | 247,424 ...
You can combine those into one row fairly easily with VLookup, as Ray suggested, or by creating a Pivot Table, where Source / Medium is the Row Label, Date Range is the Column Label, and Sessions (or whatever metric(s) you're interested in) is the Values.
If you've created a Pivot Table, copy those values over to a new sheet, and calculate the percent change in each row, just like Ray said.
Hope this helps!
Kristina
-
If I'm understanding you correctly, I think you're going to have the same problem with channels. Google changed their reporting structure in July 2013.
-
That would be effective if the Source/Medium was consistent between both years. You might have better luck with Channels for this method (less variation between years), but Source/Mediums are probably going to vary between years. I.e. 2013 includes a Source/Medium that no longer exists in 2014, so the data would not align neatly.
-
You don't have to run a VLookup necessarily. You can align the data side by side and do a simple division formula to calculate the percentage of change. Just copy and paste the data into two columns, and use the IMSUB to find the difference, then divide for a percentage.
-
Hi VC,
Unfortunately, I do not think there is a default reporting option to sort a compared Source/Medium report by % changed. Absolute change is available (although sometimes doesn't sort properly) and may give you a good idea of the traffic differences - Absolute change may even be better since it could identify a low %, but high traffic change.
To find exactly what you're looking for I suggest:
- Export the Source/Medium data for 2014
- Export the Source/Medium data for 2013
- Run a VLOOKUP function in Microsoft Excel to have a single table with 2014/2013 data
Now, you can calculate percentages, absolute values, and sort/filter the data as you see fit. Google Analytics provides a lot of the necessary data analysis tools, but it doesn't replace the power of MS Excel :)....yet.
-
The easiest way to do this is to export the data and work with it outside of Google Analytics. I reccomend using http://www.nextanalytics.com/ to automatically export data from GA into excel.
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
-
Is Google doing anything about the spam referrer plague in Google Analytics?
My client manages 15+ websites and we have observed the spam referrer issue has gotten steadily worse and worse in the last few months. I took the time to weed out the worst offenders via traffic filters but our referral traffic source garden was quickly full of weeds again a few weeks later. Does anybody know what the Google Analytics development team is doing to combat the spam referrer issue? I find it quite amazing that Google goes through the asinine effort to block out organic keyword data ("not found" & "not provided) but they don't seem to care about blacklisting/filtering spam referrers. RHnE6Wx
Reporting & Analytics | | RosemaryB3 -
Is it possible to import data from an old Google Analytics profile to a new Google Analytics profile?
We have encountered a situation where a client's old SEO firm is refusing to grant us Admin access to our client's existing GA account. For security purposes (so the other SEO firm doesn't delete the existing GA profile) we have started a new Google Analytics profile. Again we do have access to the data in the old account. Is it possible to migrate this old data over (if we just have user access)? Thanks for the help
Reporting & Analytics | | RosemaryB0 -
Identifying Bots in Google Analytics
Hi there, While you can now filter out bots and spiders in Google Analytics, I'm interested in how you identify a bots and spiders in the first place. For example, it used to be thought that Googlebot wouldn't appear in GA as it 'couldn't process Javascript' but now Google has announced new developments for its crawler with regards to interpreting javascript and CSS, this argument isn't as cut and dry. I'm not suggesting Googlebot appears in Google Analytics, but I am saying that you can't make the case that it won't appear only because it can't interpret JavaScript. So, I'm interested to see what metrics you use to identify a bot? For me, the mix of Users > Browser, Users > Operating System Version is still quite handy, but is it possible to identify individual bots and spiders within Google Analytics? And would Googlebot appear?
Reporting & Analytics | | ecommercebc0 -
Locating Source of Referral Traffic
Hey Folks, I have discovered a Korean site is sending considerable traffic to a specific landing page on my client's cosmetic surgery site in California. I am concerned Google may deem this as spammy - I know I do. I have been able to track the referral traffic to this point: cluster1.cafe.daum.net/c21/bbs_read which appears to be a community-based site and/or forum. However, I can not locate the exact source where the href back to my client's site resides. Given that my Korean is not exactly up to par 😉 and Google translate only takes me so far, can any of you suggest an advanced query or method of tracking to pinpoint the source page? Thanks!
Reporting & Analytics | | SCW0 -
Google Analytics
Is there any way around being able to set up 20 goals in Analytics? What if one of my clients want to set up 10 pages with separate actions to track on each page. Will then each actions count as a separate goal? If this is the case, how could I work around creating more than 20 goals? Would I have to look into hiring/buying a third party or separate software? Your help is greatly appreciated.
Reporting & Analytics | | flcity150 -
Google Analytics for multiple languages on multiple domains
Hi folks A quick question in regards to setting up Google Analytics for a website with multiple languages on multiple domains. The domains that needs to be tracked are: www.example.com -> English www.example.se -> Swedish www.example.dk -> Danish To my best knowledge this can be acheived in Google Analytids using 3 different setups: Different accounts Different properties Profiles What would you guys consider the best approach?
Reporting & Analytics | | Resultify
Pros and cons? Have a great day Fredrik0 -
How do I best segment tablets on Google Analytics
I would like to find a way to best segment out my tablet traffic to measure performance; however I'm finding that there are road blocks. It doesn't seem that device operating systems or screen resolutions have clear cut differences in the tablet/mobile versions. Has anyone here found a good way to create a "tablet" segment in Google Analytics? Right now I'm having to lean on solely the ipad traffic to get indicators of tablet performance. Thanks!
Reporting & Analytics | | lvstrickland0 -
Setting up Google Analytic Goals to a 3rd Party Site
I recently received help on a question I asked on SEOmoz but need additional clarification. I am trying to set up goals in Google Analytics for people who click on a “purchase botton” which sends them to PayPal. I created a Thank You page and tried to get PayPal to redirect to it, however, our customers only get to our site’s 404 page. Here is what I’ve done so far: Went into my PayPal account and turned the “Auto Return” to ‘on’ Under website payment preferences, I added the following URL http://www.teecycle.org/thank-youutm_nooverride1. (I formatted the URL this way because the person who provided me with help recommended using the format ?UTM_nooverride=1. However, our CMS system won’t allow “?” or “=”)
Reporting & Analytics | | EricVallee340