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
-
Recover/Claim Ownership of a Google Analytics Account in easy steps
Hi All, I just found this useful article on Recover/Claim Ownership of a Google Analytics Account , I've seen same question asked by website owners, webmasters very frequently in many forums so I decided to share the article. **No affiliation, sponsorship, nor any partnerships with ohow.co Thanks
Reporting & Analytics | | Alick3000 -
Google Analytics goals only show unique event triggers
I have some goals in GA which is linked to different event triggers. However I've found out that the goal is only showing the unique event triggers and not the total. I need it to show the total in order to be accurate. Is there any way to switch that option? I can't find any options like that in GA or guides to do so.
Reporting & Analytics | | WebGain0 -
Drop in google.com / referral trafic
Hi, On one of our sites (after the release of a new version, including redirections), we've seen a drop in referral trafic from google.fr (france). I know that this trafic usually comes from Google Images but it doesnt seem to be the case this time. The referal path is "/" and not "imgres" as it usually is when it comes from google images. The search trafic hasnt dropped tough... The site is a job listing site. We also saw a drop from indeed.com, I guess their crawler got lost in our new site... Any idea on the possible google site it could come from? Thank you,
Reporting & Analytics | | AdrienLargus0 -
Why am i seeing google.inc in analytics as direct traffic? Bug?
Recently i have seen two clients sites see a spike in direct traffic coming from google.inc. Is this a bot/bug which i should filter out. Just a bit confused why google.inc has visited our clients site 676 times! Any insight would be great.
Reporting & Analytics | | BlueWren1 -
Site account in Google Analytics
Hello I have a question about my site account. On 2014, during a week, my ID tracking of Google Analytics was removed of the site, in this period the volume of users and sessions is lower than the other weeks. But I don't understand why are the sessions and users still reporting during this period without ID Tracking
Reporting & Analytics | | Arkix0 -
How can I tell if I am using Universal Analytics?
On my Google Analytics page it says at the top "Upgrade to Universal Analytics Upgrade to get a deeper understanding of your users through new tools and more accurate data." Below that it talks about how to do it. I do not see what they are talking about for "Select an account and a property, then click Universal Analytics Upgrade." But if I can into my change history is shows Changed By-System Property "http://www123.com" started transfer to Universal Analytics processing." This was on May 22nd and it hasn't said anything since. Why does it keep telling me to do it if it already has? It doesn't say transfer complete anywhere so I don't know if it finished or not.
Reporting & Analytics | | EcommerceSite0 -
Conflicting numbers in Google Analytics
I am getting 2 completely different numbers in Google Analytics.According to the graph on my Dashboard organic traffic decreased ~40% comparing June 7 -> June 6.However, when I dig a bit deeper and look at the 2 dates specifically compared to each other I get a `3% increase in traffic.When I look at the traffic on just June 7, I get the number indicating the increase.Any ideas or someone getting similar conflicting numbers??
Reporting & Analytics | | theLotter0 -
Google Analytics Organic Accuracy?
Hi, On a cool summers day, I was quenching my thirst for SEO Knowledge in the depths of Google analytics, When I stumbled upon a most troublesome sight. I was Browsing the data inside Acquisition->Keywords->Organic and comparing them to Acquisition->Search Engine Optimization->Landing Pages, to find the results quite questionable.. Since Keywords->Organic measure the visits from the organic results, and Search Engine Optimization->Landing Pages measures the clicks onto one of my landing pages from Google, I assumed they should be the same or very close, (besides Keywords->Organic having visits from other search engines) but they were not the same, as a matter of fact it was telling me that Keywords->Organic visits = 1,474, 27.19% of total(5,422) and Search Engine Optimization->Landing Pages, clicks = 1,548 154.80% of total (1000). Even worst the Search Engine Optimization -> Queries clicks = 1,123, 160.43% of total(700). I have been searching, and come up empty handed in the answer so does anyone know why Google is showing me different results and strange numbers that don't make sense? Any information is greatly appreciated?
Reporting & Analytics | | KBB_Digital0