Instructor: In this video, I'm going to show you
how you can thematically categorize all of your keywords.
Which as I mentioned in the last video,
is going to make your life a whole lot easier
when it comes to adding your keywords
in your Google Ads account.
However, before we do that, what we need to do
is remove the duplicate keywords.
So as you can see, we have ceiling fans right here,
we've got ceiling fans up there as well.
So the reason why we had the same keyword
mentioned multiple times is because this list
you're looking at right now is our master file,
which has a list of keywords from multiple sources.
So as a result, naturally, you're going to have an overlap
with some of your keywords.
So first things first, let's remove the duplicate keywords.
So to do that, you want to select the whole column.
And then simply go over to conditional formatting,
and then go to highlight cell rules.
And then scroll down to duplicate values
and give that a click.
And then simply click OK.
And now what's going to happen is that every keyword
that is a duplicate is going to be highlighted in red.
So what I like to do is select the whole column
and then go to data,
and then sort that by A to Z.
So that's gonna sort all the keywords in alphabetical order.
And that way, we can easily see
which keywords are duplicates.
For example, row number 29
and row number 30 are both duplicates.
So what I want to do is simply delete one of the keywords.
And now that's going to get rid of the red highlight,
as that keyword is no longer a duplicate.
So I'm going to go through the whole list now
and remove all of the duplicate keywords,
and speed up the video
so you don't have to wait for me to do it.
And just like that,
I've now removed all of the duplicate keywords.
It's good to note as well, that I did do
some further keyword research and actually added
some more keywords to this research tab,
just so I have a decent keyword size list.
Which means when I go through the data,
it should be a little bit easier for you to understand
as I'm going to give you more examples.
But essentially, it's the same keyword list.
I've just added in more keywords
by using the same keyword processes I've already showed you
in the last two videos.
So the next thing to do, once you've removed
the duplicate keywords, is to remove the unwanted keywords
onto a separate tab.
So what I mean by the unwanted keywords
is literally any keyword which you believe
is not a good fit for your website.
So if I scroll down,
let's see if we can find any unwanted keywords.
I do scroll really fast, apologies about that.
We've got some keywords right here.
So how big of a ceiling fan for a 12 by 12 room?
Let's make it a bit longer, so you can see all the keywords.
How big of a room for a 52 ceiling fan?
How does a ceiling fan cool a room?
So these type of keywords
are what are called question-based keywords.
Now if you remember what I said in the video on keywords
and keyword intent, these keyword
in regards to the AIDA model
is going to be pretty low down in the funnel.
Someone who types in, how does a ceiling fan cool a room?
What this tells us is that this person isn't quite sure
they need a ceiling fan.
So the search term they searched for in Google
is actually a question.
So as a result, I don't want this person to see my Google Ad
because if they do, they could potentially click my ad,
cost me money and they might not even buy a fan.
So what I want to make sure I do is target keywords
that have a higher buyer intent.
This keyword, how does a ceiling fan cool a room?
This has really low buyer intent.
But instead of just deleting this keyword from our list,
what I want to do is move these unwanted keywords
onto a separate tab called negative keywords.
So I'm going to go through what a negative keyword is,
in a couple of videos later down the line.
So don't worry about that.
But just for now, all we need to know is that we need
to move all of these keywords
onto another tab called negative keywords.
So what I'm going to do is simply go back
to the top of this column, I'm going to add a filter.
And I'm simply going to tell Excel
to show me all the keywords, which contain the word how.
As every keyword that has the word how in it,
indicates it's going to be more of a question,
which means it's going to have low buyer intent.
So as you can see, I've done my filter like so.
And as a result, I now have all of my keywords
which contain the word how.
So what I'm going to do now is copy all of these keywords
and simply copy it over
onto the negative keywords tab, like so.
Once I have it on a separate tab, I am free to delete it
from our main master file.
So I'm free to delete these now.
I don't wanna see any of these keywords.
The reason why I can delete them now,
is because I already have the data
all stored on another tab.
Now it's a good idea to clear your filter
and actually go through the rest of your keywords,
as you might see some other keywords
which also aren't relevant.
So the keywords we removed at present,
is just going to be all the keywords with the word how.
However, we can have a lot of keywords as well
that are also questions, that start with the word what.
So let's go back to my main tab,
go to the filter right here.
Again, if you don't know how to add a filter
on your keywords, I'll show you exactly
how to do that step-by-step.
I did go through that a pretty bit fast,
in that first instance.
But essentially, you need to make sure
you're on the data tab.
You want to click the whole column
and then go to filter.
And then click the arrow and make sure
you choose the word contains.
So I've already done it for how.
So I'm going to do what,
see if there's any keywords that say what.
And as you can see, there's quite a few keywords here.
So what size ceiling fan for a living room?
Again, these are keywords with low buyer intent.
So I wanna get these moved across
to the negative keyword list, like so.
Now they're copied across, I can delete them.
I wanna clear my filter.
I wanna have another look through the keywords,
just to make sure I don't see any more.
Can you hang?
Can you hang a ceiling? Okay, so this is a different type
of keyword we can add.
Can you hang a ceiling fan? Again, low buyer intent.
People are just trying to find out about the product.
Can it do this?
I only want to target people
who are ready to buy my product.
Because if I target just those people, then the conversions
from our overall campaign is going to be a lot higher.
So let's add that filter again, let's go to the top,
click the arrow and then go to contains.
And then put in the word can.
And as you can see, we now have all the key words
which contain the word can.
So let's copy all of these keywords.
Go over to negative keywords and paste them in like so.
So let's go back to that and delete that now.
So essentially, it's the same process
for all of your keywords.
You wanna go through your list and just kind of figure out
what keywords aren't relevant to your business,
and then simply remove them onto a negative keyword list.
So for the purpose of this training video,
let's just imagine I've gone through the whole list
and I've now removed all of my keywords that aren't relevant
over to the negative keyword list.
The next thing you need to do is go through your keywords
and see if you can spot any keyword themes.
What I mean by keyword themes,
is keywords that are all similar in some way or another.
So for example, we have a keyword here,
three blade ceiling fan with light.
We have 42 ceiling fan with light.
42 inch ceiling fan with light.
52 ceiling fan with light.
52 inch ceiling fan with light.
So you can see, light appears quite a lot.
So as a result, one of my keyword themes
are going to be light.
As all of these keywords have a relation to the word light,
so that is going to be a main theme for me.
If we keep scrolling down and see what other things
we can come across, we've got lights.
We've got fans, which is pretty generic.
We've got ceiling fan dimensions, room.
We've got room again.
We've got room room, room, lots of room.
So I think I'm going to go to the top and add another theme
for the word room, like so.
Let's scroll down and see what else we have.
We've got lights, we've got remote potentially.
Remote control could be another one.
We've got lights, we've got rooms again,
which I've already covered.
We've got living rooms, we've quite a lot of keywords
for room and light, which is interesting to see.
Let's scroll down and see what other keywords we have.
We've got hanging in the ceiling,
hanging ceiling fan without box.
Hanging ceiling from a plastic box.
Lots of interesting searches here.
People were Googling hanging ceiling fan
from a plastic box, quite interesting.
We've got who's home Depot.
Okay so essentially, as you can see,
the whole process I'm trying to do here
is literally go through all of my keywords
and see if I can spot any similar themes.
So I did notice remote control came up.
So I'm gonna go to the top
and simply add that as another theme.
And I do believe that is enough themes for now,
just for the purpose of this training video.
So once you've categorized your main themes,
you could have one theme, you could have 50,
there's no right or wrong answer.
You simply need to go through all of your keywords
and list out the most obvious themes.
So once you've done that, the next step is to create a tab
for each theme you just found.
So the first theme for me is going to be light.
So what I'm going to do is create a new tab.
Let's move the tab to the end,
and I'm go to rename this tab,
lights and I'll put ceiling fans.
Ceiling fans and lights.
And then I'm simply going to go back to my main master file,
click my filter, choose the word contains.
And simply put in my theme, which is going to be light.
And now it's going to show me all of the keywords
which are related to the theme of light.
So what I want to do is copy all of these themes
or keywords, sorry.
And go over to this tab and simply paste them in, like so.
Let me just zoom in a little bit
so you can see all these keywords.
Like so, and I'll put in keywords at the top.
Like so, and I'll double-click that
so you can see all the keywords.
And I simply want to do the same thing
for all of my other themes as well.
So let's come off that and clear those filters.
The next theme is going to be for room.
So let's go back on that.
Contains one and contains the word of room.
This is now going to show me all of my keywords,
all to do with the theme room.
So let's copy all of these keywords again
and simply paste that back on another tab.
Which this tab is going to be called ceiling fans room.
So ceiling fans room, like so.
And paste that out there.
Ctrl + V. For some reason, that didn't seem to copy.
Let's do that again, Ctrl + C.
Go back to that, Ctrl + V.
There we have all of our keywords
and I'll put in the word keyword at the top as well.
Bold that and we'll zoom in as well on that.
So what we're doing right now is simply putting all
our keywords, which are thematically related all on one tab.
Which is going to make it so easy when it comes to adding
all of these keywords into our Google Ads account
and in its separate ad groups.
Now once you've created all of your tabs
for all of your themes, it's always a good idea
just to go through the tabs and look at the keywords
and just see if there's any more keywords
you forgot to remove.
Or maybe ones that you just originally missed off.
It's a lot easier to review your data when you're looking
at it on a separate tab for your keywords.
As all the keywords you're looking at on these
individual tabs are going to be related to that theme,
so you can very easily spot ones that shouldn't be there.
For example, we have 12 by 12 room ceiling fan.
That is a good keyword.
We have 44 inch ceiling fan room size,
which if you think about the intent behind this keyword.
If someone Googles 44 inch ceiling fan room size,
then essentially what they're trying to figure out
is what size room can a 44 inch ceiling fan
provide sufficient coverage?
So this probably isn't a keyword you want to target.
So what I'm going to do is copy this keyword
and put it on the negative keyword list.
So make sure you do spend some time
going through all of your keyword themes.
And make sure you don't have any keywords on your tabs
which you shouldn't have, as it's only going to make
your life a little bit harder
when it comes to creating your Google Ads.
So once you've cleaned up your keyword research spreadsheet,
you do not want to go ahead and copy these keywords
straight into your Google Ads account.
What you want to do is add the correct keyword match types.
So I'm gonna go through keyword match types
in the next video, and explain every single thing
you need to know.
I'll see you there!