Status: 21%

Keyword analysis; understanding your future visitors

Welcome to the Geek step. This is where I will guide you through a straightforward process of analyzing your startup idea to find out what topics are central to your idea, a step absolutely crucial to the success of your entire website. It will enable you to create content people are looking for and it will help you get that content ranked well in Google.


Keyword analysis, what?

In the previous step you have done your share of brainstorming and soul-searching to arrive at your startup idea. You probably know a lot about this topic already, but I am sure there are many related topics that you don't have in mind. All these related topics I will from here on call "keywords".

You probably can't tell what your top 10 keywords are, right? And you have no idea how much search traffic these terms potentially have, right? Time to do the math analysis.



What are your keywords



Finding out what your keywords are

Open an excel/numbers sheet and take some time to think about your startup idea, than answer these questions:


  • What is the central topic of your startup?
    Add it to the top row of your excel.

  • What are the important sub-topics?
    Add them vertically to your excel.

  • What are the most important sub-sub-topics?
    Add them vertically to your excel.

  • What are important related topics?
    Also add these.



A simplified example


My topic is: Italian food recipes

My important sub-topics are Spaghetti, Lasagna, Pizza, Risotto, Gnocchi and Tiramisu

Some of the sub-sub topics for Pizza would be: Pizza dough, Pizza sauce, Pizza toppings, Thin crust Pizza, etc.

A few related topics: Spanish food recipes, Greek food recipes, Mediterranean food recipes, but also: Italian food restaurant, Italian food ingredients, Italian food history, etc.




Excel or Numbers sheet for Keyword analysis   Searching for keywords on Google
The excel/numbers sheet in use, and search suggestions by Google.



Adding more keywords

I am sure you have done your mini assignment and came up with a lot of sub-topics and sub-sub-topics. Now it's time to get analytical and check the data. It is time to start adding more keywords by asking Google for help. You probably know that when you type something in Google, it starts giving you suggestions.

Try entering "Italian food recipes"; immediately you see Google giving you suggestions like "italian food recipes with chicken" and "italian food recipes pasta". This is useful data, I forgot about the chicken! Now try "Pizza"; depending on where you live, you probably see a lot of "Pizza Hut" and local Pizza restaurant names. That's not helping.


Time to scale things up a bit. There is a little known trick in which you can get these suggestions from Google in neat lists. Try this URL:

Now you get a list of the 10 most relevant suggestions to the term "Pizza". Note that Firefox shows the list well, but Safari sometimes shows a blank screen. Try another browser if this link doesn't work.


If Pizza is a very important keyword to my website, and I will be adding a lot of content about Pizza, I need more keywords on this sub-topic. Actually, I want to know about what people can possibly search for that is related to pizza. There is a clever way to get many more keywords, by adding the letters of the alphabet one by one in front of, but also at the back of the search term. So use terms like "a Pizza", "b Pizza" as well as "Pizza c", "Pizza d", etc.

Sounds strange, it doesn't make sense, so just try it and you'll see what I mean. Use these urls to do that:


Actually, this is a lot of work. And I only investigated the word "Pizza" and still have to get the same data for "Pasta", "Spaghetti", "Lasagna", and many more. But this is absolutely vital information for me, because I need to get into the minds of my potential/future website visitors. I need to get the data so I know for sure I am not missing important topics.

There is a really convenient website that automates some of the steps, called UberSuggest. Unfortunately they do this only for finding terms behind the keyword (not in front of it), so you will have to do part of the work manually still. Click here to see how UberSuggest works.


Collect all the keywords from all your topics, if possible try some of the related topics you came up with earlier as well. I am looking for an excel document with hundreds, of not thousands of keywords.



Analyzing your keywords



Analyzing your keywords

Alright, you have your list of keywords ready and you are sure you are not missing important topics. Now it is time to ask Google how much traffic these keywords can generate (the search volume). You will need to get a Google Adwords account to check this, but that is not much work. Step by step:


  1. Register at Google Adwords here.

  2. After registering, login and on the Adwords homepage click on "Tools" and then on "Keyword planner".

  3. Then click on "Get search volume for a list of keywords...".

  4. Open your excel and copy all your keywords into the blank field at Adwords.

  5. Adept the targeting to your potential website visitors. If that is "English speakers" do not put English as language but instead, target the countries that you focus on (like the USA, UK, etc). This will help you get better data out of it.

  6. Click on "Get search volume".

  7. You now see a list of your keywords and their search volumes.

  8. Download the data and open it, sort by descending. If you can not download it in a neat excel (only as CSV) have it added to your Google Drive and then export as XLS.



Nice! Now we have data we can use.

You have an accurate overview of what keywords/topics are important to your website, so that you know what you need to write about. You still need to apply common sense though, as some keywords attract a lot of traffic but are not central to your startup idea. We will do that in the next step.



Search volume check Google   Search volume on Google AdWords
Search volume check and results using Google AdWords.



Keywords analyzed.

You have your list of keywords and the next step

is to decide what topics you will write about.

Proceed with the next step


Step 1: Build websiteStep 2: Create contentStep 3: Attract visitorsStep 4: Make moneyStep 5: Grow your businessStep 6: Earn more