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
-
Monthly Keyword Volume Differences Keyword Research V's Campaign Rankings
Why are there differences in the keyword volume data, is this a UK only issue? Am I missing something? Within Keyword Research;
Moz Bar | | GrouchyKids
suspended ceiling systems swindon (0-10) Within Campaign Rankings:
suspended ceiling systems swindon (no data) It's not just one instance either its across multiple keywords.0 -
Does Organic CTR from Keyword Explorer show percentage of 1st position clicks? If not, how to calculate?
I have two questions about the Organic CTR number from the Moz Keyword Explorer tool. I have read through the description here, but it is not very clear on what I need to know: https://moz.com/community/q/what-is-a-good-keyword-opportunity-score Does it calculate the percent of searchers that are likely to click on ANY of links from page one of the traditional organic search results? Or does it calculate the percent of searchers that are likely to click on the NUMBER 1 position of the traditional organic search results? I suspect the answer will be that it calculates the percentage of clicks for any of the traditional organic search results from page one. Which leads me to question two... I'm trying to calculate the estimated search traffic from each keyword if there was a number 1 ranking. And if the Organic CTR shows the percentage of clicks going to any of the traditional organic search results I need to add a modifier to my formula which will calculate how many clicks the number 1 ranking receives. So I think the formula would will look something like this: Monthly website traffic from keyword = monthly search traffic * Organic CTR * Number 1 Position CTR. In this case, what would I use for the "Number 1 Position CTR" modifier?
Moz Bar | | elementpaints0 -
Lack of UK Keyword Volume Data In Moz
Is it just me or is there a considerable lack of keyword Volume data for UK Google search terms on Moz? I have 53 keywords and not a single one has any keyword volume data - these are not obscure terms and include the following as examples... leather satchel, leather laptop bag, satchels, leather bag, leather backpack, leather school satchel. Without this information aren't a lot of the services offered by Moz rather academic as it is impossible to know which terms are really worth targeting. What is the solution? I could use US data and hope it is similar but this seems close to a deal breaker for UK subscribers.
Moz Bar | | MrFrisbee0 -
Should I be concerned our FWE Mentions report shows tons of non-relevant results?
Our brand name also happens to be a common German word and when I ran FWE for the first time this week, I was surprised to see hundreds of returns for the German word rather than our brand name. Does this affect our SEO in anyway and if so, what can we do to mitigate this? Appreciate any insights! Thanks in advance.
Moz Bar | | karrabarron0 -
Why do my search results differ from MOZ's rank tracker
This is starting to happen a lot, i mean they weren't always an exact match but they differed by a few places. But now the gap between results I'm getting and MOZ's own rank tracker is quite large. For my keyword my page ranks on MOZ at 39 (it was 25 but has slipped down). Im seeing my page on page 1 locally and page 2 in incognito mode. Now I understand there are other factors such as browser history, cookies, am i logged into gmail etc. Thats why I asked colleagues to use Internet explorer and they have nothing to do with SEO so their history wont affect the search. They report seeing it on page 2, even colleagues in a different office in a different city sees it on page 2. I want to contact the department in question and share the good news that they've gone from none existent to 14th in what is a very competitive area. But MOZ's result has be second guessing whether I should. Any ideas why the gap between results is so large? Thanks
Moz Bar | | Brabian0 -
MOZ crawl test is not reporting on all the pages on my site.
I've run the crawl test one of the sites I've taken over SEO for, however its only picking all the pages. For instance it indexes all the pages under xxxxx/us but none under xxxxx/au or xxxxx/uk The pages are being indexed as they're ranking in Google. Thanks.
Moz Bar | | ahyde0 -
Moz is reporting a broken link error but GWT is not
My latest Moz report is showing a 404 for: http://www.fateyes.com/how-will-googles-hummingbird-affect-your-search-ranking/”ht
Moz Bar | | gfiedel
(and showing the link this way with the characters after the last / which are not part of the page URL) Google Webmaster Tools says we have no errors. I'm wondering why there is this descrepancy and I'm wondering how I can track down where this link is originating from on our site. I've tried downloading screamingfrog and deeptrawl to no avail (java issues). I've also tried a couple of services online and installed Broken Link Checker plugin with no luck finding it. Any suggestions? Thanks in advance!0