Documenting keyword research results
-
I really struggle to document my keyword research results in a usable way. I know the strategy for finding keywords but I wonder if there's a spreadsheet template or some guidance on the process that could help me organise things better
-
Thank you, that was helpful, I'll certainly make use of that.
-
It really depends what the use-case of your keyword research is. Maybe it's to inform what types of websites you will gain links or editorial placements on / from. Maybe it's to inform which content, that doesn't exist now (on your or your client's site) should be created. Maybe it's to inform the tweaking of content or Meta data on existing pages
What you really need is a spreadsheet that lists and groups all the keywords (along with search volumes, your search rankings and the search rankings of some key competitors). You need to work out where you have strong visibility already, where you are weak or average (in terms of rankings or KG panel placements). Once that's done, you can begin having ideas (e.g: "we're ranking at 67 for this keyword, but our competitor is #3 and also holds the knowledge graph panel. I notice that we have placed the keyword on a page which is really about something else, whilst our competitor has a dedicated URL and some great content for this keyword. We should do something similar, but even better - here is my plan...")
You can add your ideas per keyword (or per keyword group, if you assign each keyword a thematic group in your spreadsheet) into a new column. Once your sheet is finished, you can create an actions summary. Some stuff you can do, some stuff that may require design / dev support (like building a micro-site for careers at your company, or something). If you work on behalf of clients, some actions may be for the client (e.g: "send us more business-insider info and stats on X topic, so we can create a page or sub-site about it")
Once you have your actions list, deliver it to your audience (internal or external) via a simple email or a PowerPoint presentation - if some of your ideas are larger and need supporting diagrams
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
-
Keyword inside keyword
Hi, I'm a newb and I'm trying to wrap my head around how this keyword thing works. Let's say I find these KWs as part of my research: Acupuncture Acupuncture Clinics Acupuncture Clinics in Gainesville Acupuncture Clinics in Gainesville Florida Does optimizing for Acupuncture Clinics in Gainesville Florida optimize me for all the other terms as well? And furthermore, might I appear for searches like these too: Acupuncture Florida Acupuncture Gainesviile Acupuncture clinics Fl Thanks a bunch!
Keyword Research | | Graphbyte0 -
How do you check keyword rankings for your sites?
The other day I used Rank Tracker form SEO PowerSuite and SEO small tools ranking checker http://smallseotools.com/keyword-position/ to check a keyword ranking. Both said that my clients keyword is not in top 50, but when I used Rank Tracker from Moz.com it showed that my client's keyword ranks #30 ! What's the tool that works for you all the time and is 100% reliable?
Keyword Research | | vitaliykolos1 -
New Keyword Planning Tool
In the past we have used google analytics keyword tool to evaluate a keyword for our campaign. Recently though with the changes to the keyword tool becoming the keyword planning tool we've seen an extreme fluctuation in the metrics provided for avg monthly searches. Specifically the keyword "best fries" used to be reported at 33100 avg global monthly searches, now with the new tool its at less than 200 overall for the month. Additional information has the google trends for the keyword to only be increasing and is roughly near peak search interest. So I guess to simplify the question, should I trust this metric? Is there an alternative source I can use for keyword research? Why would a drop like this happen? Why isn't the google trends data similar to that of the keyword data? Surely 100 representing peak interest doesn't translate to 200 searches a month.
Keyword Research | | JamesBSEO0 -
Tool for Local Keyword Research by US State
I want to find out keyword research about a specific US State but Google's tool only gives me data by Country. Is there something else I can use?
Keyword Research | | theLotter1 -
How do I find traffic for local keywords?
We're having trouble finding reliable traffic numbers for long-tail local keywords (ex. - "computer repair green bay"). We tried using Google Insights but it doesn't display long-tail keyword information, only broad keyword keywords searched for in a certain locale. We also tried using Wordtracker, but that hasn't been too reliable either. Is there a single tool that provides real traffic for local long-tail keywords?
Keyword Research | | optimalwebinc0 -
Assesing which keywords to target
Hi Looking for some advice: Situation: Starting and SEO campaign for the French market. We have extensive keyword data from our adwords account as this has been running for a few months. Questions: What should we be looking out for in relations to keywords to target in the seo campaign? How many keywords is it sensible to target or chase? (one person dedicated to the French seo campaign) Thanks for your help, Andrew
Keyword Research | | fleurya0 -
Two spaces between keywords?
For seo purposes Looking to register a new double (keyword based) domain were popular domains are not available. Keyword difficulty rated for exact keyword is 49% For example, www.(name1)(name2).com (is not available) www.(name1)-(name2).com (is not available) (single space between keywords) What is the next best alternative? www.(name1)--(name2).com (Double space between keywords) www.(name2)(name1).com (reverse keywords with no spaces) www.(name1)s(name2)s.com (adding the letter s to the end of both keywords) or is there a better alternative)
Keyword Research | | peterds0 -
Keyword domain names
My two best key words are "gps tracking" and "vehicle tracking". For the Irish market I have got the two domain names: www.vehicletracking.ie www.gpstracking.ie Have a very poor landing page on www.vehicletracking.ie and just redirecting www.gpstracking.ie to our site. I am wondering what I should do thie these two assets? Should I be running them as micro sites? re directing them? Or something else? Let me know what you think. Andrew
Keyword Research | | fleurya0