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
-
How do you choose a country when uploading a keyword list into Keyword Explorer?
Hi There, I'v been exploring keywords in the Keyword Explorer search bar and changing the Google country via the dropdown (very useful). But now that I'm uploading lists via CSV, I can't figure out how to change the country - see screenshot attached. I think I've just wasted a bunch of monthly queries because the lists created via .csv are all for the wrong country! Any help would be much appreciated. Cheers Ben upload-keywords.jpg?dl=0
Moz Bar | | cmscss0 -
Keyword explorer not working
Hi there, The keyword explorer tool has been malfunctioning for the last week. Moz barely seem to have any data (Search Volume) for any keywords I search for, particularly for suggested keywords. It's rather frustrating as I can't explore any keyword opportunities using the Moz keyword tool... I'm based in the UK BTW. Thanks I've attached a screenshot as an example. ZX3Kw3H.jpg
Moz Bar | | SEONOW1231 -
Conversion tracking within Moz reports?
Hey guys, Quick question and apologies if this has been asked before, but is there an option within MOZ reporting (Pro) that allows you to focus on conversions for your clients? I'm finding rankings to be a very poor indicator of success. I'd much rather focus on conversions, and present this information to the client within my reports. Thanks
Moz Bar | | John_Romaine2 -
Is there a way to see keyword density by percentage?
My management wants us to track the percentage of keyword density. While I don't feel this is as important as it once was, they want it nevertheless. I don't see a way to get that information. I thought it would be in the On-Page Grade, but if it is there I'm missing any. Is this possible in Moz Pro? Thanks,
Moz Bar | | TestoUSA
Andrea0 -
Does anyone have a good article or video on how to read the SEO MOZ crawl report column by column?
I am trying to find a good how-to on how to read and analyze each column of the SEO MOZ crawl report, specifically, the excel sheet it allows you to export. What I'm really trying to get to the bottom of is what the "Yes" indiciates under rel-cononical. If it says "yes," does this mean that the link in question has been canonoicalized?
Moz Bar | | armcwill0 -
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 -
WHAT HAPPENED TO RANK TRACKER!!!
iT IS GONE I GOOGLE IT, IN A FRESH CACHE, IT SHOWS UP AS moz.com/tools/rank-tracker i GO TO IT, IT SHOWS the proper page, and then when i login it goes to http://moz.com/researchtools/rank-tracker OR http://moz.com/tools/rank-tracker even if i copy the address and try typing in directly, it redirects over there. this must have happened very recently, i was just conducting research there and had over 100 kw left to use for the day. it is now a 404 no matter what browser i use PLEASE HELP MOZ!
Moz Bar | | Raydon0