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
-
Location National vs. Country - Different Ranking
Why is the ranking for a keyword different for the locations National and for example Austria ... both should bring the ranking for the whole country, but often they are different?
Moz Bar | | Art-of-Artists0 -
Trying to duplicate Screaming Frog report
I am trying to use the crawl report to generate the Screaming Frog report shown below. I want to use it to calculate the internal page rank as Paul Shapiro outlined in this article. Google is not seeing my site the way I want them to and I want to work on the site heirarchy and structure. I am not seeing where: Type, Anchor, and Alt are listed in the crawl report - is it called something else? Is there another report I can run for the whole site to generate the data above? Does the Moz PA already calculate the internal PR of pages? Any additional resources or people that could help me with this? Thanks, SAM
Moz Bar | | SammyT0 -
KW Explorer is Working to Disambiguate Keywords Google Merges Together
Hey gang, Russ Jones from Moz has been doing a ton of heavy lifting work to try to get around the new problem posed by Google AdWords recent change to merged-keyword volume data. But, we're fighting back against this obfuscation in Keyword Explorer. I'm sharing two emails (slightly edited) from Russ about what we're doing here: Introduction to the Problem: Google Adwords Keyword Planner is the primary source for keyword search volume (how often a keyword is searched monthly on Google) for much of the search marketing industry. While Google has grouped together highly-similar terms for a while (especially misspellings), in June of 2016 they dramatically increased this keyword-grouping. This means similar phrases like "keyword rank", "keyword ranking" and "keyword rankings" would all be reported as having the same, combined search volume, rather than their individual search volumes. If you were to take Google's numbers at face value, you might think there are 3,000 searches per month for these 3 terms, when in reality there is only 1,000, divided amongst the 3 terms. How we are addressing it: Moz's Keyword Explorer uses a blend of data sources, not just Keyword Planner, to build our volume metrics. This gives us a distinct advantage in that we can adjust the volume of words that deviate dramatically in one data set verses another. Take for example the phrases "keyword rank", "keyword ranking", and "keyword rankings". While Google Keyword Planner might report all of these as having 1,000 searches per month, Moz Keyword Explorer can detect that these numbers are significantly higher than what our models would predict given our other data sets. We can then adjust the volume accordingly. Moreover, given our huge keyword data set, we can also identify grouped phrases (like these 3) and divide the volume proportionally to what we see in our other data sets. Thus, we address the grouping problem from multiple directions. Here's email #2 from Russ, detailing more of how we're attacking this: I have been working pretty much non-stop on this keyword volume disambiguation problem (finding the real search volume of individual keywords when Google clumps several together). I think I have settled on a pretty good solution and am working on getting it all in. For example... Google Keyword Volume for the phrases "briefcase for women" and "briefcases for women" are both at 3600 because they have been lumped together. My disambiguation script says the singular (briefcase for women) should be 2731 and the plural should be 869. Google Trends roughly agrees with this, showing that the singular is searched more than 2x the plural: https://www.google.com/trends/explore#q=briefcase%20for%20women%2C%20briefcases%20for%20women&cmpt=q&tz=Etc%2FGMT%2B4 Basically, Keyword Explorer should already be providing some more accurate/segmented numbers than AdWords, and in the future, we'll get even better thanks to our clickstream data and our evolving models. Any questions, let us know!
Moz Bar | | randfish15 -
Combined Countries in Keyword Explorer
Is there a way to view "all countries" in Keyword Explorer? I like being able to segment by country, when I need to, but I don't like having to pull multiple reports to get a combined view. It's more work and it eats up the number of queries I'm allowed to make per month.
Moz Bar | | vcj0 -
How do I pull a rankings report for a specific week in the past?
The date of the rankings I want is January 13th. I can see the individual keyword history in rank tracker, but I have to go each word. I'd like to just have that report to compare it to, since that is when a lot of our rankings changed. So I need that report to compare our future efforts with. Please advise and thank you! Ruben
Moz Bar | | KempRugeLawGroup0 -
Do exact keyword matches exclude "in", "based" etc?
I am trying to build a landing page for the search term "web design london" and I have included this search term as well as some variations such as "web design in london", "web design based in london" as the content doesn't really read well if I don't put in a connector word (I can't remember what the term for the use of "in" etc is). However I am using the Moz On-Page Grader to make sure I'm dotting every i and crossing every t, but it doesn't seem to pick up on the search term when "in" or "based" is used. Now is this a limitation of the On-Page Grader or should I expect Google and other search engines to not pick up on the search term when it contains these sorts of words?
Moz Bar | | mickburkesnr0 -
KW Difficulty Daily Limit |
Hi Guys, We are using Keyword Difficulty Tool in Australia and today morning we noticed new 'keywords checked today' feature has been added. Does that mean we can only check 400 kws per day? Please clarify. Thanks
Moz Bar | | WME0 -
"Avoid Keyword Self-Cannibalization" - can't find the problem
Hi, I understand what this means (or at least I think I do!), but I can't find where the problem lies. The keyword is "fire warden training" and the url is http://www.tutis-fire.co.uk/fire-warden-training-courses/ If anyone could lend a helping hand, I'd appreciate it.
Moz Bar | | Gordon_Hall0