If you have finished the keyword research process, it’s a good idea to go through the spreadsheet and remove any irrelevant or duplicate keywords.
As I’m not sure about you.
But when it comes to keyword research, I get super excited.
I come across a great keyword and I’m like, yeah, let’s talk about on the spreadsheet.
I’ll come across some more keywords.
They’ll get added.
It goes on and on and on.
And before I know it, I’ve got tons and tons of keywords on my spreadsheet.
which, as you can imagine, makes your life a little bit harder when it comes to reviewing all the data as the more keywords you have, the more data you have to review.
Remove Irrelevant Keywords
So it’s always best practice to just clean up the spreadsheet and make sure that all the keywords you have on it are indeed relevant to your website.
So, for example, without even scrolling, I can see an irrelevant keyword right here on row 27, ” travel yoga mat, Amazon “
Now, there’s search content behind this keyword obviously relates to Amazon.
If someone types in ” travel yoga mat Amazon ” then they are looking for a travel yoga mat that is sold on Amazon.
As we all know, Amazon, then this is not really a good Keyword to have on a spreadsheet as it’s not relevant to our website.
So let’s go ahead and see if we have any other keywords which reference the word Amazon.
So to do that is very easy.
- Just go over to our filters again.
- change that to containers.
- simply enter the word Amazon.
And as you can see, we have a few more occurrences of keywords that mention the word Amazon.
So all I’m going to do is simply delete these from our spreadsheet as like I said, these are not relevant.
Then let’s go back and clear that filter.
And that should have removed all the keywords which mention Amazon and exist on that because we have clear gaps in our row.
So just blank rows with a keyword was initially and that’s really good.
And again, it’s kind of the same process.
You just go for your keywords, see which ones are relevant and which ones are not relevant, and simply get those removed from a spreadsheet.
Remove Duplicates
Now, when it comes to removing duplicates, the thing I like to do is go to the top of the spreadsheet, make sure you go to data, and then filter by A to Z.
And what this is going to do is show you all the keywords in alphabetical order.
And any time you see a duplicate keyword, you simply just remove it from your spreadsheet.
For example, I can see a duplicate on rows 26 and 27 and Hislop Yoga Matau, let’s go ahead and delete one of those.
Scroll down and see if you can find any more.
These look pretty similar, but a little bit different.
We’ve got two cheap yoga mats.
So again, let’s delete one of these and hopefully get the idea here.
You just go through all of your keywords and remove all of the duplicates.
Now, this applies to your theme types as well.
So where we have towels, you can see we’ve got tons of keywords.
It would be exactly the same thing, filter by A to Z, remove any duplicates that you have.
So we’ve got better yoga mat out here and we’ve got it here again.
So of course we need to remove one of them so it’s no longer a duplicate and go for the same thing for all of your tabs.
And of course, check the tabs as well to see if you have any relevant keywords such as Amazon, maybe keywords like this Australia.
Maybe you’re not targeting Australia, maybe you’re based in the United States and you only serve the United States.
So if that is the case and this is obviously going to be an irrelevant keyword, so it is really important to do.
Please do make sure you take quite a bit of time going through your keywords as is going to make your life so much easier when it comes to doing the SEO.
