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
-
Turn off Pagination in Keyword Explorer results?
In the keyword suggestions of Keyword Explorer, is there a way to switch from paginated results back to results loading on one page? I used to be able to scroll down and have additional results load when I reached the end of the page.
Moz Bar | | watchandlearn0 -
Moz keyword mention on-page counting errors
Hi. Moz is showing 18 mentions of the keyword 'street furniture' on this landing page https://www.broxap.com/street-furniture.html But I can only count 6 in total in the body copy and 13 if you include navigation links. This is the same on other pages too for that keyword. Does anyone know where it's counting these extra keywords from? I don't want to fall foul of keyword stuffing but as far as I can see we're not! Could Moz be miscalculating? Any help appreciated! Thanks Joe
Moz Bar | | iweb_agency0 -
Fresh Web Explorer: if you put a keyword in quotes, is it case sensitive?
For example, would a saved search for "racor fuel filter" capture mentions of "Racor fuel filter"? I'm really hoping I don't have to duplicate the keywords with the alternative capitalisations!! Many thanks Steve
Moz Bar | | swbaxter0 -
Keyword Difficulty tool showing Google search volume or Bing?
Hi, I plugged in a bunch of keywords to know their search volume, chose Google from the drop down and then chose English from the next dropdown and clicked on Check dificulty. It shoes me "Bing Search Volume (Exact Match)" on top but shows the name of the keyword and "for Google CA" on the left. Is the search volume for Google? or Bing? and the difficulty as well? Google or Bing? "
Moz Bar | | SpaMedica0 -
Keyword difficulty problems
I'm just running a keyword difficulty analysis and it seems to be stuck. The analysis report is just marked as pending with the arrows going round and round. I've tried ti in two browsers (firefox/chrome) just in case it was something local. Are there current problems?
Moz Bar | | Gordon_Hall2 -
Rank Checker and Keyword Difficulty
This is the only time I have seen this but the rank checker shows a keyword ranking #2 but the keyword difficulty tool does show the url ranking anywhere on the first page. I have some ideas as to why this may be happening but I am wondering if anyone actually knows?? Keyword: motion capture url: www.organicmotion.com/motion-capture
Moz Bar | | JBeaton0 -
On the on page optimization page, I found out that there are 2 contributing factors which are opposite to each other. "No More Than One H1 Tag" and "Appropriate Keyword Usage in H1 Tag"
"No More Than One H1 Tag" and "Appropriate Keyword Usage in H1 Tag" If you fulfill one condition, the other one is not completed. If you consider Article heading as H1 then Moz do not detect keyword in the heading.
Moz Bar | | MoeezLodhi0