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
-
MOZ KD is not showing results
Hey, moz kd is not showing correct result. i searched the keyword best for apartment one time the kd was 44 and again i searched and the kd was 24. which one is the correct kd?
Keyword Research | | Ijiubu7680 -
This page could be penalized as keyword stuffing?
Dear Mates, This sample page is http://goo.gl/kGljFX Title tag: Wondershare Video Converter Ultimate Coupon Code 30% - Buy Page Meta Desc: Wondershare Video Converter Ultimate Coupon Code 30%: Convert both Standard-Definition and High-Definition formats, super fast speed. H1: Wondershare Video Converter Ultimate Coupon Code H2: Wondershare Video Converter Ultimate Key Functions: H2: Wondershare Video Converter Ultimate Detailed Features: Could you take a look and let us an idea? Thank you Claudio
Keyword Research | | SharewarePros0 -
Optimize the ranking with the right keyword
Hi, I would like to know the processs if i want use in the same time 2 keywords. "géolocalisation véhicule" and " geolocalisation vehicule " As you can see the diffence is just the accent and i would like have the same ranking for both Thank for your help Steve
Keyword Research | | fleurya1 -
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 -
Keyword ranking tool?
I am looking for a tool that would show ranking keywords for my website - except Google Anlaytics and Webmaster. I don't want to enter the keywords to see if my website is ranking I'd like to see if there are any keywords that rank already Thanks!
Keyword Research | | Rubix0 -
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 search results
Does Google always return the results of a search query in a broad based fashion if the searcher does not use brackets or quote marks? Or, do they display the older domains of sites with authority under the broad based parameters and newer sites only if there is a possible exact match? How does Google decide which type of search results to display? Thanks for any insight. I
Keyword Research | | hawkvt10 -
REAL demand for a keyword?
I once read there is a way to use google adwords to see the REAL demand for a specific keyword, google adwords tool and other tools seem to be not-so-accurate. I just don't remember the exact method, can you please remind me?
Keyword Research | | jest0