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
-
Why do i get a difficulty and CTR score in keyword explorer when there is no min or max monthly volume on a search term?
why do i get a difficulty and CTR score in keyword explorer when there is no min or max monthly volume on a search term?
Moz Bar | | eezysee0 -
How can I print out the keyword ranking chart?
I have been working diligently on these keywords. Not a lot of them but trying to get very specific. I have one that has traditionally been very high for our site and in one day it dropped from 2 to past 50+ when I reviewed the history I was unable to find any place to print or download the graph for the history or any place to print a report for our keyword rankings.
Moz Bar | | signcreator0 -
Issues generating pdf reports
When generating a pdf from a Custom report we get 'oops there must have been an error...try again" - well we have been trying again and again. Can you provide a tad more diagnostics other than 'oops'?
Moz Bar | | 7thPowerInc0 -
Scheduled Custom Reports Not Running
I have about 10 campaigns and 5 custom reports scheduled to run monthly for each campaign. Most of them have been running for years without issue, however, this month the majority have not run. There is an option to download past reports, yet the August 1st date is not highlighted. Anyone else having this issue or have a solution? There is one exception to this, a new campaign that had custom reports made with this design. They have a "action" button rather than "download past reports. Within this drop down is a option to download past PDFs. Is there a way this can just be downloaded without opening, like the previous reports?
Moz Bar | | Your_Workshop0 -
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 -
Moz ranking report shows massive loss in Bing SERP's. But it is not the case?
My weekly ranking report shows massive loss of SERP's on Bing. For most keywords I was no longer in the top 50 which where first top 5. But when I checked it out for myself, I'm still ranked top 5 for these keywords. I then used the Moz Rank Tracker and there it also says I'm still ranking top 5 for these keywords. What should I believe now?
Moz Bar | | wellnesswooz0 -
Optimise your Pages in Moz Crawl - where do the keywords come from?
I am just going through my first Crawl stats from the MOZ analytics Under the pages to optimise section I have pages that I have optimised for my best keyword with an A grade that are showing as an F grade and suggesting a different keyword? Where is this keyword coming from? I am assuming that my page has been analysed and a better keyword has been recommended? Can anyone advise? Thanks Roger
Moz Bar | | rnperki0 -
Rank Tracker Inconsistencies
My rank tracker reports are odd. The 'Changes From Last Week' don't align with the numbers in the other reports I have been getting. For instance, it will say +3 for a particular search term and show the Latest Ranking to be the same as it has been for a couple of weeks. There has been no +3 to the ranking according to the reports. Has anyone else experienced this? Thanks!
Moz Bar | | gfiedel1