How do you track mentions about your company and relevant keywords on forums and blog posts, etc.? Are there any free tools to use?

Then you can use URL tracking codes to track links and view them in Google Analytics which are both free.

You can use advanced Google Search Operators to view relevant keywords in forums. An example would be like this one.

cars site:someforum.com

This typed into the search engine above will show you all of the pages that mention cars in only the website someforum.com.

How to add a Product to Network Solutions Shopping Cart with an SEO Eye

  1. Log into your Dashboard with your username and password.
  2. Click ‘Add New Products’ on the left side.

Add product to Network Solutions Shopping Cart

  1. Click the ‘Create New Product’ button

Creating a new product on Network Solutions shopping cart

 

  1. Enter the product data in all tabs.

Enter the product data for Network Solutions shopping cart

I will go into detail what to enter in all of the tabs that will maximize search engine crawling and indexing for ranking.

  • ‘General’ tab
    • Product Name: Only put the name of the product here. An example would be ‘Alaskan Salmon Fillet Knife’. Having an insanely long product name with the full description of the knife in the title actually hurts your rankings.
    • Part No. / SKU: I have found with manufactured products like from Milwaukee Tools you can rank more easily for the products by including the SKU and/or Part Number to the product description and the short description.
    • Sort Order: Not relevant for the search engines, but if you want certain products displayed in a specific order or any products you want to show along the top you will have to utilize this.
    • Mfr Part No: I have found with manufactured products like from Milwaukee Tools you can rank more easily for the products by including the Manufacturing Part Number to the product description and the short description. This will be grayed out if your product has variations.
    • Manufacturer: Select or create the manufacturer for the product. This needs to be added to all of your products! This is Brand Recognition that will be picked up by the search engines. Another thing to do is to add schema tags to all of the products of the website. This will have to be done by using the ‘<Head> HTML’ tab under where you enter the ‘Full Description’ below. You can learn more about schema over here at Google.
    • Stock Quantity: Add the information you want here. The only thing SEO here is to not delete the product but instead just mark it out of stock. If the product has variations then this will be grayed out.
    • Product Image: This is an important one. Obviously it has to be a high-quality image but the file size of this cannot be very large where it will take a long time to load up.
      • All images should be under 800×600 pixels. If you need to resize the image from your computer you can utilize a free online resize tool like this one.
        • Before uploading the image to the shopping cart rename it to reflect the product. For example, if the knife is an ‘Alaskan Salmon Fillet Knife’ then name the file alaskan-salmon-fillet-knife.jpg. Don’t worry if you have the same file name for another product. Network Solutions will add a 1, 2, 3, etc. to the end of the file name for you.
        • Save files as .jpg files for speed loading.
        • When you click on ‘Manage Image’ it takes you to the ‘Image’ tab where you can enter in the alt tag here. Alt tags are for website readers for the blind. Don’t abuse it just enter something like this. Example: Alt tag: Picture of our Alaskan Salmon Fillet Knife with a sheath. I have found with other eCommerce shopping carts that if you have the ability to enter a description of the image like in WooCommerce then you can start ranking for the images by themselves.
        • When you click on ‘Manage Image’ it takes you to the ‘Image’ tab where you can enter the Caption Text. This text will appear below the image on your website. An example here would be just to put ‘Alaskan Salmon Knife’. Save the full description for later.
    • Weight: Enter the weight and dimensions of the product here. If your product has variations then this will be grayed out.
    • Pricing: Pretty self-explanatory here, but you have a checkbox here that enables you to make the product for sale or not. One of the things I noticed on your shopping cart was a large number of products that cannot be found so in the past they must have been deleted. I have a ton of 404 errors that should be taken care of with 301 redirect links. Instead of deleting the product make the quantity zero or uncheck the box along the bottom (Product is hidden and unavailable for sale.) to make it not for sale. The top box that has a checkbox ‘For Sale’ seems to do nothing and is useless.
    • Choose a Category: Select all categories that relate to this product, not just one. The more ‘real estate’ we have for one product with multiple categories the better. Just make sure that they are genuine relevant categories. More ‘real estate’ will also increase the chances of ranking for a specific product multiple times. However, if you have the exact same text with the exact same product on multiple category pages then you may trigger a duplicate content warning so don’t overdo it.
    • Short Description: This will show up as a snippet on the website and possibly as a snippet that will be displayed if it becomes featured on a SERP (search engine result page) so keep this short description under 180 characters long. An example would be ‘Alaskan Salmon Fillet Knife with Leather Sheath included.
    • Full Description: A very detailed description should be added here. If Google pulls a snippet of information form either the short description or the full description it will only pull the first 180 characters so be sure to display the selling point and main product description within 180 characters. Do this under the ‘Design’ tab. The ‘<Head> HTML’ tab can be used to add schema code. Below this, you also have the option to hide the product below the description box. It is preferred never to use this option because it also hides the products from the search engines.
  • ‘Advanced’ tab
    • There is nothing relevant to help you with the search engines here.
  • ‘Images’ tab
    • This was explained in detail above under ‘Product Image’ of the ‘General’ tab.
  • ‘Variations’ tab
    • There is nothing relevant to help you with the search engines here other than to put good descriptions of the variants.
  • ‘Personalization’ tab
    • You may create custom templates to save you time, but if the same text is used over and over exactly throughout your website then it will hurt your rankings so it is NOT advised. Unique content is key.
  • ‘SEO Info’ tab
    • Friendly URL: This is another important one. You can create a search-friendly-URL here. An example I found is 20gaugeleathertasselshotgunnecklace.aspx. Something like this should be changed to 20-gauge-shotgun-necklace.aspx. Don’t add a ton of hyphens and keep it short and simple.
  • Page Title: Another important one here. Put the name of the product here and it is very important to keep the page title unique. A big no-no is to have the same page title used over and over again.
  • Meta Keywords: This is useless for rankings but go ahead and enter in something like ‘fillet knife’ for fillet knives just in case they ever start to use the meta keyword tag again. It is better to do it now instead of adding it to 10,000 products later if it ever becomes relevant again.
  • Meta Description: This is an important one. You can copy and paste your short description here. Make sure you keep in under 180 characters long. If they cannot find your short description to display as a snipper in the SERPs (search engine results pages) then the search engines will pull it from your meta description tag. Normally they do not pull it from the meta description tag, but it has been found to be still useful for ranking.
  • ‘Add-A-Store’
    • There is nothing relevant to add here for search engine optimization.
  • ‘Related Products’
    • Select Products: This is an important ‘upselling’ technique. For example, if you have a fillet knife here for related products you would add sheaths and other accessories that go with fillet knives. This SHOULD be utilized and can be helpful for the search engines to crawl and index even more products from your website.
    • Define Rules: You can add a rule here where adding related products can be done for you automatically. If done wrong this could be a disaster. For example, if you created a rule that adds the keyword ‘sheath’ to all filet knives but if someone purchased the sheath and it doesn’t fit then that would cause problems. Manual is better but if you are sure the rule would not fail then you can create one to help you save time. One safe rule to create would be adding the keyword ‘necklace’ for any earing products. Or would it? Check to make sure.

