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
-
Best Keyword Strategy for Lower-Authority-Ranked Domain
Hi, What should a lower-authority-ranked blog (DA - 21) who is trying to increase general traffic focus on above all when selecting keywords: difficulty, monthly volume, opportunity, or priority? I know that all are important factors to consider, but I fear that without an already consistent following our new content will just get hidden behind more established domains if we select too difficult of keywords. I'd love to hear from someone who's built up a blog audience as to what strategy they used here. Thanks!
Moz Pro | | ascott7770 -
My website was at the top of Google search for some years... suddenly I almost can't reach first page! Moz ranks my website better than the competitors... what might be going one? Could anybody help me out? Thanks!
Hello Guys! My website was at the top of Google search for some years... suddenly I almost can't reach first page! Moz ranks my website better than the competitors... what might be going one? Could anybody help me out? Moz rank us grade A... the competitors B or C .. I think we have better back links than they do... Would you need any kind of data or report to help me here? Thanks!
Moz Pro | | wesleyms0 -
Rank Tracker violate Google Guidelines?
I would like to find out whether the use of SEOMOZ rank tracker violate Google's guidelines. "Don't use unauthorized computer programs to submit pages, check rankings, etc. Such programs consume computing resources and violate our Terms of Service. Google does not recommend the use of products such as WebPosition Gold™ that send automatic or programmatic queries to Google."
Moz Pro | | PGRob0 -
Rankings Feature Changes
Hi guys, Is there a way that the Rankings tool within the campaigns could show a monthly comparison rather than weekly? Possibly a drop down just to choose weekly or monthly. At the moment, when someone outside of the team involved looks at the results, it looks as though the website is in a downward sprial, where as we could be lower than ever, just with one bad week. Thanks for your help! 🙂
Moz Pro | | RPIDigital0 -
How to fix problem with google analytics connection?
In the Organic Traffic Data Report I receive always the same message: "It appears there's a problem with our connection to your Google Analytics account. Please go to your Settings page to update your connection." In the settings I've choosen the correct Google Analytics Account with the correct profile. Thanks for any hints. Is it because using www. in the GA Profil but *.xyz.ch without www in the campaigns settings?
Moz Pro | | FlorianMuff760 -
Is there a way to manually update the keyword rankings tool in SEOmoz?
It appears that our keyword rankings update weekly on Thursdays. Is this the same across the board or is there a way to manually run an update?
Moz Pro | | Motivators0 -
Tool which shows site ranking for a given keyword
Hi all. I have a client with a specific request and wanted to ask if there is a reliable tool which allows a user to enter a given site and keyword, and it will return the site's ranking for that keyword. More specifically: Needs to work for Google, Yahoo and Bing Needs to work for various countries such as Google.ca, Google.it, etc. Needs to show at least the top ?10k rankings, not just the top 50 The last requirement is the challenge. I clearly recognize anything past the top 50 or so ranks is really off the map, but the client would like to view his current standings.
Moz Pro | | RyanKent0