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 explorer
Hello, In Keyword explorer out of all the possibilities : https://moz.com/blog/announcing-keyword-explorer-mozs-new-keyword-research-tool Include a Mix of Sources Only Include Keywords With All of the Keyword Terms Exclude Your Query Terms to Get Broader Ideas Based on Closely Related Topics etc... Which one should I use to do my keyword research because they all me different possibilities of keywords. Rand in his article says closely related topic is best for single words like piedmont for example I imagine but what about 2 word keywords like bike tours what is best to use... Thank you,
Keyword Research | | seoanalytics0 -
Bye Bye Keyword Difficulty Tool :(
So the Keyword Difficulty Tool will be retired from the end of this month. Is anyone else worried about this? - because I just don't trust the numbers coming back from Keyword Explorer. Never have. I've even raised this with Moz staff previously, when there was a huge difference between the score given by the keyword difficulty tool vs keyword explorer. From what I see in Domain and Page authority and in the SERPs then the score from keyword difficulty tool, was always more accurate, and thankfully have been able to use both tools, but from next month I feel somewhat uneasy about solely relying on the score from Keyword Explorer. Thoughts? and feel free to run your own tests on keywords and I'm sure you'll see what I mean.
Keyword Research | | GregDixson0 -
Finding new keyword research tools
Does anyone have any recommendations for tools to help speed up the initial keyword reporting process? I'm looking for tips to streamline the current system of manually researching competition reports. Thanks.
Keyword Research | | Doug_Hay0 -
Keyword search tool or API
Anyone have a suggestion for a simplistic (scaled down) version of a keyword research tool that I can put on our website? We need our clients to be able to perform some basic keyword research on their own without getting lost in the details of something too robust. We would like to control aspects of the tool, capture the data from the site visitor and move those results (from their searches) into a database or other web application.
Keyword Research | | webindustry0 -
Question on keyword rankings
Hi everyone Within our campaign it says that we rank number 35 for a specific keyword in Google in the Unites States but when we google the specific keyword we come up as number two on the first page. Can you help me understand what the current rank is based on as well as how it's results can be different from our Google search? Thank you.
Keyword Research | | DRTBA0 -
Why is Adwords Keyword Tool showing zero search volume for popular keywords?
When I try to ascertain search volume for the the words "pills" "drugs" and "medicine" it is showing "-" for all types of search volume, including phrase, exact, and broad. Why is this?
Keyword Research | | nicole.healthline0 -
How to target very broad, umbrella keywords on the homepage
Hey there SEO Mozzers, I'm new to the SEO Moz community and would genuinely appreicate any advice/input on this topic. I'm part of the online marketing team for a UK-based site called Tendea.co.uk. We operate an introductory platform for enabling the connection between parents and families seeking care services (childcare, pet care, senior care, home & garden care, etc.) and individuals providing care services (babysitters, nannies, pet sitters, housekeepers, etc.). To take a US site for comparison, the services are very similar to those offered by Care.com I'm currently having a bit of difficulty as to what very broad, umbrella keywords we should be targeting for the homepage, primarily in the meta title/description. We've started with keywords such as "care, family services, care services, and family care", but I think these terms are almost too generic and aren't necessarily terms we really want to be ranking for. I suggested to our in-house SEO team that we just target some of our strongest keywords from each of the individual care categories for the homepage (babysitter, pet sitter, housekeeper, caregiver, etc.). They were against this idea, though, as we have separate subfolders that target the individual care categories and their specific keywords (tendea.co.uk/childcare, /pet-care, /elderly-care, etc.) Essentially the argeument is that we don't want to be targeting these terms on the homepage and on a separate subfolder page, as then the two pages would be competing for each other's keywords. Instead we're being encouraged to find some sort of umbrella terms to target for the home page that can encompass all of the care categories. For comparison's sake, I took a look at Care.com's meta data and it targets all their specific keywords for the various care categories "Babysitters, nannies, Child Care & Senior Home care - Care.com". Is this the right kind of strategy to take, or do you guys have any suggestions for much broader, umbrella keywords to target on our homepage? Thanks in advance for your input! -Mike
Keyword Research | | Tendea0 -
Keyword Updates
I have a list of keywords in a campaign that I need to update. I use the keyword report card to review those keyword performance by page. I dont currently see a way to update those keywords, I only see the option to add or delete. I don't want to delete and re-enter because then I will lose that "mapping". Is there a way to simply update a keyword?
Keyword Research | | webdecorators0