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
-
I get this on every product, but i have put the keyword in the H1 tag makes now sense
Why it's an issue: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
Moz Bar | | Carlsimp0 -
Is Keyword Explorer now providing search volume by country?
I think Keyword Explorer was only providing search volume data for the US (whereas difficulty and opportunity were available at a country level) but recently I've started to see differences between the US volume data and the UK (see examples attached). Does this mean Keyword Explorer is now providing accurate volume data for the UK and other countries? DEIKsVJ 5kels
Moz Bar | | A_Q0 -
Keyword Difficulty Score Meter: how to interpret levels
I'm hoping to find what percentages change the levels for the difficulty score meter in the keyword difficulty tool. For example, when does a blue -- non-competitive -- move into the green level, and so forth. Also, I can't find the description (names?) of all the levels (highly competitive, non-competitive, etc). Thanks for your help.
Moz Bar | | IT-dmd0 -
Signed up for moz reports - have received Moz error report - need someone who is capable to take report and perform cleanup edits within Joomla site?
Looking for someone in the US - please contact me at Mary@workingwebsolutions.com If available and interested in task. Thanks Mary
Moz Bar | | PortlandWebDesign0 -
On-Page Grader is not counting H2 and H3 Keywords
I used on-page grader in one of my webpages and it showed the limit of 15 keywords used. The problem is that it counted only when the keyword appears in the Title, URL, Meta Description, H1, Body and IMG ALT. If you take into account the H2 and H3 tags, the count will go to 22. Is there a problem with the On-Page Grader Tool or it's not a problem to go above 15 keywords if they are in H2 and H3? Here's the link for the page: http://www.tororadar.com.br/acoes/bbse3-bb-seguridade/cotacoes-bovespa Keyword: BBSE3 Thanks in advance.
Moz Bar | | Guilhermealvesc0 -
Keyword Difficulty Search Engine Selection
I'm using the Keyword Difficulty tool. The results generated are Bing search engine results, even though I have selected Google for the search engine. I cannot get this feature to work, and I've tried it in both Chrome and Firefox. What's going on here...??
Moz Bar | | AcroPilot1 -
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 -
Does moz Ranking report canadian rankings?
Hi I would like to know Moz rankings can report canadian ranking or does it just focuses on US market search engines only? If it does also focuses on the canadian market, how do you set it up? Thanks
Moz Bar | | Ideas-Money-Art0