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
-
Multiple keywords one page.
I want to focus on these 4 keywords. E-waste management
Keyword Research | | themesh
E-waste recycling
E-waste solutions
Brand name Do I need to create a separate page for each or can focus them from home page itself, With title tag like this E-waste Management and recycling company in _Cityname _| Brandname:0 -
Google Keyword Planner - Just PPC?
Morning Mozzers, Please help a layman learn. This is probably a silly question but when I look at keyword search data in Google's Keyword Planner Tool and I see "COMPETITIVE" or "LOW" am I looking at all searches inclusive of organic and PPC? I have been a bit confused by logging in through an Adwords account? At the moment to get my keyword research I am using a combination of Moz, Webmaster Tools, Keyword Planner. I have had a look at the free version of SEMrush which looks really cool. Is my approach right using these tools? Am I covering all bases / missing key opportunities? Regards Ben
Keyword Research | | Bendall0 -
How to finalize the keywords for SEO?
Hi, I use the following method for keyword research: Create a long raw list of keywords. Use Google AdWords Keyword tool to find monthly searches. Find raw competition. Find direct competition (via allinanchor: search operator) Calculate KEI (Keyword Effectiveness Index) Calculate KOI (Keyword Opportunity Index) Is there any other (better) way to execute the keyword research? Or is finalizing/selecting the keywords only on the basis of monthly searches sufficient? In short, how to select the best keywords from a long list? Thanks & Regards
Keyword Research | | IM_Learner0 -
Ignore keywords that have no data in the Google Keyword Tool?
Hello, There are some keywords that have no monthly search data in the Google Keyword Tool. In many cases, this is because there have been very few searches for the keyword. Would you recommend focusing on other keywords that do have search data in the Google Keyword Tool? Perhaps focusing too far out on the long tail of search results can be less productive than focusing on keywords that have proven that at least some people care about them. What do you think? Thanks!
Keyword Research | | nyc-seo0 -
How to stay organized for keyword research?
As most of you know keyword research can be quite taxing. I have been trying to get organized and do extensive keyword research. But trying to stay organized is proving to be more and more difficult. Can I get some expert views from experts in the community as to how you all go about organizing your research and how you track things over time. Thanks
Keyword Research | | EricMoore0 -
Keyword: singular vs plural
Hi, I've been putting some efforts to rank well for "San Antonio Wedding Photographer". I am ranked ok for that but not so on "San Antonio Wedding Photographers". My website is http://www.soobumimphotography.com/ So now, I am trying to rank for "San Antonio Wedding Photographers" instead since Google auto fills wedding "photographers" in search term. Question - Should I change my site title and some post / page title etc? What's the best way to do this? Thank you Soobum
Keyword Research | | BistosAmerica0 -
Keyword Ranking
Soooooo, let's just say that I put a lot of keywords into the ranking tracker. Is there an easy way to reduce this list without having to go in word by word and pause or delete them? Like is there a bulk upload type of system? Thanks!
Keyword Research | | PGD20110 -
Newbie has various questions about keywords
Hi All - Im just learning, would appreciate some clarification on how keywords work. Specifically: For a phrase keyword, does order matter? E.g. is 'Bridging loans UK' the same keyword as 'UK bridging loans'? Again in a phrase, do the keywords need to be adjacent? So if I had a an H1 tag on my page which was 'We provide Briding loans for the entire UK', would this be considered a match for the keyword phrase 'Bridging loans uk' ? As I understand it, optimising your site for a certain keyword involves 2 things at a basic level:a) Including that keyword on your site, and b) Getting relevant inbound links from other sites with that keyword as the anchor text. Is this correct? Are there other large scale factors? What is the balance between those 2 (or more) main factors? Which is most important?
Keyword Research | | nebbisch0