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
-
Keyword explorer and relevancy
Hello, In the keyword explorer when I group keywords by lexical similarity should I only choose keywords that have a high relevancy to my seed keyword (the one I typed and want to rank on ? Let me give you an example. Let's say my seed keyword (the one I want to rank on) is "Alsace bike tours. With the keyword explorer I group the keywords and find the group " cycling in Alsace" (ok I take that one because it relevant to "Alsace bike tours" then I find "Strasbourg to Colmar by bike" I also take this one because it is also relevant to "alsace bike tours" but what about concepts like "Alsace wine region", Alsatian architecture, wines of Alsace, cuisine of Alsace or prettiest villages in Alsace... should I totally dismiss those from my content because they aren't relevant to my keyword "Alsace bike tours" or is it ok to use them but it won't help me at all ? Thank you,
Moz Bar | | seoanalytics0 -
Is there a way to view difficulty for related keyword suggestions?
I'd really like to view the difficulty/organic CTR/priority of suggested related keywords without having to click on each individually - is there a way to do this?
Moz Bar | | avfundstack2 -
What does "Optimal Use of Keywords in Header Tags" really mean?
I get this explanation on the grader: Although using targeted keywords in H1 tags on your page does not directly correlate to high rankings, it does appear to provide some slight value. It's also considered a best practice for accessibility and helps potential visitors determine your page's content, so we recommend it. Over-using keywords, however, can be perceived as keyword stuffing (a form of search engine spam) and can negatively impact rankings, so use keywords in H1 tags two or fewer times. To adhere to best practices in Google News and Bing News, headlines should contain the relevant keyword target and be treated with the same importance as title tags. But I have the keyword in an H1 tag, only once. So why am getting this message on the grader? The URL is https://www.armsecuritysystems.com/business-security-systems/ The keyword is "business security systems" Any insight would be greatly appreciated.
Moz Bar | | bizmarquee1 -
Is Keyword Difficulty tool algorithm changed ?
I'm very confused about this. From today, I realized that your algorithm for this tool changed. For example, I have search KC for this keyword before: suitcases for kids has KC is 23. But today I checked it again and it's 43. How can I deal with this new data? Is KC is good for determine that a keyword is easy to rank for ?
Moz Bar | | trungbq060 -
Track ranking history
I'm trying to find out how a keyword phrase ranked over time. I remember how to do it on the old Moz platform, but do not see it in the new platform. I've checked the help files and forums and the information seems outdated because it mentions to click on a link that is not there. Michael
Moz Bar | | Michael_Rock0 -
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 -
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 -
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