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
-
Mass Moz Grading
I want to know if there's a workaround to grade my individual pages for multiple keywords in a more efficient manner. Let's say for example (this is an extreme hypothetical) that I'm targeting these keywords: "Red Castles" "Blue Cars" "Green Bottles" on one page. I want to know if there is a way to run three grade reports at once for the single page that they're on with the Moz tools. Thanks a bunch!
Moz Pro | | OOMDODigital0 -
Does SEOmoz tool provide me the option to track rankings for other search engines like google.co.uk?
I need to track rankings on search engines across different geographies. Does your tool provide the option to track rankings for search engines other than the ones used in US
Moz Pro | | zycus0 -
Ranking Tool
We are considering purchasing your complete suite. Our question is regarding your Ranking Tool. We currently subscribe to Market Samurai and they provide us with keyword ranking abilities tied to our internal pages. Our domain, www.wklaw.com has hundreds of internal pages. (86 areas of law, each with 5 pages). will your ranking tool match our keywords to our internal pages? or does it only provide us ranks for the main domain? Thank you.
Moz Pro | | Wallin_Klarich0 -
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 -
What keywords should I use in my campaign.
I am a chiropractor. I only compete against web sites in my town. Should my key words be neck pain, back pain? Or should it be neck pain Bloomington Illinois and low back pain Bloomington Illinois? I am referring to the campaigns I just started. (I am new)
Moz Pro | | Bob550 -
List ranking analysis for all keywords?
I would love to see the option of having the ranking analysis listed for all my keywords! As it it now I have to click and get the numbers one by one and manually create a spreadsheet in order to have an overview of which keywords to pursue. I want to see my google ranking for each keyword next to information on how many people search for that term (in my country of choice - google.xxx) and the keyword competition in % Please tell me there's a way to do this and save me a truckload of time!
Moz Pro | | JaneVO0 -
For those using Omniture instead of Google Analytics
Instead of connecting Google Analytics into the SEOMOZ campaign monitor, is there a way to link Omniture or alter their output to plug into SEOMOZ?
Moz Pro | | Dekoda_Jones1 -
Report: keyword difficulty verses SERPS ranking
Hi there, I've been using the PRO tools for a few months now, and find them great for revealing information for my clients, and planning our SEO approach. One report I've put together has been really helpful for a client, but I built it manually and it took ages. It lists, in a spreadsheet, keywords side-by-side with keyword difficulty, target URL, and SERPs result. Sorting by keyword difficulty or SERPS position has helped us to prioritise which pages to hit first. But it took a while to generate the report, and I'm wondering if anyone has a better approach, or if this kind of report can be generated automatically: http://www.cicada-online.com/app/images/documents/product-page-SEO-blank.pdf Thanks Mozzers!
Moz Pro | | nedwells0