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
-
How much backlinks are required to rank a keywords.
I have a boxing gloves keyword kindly tell me how many backlinks required to rank this keyword
Moz Pro | | saadrazaa120 -
I have used my keyword only 12 times but on-page grader shows it 40 times?
Hey experts, I hope you are doing great, kindly have a look at this page, my keyword for this page is "Sports Streaming Sites". The text has a length of 5344 words and I'm using my keyword in this post as follow: 1. Text Body: 12 times(including headers)
Moz Pro | | louisaclark1
2. Alt tags: 10 times (20+ Images)
3. Title: 1 Time
4. Description: 1 Time
5. Permalink: 1 Time This is a total of 25 times in 5344 words, but when I check this page with moz on-page grader, it shows that I'm using this keyword 40 times and its stuffed, can anybody please explain it to me, I'm so confused and it'll be so nice of you. Here is the on-page grader report page: https://analytics.moz.com/pro/research/page-grader?keyword=Sports%20Streaming%20Sites&url=https%3A%2F%2Firiveramerica.com%2Ffree-best-sports-streaming-sites%2F0 -
Google RankBrain Update Affecting Ranking Reports?
In the past 2 months we have been seeing a large amount of movement in our ranking reports in Moz Pro. Here is what is going on: We run reports for around 15 different clients using Moz. We also track around an average of 100-150 different keywords for each client (some more, some less). What I have seen lately is that we have a week where the sites do great, next week a large shift down. The week after a large shift up. The next week a large shift down. Rinse, repeat. It makes it very hard to spot the trouble areas on a page or keyword when there doesn't really seem to be a consistent way of knowing what the trends are. It appears to be random, and the next week they seem to recover, along with some that do not. We will see some keywords drop 30 places, only to regain the majority of that drop the following week. Some of the sites have received content updates while others have remained largely untouched. It is very confusing to see this pattern, and I have tracked it for about 2 months. Is anyone seeing a similar pattern in their reports? Could this be related to the rollout of Google's RankBrain, the new AI learning tech from Google? Most of the keywords are tracked are not long tail, and are basic local business/service type of keywords. Plumber in St Louis, etc etc
Moz Pro | | David-Kley1 -
Keyword rankings are not updating from past two weeks? Is there any issue in SEOmoz tool ?
I have added 215 keywords to my account. From past two weeks i am waiting to see the rankings, however it's not updating.
Moz Pro | | Sasank0 -
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 -
Woo rank features
Is there a way to find the same type of information that woo rank provides via the pro toolset? I am just learning SEO and exploring the PRO tool set and just received a woo rank report for a clients site and right off the bat I see that it is missing the robots.txt file, but I haven't found anything like that on SEO moz. Thanks!
Moz Pro | | ClayW0 -
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 -
Can I change Keyword Analysis from Google USA to Google Brasil:
I am on SEO MOZ pro and I am running an analysis on some Keywords. I would like to see how competitive they are on Google Brasil, but I only see GOOGLE USA and don~t know how to change it.
Moz Pro | | juliantile1