Using MOZ Keyword Rankings with Google Analytics in Excel to track paid keywords
-
Hi,
I sorted my keywords in GA from highest incoming traffic to lowest, exported it and then imported these 280 or something keywords into SEO Moz.
The problem is, it appears that SEO Moz Keyword Rankings tool pulls traffic data (in the traffic column) only for NON-PAID traffic ...
So what I'm seeing is that keywords that brings A LOT of traffic to my site (because of AdWords) sometimes have 0 of traffic in SEO Moz, because I'm on page 3 of SERP and I literally got no non-paid traffic that week.
The thing is: I want to improve my rankings for keywords that I'm already performing well, even if they are paid keywords, because they already bring me a lot of traffic to my website. The way this is working is not helping me out, because when I sort by the traffic column very important keywords end up in the last place for me.
Questions:
-
Whey does SEO Moz pull traffic data from non-paid keywords only ? Shouldn't be at least an option for this or I'm missing something here ?
-
While they don't change it, any Excel Gurus could help me how to export SEO Moz ranking data, import it on Excel and MERGE a new "paid traffic" column that I export from Google Analytics ? How to assing each keyword line the paid traffic value I'm getting from GA ?
Thanks !
Felipe
-
-
Hi Felipe,
You raise an excellent point about paid keyword traffic in GA. The reason SEOmoz hasn't offered this until this point is that:
- Integration with Google Analytics is still pretty new to the PRO platform - but new features are being added all the time.
- Most of our historical focus has been on promoting organic traffic - but we could definitely do a better job of making room for paid traffic as well.
- This fits most of SEOmoz customers needs.
That said, there's a lot of validity in wanting to look at paid search volume and it would make a great feature request. (I encourage you to submit and vote for this feature)
Part 2 - If I understand correctly, you want to combine/import paid traffic data from Google Analytics with the keyword report csv from your PRO campaign. The good news is this is simple task in Excel and easy once you get the hang of it, but it takes a little learning to get there.
The full answer would require a short book (or really long blog post) detailing each step - but fortunately by learning the basic functions, you can do all this yourself and more . It might take and hour or two to get the hang of it, but you will be armed with the knowledge to tackle all kinds of common Excel challenges.
To combine data like this, what you are looking for can be achieved in Excel using VLOOKUP or INDEX/MATCH functions. The best place to learn these is in Distilled's excellent Guide on Excel for SEO. I worked myself through this guide about six months ago, and now I tackle "advanced" Excel tricks with a bit more confidence.
Hope this helps! Best of luck with your SEO.
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
-
Unsolved How to concat moz.com
Hello,
Moz Pro | | GrzegorzZ
I wanted to contact moz.com. I started my 30 day trial to test service.
After 2-3 days totally forgot about it. I remembered about moz.com when i received invoice saying they're gonna charge me.
I immediately wrote email to them that I do not want this service. I forgot and only put credit card data because i was required to. And would like a refund since it was 2-3 hours after bill. Unfortunately sending messages via their contact form is not an option. There is no confirmation on my email they received message nor return message from them.0 -
How to sift "site search" data from Google Analytics for trends
I apologize in advance if this has been asked a million times but I'm just not able to find anything on it for some reason. Probably the words "site" and "search" come up a lot in this area... Anyhow, my question: How do I find trends in "site search" data from Google Analytics? I set up "site search" a long time ago. I have thousands and thousands of searches people have made on my site logged and squirreled away. The plan was to review them on a weekly basis, find the trends and start writing content to address interests people seem to be having but not finding on our site. Sounded great at the time. The problem I have, of course, is that among my 10,000 searches (many shown in Google Analytics as "no-results:cats and dogs", etc), there are slight differences that make it difficult to total up search trends. Let's say the list is like this: Term | Search Count Cats | 500
Moz Pro | | rtkl
Dogs | 500
Cat | 250
Dog | 250
Cat food | 5
Dog food | 5
Birds | 1
Bird | 1
Cats are great | 1
Cats are really great | 1
Dogs are great | 1
I like birds | 1
Seriously, I like Cats | 1
Turtles | 1 ... 10,000 more entries, every single one only 1 search per term. OK, so it looks like people like Cats and Dogs a lot, but also Birds and Turtles. But maybe there are snake searches. Maybe there are "cat pajamas" searches and variations on all of the above. Who knows what else is really trending in there??? The review of this data is MIND-NUMBING. Especially when you get into plurality and misspellings, this rabbit hole has no bottom. Is there a tool people in the SEO jam use to take a big ole CSV dump and have it magically sorted by at least potential trends? I mean, there's gotta be, right? And I'm silly for not already knowing what it is.0 -
When using Moz Pro do I want Google-UK or -GB as default and why?
Hi. When using Moz Pro, I always select Google UK as default search with GB and US next. Is there a reason to choose one over the other? If so why? I am UK based and so are my clients. Thanks
Moz Pro | | YNWA0 -
Understanding how moz grades webpage and Keyword stuffing
Hi friends i have few questions about how moz ranks webpage. I just started so i looked only on front page of my website And i have grade A and few problems 1. Keyword stuffing. I can not understand how moz page grade tool runks page? does it looks source and counts all keywords? I have menu with 46 countries in which have keyword like "Freight forwarding - England" and so on. May be this is the problem? because if i search in chrome i just see 9 keywords but in source 100. But removing menu does not reduce number of keywords. So i can not understand what should i remove. An we made these pages for adwords campaign us landing pages for targeted keywords. The keyword is : Kravu pārvadājumi (freight forwarding) 2. On page grade shows i have too many links on page like 103. Does it count menus? Is it so bad? 3. what moz crawls for links, Google or my page? because i see duplicated content like vervo.lv and vervo.lv/lv. But if you try to write vervo.lv/lv it redirects to vervo.lv so how it is possible to resolve? What Should i do else if redirect does not help. on the moment page have 3 languages and main language is Latvian, webpage: http://vervo.lv/ Thanks for help.
Moz Pro | | vervo0 -
Are labels useful in managing keywords in SEOMoz Campaigns?
I am using SEOMoz for only one domain. Should I track keywords under only one campaign, or should I utilize the different campaigns for different types of keywords under the same domain? Is it easier to keep all keywords for a domain in one campaign? Is it helpful to assign labels to keywords within the campaign? What types of labels should I create?
Moz Pro | | djlittman1 -
SEO MOZ keyword ranking tool
Hi Guys, Can anyone please help me! I have a client that has two web pages that he wants optimising, one page is the home page and the other page is within the page.. Does anyone know if the SEO MOZ ranking tool only looks at the home page for jeywords or will it look at what ranking is the the other page within the website?? Or do I have to set up separate campaign jut for one page within the website?? Can anyone answer this please? Thanks Gareth
Moz Pro | | GAZ090 -
SEOmoz v's Google Webmaster Keyword Ranking
Hi, how accurate is SEOmoz keyword ranking v's Google Webmaster? Some Keywords in SEOmoz say I'm in position 3 in Ireland for some Keywords and in Google Webmaster they are figures like 16. I understand in Google Webmaster that the keyword position is an Average What should I be going by and what is the credibility of both ranking estimators?
Moz Pro | | Socialdude0 -
How Long For New Keyword Rank Data?
I have a PRO account and added the initial keywords and got the immediate rankings for those. Then I added new keywords and those have not been updated. How long do I have to wait to get Keyword Ranking data on those keywords. I know it says they are updated every Friday, but does that mean I have to wait until next Friday for my first run of data on new keywords?? I ask because I have to present to a client before then and I require the data for that meeting. Any insight is appreciated.
Moz Pro | | mc418720