If you want to grow organic traffic for your website or websites, one of the key levers you can pull are the creation of content.
In the last couple of years, the term “content velocity” or “publishing velocity ” was coined by the guys over at ContentDistribution.com. It basically comes down to how much quality content you can publish to cover all relevant searches users could perform across the funnel.
This usually means covering multiple topics and stages of the Informational, Navigational, Transactional and Retention stages of keyword searches.
In order to achieve high content and/or publishing velocity in order for Google to take notice and for you to see more qualified traffic coming to your site, a solid keyword research, content production and publishing process needs to exist. Below, I break down the steps, processes and document templates you can use to achieve this in under two hours with 100s of content briefs to either outsource or write in-house.
For me, the number one place to start when looking at any piece of writing and potential content is to research the topic with keywords in mind.
This achieves a couple of things:
In order to do this, you will need access to a couple of paid tools alongside some free ones. I have also tried to provide a purely free way of doing this below so that anyone can collect keyword data.
You will also need a place to store all of these keywords, my recommendation would be to collect and store them in Google sheets which provides all of the functionality you need to de-dupe and interrogate the keyword data.
Let’s get cracking.
The first thing you are going to want to do is to download a Chrome extension called Search Analytics For Sheets, this will allow you to download more than 1000 keywords compared to downloading the data directly from Search Console.
After downloading the extension, head over to Google Sheets > Extensions and select Search Analytics for Sheets > Open Sidebar.
You will see a sidebar pop-up which will allow you to select the domain you want to download keyword data from the respective Search Console account you want to use.
The best way to download the data is to select the following settings:
When you click “request data”, your sheet should look something like this:
Once you have this in the first tab, I would suggest you create two more tabs, one for new data and the other one will be used to dedupe all of the combined keywords you download from different sources.
This is ideally how your sheet would look if you use tools like Search Console, semrush and ahrefs.
I haven’t finished writing this yet so please come back tomorrow to see this section updated!
If you did, consider subscribing to my email list so you get updates about new tools I test out every week. I won’t ever spam you.