Blogging

How to Generate Dozens of Blog Topics in Under an Hour

Here's the scenario....

You've chosen to pursue a new profitable niche market that you know very little about.

You know that you want to develop blog content to attract more visitors to your niche site so you can start growing your mailing list and earning income from affiliate products.

The question is - how do you come up with blog topics for a niche you know little about?

In this post, I'm going to show you a method that will help you generate dozens of blog topic ideas that use great keywords for search and headlines that make people want to click.

For this post, we're going to use shuffleboard as an example niche topic from this list of 1,109 profitable niche markets analyzed.

Follow along with this tutorial as you go through out...

To discover 200+ profitable niche markets click the image below now...

1. Create a master spreadsheet.

In Microsoft Excel or Google Docs, create a master spreadsheet for blog topics.

The spreadsheet will have an individual sheet for your final titles plus each of the six tools that we will use to generate topic ideas.

You can get a copy of the spreadsheet I use by clicking on this link and using the options under the File menu to make a copy to your own Google Drive or download it to your computer.

2. Start with Google AdWords Keyword Planner.

In your master spreadsheet, create a sheet called GAKP.

This sheet should have three columns: Keywords, Search Volume, and Your Custom Titles.

Using Google AdWords Keyword Planner you will enter your niche topic keyword.

This free tool will give you hundreds of related keywords for the topic you enter, plus the search volumes for each.

blog-topic-generator-google-adwords-keyword-planner

Use the Download button above the search results to download all of the keyword ideas into a CSV file or save them to your Google Drive.

When you open the file, delete the currency column and copy the content in the keyword and search volume columns.

blog-topic-generator-google-adwords-keyword-planner-1

Paste the content into your master spreadsheet in the GAKP sheet.

blog-topic-generator-google-adwords-keyword-planner-3

Sort the Search Volume column in descending order, so the most searched keyword phrases are at the top of the list.

Now, start your way down the list and try to come up with some good blog post topics for the most relevant keyword ideas.

blog-topic-generator-google-adwords-keyword-planner-4

As you come up with blog post topics, keep in mind your goals: growing your email list and selling affiliate or information products.

Think of blog topics that could be expanded into a free, downloadable list or ebook and those that could easily include affiliate products to sell.

Don't stress if you don't come up with a lot of blog topic ideas at this stage.

Just run through the list of keywords, jot down topics as they come to you, and then move on to the next step.

3. Move on to UberSuggest.

In your master spreadsheet, create a sheet called UberSuggest.

This sheet should have two columns: Keywords and Your Custom Titles.

Using UberSuggest, you will enter your niche topic keyword.

This free tool will give you keyword ideas based on the suggestions that Google offers when people start typing in a keyword into search.

blog-topic-generator-ubersuggest

But instead of having to type in your keyword plus each letter of the alphabet, UberSuggest does the work for you.

blog-topic-generator-ubersuggest-1

Copy all of the suggestions that UberSuggest gives you and paste them into your master spreadsheet.

Use the Paste Special > Text (Excel spreadsheet) or Paste values only (Google spreadsheet) instead of CTRL+V to keep a clean format in your master spreadsheet.

blog-topic-generator-ubersuggest-2

Ignore the headers for each section (shuffleboard +, shuffleboard + a, etc.) and try to come up with some good blog post topics for the most relevant keyword ideas.

Again, keep in mind your goals of growing an email list and selling affiliate products when coming up with topics, and don't stress if you don't come up with a lot.

We've still got a few more tools to go to help inspire ideas.

4. Enter your niche keywords into the HubSpot Blog Generator.

In your master spreadsheet, create a sheet called HubSpot.

This sheet should have two columns: Suggested Titles and Your Custom Titles.

Using HubSpot's Blog Topic Generator, you will enter your niche topic keyword.

This free tool will give you actual blog titles that you can use for your blog posts.

blog-topic-generator-hubspot-blog-topic-generator

Copy all the five suggestions that HubSpot gives you and paste them into your master spreadsheet.

Use the Paste Special > Text (Excel spreadsheet) or Paste values only (Google spreadsheet) instead of CTRL+V to keep a clean format in your master spreadsheet.

Then delete the numbers 1 through 5 from the topics.

blog-topic-generator-hubspot-blog-topic-generator-1

You can click Try Again and re-run the tool to get more blog titles using your keyword.

You can also enter some more related keywords discovered by the Google AdWords Keyword Planner to get more specific titles.

blog-topic-generator-hubspot-blog-topic-generator-2

After you run the tool a few times, you'll get the option to download more blog topic ideas after you submit a lead form to HubSpot.

They will then send you a spreadsheet that you can enter your keywords into to get even more titles.

blog-topic-generator-hubspot-blog-topic-generator-3

After you enter your keywords into the 3 terms you would like to write about boxes as Noun 1, Noun 2, and Noun 3, copy the finalized titles and paste them into your master spreadsheet.

Use the Paste Special > Text (Excel spreadsheet) or Paste values only (Google spreadsheet) instead of CTRL+V to keep a clean format in your master spreadsheet.

blog-topic-generator-hubspot-blog-topic-generator-4

While you do have actual blog titles to work with, you will not want to use them exactly as is.

For starters, HubSpot tends to generate titles that are a little more business focused, so not all will apply to all topics.

Plus, you don't want to have the same blog post titles as someone else who used this tool.

So go down the list, pick out the ones you want to write about, and modify the titles.

