Welcome back in the last video, we looked at keyword match types and why they're so important.
However, in this video, what I want to do is to show you how you can add those match types so all
of the keywords you have in your keyword research template.
Now I just want to confirm as well that I have actually padded out this keyword research template a
little bit more from when you last saw it in the last video, which if you remember, we actually had
one theme for the word room.
However, now I've split this up into two different themes.
One for large room and one for small room.
And I've also added another theme for Hunter.
Now, the reason why I split it up the keywords into two different themes for room is because when I
was actually going through all of the keywords, I noticed there was lots and lots of keywords unrelated
to large ceiling fans.
You got a large ceiling fans, large ceiling fans, large indoor ceiling fans, large room, large,
large, large and large.
So basically what I noticed was the word large was appear in a lot, and we also had quite a few mentions
for the word small.
Best ceiling fan for small rooms, small room ceiling fans, small room flush mount ceiling fans and
so on and so on.
So it made more sense to split these up into two different themes.
As someone who owns a large fan is going to be different to someone who wants a small fan.
So this just goes to show that even though you think you may get it right when it comes to determine
how many themes you have unless you really go for the keywords in an immense amount of detail, you may
not initially always end up with the correct amount of themes, which is actually really good to stress
because I do get a lot of questions from students saying How many themes should I have?
How many keywords should I have in each theme?
Well, there isn't any perfect number, and there isn't any way to know unless you start actually going
through the keyword yourself.
And please do not rush this as this keyword research process is so, so key.
If you get this wrong, well, what happens, which in my instance, I could have all of these keywords
talking about large and small fans, all in the same theme, which means I can't speak to any of these
people on a specific level and actually crop my ad text to what that person is after.
Whether that's a large ceiling fan or a small ceiling fan.
So more of the story is make sure you do not rush this process and you can have as many themes as relevant
and include as many or as little keywords in those themes as relevant as well.
So now we got that out of the way.
Let me show you how you can add your match types to the keywords you have in your spreadsheet.
So let's go with the large ceiling fans as our first theme.
Well, what you could actually do is add some advanced formula and tell excel to copy this keyword and then
paste it into the next column and then add the speech marks.
Add brackets to create your keyword match types.
However, you're way better off just using a free online tool to do the process for you.
So remember, there are three different keyword match types.
We have the broad match, which is essentially just going to be your keyword as it is.
Then we have the phrase match and we have the exact match match types so we can use this tool right
here called merge words.
The URL for this page is Toptal.com/marketing/mergewords
I will actually include a link to this in resources for ease.
Essentially, all you need to do is take the keywords from one of your themes, so I'll be using the
ceiling fans for a large room theme.
For the example of this training video then we want to do is go back to the tool, paste in all of your
keywords and we can see we have 23 in total.
You then want to click extra options.
And what this will do is give you options to add EVA speech marks or brackets to all of your keywords.
And of course, the speech marks are going to be your phrase match keywords and the brackets is going
to indicate your exact match keywords.
So let's go for the brackets and then click Merge.
And as you can see, it's now generated all of our keywords below and added a bracket at the start at
the end of each keyword.
So these are all of our keywords, which you can then add in our Google ads account.
So let's go ahead and copy all of these.
But before we actually go ahead and copy them into our Google ads account, what I like to do is actually
go ahead and add them back to our keyword research master template just to make sure we have all of
our keywords in one place.
You can actually replace the keywords as you have at the top, because, like I said, most people won't
be using the broad match keywords, which are basically your standard keywords.
However, if you want to keep them for reference, just go ahead and pasting your exact match keywords
below like so.
So now let's go back to the tool and do exactly the same thing, but let's get a phrase match keywords.
So let's simply change that to this icon right here.
Click Merge.
And then just like that is added, the speech marks at the start and at the end of each keyword once
again will copy.
That will go back to our spreadsheet and then paste them in like so and you are going to notice that,
hey, for some reason the speech marks are actually missing, and that is to do with a conditional.
Format in Excel.
So to get your speech marks to appear, what you need to do is select all of those keywords and then
go to general at the top and then go to more number formats.
Then go to custom and delete general.
And then what you want to do is paste in this little formula.
Right here, I've zoomed in as much as I can, so you can see it.
But basically, it says backslash speech mark the @ symbol, backslash and speech mark again so that she
just copy that, go back to excel and then paste it in.
So just confirm it, says backslash, speech mark, @ symbol, backslash and speech.
Mark once again click OK.
And as you can see, is now added speech marks at the start and end of each keyword.
So that is literally how easy it is to add your keyword match types.
So all of your keywords.
Like I said, a lot of people like to complicate this process.
Add in all these amazing advance formulas and whatnot.
I mean, if you are good at Excel, feel free and go for it.
But I like to work smart instead of hard.
And this is by far the easiest way to add these match types.
So once you've added all of your match types, the next thing to do is to copy all of these match types.
I'll take the exact match and I'll take the phrase match.
I'm going to leave the broad match ones at the top.
As, like I said, that is going to result in Google showing my ad to tons and tons of searches, which
probably even related to what I offer.
Then once you've copied all of your keywords, you want to go back into your Google Ads account, find
your campaign, which is the one we created right here for domestic fans.
So going to that campaign, you can now see that ad we created earlier for ceiling fans.
However, since we've done our keyword research process, it's become very apparent that we're not going
to have one ad group for ceiling fans, as of course, there are multiple themes for ceiling fans.
So I'm going to do is simply rename this ad group now and we'll call it ceiling fans for large rooms
will go for.
So here we have ceiling fans for large rooms.
Then why don't you done that?
You want to go into that ad group?
Click the plus icon right here to add your keywords and then simply paste in all the keywords we already
have, and they already have all of the perfect keyword match types next to them.
So go ahead and click Save.
I think Google is going to add all of those keywords to that ad group within that campaign.
Now this is going to be a really, really targeted ad group as essentially every single keyword in this
ad group is all to do with large room ceiling fans.
So guess what?
When it comes to writing my ad text, I can speak 100 percent to people who are looking for large ceiling
fans.
This is the beauty you have when you spend quite a lot of time in your keyword research process.
Essentially, the more time you spend here, the easier is going to be for you to create ads and actually
generate the best results from your ads as well.
So that is the whole process in a nutshell.
And essentially what you want to do is go ahead and do exactly the same thing for all of the other themes
you have for your Google Ads campaign as well.
Before we move into the next part of the course and start creating our ad text, I want to cover one more
really, really important thing when it comes to keywords and that is what we call negative keywords.
So in the next video, I'll be covering just that.
Please be sure not to skip that one and give it a watch as it's going to save you tons and tons of money
when it comes to running Google ads.
I'll see you in the next video.