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 Keyword Rank History chart has missing data for periods of time
Hello, When I look at the rank history for a particular keyword, there are missing gaps in the data. For example, the keyword was fluctuating around rank 10-20 from Jan 2022 to July 2022. Then suddenly the line on the graph disappears. It starts tracking again in Oct 2022 starting at rank 16. It almost appears as if Moz lost track of the keyword for some time. Other tracked keywords did not experience the same issue during this time. Then as a result, Moz reporting will say the tracked keyword moved up in ranking 40+. What is happening here? I'm unsure how to explain this activity to my clients.
Moz Pro | | celsiusmarketing0 -
Improving ranking for a more specific keyword - eg 1 word
Hi there Ive managed to get my site ranking in top5 of Organic search for a 2 word keyword "keywordname australia" for example or "buy keywordname" - however finding it a lot slower process improving rankings for just the actual 'keywordname' Any suggestions as to what might be the best thing to focus on to improve a more competitive term?
Moz Pro | | IsaCleanse0 -
Perplexed - Errors increasing, moz rank dropping, conflicting data from other sources. Please Help.
Hi there, I'm in a bit of a bind and could seriously do with some help. For the past month I've been working with a client to resolve errors onsite. In that period my moz rank has plummeted and my errors (dupe title & content) have increased dramatically. The correlation makes sense, the increase - not so much. Here's why, screaming frog is reporting that the majority of duplicate titles have been removed or dealt with. I've also got the assurance of the developer that the suggested changes are being implemented. Unfortunately, I'm not familiar with the CMS - umbraco - and this is the first time I'm working with this particular developer, so I'm not sure how to gauge progress without using moz tools. So, here are my immediate questions: 1. Why would I get different results from Screaming Frog and Rogerbot? 2. Has anyone here been in a similar situation and could they recommend areas to watch for errors creeping in? 3. Is there a way of identifying which errors have occurred when? Narrowing it down to the week each error occurred would be good enough. 4. Is anybody aware of any inherent SEO flaws in umbraco or common SEO mistakes made using the CMS? 5. is there anything I could provide you with to help you help me? 6. Do you have a suggestion? I'm pretty stuck. Thanks in advance.
Moz Pro | | KJDMedia0 -
How can I change the day my keyword rankings are updated?
I have several campaigns which currently get their weekly keyword ranking reports updated on different days. I'd like all of them updated on the same day, so I can just check in one a week for everything.
Moz Pro | | RichardDavies0 -
How do we use SEOmoz to track Local Searches? Is there a way to set the location from which the campaign tracker is "searching"?
It seems that there is no way to set a parameter for location. In Places, I'm able to define my targeted region. How does SEOmoz mimic that localization? Thank for any help! -- Chris
Moz Pro | | ChrisPalle1 -
Google.com corresponds to google us ?
Rank tracker can't find sonosurgery.it ranked for sinus lift on google.com (us), but If I perform a real search thru google.com I can find it ranked at 15 . Why ?
Moz Pro | | Filolari0 -
Linkscape update tracking
I've got two questions really. First, is there anyway to compare your current Linkscape updates with previous updates? Second, I've made a concerted effort to gain accumulate links in strong performing domains over the past 3 months. However, Linkscape does not seem to be finding those links. Some of them are pretty straight forward, like Yahoo Directory (this went live last month). Is there a lag time between when I link to a page and when Linkscape picks up. Thanks,
Moz Pro | | vinnyb2000
Vincent0 -
Ranking better
Hello there, I am after some specific guidance on how to rank well for the keyword ‘Translation Services’. I have managed to get the site www.pstranslation.co.uk to page 2 of google UK for this key term. The difficulty is I seem to have run out of steam now on how to get higher rankings. After spending a considerable amount of time creating content and gaining links I managed to get the site from around page 15 on google uk to page 4 then to page 2. That’s where it seems to have stopped. I (think I) have got the onsite SEO pretty well nailed. I have got some good linkable content (http://www.pstranslation.co.uk/infog_languages.html,http://www.pstranslation.co.uk/language_resources_indus.html) and have plans to produce a more. Experience working within the language industry tells me that a top 3 position on page 1 for this keyword can very lucrative so my main focus of SEO is to rank well for this key phrase. There is a very good chance you reply will simply be get more (better) links and if it is that’s fine but is there anything else I can do? Am I missing a very obvious trick anywhere? Looking forward to your reply.
Moz Pro | | bigtimeseo0