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
-
What is the difference between my pages' keyword rank and keyword-specific SERP?
I've been tasked with identifying high volume keywords for products our company sells and optimizing our copy and listings to rank higher on Google. The Keyword Explorer and On-Page Grader have been fantastic for this, but as I write my reports, i'm not sure whether SERP or Moz's keyword page rank would be more accurate for reporting results and movement. For instance, one of our product pages ranks #12 for the highest (relevant) volume keyword, but when looking at the SERP analysis for that keyword, our product page actually shows up at #7 down the list. I've tried naturally searching in Google in case it was an issue of private results based on my user data but it seems to give the same result. Am I conflating two different tools? Or is the Moz rank just an estimate?
Moz Pro | | BJake0 -
Domain authority get down significantly. Internal MOZ Issue? Google Algoritm Update?
I've noticed that several websites have lost DA since middle of october. I attached a picture. Could be this a MOZ internal issue like happened a time ago? Not only the DA get down, I have lost C-blocks links, too
Moz Pro | | NachoRetta
I check in http://health.moz.com/ and found this Crawl Services Outage: http://health.moz.com/incidents/fbn00m7xxzx2
But not appear to have direct relation with my question.
Or may be a google algoritm update? 3anVE5J.png2 -
Why do the Ranking Report emails differ from the acutal Ranking Report?
I have been noticing that the Rankings listed in the emails are far different from the ones in my report once I log in. Any idea what this is about? Often the rankings in the email are much better then in the report. And I am talking about on the same day as the email was sent out, not a week later.
Moz Pro | | 2CDevGroup0 -
Google Analytic Caching Issue?
Two weeks ago, I started testing a campaign and linked it to my Google analytics account. At the time there were 4 domains linked to the GA account. And I could see all 4 domains at the drop down menu that asked me to choose one to connect to. One week ago, I added a 5 more domains to GA. When I log directly into GA, I see the total of all 9 domains, and all are verified and collecting data. Today at pro seomoz I started a new campaign, for one of the new domains recently added to GA. When I try to connect the campaign to GA, only the ORIGINAL 4 domains are visible on the drop down menu. None of the 5 new domains are visible. So I am unable to connect to the new domain. At campaign settings, I disconnected from GA, and connected again, but could not see the new domains on the drop down menu. I tried to use both FF and IE. I can only assume that this is a caching issue at pro.seomoz. If so, how to flush cache and get current again. Please advise
Moz Pro | | microonae0 -
Why have my rankings dropped on my keyword report but there is no change for the same keywords on google??
I received a keyword ranking report over the weekend, was horrified to see some of my keywords have dropped ranks by 20+ for some 😮 I checked them on google and they haven't moved (confused.com) Any information would be greatly appreciated.
Moz Pro | | Anthonykal-group0 -
Press Release - using moz bar/OSE is reading domain not page? How? Why?
A question posed by Christopher Glaeser from early today:low PA high DA, had a follow up response from him providing 2 urls from PR WEB for separate press releases: http://www.prweb.com/releases/2011/11/prweb8923419.htm (HP White) On moz bar Page Analysis/Link Data = PA - 47 DA - 36 http://www.prweb.com/releases/2011/12/prweb9051351.htm (Golfer's Advice) On moz bar Page Analysis/Link Data = PA - 1 DA - 96 I kept scratching my head as to how a press release of 6 weeks ago had garnered such attention from a company that would not seem to have a huge traffic due to more obscure product offering and scientific subject (Analyses of Armor Industry versus Golf Advice).
Moz Pro | | RobertFisher
Then I realized that for HP White, Link Data was not about the PR. The url from mozbar was HPWhite.com not the above, I did not notice until I used OSE where same thing was happening. When I cut and pasted the above press release url for HP White and placed it in OSE this changed: PA - 49 DA - 96 (2 links 2 linking root domains) For Golfers advice (0 links from 0 linking domains) Note to all: the links to the PR WEB release for the HP included a low end directory type link and a link from PR WEB (. For Golfer's Advice there was not a link back to the release from PR WEB: Note that Golfer's Advice is a newer release (6 weeks). So, any link from HPWhite release would equal more juice to HP White and PR Web and Vocus. Any link to Golfer's Advice from release offers......???? to Golfer's Advice and who cares to Vocus and PR Web. So, I guess this begs a couple of questions: Why the mozbar link analysis difference for one versus the other? Does PR Web treat some differently than others? Who benefits most from me paying a PR Web to do press releases for a client, PR Web and Vocus or my client and I???? I have tried to order the images to make sense: L to R top, then bottom is last. [](<a href=)" target="_blank">a> [](<a href=)" target="_blank">a> [](<a href=)" target="_blank">a> [](<a href=)" target="_blank">a> [](<a href=)" target="_blank">a> [](<a href=)" target="_blank">a>0 -
A tool for seeing all the keywords a website ranks for
As title, is there a tool out there that will allow you to see all the keywords a website ranks for in the first few pages of a particlur search engine? I would be particularly interested for keywords in the first 10 pages of Google. Thanks
Moz Pro | | blagger0 -
How do you use mozMetrics
How does everyone use the mozMetrics (mozRank, mozTrust, Domain Authority, Page Authority) with their clients? Do they ask you what these metrics mean and if so how do you explain it to them?
Moz Pro | | caseyhen1