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
-
Which keyword to use (plural / singular)
Hi guys. So I'm racking my brain with a question whether I should use plural or singular keyword as a focus keyphrase of my page. The page that I'm optimizing is basically a review page of different websites offering proofreading services. Considering the fact that this is a review and I mention a lot of websites on my page, I decided to rank for a plural keyword that ends with "services". However, this keyword is very unpopular (ahrefs doesn't show any volume for it), while singular "service" has about 100 searches per month. As far as I understand, Google sees both keywords as synonyms, because search results for both keywords are almost identical. Should I change my keyphrase to singular "service" (even though the page mentions a lot of services), or stick with "services" instead? Do I have a chance of ranking for "service" if I stick with "services" in this case? Thank you.
Keyword Research | | AslanBarselinov0 -
Google Keyword Tool alternatives?
Does anyone have any suggestions for Google Keyword Tool alternatives, since is has been closed by Google? Thanks
Keyword Research | | BoomDialogue690 -
SEOMoz deleting keywords in bulk
Hi All Was hoping to delete a large number of keywords we are tracking in SEOMoz. Is it possible to delete keywords we are tracking in bulk? Similar to adding keywords cheers IB
Keyword Research | | sodafizz0 -
What is the time frame for the search volume on a Keyword?
Let's say I search for AP automation and the search volume comes back as 210, where did that number come from? Is this how many searches by day, by week, year to date, etc.?
Keyword Research | | SheriGolla0 -
Google Keyword Tool Category Selector
Has anyone developed any useful techniques for using the category selector in the GKT? Perhaps in conjunction with a site URL. Always looking for something better
Keyword Research | | waynekolenchuk0 -
Comprehensive Keyword Research Report?
I'd like to provide a keyword research report to a client, that includes all of the keywords we're targeting, organized nicely along with relevant data for each (keyword difficulty, search volume, etc.). Is there a way to do this other than running an individual report for each keyword? I'd like to avoid sending them a 50 page document showing all of the keyword research 😉 Thanks for any help! Josh
Keyword Research | | JoshTurner0 -
Please help with SEO keyword research
Hi Moz community, I would like to request your collective wisdom. I'm new to SEO and putting together an SEO research and strategy document for the employment service I work for. Have solid skills in Google Adwords and have ran a campaign over the last two years with excellent results. But this SEO thing is a whole new world! That's why who better to turn to than the leading community for SEO professionals? 🙂 Any support, advice, tips would be most welcomed appreciated. It's an employment service and I've got a list of keywords. For example, here are some of the action words I thought could be useful: <colgroup><col width="215"> <col width="91"> <col width="65"></colgroup> [find staff] 0.79 73 [find employees] 0.97 73 [looking for staff] 0.94 58 [looking for staff] 0.94 58 [staff wanted] 0.62 58 [looking for employees] 0.94 46 [look for work] 0.77 36 [looking for workers] 0.93 36 [find workers] 0.91 36 [employee search] 0.72 28 [staff search] 0.37 28 [find an employee] 0.79 22 [search for employees] 0.71 12 [find a worker] 0.66 12 [how to find employees] 0.71 12 My questions: Where to from here? If this was a Google Adwords campaign I would place the words in, create ad copy and test response. But with SEO, are these words useful? Can you target all of these words with SEO - or am I better finding words with higher volume? How many words should I be looking to target? For example, am I only trying to find the 5 or 10 highest volume words, or is it important to target lots of words with SEO? Is it just one set of keywords per page, or can I target all the above keywords on one page? I'm a bit lost. Thanks in advance for your consideration.
Keyword Research | | jasonlewisdiiigy0 -
SerpIQ vs. Keyword Difficulty tool
http://imgur.com/6uidr Is this any good for keyword research? I see they use some weird metric and I'm not sure whether those are relevant at all, plus it's really hard to do a bulk research. Let me know what you think.
Keyword Research | | jest0