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
-
Reworked the keyword strategy - affect on reports
Hello, We're ditching our current keyword strategy and starting over. The reports have been running for about 3 months though. Will our ranking reports factor in those keywords that have been removed? We really only want to see where are campaign is from the new starting point. Or, do I just need to narrow the time frame on my reports. Any advice is appreciated! Thanks!
Moz Bar | | craig_mozbot0 -
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 -
Rank Tracker Tool Accurate?
Hi Everyone, Just wondering if you all have been noticing inaccurate information in the rank tracker tool. Many terms are showing not in top 50, yet when i search from random devices that have never accessed my website before i find the url to be in the top 50. Anyone experiencing similar issues and anyone have any ideas why the inconsistency? Thanks
Moz Bar | | Prime850 -
Keyword Difficulty Tool - Bulk Data of Specifics?
For the keyword difficulty tool, if I want to see the details, I have to click on the keyword in order to see the list of the competitors and their DA and RLRDs. Is there a way to download this list for all of the keywords and their DA and RLRDs? The only bulk I can download is the list of keywords in my difficulty tool list along with their Bing search volume and keyword difficulty %. Thanks!!!1
Moz Bar | | Titan5520 -
How often are keyword rankings updated?
My keyword rankings were last updated on the 8th of October when will they be updated? Thanks, Sam
Moz Bar | | Sam.at.Moz0 -
Keyword Analysis: Limited to 400 Keywords per day?!
I needed to do keyword research, but to my absolute horror I see this: "Currently we are only able to offer results for 400 keywords per user per day." I need to check more than 400 today, how can I use more? I don;t want to have to pay for 10 accounts or something!! PLEASE PLEASE PLEASE remove this limit! I would be willing to pay more than $99 per month!!
Moz Bar | | Zovi0 -
Keyword Difficulty Showing ONLY Bing Search Volume (Exact Match)
Hi I am using the "Keyword Difficulty" tool and selecting "Google US". But the report that gets generated shows "Bing Search Volume (Exact Match). Is there any way to get "Google Search Volume (Exact Match)" being shown in the report? Regards
Moz Bar | | rholt0