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
-
When I try to run a Moz report, it sends me to a 404 page?
Hey there. I'm trying to export a .pdf to send to my client. When I click "export pdf", the page sits for a second then goes to a 404 page? I've never seen this before. Is anyone else getting this problem?
Moz Bar | | TaylorRHawkins2 -
Has Google officially dropped the mobile-friendly label?
I noticed in my keyword ranking reports that the heading "Google en-US Mobile Friendly" indicates false for all tracked keywords... Is this information still helpful in the reports? _Cindy
Moz Bar | | cceebar0 -
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 -
Problem Downloading Crawl Error Report PDF's
I am trying to download the PDF reports for the various 'crawl errors' - now some of them are quite large but would that justify why I am unable to download - the error is a straightforward one, see attached. Any ideas? Andy aDlViIN
Moz Bar | | TomKing0 -
Reports translation
Is there a way to translate the reports or to export them in a editable format?
Moz Bar | | RicardoLG0 -
Clarify "broad keyword usage in page title"
Hello Page grader has two different grades for page title that I want clarification on. There is "Broad Keyword Usage in Page Title" and "Exact Keyword Usage in Page Title". Googling around about and searching here I have found that "broad" seems to mean the keywords should be used throughout the page, rather than just in the title and header. Which makes sense as this is a kind of check to ensure the page IS about the keywords and not something unrelated. But what is meant by "broad" usage in the page title? This refers specifically to the page title and not the whole document. My best guess got me to this, given the keyword "Visit London Today"; "Come and visit London today" - exact match only "London - visit today" - broad match only "Visit London the city of dreams | visit London today" - matches both That could be complete nonsense, but basically is broad usage the use of keywords scattered in the page title? Thanks.
Moz Bar | | yolkcreative0 -
How to get Universal Results to Show in Reports?
This has been a source of frustration for me for a long time. I have asked many times and never found anything in the support documentation on how to add this. Is it something that is simply not offered? If so is it not outrageous to others that this simple feature is not present? What I want: I would like to be able to include Universal Results icons in my rank reports. Why? Well as is the case much of the time my clients Google profile is included in the maps results (thanks to our optimization services) but they are not on the first page. The client can't see the results of this type of SEO. It shows up when logged in but not in the exported reports. How easy would it be to include these? It seems like a no-brainer. If anyone knows where to add them or why they don't automatically include them please let me know. If this feature is not offered I call upon my fellow SEO's to demand this feature. If anyone knows of a way to contact the developers to recommend adding this feature I would also appreciate that information. Thank you Universal Result: Local
Moz Bar | | TotalMarketExposure
You're in it!
Position: before 1st natural result
Contains: 7 results0 -
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