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
-
Learn how to use Rank Tracker to analyze rank progress for any given keyword. Get your Daily SEO Fix!
Moz's Rank Tracker tool retrieves search engine rankings for pages and keywords, and stores them for easy comparison later. With it, you can analyze and track rank progress for a keyword or set of keywords that you may not want to include within a Moz Analytics campaign. In today’s Daily SEO Fix, James dives into the tool to show you how to use Rank Tracker to start keeping tabs on the ranking history of a given keyword. This video is part of The Moz Daily SEO Fix tutorial series--Moz tool tips and tricks in under 2 minutes. To watch all of our videos so far, and to subscribe to future ones, make sure to visit the Daily SEO Fix channel on YouTube.
Moz Bar | | kellyjcoop1 -
On Page Grader - We have keyword in Meta Description But does not show up
The on-page grader is not counting/picking up the keyword in the meta description. We have double checked the meta description and re-uploaded the page, and checked the source code on-line. The keyword is there in meta description, but not showing up in on-page-grader. https://www.trustdeedrealestateinvesting.com/trimarkfunding/buy-first-trust-deeds.html keyword buy first trust deeds
Moz Bar | | Manifestation0 -
Rank tracker not showing proper rankings.
Just joined MozPro and pretty amazed at all of the info and tools it contains. However I was playing around with the rank tracker and just to test it I put in a keyword and a URL I can clearly see that is ranking #2 for the keyword. Went I ran it through it said that domain wasn't ranked in the top 50. Tried it again and made sure to put in "http://www." and then it said it was #50. I can clearly see it is #2 for the keyword. Wondering if I am doing something wrong?
Moz Bar | | digimarketmn0 -
No Keyword in URL, but it is there
Hi,friends. I have grade A on all pages but system shows like no keyword in url, but it is there. for example i have Latvian keyword: bīstamo kravu pārvadājumi (with Latvian characters like Ū, Ā) I have url with exact keyword in it: http://vervo.lv/lv/kravu-parvadajumi/transports/bistamo-kravu-parvadajumi So why moz dont see that keyword, it does not understand special characters?
Moz Bar | | Liva0 -
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 -
Rankings Tool Shows 'Wed' for Most Keywords
Hi Folks, I have 300 keywords in the moz rankings tool but I would say over 90% of them simply show a 'WED' icon instead of the icon. It has been like this for nearly 3 weeks now. Any ideas why this is? Cheers Gaz
Moz Bar | | PurpleGriffon0 -
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