Keyword Research To 100s of Content Briefs in Under 2 Hours

Posted in: SEO Tips
Date posted: September 26, 2022
Read time: 4 minutes


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 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.

  1. Collect & Research Relevant Keyword Topics
  2. Cluster The Keywords Using AI Tools
  3. Place Keywords Into My Automatic Brief Generator
  4. Create Content Briefs For Your Audience
  5. Connect Briefs To Automated Briefing Document
  6. Run Automated Brief Generator
  7. Write or Outsource Content Generation

1. Collect & Research Relevant Keyword Topics

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:

  1. It lets me know if there is a current demand for the topic I am writing about.
  2. It gives me vital information about the types of queries being used, the questions being asked and what language is being used to find the content the user needs.

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:

  • Select your domain
  • Select date range. (6 months+)
  • Select Search Type (Default – Web)
  • Group By – Select “Query”
  • Filter by – leave blank
  • Aggregation type – Auto
  • Rows Returned 5000 (you won’t need any more)
  • Results sheet – Select the current sheet
  • Mode – Replace

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.

2. Cluster Keywords Using AI Tools

I haven’t finished writing this yet so please come back tomorrow to see this section updated!

Did you like this?

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.

Mersudin Forbes

Previous Post

5 Chrome Extensions You Didn’t Know Existed

Next Post

“Mortgage Rates” Google Searches Rise As Consumers Scramble To Figure it all out

mortgage rate searches