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
-
Relevant but not-relevant keywords impact to SEO
Hello, I would like to know if the selection of individual keywords(that are not primary, secondary or tertiary) are important for SEO regardless of the relevancy to the page topic. I am wondering how much of a contribution a non-P1/P2/P3 can make in terms of SEO? For example it is a product page and I have built my content with P1,P2&P3 based only on the product and its properties itself. Do you think that a content gap for the page could be the production process of that product? So even if it is a product and its properties page, I can add 2 sentences about the production, so that I can drive more traffic by including these 2 informative sentences.? EXAMPLE:
Keyword Research | | Siir
So lets' say my topic is "hair types" (P1) and my subtopics are "Straight," "wavy," and "curly"(P2s) which I used as subtitles. But throughout the page, I am planning to add some relevant but not-directly-relevant keywords here and there since they have high metrics and volumes. For example a potential sentence I can add: "innovative hair products these days can offer amazing results for the desired hair types". It is not specifically about "hair types" but I am using the keyword "innovative hair products" (good metrics keyword) which may help for the traffic... Another potential not-so-direct sentence can be: "For all hair types, the hair damages are common: heat damage, chemical damage and mechanical damage". Would adding this extra sentence where I am not specifically talking about "hair types" (my topic) but "hair damages" and damage examples (off-topic high metric keywords) help me to drive traffic to my website? And how much of an impact would it be?0 -
Keyword ranking by word order
If we have a keyword with 2 words like "SSL Audit". Will it rank in the same position the other way "Audit SSL" ?
Keyword Research | | Cistrust.com0 -
How can I learn what are the most popular keyword phrases?
I have done a lot of research on Google AdSense (e.g. how to get started, best practices, how much money can be made, custom channels). I want to write a blog post based on my research, but my question is -- how can I learn what are the most common questions about Google AdSense or Internet advertising from a keyword search perspective? For example, are more people searching for "How to make money with AdSense" vs "How to make money with Internet advertising" vs "How to make money with a website"? How do I know which phrase is searched most? It seems to me that I should make my page title, URL, H1, etc. exactly match (or as close as possible within proper grammar) the question that is most often searched. Thanks everyone! Ryan
Keyword Research | | GreenHatWeb0 -
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 -
Keywords google takes into account
hello MOzzers, I know some words are not as important whenGoogle indexes or crawls ex the word "the" etc. I am curios what weightage google places on the word " google" when people search. Silly question?? maybe hee hee, but I would like to know. Its been bugging me. Thank you so much, V
Keyword Research | | vijayvasu0 -
Keyword Strategy for an E-Commerce Site
I've seen this touched on in other posts but have read conflicting answers and am hoping to get some clarification. What should my keyword strategy be for an e-commerce site in an industry that has moderate to high competition for it's short-tail keyword phrases? Should I try to optimize my homepage for the highly competitive, short-tail keywords, while going after the long-tail, and less competitive (but less traffic, too) on my product pages? What's a good rule of thumb as far as the number of keyword phrases to target per product? Thank you
Keyword Research | | NiallTom0 -
Invisible Long Tail Keywords
I've been doing some research on SEOmoz and have seen some posts relating to invisible long tail keywords. I have a couple of questions relating to this: Am I correct to understand that an invisible long tail keyword won't show any search in a tool like the Google Keyword Tool? If not, how do you define it? If an invisible long tail keyword has almost no search (or search that can be proven by an SEO researcher), how can you be confident that it will produce results?
Keyword Research | | EricVallee341 -
Keyword Targeting
If I am currently ranking well for "Lawn Mowers" and I also want to target "Cheap Lawn Mowers" will it affect my ranking for "Lawn Mowers" if I change my on page optimization by adding "Cheap" to the title, H1, etc. or will it effectively target both.
Keyword Research | | UK2Group0