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 find keywords your competitors rank for but you don't?
Hi, I'm just digging through Moz pro at the moment, and really like the true competitor feature, but would like to be able to see the keywords our competitors rank for and we don't, rather than just the overlapping ones. Is this possible at all? Thanks
Moz Pro | | pm-mbc
Paul0 -
Ahrefs vs Moz
Hi! I noticed the Moz DA en the Ahrefs DA are very different. Where https://www.123opzeggen.nl/ has a DA of 10 at MOZ, the DA at Ahrefs is 26. Where does this big difference come from? Do you measure in different ways? I hope you can answer this question for me. Thank you in advance!
Moz Pro | | NaomiAdivare2 -
I'VE DONE EVERYTHING RIGHT BUT STILL GET LOW GOOGLE RANKING
Moz Pro Dashboard compared my site to three competitors' site. My site is better in every aspect. My DA is higher, I have four times more external links, I have more relevant content than my competition, my site also is the fastest, I have solved all redirect issues, there is no broken link internally or externally. We are custom home builders. So all our sites have numerous full screen images. I have optimized all of them. When I ran WebPageTest on my competition, they all fail. My site got A's in all categories. The three competitors' sites rank first, second and third. My site ranks bottom on the 2nd page. Since my site was online last January, I have spent thousands of dollars on SEO work. Its url is www.pokudesign.com I am hoping somebody can point me in the right direction. I am attaching a screen shot of my Moz Pro Dashboard. frEpZ
Moz Pro | | pokongku0 -
Why is my page ranking lower when my moz stats are higher?
There are several keywords that I search for and I notice we rank lower than a couple of competitors. When I use the mozbar and view the stats, I see that are PA and DA are higher and in some instances the ones who rank higher don't even show all the keywords in their meta descriptions. If this is the case, how are they still ranking higher?
Moz Pro | | Smart_Start0 -
IP TRACKING
Is there a 3rd party that can provide me with all the ips that have hit my site http://1-800-medigap.com ? Does the MOZ API have that ability? Does anything?
Moz Pro | | jdcline0 -
Which URL to use for my campaign?
My outdated CMS redirects from a clean url root domain to an ugly url. Should I use the ugly one to start a my campaign? So when you type in www.site.com it redirects to www.site.com/site/c.leJRIROrEpH/b.5699537/k.BEF4/Home.htm Should I use the url it redirects to when starting a campaign?
Moz Pro | | mstanwyck0 -
Cities in Keywords Ranking Reports
So I've been in the habit of creating a master list of keywords concatenated with the city name so I can track my local rankings versus competitors. 1. Is this the correct thing to do to help hone in on who competitive my sites are ranking in the local market? 2. If so, by doing this the On Page reports seem to be totally screwed, because the searches I'm tracking (with city) vs the keywords I want to analyse for on-page ranking (without city), are different. What is the solution?
Moz Pro | | justlawonline0 -
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