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
-
Long tail keyword research
Hi guys, what is the best practice to find the long tail keywords, like Google Instant Suggestion, people also search, or moz keyword explorer I have experienced a lot in MOZ pro Keyword Planner, but now I want to know easiest way to find long tail keywords for my website olehana Makeup, still I'm using just 3 keyword that I already ranked in Google SERP top 3 positions now I also want that some long tail keywords also gets ranked.
Keyword Research | | daimon670 -
Keyword Ranking
I would like to understand how to search for all instances where Johansens is on the 1st page of Google (US/UK) for any keywords that have Portugal, Lisbon or Algarve in them i.e. "luxury hotels portugal". Is there an easy/automated way to do such a search? Many thanks for your support, Doug
Keyword Research | | CN_Johansens0 -
How to do keyword research for a specific webpage
Kindly let me know how to do keyword research for a specific webpage and what is the process.
Keyword Research | | AlexanderWhite0 -
Is my copy too keyword rich?
www.heartwavemedia.com - Wordpress - All in One SEO Competitors: photonsf.com, h2video.com, corduroymedia.com, thehivestudios.org I've spent the last week writing and tweaking my landing page copy along with my SEO page titles and descriptions. I think I finally feel pretty good about it but I'd like your professional opinions. Is it too keyword rich? Does it flow naturally? Is the voice fresh? Do my SEO titles vary enough? Thanks in advance for your thoughts and advice.
Keyword Research | | keeot1 -
Include Location in Keywords?
I understand Google's local search automatically searches keywords with the location you are searching from. For example if I'm searching from Calgary and query "best shoe repair", Google knows I'm searching from Calgary and presents Calgary based results. I'm using Google's new Keyword Planner tool which allows for city based search results, meaning I don't have to include "Calgary" in the keywords I submit. The question I have is should I be attaching "Calgary" to my keywords for on-page optimization, and why or why not? Any help would be greatly appreciated!
Keyword Research | | reidsteven750 -
How Can I Rank My One Keyword ?
I read many places about never use the same keywords/anchor text this will consider as spam by google, so i want to know if suppose my main keyword is Indian bridal sarees than how can i give rank to that keyword, should i use the same exact keyword but in different format like bridal indian sarees or indian bridal sarees shopping something like that. Should i use LSI keywords in that keywords. Please help Second, I also read some people saying they use 70% primary keywords and 30% LSI or generic words, so that mean if i have 10 articles so in 7 articles i have to give primary keyword and the rest of the 3 will be generic. Kindly please advice this also.
Keyword Research | | chandubaba0 -
Local Keyword Geolocation
I am really confused about how geolocation and search works. For example, I can search "Air Conditioning Repair" in Google and will get local search results depending on my geolocation. How do I set up keywords in SEOmoz "Air Conditioning Repair" and get the ranking depending on the users geolocation? Do I have to have the keyword "Sacramento Air Conditioning Repair" to get the same results if I search within the vicinity of Sacramento with the term "Air Conditioning Repair." Thanks in advance for everyones help on this question.
Keyword Research | | TalkingSheep0 -
Google keyword tool
Hey anyone noticed Google's keyword tool seems to be returning weird data for search volume compared to just a few days ago? "iron fist clothing" exact match was returning around 1,000 local monthly searches and a monthly trend of approximately the same over the past year. As of yesterday it has zero searches for exact match and even the monthly trends have all been set to zero for every month going back a year Now I suppose this could happen in theory but the fact that the trend is showing up as zero for each month over the last year makes me think this could be a bug. I've also noticed this for one of my keywords on my SEO site, again suddenly gone to zero searches and monthly trends going back a year. However a quick check on webmaster tools shows the impressions going back a few months at the average of 1,300 that the old trend suggested it should be. Anyone else noticed this?
Keyword Research | | barabis770