Create a report with keyword, label, difficulty, global search volume, and ranking?
-
Is it possible to create a report with containing keyword, label, difficulty, global search volume, and ranking? Currently in order to get the data, it seems like I need to manage two lists, the keyword list we are tracking and the keyword list in the Difficulty tool then somehow manually combine the data. Is there an easier way?
-
Glad to see you got most of the reporting needed.
You may also want to submit a feature request over here and see if the community and Moz team can plan to implement your feature.
-
Thank you. I did get vlookup working with the two data sets and I do have some N/A values. It's going to take some work to get all my tracked keywords into the difficulty list. I wish there was a way to auto check the difficulty and bing volume for my tracked keywords and generate a report. Your info helped a lot though. Thanks
-
The keywords would need to match exactly to make sure the Vlookup works properly. If you're tracking keywords that are not in the difficulty list / vice versa then the Vlookup would pull a N/A value, which would let you know the keyword is not on the list.
-
Thanks for the reply. I'm using the Bing Global Search Volume in Moz. I found that the Google Keyword Planner tool is not accurate as the data is based on the particular adwords account. I'll look into the excel vlookup feature. What about the best way to make sure the keywords in the Moz Keyword difficulty list are the same ones being tracked in the tracked keyword report?
-
Hi promfgsystems,
A report like that is not available within the Moz tools with all the information in one place. However, is you're familiar with Excel then combining a few reports together to create that dashboard is not very difficult with the help of Vlookups.
-
Download the Tracked Keywords report - This will give you...
-
Keywords
-
Labels
-
Ranks
-
Download the Keyword Difficulty and SERP Analysis report - This will give you...
-
Keyword difficulty
-
Bring all your keywords to the Google Keyword Planner Tool - This will give you...
-
Global search volume (Moz cannot shot Google search volume)
Then you would put all of these reports into a single Excel workbook and use a Vlookup to put the information into 1, simple report.
-
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
-
Strange insight "tracked keywords" from Moz
Hi there, I was wondering if somebody is seeying the same problem. Since a couple of days i got a new keyword insights in my mail and i've seen some strange things for two accounts. The branded keywords are dropped lower then position 51. The thing is that i got an insight, i checked it in my private mode and the branded keywords are still there. Other keywords are still ranking, and there is no effect on my traffic. There is no connection between the sites. One has a couple of links and the other a lot. One has a very good page with nice optimalisation and the other has no text. So it couldn't be over-optimalisation and incoming links...
Moz Bar | | NielsVos
Does anybody have the same problem? Greetings,
Niels0 -
Turn off Pagination in Keyword Explorer results?
In the keyword suggestions of Keyword Explorer, is there a way to switch from paginated results back to results loading on one page? I used to be able to scroll down and have additional results load when I reached the end of the page.
Moz Bar | | watchandlearn0 -
What is a Good Keyword Volume Score?
Hi All! Continuing my series of discussions about the various keyword scores we use here at Moz (previously: Keyword Difficulty & Keyword Opportunity)... Let's move on to Volume. Volume in Moz's tools is expressed in a range, e.g. Bartending Certification has volume of 201-500. These ranges correspond to data we have suggesting that in an average month, that keyword is searched for a minimum of X to a maximum of Y (where X-Y is the volume range). We use clickstream data as well as data from Google AdWords and then some PPC AdWords campaigns we run and have access to when we build the models for our volume data. As such, we've got very high confidence in these numbers -- 95%+ of the time, a given keyword's monthly search volume on Google will fall inside that range. If you want to see all the nitty gritty details, check out Russ Jones post on Moz's Keyword Volume and how we calculate it. As far as a "good" volume score -- higher is usually better, as it means more demand, but lots of keywords with low volume scores can also add up to strong traffic when combined, and they may be more relevant. Capturing exactly the audience you want that also wants you is what SEO is all about. p.s. When Keyword Explorer or Moz Pro gives you a "no data" or "unknown" volume number, it may just mean we haven't collected information from our clickstream providers or AdWords crawls, not that the keyword has no volume (though it sometimes means that, too, we just don't know yet). One way to verify - see if Google Suggest autofills it in when you type in the search box. If it does, that's usually a sign there's at least some volume (even if it's only a few searches a month).
Moz Bar | | randfish11 -
Rank Tracker won't update rank
Hi all, Is anybody else having trouble with Rank Tracker this morning? It doesn't want to play with me today. It just hangs when the update rank button is clicked. They all go orange/amber and think about it for a while but never update. Any ideas?
Moz Bar | | SanjidaKazi0 -
Comparing details of current on-page grade reports with previous reports
Hi Whilst i've set up reporting for on-page grader when it comes through on report it just shows any changes in grade and rank, what i also want to look at is changes in the detail/components of current report compared to previous reports, is this possible historically (over the previous reporting periods) ? There doesn't seem to be any kind of archive that i can find to previously carried out on-page grade report ? Cheers Dan
Moz Bar | | Dan-Lawrence0 -
Rank Checker Replacement Suggestions?
We have used SEObook’s Rank Checker Firefox Plug-in when running one off rank reports. Do you have any suggestions for a replacement (either free or paid) that would not run on our own IP? Some hosted type solution. Again this is for one off rank reports for sets of key phrases. NOT ongoing week to week or day to day rank tracking.
Moz Bar | | bozzie3110 -
Path of Moz Crawler Report?
Hi, I'm finding path of moz crawler report. Please tell me where I can find this tool?. Thanks
Moz Bar | | KLLC0 -
Is there any tool that checks the rankings at any time I want?
My problem is that in Moz when I check ranking it shows me only on a weekly basis. Acording to MOZ I was on rank 11 yesterday. This is not what my SEO guy has sent me in his report. And usually he is right. Would be nice to have a ranking report for each day. What is the sense of a ranking tool if I don't know what happened between 2 ranking dates? How can I check that? Is there any rank history tool? Or a tool that will check in real time. The way I do it sometimes is to go on google.com/ncr to see the us version of google because I am in Europe. Rank tracker does not work for me at the moment. Get ranking button is inactive. My old keyword list has not been imported from SEOMOZ
Moz Bar | | Valentinopolus0