Keyword Research in SEO: Part 3

Summary of Part 3

Doing an in-depth analysis of the keyword phrases found in part 2 and narrowing down the list. Then, examing the narrowed down list to help determine which keyword phrases that you want to try and rank for.

Exploring the List

Choose the right keywords for your keyword research.

Keyword Research Reports

In part 1 of “Keyword Research in SEO,” we decided to do research on ‘SEO Tools’. In case you missed it part 1 of how to pick your main keyword theme to research is located here.

In part 2 we generated a list of possible keyword phrases to use from numerous sources and run them through SEMRush’s Keyword Magic Tool.

In Part 2 of my keyword research articles, 3,239 keyword phrases were discovered and I narrowed it down to 551 keyword phrases.

To add the groups to SEMRush export the keyword phrases to the tool PPC Keyword Tool.

 

With the Keyword Manager Tool in SEMRush or by adding a category in your spreadsheet, we can group the keyword phrases by category.

(# of Keyword Phrases)
(Category Name)
(Examples of Keyword Phrases)

Note: The keyword phrase ‘website grader’ was actually the name of an online tool so it is in the category ‘Brand Tool’. When in doubt Google it!

  • (39)
    (Brand Tool)
    (Ubersuggest, KWfinder, Moz SEO, etc.)
  • (2)
    (Competition Analysis Tools)
    (SEO competitor analysis tool, competitor keyword research, etc.)
  • (2)
    (Content Tools)
    (SEO writing tools, SEO tools to check duplicate content, etc.)
  • (10)
    (Keyword Tools)
    (keyword tool, LSI keywords, etc.)
  • (5)
    (Linking Tool)
    (backlink checker, google backlink checker, etc.)
  • (4)
    (Local Ranking Tools)
    (local SEO software, local SEO tools, etc.)
  • (33)
    (Ranking Tools)
    (google rank checker, keyword rank tracker, etc.)
  • (5)
    (Reporting Tools)
    (SEO reporting software, SEO reporting tool, etc.)
  • (59)
    (SEO Tools)
    (SEO tools, SEO software, etc.)
  • (16)
    (SERP Tools)
    (SERP checker, SERP tracker, etc.)
  • (4)
    (Video SEO Tools)
    (SEO tools for youtube videos, SEO tools for youtube, etc.)
  • (16)
    (Website Checker)
    (domain authority checker, SEO checker, etc.)

What we can deduce from how many keyword phrases there are in each category is that people are looking for brand name SEO Tools, Ranking Tools, and SEO Tools in general. This will help you get a mindset on what the general population is looking for.

Here is an example of the top 10 phrases according to search volume. When looking at this chart you can see what is the most popular and that Brand Tools and general SEO Tools are the most searched for phrases.

Keyword Group Quick Notes Volume
Ubersuggest Brand Tools 27100
backlink checker Linking Tools 8100
keyword tool Keyword Tools 8100
domain authority checker Website Checker 6600
SEO tools SEO Tools 6600
SEO checker SEO Tools 5400
SEO analysis SEO Tools 4400
google website speed test Website Tools 3600
KWfinder Brand Tool 3600
Moz SEO Brand Tool 3600

This table below shows it sorted by groups, then the number of searches.

When you look at the above table sorted this way you will discover that the one that you want to try and rank for is ‘SEO analysis tool’. It may only receive 880 visits per month but your chances of ranking for it are greater than ‘SEO tools’.

If you remember in my article Green is the easiest to rank for then followed by Yellow and lastly Orange.

This way you can write topics that have to do with ‘SEO Tools’ and write your first article with the title being ‘SEO Analysis Tool’ then write the content for it.

The first thing you want to do is check the SERPs (search engine results pages) for the phrase ‘SEO analysis tool’. You will notice that the first positions ‘above the fold’ are nearly all ads. So you may want to consider opening up a pay-per-click campaign for this particular keyword phrase.

If we scroll down (below the fold) we see the following results. I have my Moz Toolbar and SEOQuake for SEMRush turned on to give me a quick overview.

From looking at the DA (domain authority), PA (page authority), and quick links in the SEOQuake toolbar I can see that there are a few open spots on the first page of Google that we may have a chance to rank, but it is still tough-looking competition after looking at the number of backlinks per site. Of course, you have to know the stats of your own website to compare with what shows up in the SERPs.

This brings an end to the keyword research article I wrote. The next steps would be to do some competition analysis on the websites that show up in the SERPs and find out why and how they rank then do one better than them. I hope this in-depth three-part article gives you some detailed insight into how keyword research is done and gives you some tips and ideas if you would like to do this on your own.

Sincerely,

Michael

Keyword Research in SEO: Part 2

Summary of Part 2

Putting together a list of keyword phrases, putting them through some SEO Tools and viewing the results.

Finding the Keyword Phrases from the Topic you are Exploring

Choose the right keywords for your keyword research.

Keyword Research Reports

In part 1 of “Keyword Research in SEO,” we decided to do research on ‘SEO Tools’. In case you missed it part 1 of how to pick your main keyword theme to research is located here.

In part 2 we will start generating a list of possible keyword phrases to use from numerous sources and run them through SEMRush’s Keyword Magic Tool.

Keyword Research Main Topics Statistics

If you remember we had these ideas above to work with for the main phrase. I like to color-code the background according to its difficulty to rank. That way when I have a list of a thousand or more I can quickly sort by whatever column I want and get a quick overview of everything. This makes narrowing down the list quicker.

The color-coding I created and the definition of how hard it would be to rank each keyword phrase comes from SEMRush which is what I use right now. This keyword research tutorial will also be a tutorial on how to use SEMRush’s tools as well.

From looking at the image above you can see that it is much easier to rank for ‘sem tools’ but is not searched for as much as the other phrases. You will find that the easier to rank for keyword phrases will typically be searched for less. But the good news is that when we do keyword research we can come up with hundreds or thousands of ideas that we can quickly sort by keyword difficulty, the number of searches, topic category, etc. This will help to find the gems that are searched for quite a bit with very little competition.

Also, you can look at your research overall and determine what people are interested in and looking for on a whole. Plus, you can even find out what questions people are asking and help them out by answering them on your website and gain traffic to your website at the same time.

When checking the SERPs (search engine results pages) I have found out the following:

  • SEO Tools (DA is Domain Authority and PA is Page Authority)
    • ‘Above the fold’ shows nothing but paid ads. (Above the fold means what you see without having to scroll.)
    • #1 position is a Moz blog post (High DA and PA)
    • #2 position is another Moz blog post (High DA and PA)
    • #3 position is a Backlinko blog post (High DA and PA)
    • #4 position is a Backlinko review blog post (High DA and PA)
    • #5 position is a Search Engine Journal post (High DA and PA)
    • #6 position is a Tech Radar review blog post (High DA and PA)
    • #7 position is an Ahrefs review blog post (High DA and PA)
    • #8 position is a Buffer Marketing Library post (High DA and PA)
    • #9 position is an SEO Book blog post (High DA and PA)
    • #10 position is a Neil Patel blog post (High DA and PA)
    • Then there are two more ads along the bottom

I also did a quick SERP analysis on the other main topic phrases as well and discovered they were very similar to the ‘SEO Tools’ SERP analysis.

What did we learn from this?

We learned that it is a very competitive market and it would be very difficult to rank for this phrase. Also, when I checked the other main topics I came across the same thing with the exception of ‘SEM tools’ which has a few listings in the SERPs that display lower DA and PA scores which means it would be easier to rank for this keyword phrase.

We also learned that the big companies are spending a lot of money on pay-per-click ads so you may want to consider adding that into your budget.

Did the SERP results match your goals? When looking at the SERPs the big pattern is to educate the people on what is out there for SEO Tools, giving them reviews, and explaining what they can be used for.

All the results were blog posts and reviews (2020 will mark more importance of content rather than backlinks). The examples of the SERPs with the exception of ‘sem tools’ show a large number of backlinks to the blog posts/reviews, however.

If you want to rank for ‘SEM tools’ then you can write a few decent articles and get backlinks to them then would stand a pretty good chance. But does it match your goals?

If your goal is to bring traffic to your SaaS (software as a service) company to offer them free trials for your own tools then these SERPs would align with your goals.

If your goal is to provide information for the general searcher and maybe have them sign up for your newsletter then this would match your goals as well.

Why would you want your website to rank for ‘SEO tools’? Personally I cannot think of a reason why these SERPs would not match any goals. Affiliate marketing, selling your own tools, getting people to sign up for your newsletter, promoting a service that is needed along with ‘SEO tools’, etc.

So now what?

Don’t get discouraged. Even though these are very hard to rank for we are just picking the main topic for the keyword research and soon we will have hundreds of phrases to pick from.

I will be using SEMRush’s new Keyword Magic Tool to help explain the process.

From this tool, you can quickly see the trends, volume, difficulty to rank and sort by any column which is nice. But the thing that makes this tool stand apart from others is the ability to get results between exact match, phrase match, and broad match. The addition of deleting certain words from the results to quickly narrow down your list is nice also. In the past, I used custom tools on Google Sheets to take care of this.

First, I would enter the keyword phrases in column 1

Second, in column 2, I would list the lowercase value of column 1 by using =LOWER(B2).

Third, in column 3, I would enter in phrases I wanted to exclude to narrow down the list. For example, the word ‘free’ is used to delete all keyword phrases that contain this word. In column 4, I would enter in =FILTER(C2:C, NOT(REGEXMATCH(C2:C, TEXTJOIN(“|”, 1, D2:D)))).

This would leave a list of keyword phrases that do not include any words that you entered in column 3. Below is a small example of using these formulas in a spreadsheet.

Enter Keyword List Here Lowercase List on left Enter Words to Delete Here Modified List
free SEO tools free seo tools free seo tools
SEO tools seo tools

I also added in a couple of more tools like a list of ‘Single Words before Modified List’ using =ArrayFormula(QUERY(TRANSPOSE(SPLIT(JOIN(” “,C2:C),” “)&{“”;“”}),“select Col1, count(Col2) group by Col1 order by count(Col2) desc limit 10 label Col1 ‘Single Words Before Modified’, count(Col2) ‘Frequency'”,0))

‘Single Words after Modifying’ uses =ArrayFormula(QUERY(TRANSPOSE(SPLIT(JOIN(” “,E2:E),” “)&{“”;“”}),“select Col1, count(Col2) group by Col1 order by count(Col2) desc limit 10 label Col1 ‘Single Words After Modified’, count(Col2) ‘Frequency'”,0))

Which gives me the results of how many times each word appears in your phrases to give me an overview idea on what is popular.

Below is an example of some past keyword research I did on types of flooring. As an example, it shows me that people are more interested in laminate flooring over vinyl flooring.

Single Words Before Modified Frequency
flooring 952
is 72
for 69
laminate 52
vinyl 44
to 40
near 37
can 33
with 31
me 30

This can be done for phrases as well.

Before Modified uses: =ArrayFormula(QUERY(TRANSPOSE(SPLIT(JOIN(“, “,C2:C),“, “,false)&{“”;“”}),“select Col1, count(Col2) group by Col1 order by count(Col2) desc limit 10 label Col1 ‘Phrases Before Modified’, count(Col2) ‘Frequency'”,0))

After Modified uses: =ArrayFormula(QUERY(TRANSPOSE(SPLIT(JOIN(“, “,E2:E),“, “,false)&{“”;“”}),“select Col1, count(Col2) group by Col1 order by count(Col2) desc limit 10 label Col1 ‘Phrases After Modified’, count(Col2) ‘Frequency'”,0))

Phrases Before Modified Frequency Phrases After Modified Frequency
remove_circle_outline 22 flooring for bathrooms 3
flooring for bathrooms 3 flooring for kitchens 3
flooring for kitchens 3 flooring near me 3
flooring near me 3 flooring and fitting 2
can flooring 2 flooring and installation 2
can flooring a car damage it 2 flooring calculator 2
can flooring be installed over tile 2 flooring for bedrooms 2
can flooring be put over tile 2 flooring for conservatory 2
can flooring go over tile 2 flooring for hallway 2
flooring and carpets 2 flooring for living room 2

This helps because when you glanced at the left column before the deletions and compare it to the right column after the deletions it gives you a better idea on the searchers’ intent. It turns out that the phrase ‘remove_circle_outline’ is a result of exporting data that I missed that is irrelevant.

Back to the Keyword Magic Tool

I selected ‘Broad Match’ because the phrase ‘SEO tools’ is too difficult to rank for and I would like to get ideas for similar searches.

When going over the list of suggested keyword phrases I make note of what does not apply to me and add them to the ‘Exclude Keywords’ portion when you click on the ‘Advanced Filters’ dropdown menu. You can also filter out keyword phrases that are too hard to rank for, not searched for enough times, are too expensive to bid on for pay-per-click campaigns, etc.

Filter option on SEMRush's Keyword Magic Tool

Filter option on SEMRush’s Keyword Magic Tool

I also applied the filter to only show me keyword difficulty from 0 to 60 and a volume of 100 times per month on up. This narrowed down the list considerably but I do not only rely on just SEMRush for keyword research. I get ideas from many different sources.

Then with the new list, I export the phrases to a new ‘Keyword Manager’ in SEMRush.

Manual (Non-SEO-Tool) Research

Of course, from part one of this article, I hit the Thesaurus and added the keyword phrases to my manual research.

  • SEO Tools
  • SEO checker
  • SEO software
  • online marketing tools
  • SEM tools

SEMRush’s tool gives me these phrases to add to the list.

  • SEO reporting tool
  • enterprise SEO tool
  • SEO rank tracking tool
  • group buy SEO tools
  • best SEO audit tool
  • Moz SEO tool
  • SEO tool rank tracker
  • SEO tools plagiarism checker
  • SEO website analysis tool
  • white label SEO tool
  • Etsy SEO tools
  • rank tracker SEO tool
  • SEO tools comparison
  • SEO tools plagiarism
  • Google tools for SEO
  • Neil Patel SEO tool
  • seo reporting tools for agencies
  • SEO site analysis tool
  • Shopify SEO tools

If you look at this list you can see that most of the searches are done by people looking for more information to purchase or use a subscription service. Keep that in mind.

Ubersuggest

Ubersuggest was taken over by Neil Patel but I still use their tool. They have added a few more nice options to it. You still have the option for limited information for free which is what I do because I am just going to plug in the phrases into my SEMRush tool to get the statistics.

Oops, it looks like you can no longer export the keyword phrases and when you try to copy and paste them into a spreadsheet it does not format right so it looks like I will delete this from my arsenal of free tools.

Google Keyword Planner

Next on the list is Google’s Keyword Planner which you should not trust the volume numbers for. I have found them to be way off.

I ended up with 1,951 keyword phrases to go through. Time to use the quick deletion tools I described in my spreadsheet. You can use the formula =unique(F2:F12088) to delete the duplicates.

Or you can add these keyword phrases to the SEMRush Keyword Manager tool. I’m glad they have this advanced filter here as well. Otherwise, I would have to take a lot of time going through these manually. Now I can just import this into their tool, lower my time, and pass the savings to my customers. The Keyword Manager Tool does have a limit of 1,000 keyword phrases to add per project so I just create extra projects, delete out the bad keyword phrases, then add them to the original project folder. Then deleted the other folders I used. This is a little bit of a hassle but it still saves me a ton of time.

After I deleted the phrases with the word ‘free’ in it, are searched for less than 100 times per month, and deleted the ones with a keyword difficulty of higher than 60 I ended up narrowing down the list from 1,951 to 847.

Google Trends

Next, I’m going to Google Trends where I will get an overview of what is trending for the phrase ‘SEO tools’ and get more keyword phrase ideas. I have found out that the searches and trends for SEO tools are going up and not going away any time soon. If you follow the Google Trends link you will discover which states it is the most popular in, which can help you for targeting your pay-per-click campaigns. At this time New York seems to be the big winner. Surprisingly only one phrase popped up for suggested phrases to use.

SEOBook

Next on the list is SEOBook where I have been a member for 10 years and 11 months (it reminds me whenever I log in). Aaron writes great articles here if you are interested. This tool returned 394 entries which I will add to the Magic Keyword Tool and filter out the ones that I do not want.

Google Suggested Search

Now I will be using Google Suggested Search. This resource is an excellent resource because according to Google’s search engine it shows what related phrases people are searching for and you can get an idea of what is on people’s minds when they search for ‘SEO tools’.

Google is spending a ton of money on artificial intelligence research so it is a good idea to use this. At the bottom of the page, you are given eight suggest phrases to also search that is the most relevant. Then you can click on each of those eight phrases to get eight more phrases that are relevant to the one that you just clicked on. The further you click the further you get away for ideas on ‘SEO tools’. You will find some duplicate phrases as you click deeper so I open the links in a new tab and copy and paste the relevant ones. How deep you go will depend upon what results you get. I usually do not go deeper than three clicks.

You can see how it progresses after a few clicks.

1st click 2nd click 3rd click
cheap seo tools seo checker google seo checker
open source seo tools seo software seo ranking checker
seo tools and their uses keyword tool best seo checker
seo tools meaning what are seo tools seo value checker
top 5 seo tools buy cheap seo tools seo audit
open source seo tools php seo friendly website checker
seo software meaning
seo softwares list
moz seo
seo powersuite
best seo tools
wordstream keyword tool
how to find keywords
buy ahrefs cheap
flikover group buy
group buy internet marketing tools
group buy seo tools coupon
group buy seo tools reviews
groupbuyseotools.org review
seo group buy india
seo tools package
open source seo audit tool
php seo script open source
seo audit open source
seo checker open source
seo panel demo
seo panel review

Ask.com

I still use the suggested results from here because from time-to-time Ask.com gives me some ideas that the other sources do not. When I look at the results they did not disappoint me there are a lot of fresh ideas here as well such as SEO tools for excel. You can click deeper than the first click like Google’s search results as well. The phrase ‘SEO tools for excel’ opened up a whole new avenue to explore. I’ll be clicking deeper for that one. I added 33 good phrases from here.

Yoast Suggested Phrases

Yoast makes a great SEO plugin for WordPress that I use quite a bit. There is a free version along with a paid version of the plugin. This has become one of my sources for hunting down keyword phrases as well. When you visit this site it will resemble what the old Ubersuggest used to look like so I will just use this one instead of the Ubersuggest I used to use above. It gives you results that are separated by category. This one returned 245 results.

Here is a quick tip for you. Sort the results alphabetically to quickly delete some irrelevant phrases. Also, you can enter this as a formula to quickly delete duplicates.

=unique(F2:F11253)

Note: (F2:F11253) is the range of cells that you examine to delete any duplicates. You will have to change it to what matches on your spreadsheet.

Answer the Public

Answer the Public is one of my favorite resources. You input a term and it will spit out a ton of phrases that are related to questions. It also has a version like the old Ubersuggest where it returns non-question results by the alphabet.

I liked it so much that I even created some formulas in Google Sheets that will help narrow down the list quickly. Here they are.

Question?
=IF(RegExMatch(A2,“(?i)who |what |where |when |why |how “),“YES”,“NO”)

Possible Questions
=IF(RegExMatch(A2,“(?i)are |which |will “),“YES”,“NO”)

Possible Preposition Questions
=IF(RegExMatch(A2,“(?i)can |for |is |near |to |with |without “),“YES”,“NO”)

Possible Comparisons
=IF(RegExMatch(A2,“(?i)and |like |or |versus |vs “),“YES”,“NO”)

You will find that when you research questions that a lot of them will get deleted from the list because the search volume on questions always seems to be lower than non-questions. So I give these results some slack for volume when I add them to my main list. To me, they are more valuable than non-questions.

This website returned 592 results that 140 are possible questions to use. Here is a small snippet of what it looks like in my spreadsheet. You can sort the columns to display the yeses at the top. It makes sorting through it a lot faster. For example, the first keyword phrase, “are SEO tools worth it” is obviously a question that did not use who, what, where, when, why, or how but the next column ‘Possible Questions’ picked it up.

Keyword Phrase Question? Possible Questions Possible Preposition Questions Possible Comparisons
are SEO tools worth it NO YES NO NO
what are SEO tools YES YES NO NO
are Bluehost SEO tools worth it NO YES NO NO
what are the SEO tools do you use YES YES NO NO
what are best SEO tools YES YES NO NO
what are Bluehost SEO tools YES YES NO NO
what are SEO audit tools YES YES NO NO
how SEO tools work YES NO NO NO
how SEO tools work YES NO NO NO

Keyword Phrases are Compiled

3,239 keyword phrases were discovered now I will begin narrowing down the hard to rank, low volume, irrelevant, etc. The list was still very large so I ended up deleting anything with a search volume of 200 or less. So far I have it narrowed it down to 551 keyword phrases.

In the next article, I will go over narrowing down your results.