This post is a follow up of this post. So, before you continue reading this post, make sure to read the previous post first so that you will have a clear idea of what you will do after finishing this post.
In the previous post, you have learned the fundamentals you need to write an SEO friendly blog post. You have also understood the content type you need to write on each step on the marketing funnel.
In this post, you will specifically learn how to get the first 10,000 monthly visitors for your blog so that you can start sending the partnership proposals.
To make it easier for you to achieve the goal, I have created a spreadsheet template which you can download below.
How to Use the Spreadsheet File
You can use the spreadsheet file you have just downloaded above as the blueprint to get the first 10,000 visitors for your blog. You can use it for as long as your blog running.
Once you get your first 10,000 visitors, you can populate other cells to target more keywords to get more visitors.
The spreadsheet file itself consists of 8 columns as follows:
- Keyword (column B)
This is the column dedicated to accommodating the keywords you want to target. More about keyword research will be covered shortly.
- Search Volume (column C)
On this column, you can add the monthly search volume of each keyword you target.
- Editorial Type (column D)
Just because you have published all the posts on the spreadsheet, it doesn’t mean you are done. You run a blog for business so that you need to maintain your posts.
Editing your posts regularly is crucial to keep them relevant. In fact, it should be on your editorial calendar plan.
In the future, when you want to edit some posts, you can change the editorial status on this column.
- Title (column E)
Again. You need to maintain your posts to keep the relevancy. You can add the titles of your posts to this column to make it easy for you to identify them.
Adding post titles to this column also helps a lot in recording your ideas for posts that are not executed yet.
- Status (column F)
This column is designed as the reminder of the status of each post. Whether it has been published, not started, or still in progress.
- URL (column G)
For posts that have been published, you can add the URLs here so that you can easily check them when needed.
- On Page One (column H)
This column is designed to monitor the status of your posts on Google. For posts that have been on Google’s first page, you can set the status to Yes.
- Total Search Volume (column I)
Finally, here is the column you need the most during your journey to get your first 10,000 visitors.
The number on this column is based on the calculation on column C (Search Volume). Everytime you add a new number on column C, the number on this column increases automatically.
The number itself shows the total of monthly search volume for all keywords on column B (Keywords).
Since your goal is to get your first 10,000 visitors, you can populate the cells on column C until you get the number of 10,000 on column I (Total Search Volume).
Move on to the step below to learn how you can get the keywords and search volume to populate the cells on colum B and column C.
How to Find the Keywords
Listen. Just because a keyword/topic sounds cool and potential, it doesn’t mean you need to write it until you can validate that the keyword has enough search volume.
In the previous post, I have showed you how to do keyword research using Free Keyword Tool from WordStream. While the tool is free, it lacks of features and a bit slow.
If you are looking for a paid solution, my recommendation is Wordtracker. It is way more affordable than Semrush and Ahrefs.
| Wordtracker | Ahref | Semrush | |
|---|---|---|---|
| Price per month (the lower plan) | $24 | $129 | $139 |
Apart from keyword research tool, Wordstream also comes with other features like ranking tracker to track the ranking of your keywords and the ability to monitor your competitors’ keywords.
If you are interested in trying Wordtracker, you can click the button below.
How to Do Keyword Search Using Wordtracker
I have demonstrated how to do keyword research using Free Keyword Tool from WordStream in the previous post. So, in this post, it’s Wordtracker’s turn.
You don’t need to subscribe to a paid plan in a rush. Instead, you can try the trial version first. You can even use the trial version of Wordtracker without creating an account.
To get started, visit the Wordtracker website. Go to the Features menu and select KEYWORD TOOL.
Enter your keyword idea to the available field and click the Search button. If you want to check the search volume in a specific country, you can click the Territory dropdown.
As you can see, you will be presented with a list of keywords you can target. Complete with the search volume.
Apart from search volume, you can also check the competition level. The lower the competition, the easier it becomes for you to win on Google.
If you want it, you can also download the keywords list or save it to your Wordtracker account.
Now back to your spreadsheet file. Copy the keywords generated by Wordtracker and put them to column B. For the search volume of each keyword, you can put it to column C of the spreadsheet.
Remember. You don’t need to write a different post for every single keyword. Instead, you can build a list of keywords — that are related between each other — and write a single blog post that target the keywords using Semantic SEO technique I mentioned in the previous post.