To start, you want to sort the sheet by word stem.

[kexej28769@nongnue]

At the top of the sheet, I use the COUNTA functionدکھانے کے لیےhow many times the word step is found in our keyword set:

=COUNTA(C3:C10000)
This is important because as a general rule, it's best to start with the most specific topics that have the least overlap with other topics. If you start too broadly, your keywords will overlap with other keyword groups and you'll have a hard time breaking them down into meaningful groups. Start with the most narrow and specific groups first.



Word stems that occur only a handful of times venezuela number data don't have much overlap. So I start by sorting the sheet by this column, and copying and pasting those keywords into their own new tab.

You now have your first keyword group!

Here's a first group example: the "Match" group. This could be its own project: For example, if a website was about Matcha Tea and had other tangentially related keywords.



Screenshot of a list of keywords related to matcha


As we continue to break down one keyword group and then another, we end up with many different keyword groups. If the groups you arrive at are too broad, you can break them down into more narrow keyword subgroups for more focused content pieces. You can follow the same process for this broad keyword group, and make it a microcosm of the same process of dividing keywords into smaller groups based on word stems.

We can create an overview of the groups to see volume and situational opportunities from a high level.



Screenshot of a spreadsheet with a keyword group overview