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
-
Is there any way to automatically filter negative keywords out of Keyword Explorer results?
I use Keyword Explorer a LOT for fleshing out new campaigns. However, the results I get frequently contain queries with words that are in my negative keyword lists. Today, I solve this with export and some Excel wizardry but keep thinking how convenient it would be if there was a way to provide a list upfront of negative keywords and get pre-scrubbed results. Does this exist? If not, how can I escalate this as a feature request? 🙂
Moz Bar | | ngowdy1 -
Keyword Explorer Stuck
Is anyone else experiencing troubles with Keyword Explorer? We have several keyword lists and they keep getting frozen on "Gathering Metrics" for days, even if we had results for those particular keywords previously. Just curious to know if this is a pervasive problem and if there's some kind of an easy fix.
Moz Bar | | hesaulsbury0 -
I got a 404 in the Crawl Test Tool Report
I, yesterday i ran an crawl on http://www.everlastinggarden.nl and i get an 404. Does anybody know why this happens? <colgroup><col width="1535"></colgroup>
Moz Bar | | IMforYou
| # ---------------------------------------- |
| Crawl Test Tool Report | Moz,http://pro.seomoz.org/tools/crawl-test |
| www.everlastinggarden.nl |
| Report created: 15 Jul 18:34 |
| # ---------------------------------------- |
| URL,Time Crawled,Title Tag,Meta Description,HTTP Status Code,Referrer,Link Count,Content-Type Header,4XX (Client Error),5XX (Server Error),Title Missing or Empty,Duplicate Page Content,URLs with Duplicate Page Content (up to 5),Duplicate Page Title,URLs with Duplicate Title Tags (up to 5),Long URL,Overly-Dynamic URL,301 (Permanent Redirect),302 (Temporary Redirect),301/302 Target,Meta Refresh,Meta Refresh Target,Title Element Too Short,Title Element Too Long,Too Many On-Page Links,Missing Meta Description Tag,Search Engine blocked by robots.txt,Meta-robots Nofollow,Blocked by X-robots,X-Robots-Tag Header,Blocked by meta-robots,Meta Robots Tag,Rel Canonical,Rel-Canonical Target,Blocking All User Agents,Blocking Google,Blocking Yahoo,Blocking Bing,Internal Links,Linking Root Domains,External Links,Page Authority |
| http://www.everlastinggarden.nl,2014,404 : Received 404 (Not Found) error response for page.,Error attempting to request page | Best regards, Jos0 -
Bulk Upload to Rank Tracker?
I know the rank tracker limits you to 200 keyword phrase checks per day. Is there a way to bulk upload 200 so you don't have to put them in one at a time?
Moz Bar | | JenKeller0 -
Why Moz Rank tracker's results are different from results search in browser?
I would like to perform a competitor rank analysis in Google.gr . I have noticed that the results from the rank tracker for Google.gr are different than the results in Google.gr from a machine located in Greece with no Google account logged in. Could you inform me why such a behavior occurs?
Moz Bar | | thmavri0 -
How to make sense of data for this keyword (Moz Keyword vs. Google KW Planner)
The keyword "auto immune disorder" has an avg monthly (local/US) search of 880 in Google KW Planner with "low" competition In Moz, the same keyword has an avg monthly (local/US) search of 5 with a KW difficulty of 71%. I realize that the competition in Google KWP is based on ads, but is there a discrepancy when the search volume is so different in Google vs. Moz/Bing? Based on the above data, it seems like it would make sense to do a Google Adword (high search volume, low competition) instead of trying to rank organically...am I on the right track here? Thanks!
Moz Bar | | lulu710 -
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 -
How to print segmented keyword lists to PDF?
Hi Moz forum, We're trying to print segmented keyword lists to PDF. Using the 'segmented lists' feature, we have created segmented lists for several different keyword groupings. We are looking to print each list individually as a PDF, but the feature seems to print ALL keywords from the entire campaign. How can we print segmented keyword lists to PDF? Thanks
Moz Bar | | BoomDialogue690