Also think of ways to incorporate some of the related keywords discovered by the Google AdWords Keyword Planner to get more specific titles.

To discover 200+ profitable niche markets click the image below now...

5. Enter your niche keywords into the Content Forest Ideator.

In your master spreadsheet, create a sheet called Content Forest.

This sheet should have two columns: Suggested Titles and Your Custom Titles.

Using Content Forest's Ideator , you will enter your niche topic keyword.

This free tool will give you actual blog titles that you can use for your blog posts.

It doesn't work with all keywords, including shuffleboard, so we used billiards instead for this example.

If it doesn't work with your niche, move on to the next tool.

blog-topic-generator-content-forest-ideator

Highlight the titles and copy them, then paste them into your master spreadsheet.

Use the Paste Special > Text (Excel spreadsheet) or Paste values only (Google spreadsheet) instead of CTRL+V to keep a clean format in your master spreadsheet.

blog-topic-generator-content-forest-ideator-3

Because these are actual titles that have been used in published blog posts, you will not want to use them exactly as they are.

Instead, go down the list and customize the ones you would want to write about.

If you didn't get titles related to your niche, modify them for your niche keyword.

6. Enter your niche keywords into the SerpStat Keyword Suggestion Tool.

In your master spreadsheet, create a sheet called SerpStat.

This sheet should have two columns: Suggested Titles and Your Custom Titles.

Using SerpStat's Keyword Suggestion Tool, you will enter your niche topic keyword.

This free tool will give similar keyword ideas as provided by UberSuggest earlier.

But it also has an option to reveal only questions related to your niche keyword.

blog-topic-generator-serpstat-keyword-questions

You will need to use the Authorize for Export button at the top right of the search results to copy all of the ideas this tool generates.

Once you enter your email address and preferred password, click on only questions again in the left sidebar and then the save button.

You will get a txt file with the suggested questions that you can copy and paste into your master spreadsheet.

blog-topic-generator-serpstat-keyword-questions-1

From here, go down the list and customize the ones you would want to write about.

You can leave them in question format or change them into titles that answer the questions.

7. Enter your niche keywords into the TweakYourBiz Topic Generator.

In your master spreadsheet, create a sheet called TweakYourBiz.

This sheet should have two columns: Suggested Titles and Your Custom Titles.

Using TweakYourBiz's Topic Generator Tool, you will enter your niche topic keyword.

This free tool will give you actual blog titles that you can use for your blog posts.

blog-topic-generator-tweakyourbiz-topic-generator

Copy the titles from the plain text column to the right and paste them into your master spreadsheet.

blog-topic-generator-tweakyourbiz-topic-generator-1

While you do have actual blog titles to work with, you will not want to use them exactly as is because you don't want to have the same blog post titles as someone else who used this tool.

So go down the list, pick out the ones you want to write about, and modify the titles.

Also think of ways to incorporate some of the related keywords discovered by the Google AdWords Keyword Planner to get more specific titles.

8. Get headline formulas with the Impact Blog Title Generator.

In your master spreadsheet, create a sheet called Impact.

This sheet should have two columns: Suggested Titles and Your Custom Titles.

Using Impact's Blog Title Generator , you will enter your niche topic keyword.

This free tool will give you actual blog titles that you can use for your blog posts.

blog-topic-generator-impact-blog-title-generator

Skip filling in the blanks as this would take forever since the titles are suggested one at a time.

Instead, click on the heart icon, which will save the title to the list below and then display a new title.

You can keep clicking the heart icon over and over again (hundreds of times if you choose), and you will continue to get new titles.

Once you are done (or get tired of clicking the heart), you'll click the Email Me My Titles button at the bottom of the page.

After you enter your name and email address, you'll get an email with all of the titles you saved.

blog-topic-generator-impact-blog-title-generator-1

Copy the list of titles and paste them into your master spreadsheet.

blog-topic-generator-impact-blog-title-generator-3

Go down the list and customize the titles you want to write about with your niche keywords.

Also think of ways to incorporate some of the related keywords discovered by the Google AdWords Keyword Planner to get more specific titles.

9. Consolidate your titles into the Final Titles sheet.

In your master spreadsheet, create a sheet called Final Titles.

This sheet should have two columns: Your Custom Titles and Length.

The Length column will use the following formula to calculate the number of characters in each of the titles you created to ensure they are SEO friendly.

Moz suggests 50 to 60 characters or an average of 55 characters.

=len(A2)

Go to each of the sheets for each tool that you used and sort the Your Custom Titles column in descending order.

This should put all of the titles you came up with at the top.

blog-topic-generator-final-titles-1

Copy them and paste them into the Final Titles sheet.

blog-topic-generator-final-titles-2

Edit any titles that are too long based on the length calculation, and voila!

You should have dozens of great titles to get started with on your niche site blog!

Once you've written blog posts to go with your first set of titles, come back to your master spreadsheet, go through all of the keywords and suggested titles you haven't used, and try to come up with more titles.

To discover 200+ profitable niche markets click the image below now...

The Conclusion About Blog Topic Generators

As you can see from this exercise, there are hundreds of keywords and headline formulas you can choose from to generate blog post topics that will be optimized for search and intriguing to readers.

Even if you don't plan on writing the posts for yourself, you can provide great titles for your outsourced help to work with!

Once you've done this exercise for your niche site and generated blog topics, share in the comments how many blog post ideas you generated!

Niche Hacks