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.
-
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
-
Unsolved Did Moz Bar change to have no Keyword capabilities?
I'm trying to use it during SEO training over here and the KW button goes to a "Get Page Optimization Score with MozBar Premium - Try Free", with a link that takes you to: https://hsinfo.moz.com/mozpro/mozbar/lander?utm_medium=cpc&utm_source=google&utm_campaign=Brand | NA&utm_adgroup=Brand - MozBar&utm_term=mozbar&gclid=CjwKCAjwxOCRBhA8EiwA0X8hi4Tx1YaOVwzWZaCGmzmYdBO4JEON8YlRMw52stp2AyfEBbH4uWDnARoCum0QAvD_BwE? Didn't this used to accept keywords and allow keyword checking? My training materials have the KW button behaving like this: [1] Do Keyword Research in MozBar.
Moz Bar | | EricaJorgensen
1. Click the icon with KW and a magnifying glass.
2. Enter a term related to your subject. For example, "cyber security".
There is a section telling you the keyword score, the relevancy to your page, and giving you optimizations that you can make to the page regarding this term.... Thus, I feel sure KW had useful and free features and not a button for a trial and paid Moz Bar Premium account. What is the pricing for this feature now? Or am I missing something? Thanks,
Tracy!0 -
Explain me how you use keyword explorer for SEO
Hello, Can you explain me how you use keyword explorer for SEO because I watched many video and after watching them everything is a little confusing... From my understanding, you have you main keyword let's say "Normandy bike tours". Based on that keyword you decide to cover TOPICS. Let's say I decide to cover D-Day landings, Omaha beach and and Caen on my page about" Normandy bike tours" ( I could cover more or others I imagine but now let's say those TOPICS are the ones I have decided to cover. From that point on what I understand is that I need to cover each of those TOPICS and the way to cover each of them is to type each of those words separately in the keyword explorer and look for words that the keyword explorer gives mes that it considers to be "semantically related" to each of those TOPICS. Then, if I choose the corrects one google will understand the different TOPIC and that should boost my ranking. Is it the whole idea ? PS : How many do you look at to find semantically related words ? 10, 20 or more ? Thank you,
Moz Bar | | seoanalytics1 -
Can I retrieve city based keywords from Moz Keyword Explorer?
I was trying to take keywords based on cities, but could not find an option to set the city based target. Please help!
Moz Bar | | S-A-Marketing1 -
Many more 404 being reported in GWT than MA
Hi I have been submitting MA crawl reports to clients developers post going live with a new site migration and instructing them to set up 301's for any 404's still reporting which they have now done (despite instructing them not to go live until all old url's mapped & 301'd to new replacement page, or HP if no replacement). 1) When i look in GWT crawl errors there has been a spike since going live with 660 'page not founds' being reported compared to x11 404's in MA. Could there be a 'lag' in GWT reporting and actually they have already been dealt with just not updated by GWT in this report and the MA report is more accurate ? Should i wait and see/or mark as fixed and see if return tomorrow, or tell dev to immediately investigate ? I have checked some samples links and they are going to 404 type pages so presume they are still broken and urgent issue dev must fix immediately ? 2) How long does it take aprox for the page authority to be transferred via a 301 redirect to a new page since i see some category pages that had good PA and have been 301'd to new category urls, are now showing a PA of just 1 !! Cheers Dan
Moz Bar | | Dan-Lawrence0 -
Reporting for a US subfolder: New campaign or just add US kw & engines to existing
Hi My UK based client is about to target the USA via a domain.com/US/ subfolder For reporting purposes do you (either Moz staff or Mozzers with experience or pref both) recommend setting up a new campaign or simply adding US engines and KW to existing campaign ? In regard to all other reporting options as well so not just keyword rankings All Best Dan
Moz Bar | | Dan-Lawrence0 -
Moz reporting appropriate Canonical tag usage but no canonical tag on page !?
I take it this means that the page in question has been referenced via a different pages canonical tag but that the page in question itself does not have a self referencing canonical tag (and that it should do) cheers dan
Moz Bar | | Dan-Lawrence0 -
Keyword Difficulty Report - Google Engine selected, however system is return Bing results
Is there happening for anybody else?? We run a Keyword difficulty report and select Google Australia, however in the results it is showing the values for Bing search volume ... instead of Google 1083.jpg
Moz Bar | | L10Group1 -
Ranking report in Pro Campaign Not Accurate?
I have been running ranking reports on my pro seomoz account for a couple of years now. I recently added a lot more keywords to my list. Unfortunately there now seems to be a problem. It shows that many of my keywords have dropped out of (and climbed in) the top 50 when they actually haven't. I think it's just missing the keyword out and assuming that it dropped. I'd prefer it said "Not checked". Anyone else with a similar problem? or ideally a solution at my end... Thanks all!
Moz Bar | | trickshotric0