Screenshot of the keyword spreadsheet

[kexej28769@nongnue]

Now, the real magic begins.

After a lot of research and poking around, I discovered a function in Google Sheets that tells us if a stem or term is in a keyword. It uses RegEx:

=IF(RegExMatch(A5,"health"),"YES","NO")
It just tells us whether it is a word stem or a word in that keyword. You have to set the term individually for each column to get your "yes" or "no" answer. Then I drag this formula down all the rows to get all the yes/no answers. Google Sheets often takes a minute or more to process all this data.

Next, we need to "hardcode" these formulas so venezuela number data we can remove the NO and be left with only YES if those terms are present in that keyword.

Copy all the data and "Paste values only."


Screenshot of the spreadsheet menu
Now, use "Find and Replace" to remove all NO.

Screenshot of the Find and Replace popup

What you're left with is nothing short of a work of art. Now you have the most powerful way to group your keywords. Let the grouping begin!

Screenshot of the keyword spreadsheet


Part 5: Keyword Grouping
At this point, you are now set up for keyword clustering success.

This part is half art, half science. No wait, I take that back. To do this part correctly, you need:

A deep understanding of who you are targeting, why they are important to the business, user intent, and relevance
Good decision to make when separating keywords into groups
Good insight
This is one of the hardest parts for me to train anyone to do. It comes with experience.