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
-
Bulk Reports
IIs there a way to pull bulk data out of my Moz account to get the two reports below? Competitors (all URLs for 15 to 20 domains)
Moz Bar | | DevWired
URL
Keyword - Keywords ranking for URL
Linking Domains - Domains linking to URL
Search Volume Similar Keywords (Run the keyword list above)
Original Keyword
Similar Keywords - The keyword suggestions available in the keyword explorer
Search Volume
Mentions - Also in keyword explorer report0 -
Keyword Explorer: Search by Domain Not Working?
We have tried Keyword Explorer for several websites today using the domain, subdomain and exact page option. None of these are returning keyword results. Is the tool currently broken? As a test we tried Amazon.com, see screenshot: JbWsaLi.png
Moz Bar | | SeanTheWebGuy0 -
Crawl report shows that it gets 4xx errors for pages that work fine. Why?
On the crawl report it has all these "Critical Crawler Issues". They all say "4xx Error", yet when i click on the link from the crawler report, it goes to a perfectly functioning page, not a 404 page or anything. If i click in it actually says it's a 403 error. It's all for pages generated by the IDX solution for our real estate website. Is Moz broken or am i missing something? Here are a couple examples: <dl class="crawl-page-details-list"> <dd class="crawl-page-details-list-emphasis">https://teamvivi.com/homes-for-sale-map-search/</dd> <dd class="crawl-page-details-list-emphasis"> <dl class="crawl-page-details-list"> <dd class="crawl-page-details-list-emphasis">https://teamvivi.com/email-alerts/</dd> </dl> </dd> </dl>
Moz Bar | | TeamViviRealEstate0 -
Site Crawl report show strange duplicate pages
Beginning in early in Feb, we got a big bump in duplicate pages. The URLs of the pages are very odd: Example URL:
Moz Bar | | Neo4j
http://[email protected]/dir/page.php
is duplicate with http://website.com/dir/page.php I checked though the site, nginx conf files, and referral pages, and could not find what is prefixing the pages with 'http://firstname.lastname@'. Any ideas? The person whose name is 'Firstname Lastname' is stumped as well. Thanks.0 -
A good ranking Tool to generate reports for multiple markets
Hi, Unfortunately, Moz doesn't offer any feature to generate 1 report with the multiple keywords I have across different campaigns. Since I am running around 10-11 campaigns, it's quite time consuming to create the reports manually. Could you please suggest any good tool/service that can generate a report for multiple keywords across different campaigns ?
Moz Bar | | ebsbarschools0 -
Keyword research in Moz - Am I missing something?…
I'm fairly new at SEO and am still trying out MOZ. I'm finding myself wishing that Moz had a broader set of tools for keyword research, but am wondering if maybe I'm just missing something. Am I correct in saying that there is no place within Moz that you can get keyword ideas, select/organize keywords, find new/related keywords? I've appreciated the keyword difficulty tool and have played around with Moz Analytics keyword tracking, but these don't help with the broader keyword research aspect. The various tutorials talk about using Google AdWords Keyword Planner and other tools to do that job. But with all that Moz can do, it just seems backwards to do lots of copying-pasting from other tools into Moz, or to have to rely on old excel spreadsheets to organize keywords. It seems that life would be much easier if Moz would be able to pull that kind of external research information in, like Raven does. That way you do most of your research within Moz – allowing you to organize/evaluate potential keywords BEFORE choosing the ones you would like to test for difficulty or track. That way you could simply select the desired keywords and add them to your tracked list. The way it is now, even the one research tool that Moz does have (keyword difficulty) does not allow for an easy way to track or manage a chosen set of keywords. For example, after doing some keyword difficulty analysis, I've chose 5 keywords. To add these 5 to the tracked keywords in a specific campaign I can't just select them and say "track keywords > in xxx campaign". From what I've understood, I must copy-and-paste them into the manage keyword section of the desired campaign. To me this all feels a bit awkward. But since I'm new at this, maybe I'm just missing something? Or maybe it's unrealistic to expect a single tool to address all my SEO needs?
Moz Bar | | Mike_E0 -
Moz keywords tool obsolete?
It looks like Google is going to encrypt all user searches, rendering entire sections of SEO tools useless like portions of Moz. What's Moz's reaction to something like this? http://blog.hubspot.com/google-encrypting-all-searches-nj
Moz Bar | | BlueLinkERP0 -
Moz Rank Tracker doesn't work with "PHRASE" Keywords!?
Hello, If at http://ranktracker.moz.com trying to track phrase KW - the system wont accept it. But adding [EXACT] match with [] - works well. Have I missed something? Cheers.
Moz Bar | | SEOisSEO0