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
-
Does Keyword Tracker rank eBay links as weaker competition than they actually are?
This might be a confusing question but hopefully I can explain it well enough and someone is able to understand where I am coming from. I have used the Keyword Analysis Tool to search the keyword "alice in wonderland fancy dress", the results come back saying that the competition for this keyword is 24%, which I consider to be pretty low. When I look at the Page Authority, Page Linking, Domain Authority and Domain Linking of each site which rank in the top 10 for this keyword I see that places 4 - 7 are taken by eBay links. I then look at the bottom three places (8 - 10) and although their Page Authority and Page Linking is not very high, their Domain Authority and Domain Linking is reasonable. Based on the results I have seen for other keyword, who's overall competition % was higher than 24%, I thought to myself that these bottom three links were actually quite strong, which made me ask the question "why has this keyword got a competition % as low as 24%?". I then wonder whether it was because the Keyword Analysis Tool ranks the eBay links as weaker competition than they actually are? My question to you guys: Does Keyword Tracker rank eBay links as weaker competition than they actually are? Or can anyone explain why the competition % for this keyword is so low but the bottom three links are actually relatively strong? And how do the eBay links rank higher than these bottom three links? Yes the eBay links are relative to the keyword but these eBay links are ranking higher solely on the fact that the Domain Authority is so high and have very little SEO in relation to the keyword, does Google not recognise that the bottom three websites would be more beneficial to customers than the eBay links? And if the eBay links are ranking so high solely on the fact that the Domain Authority is so high then shouldn't they be in the top 10 for almost every product related keyword? Thanks in advance.
Moz Pro | | conor10050 -
SEO moz poor rankings reporting
How are we supposed to send ranking reports to clients if the rankings are constantly reporting false metrics This is not the first time this has happened, but the rankings are WAAAAAAY off. What is the point of reporting rankings that are not accurate? What is the possible cause of this. Is there a solution? What is SEOmoz doing to improve their ranking programs. Our client actually ranked #2 for "northern Virginia HVAC contractors" when moz had us not in the top 50! How are we supposed to bank on information that is so consistently unreliable? northernvirginiahvaccontractors.png northernvirginiahvaccontractorsrank.png
Moz Pro | | imageworks-2612900 -
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 -
Tracking 1000 Keywords / 5 Competitiors
What's the best way to track 1000 keywords for a website along with monitoring how the competition ranks for the same set of keywords. We love the SEOMoz Tools but would love to see what else is out there using which I can pull weekly reports maybe of our rankings along with those of the competition.
Moz Pro | | NakulGoyal0 -
Capitalisation of campaign keywords - why does this affect traffic but not rankings?
Having accidentaly entered keywords into my campaign with both upper-case initial letters ("Product Design") and lower-case initial letters ("product design") I find that the rankings are, as expected, identical. However, the traffic generated by the keywords is markedly different. Does this mean that the two versions of the keyword should be treated like totally seperate keywords in future? Indeed, should I be entering all variants of capitalisation into future keyword campaigns (such as "product Design" and "Product design") if I wish to get the full picture in future? Any answers would be welcome. David in Scotland
Moz Pro | | ContactOnline0 -
Why are SEOmoz Pro Keyword Ranking reports different between two 301-linked URLs?
Hi, My main domain is www.dancenut.com. I have this 301 URL redirected to www.dancenut.com/boston/. I set up an SEOmoz Pro campaign for each of these URLs in order to see if they were being treated differently in any way. In most cases the report results are identical, or the small differences are understandable. However, there is one big difference between the two sets of campaign reports. In the Keyword Ranking reports, the data for the Bing and Yahoo! reports are identical, but the data for the Google reports are dramatically different. Out of 21 keywords, 9 are listed in the top 50 for www.dancenut.com, but only 2 are listed in the top 50 for www.dancenut.com/boston/ (the specific positions are the same for the 2 keywords that are listed for both). Does this make any sense? Could the SEOmoz Pro data be wrong? If not, then I'm suspicious that Google may not be interpreting the 301 redirect properly. I don't think this could be fully explained by a 1-10% reduction in link juice due to the 301 because I have one keyword for which my site ranks #1 in Google, Bing, and Yahoo! with www.dancenut.com, but it doesn't even rank in the top 50 in Google with www.dancenut.com/boston/. And why would these differences only exist for Google? Any insight would be much appreciated! Andrew
Moz Pro | | dancenut0