Status: 25%

From keywords to content; making the big list

In the previous step (keyword analysis) we arrived at a big list of keywords and their search volumes. Some startup websites don't need to create content in the form of articles, but without doubt, most do. So let's take the keyword analysis one step further to create our to-do list in terms of content that we need to create.


From keywords to content

Open your keywords excel sheet and sort search volume by descending. This is the big list of keywords that matter to your startup idea. But right now, it is just an endless list of words and we need to decipher it to get to a list of unifying topics.


Using our previous example


My topic was: Italian food recipes

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


I take my excel sheet with the keyword data I generated and start working from the top to start structuring the keywords into my (previously established) sub-topics. Most likely, several keywords can not be categorized into my sub-topics. This means I am either missing categories, or these keywords simply don't make sense for my website.

Using my Italian food recipes as example; I have a lot of keywords with traffic on Meatballs. Did I really forget about meatballs? This new sub-topic is added to my list pronto! And the same applies to many other categories, including Bruschetta, Cannelloni, Wine, etc. I will also discard keywords if I feel they don't match well. Either way, my sub-topics list is growing.

Not only would I be adding sub-topics by analyzing my keywords, I will also be adding sub-sub-topics. What if I see a lot of traffic on keywords like "salami pizza" and "pizza funghi", these are all sensible sub-sub-topics for the Pizza sub-topic right? Keep adding to that topics list.



The topics list

Finally, after analyzing my keywords and structuring it into sub-topics, I arrive at a topics list that from now on I will simply call my future website's structure.

With my Italian food recipes example I will have hundreds, if not thousands of potential topics on my list. This is just an example though and in this example I would surely have to focus on a niche (or spend the rest of my life writing).

Let's hope you have been more clever and you selected a niche; apart from your main topic you might have about four sub-topics and each of those sub-topics have a few sub-sub-topics. You have a website structure now and you're ready to start creating content.



Honestly, I had no idea what content I needed to create for my startup website. Having analyzed the keywords central to my idea, and structuring them into topics, really helped.



Apart from using data to get to a to-do list of creating content, also select topics you are simply passionate about. Always write about stuff you love or are knowledgeable about. If it doesn't match with your main content, add a blog to your site where you can add it. Use that passion!




I have a list, now what?

You have your website structure in mind, and

a list of topics, let's start writing articles then!

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