How to Generate Dozens of Blog Topics in Under an Hour

Filed in Blogging, Content, Ultimate Guides & Resources by on January 9, 2015

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.

 

(P.S. If you'd like to download a free checklist of 31 blog traffic secrets click here or the image below)

 

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.

 

 

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.

 

(P.S. If you'd like to download a free checklist of 31 blog traffic secrets click here or the image below)

 

 

In Conclusion

As you can see from this exercise, there are hundreds of keywords and headline formulas you can choose from to create 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, share in the comments how many blog post ideas you generated!

 

Author Bio: Kristi Hines is a freelance writer, professional blogger, and ghostwriter. In addition to developing blog content for businesses, she maintains niche websites related to mal-shis, online education, and photography.

 

Kristi Hines

Comments (24)

Trackback URL | Comments RSS Feed

  1. paul says:

    You could add using something like SEO content machine or Kontent Machine or Word IA. Look @ these from a scientific standpoint. Nice to see a follow up on this at you only really about this sort of software on forums.

  2. I have read a lot of posts on how to get blog ideas, but this one is certainly the best. And this blog post proves the fact why I love to read most of the articles written by Kristi Hines.

    Thanks for sharing this article 🙂

    • Kristi Hines says:

      Thanks Sandipan! I worried a bit about writing this since so many people have written about topic generation, but I knew I had a different approach to it. 🙂

  3. I dig the strategies Kristi in that each focuses on generating a bunch of pertinent, eye-catching ideas.

    It's one thing to generate blog post ideas.

    It's another thing to generate interesting, attractive, eye-catching ideas which help to bring in the bacon.

    Your strategy definitely brings in the bacon because it's based on logical, sound thinking that leads to prospering results.

    I get to be lazy; only 1 post weekly here. But even though I have all the topics I could ever tackle in mind it sure helps to have a nice title analyzer to get the most bang for my blogging buck.

    Thanks, and thanks Stuart for sharing your platform.

    Ryan

    • Kristi Hines says:

      Thanks Ryan! I've read a lot of posts lately on generating topic ideas, and most are based on just using the exact titles that one tool spits out. I've found that if I use a variety of them, I get a lot more unique ideas, which are more useful and inspiring to work on. 🙂

  4. neale says:

    Awesome roundup! quite a few here i have never seen.

    Heads up link in section 8 is wrong should be
    http://www.impactbnd.com/blog-title-generator/blogabout

  5. Lindsey says:

    This is amazing! I always struggle with titles, this plan gives me so many ways to stop the struggle. I will definitely be using these tips from now on.

    Thank you!

  6. Paul says:

    I think there's value in the above but way too many steps.

    It's good maybe for building out a category of pages around a topic rather than a blog post.

    I tend to scrape good search results and then pull the comment number -- if a topic got lots of comments it's usually a winning to repurpose.

    For a lot of niches I also look at what academics debate and this tends to get a lot of sources to quote.

    Another good one is finding a Huff Post tag and then scraping all the blog titles and authors.

    I'd say automate finding human writen articles stuff, rather than using Keyword tool, especially for blog articles when you want to find actual subjects of contention and stuff that people in a niche cares about. You loose this human element of reality with the above model.

    I'll print out your article and try it on a few niches to give me additional html pages to create around product or service pages.

    • Kristi Hines says:

      Thanks for sharing your strategy Paul - can you tell me what tool you use for scraping comment counts?

      Another way to do this is to get ideas from BuzzSumo. BuzzSumo will allow you to export the top articles on a particular topic based on social shares. You can browse the results with a free account, but if you want to get them into a spreadsheet, you have to get a premium account at $99 per month. 🙂

  7. paul says:

    to scrape huff post I use visual web ripper, but to get the comments you can use free tools but you need some formulas

  8. p says:

    Ubbersuggest broken link

    thank you!!

  9. Rema says:

    Thanks a ton Kristi for sharing such wonderful information. Very helpful indeed especially for beginners like me. So organized and very well-laid out and very easy to follow. I can't thank you enough for sharing this.
    Regards
    Rema

  10. Sylvia says:

    This is so incredibly helpful. I haven't written anything for my site in weeks. I felt spent and burned out and the thought of brainstorming for topics was just too much.

    Your methods make it obvious there are always topics to write about. Thank you again.

  11. Rajeev Joshi says:

    This is great article for those people who are beginner and searching for a good topic for starting there blog. Thanks for sharing surely going to help.

  12. Dee says:

    In my industry I ave decided to leave it up to the professionals to take care of my marketing. I still enjoy reading up on some interesting blogging tactics, perhaps to pursue as a hobby. As a vet I have many very detailed stories.
    Thank you for this interesting read, I will look into the suggestions you have made and see how to apply them to my own business.

  13. Samantha @ Wishpond says:

    Yes, yes, yes! What a fantastic and actionable article. I don't always but I do sometimes struggle to figure out how to build headlines that people want to click. Thanks for sharing step-by-step how I can come up with ideas and headlines for my articles 🙂

  14. Carinne Bird says:

    🙂 Hello Kristi! Thankyou for sharing this post! The steps are really helpful and it inspires me to think more blog topic ideas. Thanks again and keep it up!