00:00:00
hi and welcome to this video tutorial
00:00:01
where I'm going to show you how to
00:00:03
automate and simplify your keyword
00:00:05
research making it extremely cheap and
00:00:08
affordable for you to do every time with
00:00:10
this keyword research automation I can
00:00:12
easily get a lot of data from these
00:00:14
starting keywords for example let's take
00:00:16
learn SEO as an example we've got uh all
00:00:20
of the top ranking results for that
00:00:22
keyword in the location that I've
00:00:24
selected I've got keyword suggestions
00:00:27
for that original keyword that
00:00:29
essentially are variations of longer
00:00:31
tell keywords of the original one and
00:00:33
I've also got keyword ideas which are a
00:00:36
little bit more broad ideas of that
00:00:38
keyword with all of these though I'll
00:00:41
also have the monthly search volume the
00:00:43
competition whether it's low medium or
00:00:45
high the cost per click how much it
00:00:47
would cost me to run ads for that and
00:00:50
the search intent for that keyword I'm
00:00:54
going to show you how to do all this
00:00:55
with make and we're going to be using
00:00:58
the API from data for SEO which is going
00:01:01
to be your predominant data set for this
00:01:04
why are we using data for SEO well
00:01:07
probably 95% of all SEO tools that you
00:01:11
might use are actually using data for
00:01:13
seo's API and then they're handing the
00:01:16
cost plus some over to use so in this
00:01:19
instance we're going to go directly to
00:01:21
the source and use data for SEO it's
00:01:23
going to immensely lower the cost for us
00:01:26
and we can only and we can just do a pay
00:01:29
as we go kind of thing we don't have to
00:01:31
apply for a subscription using the link
00:01:34
below to sign up for data for SEO you're
00:01:36
going to get some free credits a dollar
00:01:37
worth of credit you might think that's
00:01:39
not a lot but it's going to be more than
00:01:41
enough doing all the keyword research
00:01:43
that you're going to need for today if
00:01:44
you don't know me my name is Niko I run
00:01:46
an online community called the AI
00:01:48
ranking School Community where we
00:01:50
simplify SEO and we help you maximize
00:01:52
search engine optimization with AI tools
00:01:54
and automations just like the one I'm
00:01:56
showing you today there is a free
00:01:58
community and a premium Community if you
00:02:00
want to just kind of start off with and
00:02:02
maybe get your toes wet into how to do
00:02:05
SEO with AI you can start with a free
00:02:07
community and then in the premium
00:02:09
Community we've got a lot more support a
00:02:11
lot more premium stuff but I'll let you
00:02:12
check that out at your own time all the
00:02:16
assets that I'll be talking about in
00:02:17
this video will be obviously Linked In
00:02:19
the description below again there's
00:02:21
going to be a couple of tools we need
00:02:23
for this you obviously need Google
00:02:24
Sheets you need make the automation
00:02:27
software if you don't have that again
00:02:28
I'll leave a link for you to start that
00:02:31
we're going to need an account for data
00:02:33
for SEO you're going to sign up with a
00:02:36
link on data for SEO it's going to take
00:02:38
you to a dashboard like this except your
00:02:40
balance is just going to have $1 which
00:02:42
is what they give you right away you're
00:02:45
going to go to API access and you're
00:02:47
going to understand this API login which
00:02:51
is just going to be your email and you
00:02:52
should have an API password in here
00:02:54
which you're going to copy if you don't
00:02:57
and it just says send by email you're
00:02:58
going to click that and you're going to
00:03:00
save that little password which they
00:03:02
send by email because we're going to
00:03:04
need it in a second so the first thing
00:03:06
to do is to make a copy of the Google
00:03:08
sheet template that I've provided for
00:03:11
you below when you make a copy of that
00:03:13
and it's in your Google sheet and your
00:03:15
Google uh Drive sorry you're going to
00:03:17
have three little sheets that say
00:03:19
initial keywords the one the I'm on now
00:03:22
the template for keyword suggestions
00:03:24
template for keyword ideas and the
00:03:26
template for the search engine results
00:03:28
keyword results in the initial keywords
00:03:31
you won't have anything here but I want
00:03:33
you to fill this out with me so you can
00:03:35
use whatever you want whatever keywords
00:03:37
you need to search for I'm going to do
00:03:38
the same ones again learn SEO the
00:03:41
location I'm going to go United
00:03:45
States and the language I'm going to go
00:03:50
English the they have over 150 locations
00:03:54
available and many languages you can
00:03:56
look at the data from data for SEO to
00:03:59
see if if your country is within the
00:04:01
locations that they offer so with these
00:04:04
set the starting keyword the location
00:04:06
and the language we're set to go you're
00:04:08
going to go to make and you're going to
00:04:10
start a new scenario the first module
00:04:12
we're going to do is Google Sheets and
00:04:14
we're going to search a row just type in
00:04:17
search this one
00:04:19
here perfect and obviously we need to
00:04:22
find the Google sheet that you just
00:04:25
copied uh the spreadsheet ID here I'm
00:04:27
just going to look for it I know it's
00:04:28
called Data for SEO template example
00:04:32
that has been misspelled but that is
00:04:34
okay the sheet name is really important
00:04:37
here you're going to select the initial
00:04:39
keywords this refers to this one here
00:04:42
not that one but the initial keyword
00:04:44
where we're placing the keywords that we
00:04:45
want to search for everything else we're
00:04:48
going to leave as is the next thing
00:04:51
we're going to add is the first data for
00:04:54
SEO module which is going to be the get
00:04:56
keyword suggestions so you're going to
00:04:58
look for data for SEO and it's this one
00:05:03
here when you initially want to connect
00:05:07
it to your make account it's going to
00:05:08
ask you for the ID and the password and
00:05:11
again I showed you where to get these
00:05:14
the ID you need to go to API access the
00:05:17
API login is your email and the API
00:05:19
password is the one that you should have
00:05:20
received by email if you clicked on this
00:05:23
button once you create the connection
00:05:25
that's the only time you're going to
00:05:26
have to do that so we're going to get uh
00:05:29
key word
00:05:31
suggestions
00:05:34
here and now we start inputting the data
00:05:37
from the previous module meaning from
00:05:39
our Google sheet the location we've got
00:05:42
here uh B the language is C and the
00:05:46
keyword is a so again we're just mapping
00:05:49
these components
00:05:51
here uh the limit I don't want to go
00:05:54
crazy I just want to do 10 meaning I
00:05:56
just want 10 keyword ideas you can do up
00:05:58
to 10,000 if they exist but I'm going to
00:06:02
go to okay
00:06:04
perfect now what do I want to do well
00:06:07
keyword ideas I'm going to copy this
00:06:11
template you can't just fill this one
00:06:13
out if you're only doing this for one
00:06:15
keyword that's fine but I want to show
00:06:17
you how to duplicate it so this becomes
00:06:18
an incredibly useful tool which we can
00:06:21
reuse and reuse so we're going to copy
00:06:23
this template of keyword ideas or
00:06:26
keyword suggestions sorry the first one
00:06:28
that we're going to do
00:06:30
so we're going to go to Google Sheets
00:06:33
and you're going to search for copy and
00:06:36
you're going to copy a
00:06:38
sheet you need to select
00:06:41
which uh sheet we're copying obviously
00:06:43
so I need to find the original one which
00:06:46
is data for SEO the sheet ID is going to
00:06:50
be this one here template keyword
00:06:52
suggestions and now where are we placing
00:06:55
this well we're placing it in the same
00:06:57
sheet you can place this in a new Google
00:06:59
sheet if you want but for this example
00:07:01
I'm just going to choose the same one
00:07:04
it's going to look a tiny bit messy in
00:07:06
the end but you can fix it however you
00:07:11
want data for SEO and the sheet name
00:07:15
this is really really important so we're
00:07:17
going to go keyword
00:07:20
suggestions we're going to put the
00:07:22
vertical line and then or whatever you
00:07:24
want but then you need to select the
00:07:25
original keyword starting keyword there
00:07:28
this will be very very important for
00:07:30
later down the track in our
00:07:33
automation now because the way the data
00:07:36
for SEO gives us 10 data sets or 10
00:07:40
keywords and a bunch of information
00:07:42
about that keyword in the one we need to
00:07:44
create a iterator loop between the to be
00:07:48
able to place all those keywords in the
00:07:50
one go in the data set so we need to
00:07:53
press the iterator don't worry if this
00:07:55
doesn't quite make sense you just copy
00:07:57
step by step what I'm doing and it will
00:07:59
in a second so the array here we need to
00:08:03
look at the module previous the data for
00:08:05
SEO we're going to go to tasks we're
00:08:08
going to go to results we're going to go
00:08:10
to items that last one there and we're
00:08:13
going to select that
00:08:15
one going to go to okay cool we're
00:08:18
nearly there now we just need to add a
00:08:20
row in the Google sheet that we created
00:08:23
all in this sheet that we just
00:08:26
created going to go to the module Google
00:08:29
sheet
00:08:30
add a
00:08:31
row find the oh before we do even find
00:08:35
the ID this is very important the search
00:08:38
method we're going to enter manually
00:08:41
because we've created the new name of
00:08:44
that new sheet it's not actually going
00:08:46
to be able to record that or find that
00:08:48
automatically so we need to place that
00:08:50
ourselves the spreadsheet ID we've got
00:08:52
that already in the previous module the
00:08:54
first one spreadsheet ID the sheet name
00:08:58
if you remember this correctly it needs
00:09:00
to be keyword
00:09:04
suggestions and then the keyword itself
00:09:08
here you can verify this by going into
00:09:11
the keyword sheets the previous module
00:09:13
and see keyword suggestions keyword
00:09:15
ideas that's the one we named that same
00:09:17
spreadsheet the column range we're going
00:09:20
to go A to
00:09:23
Z and now is where we need to start
00:09:25
filling out the information so let's
00:09:28
reference the keyword suggestions thing
00:09:31
so in a we have the keyword the main
00:09:34
keyword the in B we have the suggested
00:09:36
keyword so the new one and we have its
00:09:38
monthly search volume competition Costo
00:09:40
click and search intent so we need to
00:09:42
fill this out a is going to be the
00:09:45
original keyword we can just grab it
00:09:48
from the Google sheet B is going to be
00:09:51
the new keyword which we found which is
00:09:53
going to be this one
00:09:55
here C is going to be the monthly search
00:09:58
volume
00:10:00
and we should be able to find it here
00:10:02
search volume D is the
00:10:07
competition high low or medium
00:10:10
competition level is what we
00:10:13
want and E is going to be cost per click
00:10:18
that's is the CPC and F is the search
00:10:21
intent we need to scroll down a little
00:10:24
bit and the search intent is the main
00:10:26
intent under search intent not the SE
00:10:28
type the SE C type stands for search
00:10:31
engine and that's not really what we
00:10:32
want go to okay perfect so you've done
00:10:36
the first set of automation that's
00:10:38
already quite good so if we save this
00:10:41
let's try this out and look at our
00:10:44
Google sheet I'm going to run this go
00:10:46
back to our Google sheet and see that
00:10:48
it's made a copy renamed it and now we
00:10:50
see all the data coming in so we've got
00:10:53
the keyword suggestions from the main
00:10:56
keyword learn SEO we've got the monthly
00:10:58
search volume the competition the cost
00:11:00
per click and the search intent how can
00:11:02
I learn SEO the monthly search volume in
00:11:04
the United States for that is 880
00:11:07
estimated search volume low competition
00:11:10
you get the idea so well done we've done
00:11:13
the first section of this I'm just going
00:11:15
to delete this because I want to show
00:11:17
you how this looks when we create the
00:11:20
entire thing let's save that and now
00:11:23
we're going to add our first router well
00:11:26
first and only router I should say and
00:11:29
add a new module here we're going to
00:11:31
align it to make it nice and pretty and
00:11:33
easy to deal with and we're going to go
00:11:36
and add the search engine results page
00:11:40
for that keyword why do we want to do
00:11:42
that it's good to know what are the top
00:11:45
ranking results for a particular keyword
00:11:47
in your country so you understand what
00:11:49
the search intent is perhaps what you
00:11:51
need to write in order to rank really
00:11:53
well and what your competition looks
00:11:55
like as well so the next module here is
00:11:58
going to be a data for for SEO module
00:12:00
you're just going to typee in
00:12:02
sep get past sep results and again the
00:12:07
keyw we're selecting from our Google
00:12:09
sheet same with the location and same
00:12:12
with the
00:12:14
language device everything else we're
00:12:17
going to leave as is the depth I just
00:12:19
want to get 10 meaning I want to get the
00:12:22
top 10 results I don't need the top 100
00:12:25
you might but for this instance I want
00:12:26
to limit the amount of API that I'm
00:12:28
using so I'm just going to leave
00:12:29
everything else as
00:12:31
is uh the target if you leave it empty
00:12:35
it's going to choose the best search
00:12:37
engine that it recommends for this so
00:12:39
I'm going to leave it at that okay so
00:12:42
now essentially I need to copy these
00:12:44
three steps again really but you know
00:12:48
copying the right sheet in in that
00:12:50
instance so what I like to do instead of
00:12:52
looking for the module I just clone this
00:12:55
one take it down and obviously I need to
00:12:57
change a couple of attributes here so
00:13:00
we're copying the sheet from our
00:13:01
template and the template that we're
00:13:04
copying now is sep keyword result right
00:13:09
go back here and the sheet ID that we
00:13:13
are copying is not key template keyword
00:13:15
suggestions it's template
00:13:18
sep the location stays the same because
00:13:21
we're sending it to the same spreadsheet
00:13:23
the name changes
00:13:32
it's going to be sep keyword and the
00:13:35
starting
00:13:36
keyword we need to make sure we iterate
00:13:39
this data again this iteration you need
00:13:43
to run the data through ones to be able
00:13:45
to get the right information I'll show
00:13:47
you this in a second because if I go to
00:13:49
array now and I select the data that I
00:13:52
want I need results and this isn't quite
00:13:55
the one because if I click results here
00:13:58
and leave leave it there let's
00:14:01
disconnect this just for now unlink it
00:14:03
we're going to run it once to see what
00:14:06
kind of data I'm getting through I'm
00:14:09
going to run
00:14:11
anyway now it's doing the results and I
00:14:15
just want to see here the output bundle
00:14:18
that I'm getting is items and I need to
00:14:21
go to the collections here so what I
00:14:23
need now that the first data set has
00:14:26
come through
00:14:29
I need to go to the module or refer to
00:14:32
the module from data from SEO go to task
00:14:35
go to
00:14:36
results go to items down here which
00:14:40
won't appear until you do one data
00:14:44
throughput essentially and I'm going to
00:14:46
copy this items here this is the bit
00:14:50
that took me a little while to figure
00:14:51
out I was pulling my hair out but now I
00:14:54
can give that to you so you don't have
00:14:55
to waste your time perfect so now I can
00:14:59
duplicate this one here above clone it
00:15:02
CU I'm a little bit lazy I don't want to
00:15:03
look for the whole thing but I do need
00:15:05
to change a couple of components again
00:15:07
so within that spreadsheet spreadsheet
00:15:10
ideas is the same the keyword suggestion
00:15:12
sheet name I need to make sure that I
00:15:16
select the one or I name it the same one
00:15:19
that I've created this one so this is sh
00:15:22
sep
00:15:24
keyword I believe let me just double
00:15:26
check
00:15:27
that yeah SCP keyword
00:15:31
fantastic and again let's look at what
00:15:34
that template looks like I've got the
00:15:35
rank number the URL the title and the
00:15:38
description going from a to d so I'd
00:15:41
like to try and remember that the a will
00:15:44
be the absolute rank the B will be the
00:15:50
URL I believe yep
00:15:52
perfect B will be the URL not the domain
00:15:58
I want the URL
00:16:00
C I believe was the title and D I
00:16:03
believe was the description because I've
00:16:06
copied it I've got these last little
00:16:08
things that I want to delete make sure
00:16:09
you don't have those there perfect I'm
00:16:12
going to go to okay I'm going to save
00:16:16
this I'm going to join this other one
00:16:23
and cool just or align it okay now I
00:16:27
need the last one and we're going to
00:16:29
test it all I know it's a bit risky but
00:16:31
we're going to test it all when we've
00:16:32
got all three data sets done I'm going
00:16:34
to save this the last one that I want is
00:16:36
the keyword ideas this is different from
00:16:39
keyword suggestions keyword suggestions
00:16:42
use the keyword that you've used and add
00:16:45
longer tale keywords to that so for
00:16:47
example learn SEO with AI learn SEO in X
00:16:51
part of the world or for free for
00:16:53
example and keyword ideas are a lot more
00:16:56
Broad and you'll see that in a second
00:16:58
it's a great thing to have CU it might
00:17:00
give you some ideas into something that
00:17:03
you haven't thought about that might be
00:17:04
related to that
00:17:05
keyword so I'm going to select a new
00:17:08
module data for SEO I'm going to search
00:17:10
for
00:17:12
ideas and you'll see that it's slightly
00:17:15
different not veryy though for the
00:17:16
keywords I'm going to add an item select
00:17:19
the keyword here the location United
00:17:21
States or B language
00:17:24
C uh again the limit I just want to do
00:17:27
10 so I don't go crazy you can do up to
00:17:30
100 uh or even more but just so I don't
00:17:33
use too much data I'm going to leave it
00:17:34
at
00:17:35
that again I need
00:17:37
to make this same kind of row here
00:17:42
slightly different so I'm just going to
00:17:44
copy this or clone that
00:17:47
module select it
00:17:49
here and what we are doing the sheet ID
00:17:53
that we're copying is not keyword
00:17:55
suggestions keyword
00:17:57
ideas per perfect everything else stays
00:18:01
the same I'm just going to change this
00:18:02
to keyword
00:18:06
ideas okay I'm going to uh add an
00:18:10
iterator this little sucker here and in
00:18:14
the array I need to go to tasks I need
00:18:17
to go to results I need to go to items
00:18:21
and that is the stuff that I need really
00:18:23
need to dig here data for SEO gives you
00:18:26
so much data that you need to segment it
00:18:30
appropriately and I'm going to clone
00:18:32
this last sheet but I need to change a
00:18:34
couple of components here the sheet name
00:18:37
is going to be
00:18:42
um keyword
00:18:48
ideas and then I need to change a couple
00:18:51
of variables here let's go and see the
00:18:54
template that I have for keyword ideas
00:18:57
which is the main keyword suggestion
00:18:58
monthly search volume competition cost
00:19:00
per click and search
00:19:01
intent so so we don't get lost here
00:19:05
going to go to a and then it's going to
00:19:07
be the key original
00:19:10
keyword B is going to be the suggested
00:19:13
keyword that it's given me and that's
00:19:16
going to be this one here C is going to
00:19:19
be monthly search
00:19:22
volume and search volume
00:19:26
here D is going to be be
00:19:31
competition and the competition that we
00:19:34
want
00:19:37
is competition
00:19:40
level E will be cost per
00:19:45
click Title by CPC and F is going to be
00:19:49
the search intent and the search intent
00:19:51
is the main
00:19:53
intent cool we're going to save this now
00:19:57
I'm just going to go back to the sheet
00:19:58
where I've done all this I'm just going
00:20:00
to delete um learn SEO this one here cuz
00:20:04
it's not a template uh
00:20:06
yes so hopefully I'm going to save this
00:20:10
I've got everything done and I'm going
00:20:12
to pray to the automation gods that this
00:20:14
is going to work if there's an error
00:20:16
that's quite all right uh we'll actually
00:20:17
go through it
00:20:19
together but it looks like everything's
00:20:22
fine otherwise I would have had an error
00:20:23
message already let's go to our Google
00:20:25
sheet and we can see that it's uploading
00:20:27
the data it's created a another one and
00:20:29
it should start uploading that if there
00:20:31
are keyword ideas for this uh might have
00:20:34
stopped perfect so we got an error let's
00:20:37
see where we made the mistake keyword
00:20:39
ideas so it looks like we named this
00:20:41
incorrectly keyword
00:20:45
ideas and that's the error that we made
00:20:48
I was referring to the sheet is keyw
00:20:51
ideas uh and I've placed here keyword
00:20:54
ideas I need to change this to keyw
00:20:57
ideas now I can go okay I'm just going
00:20:59
to save this perfect I'm going
00:21:04
to delete these two and start
00:21:07
again I don't have to but I just want to
00:21:10
show you make sure that the whole thing
00:21:12
is working I'll save it let's run this
00:21:15
bad boy
00:21:17
again look at my Google sheet template
00:21:20
in the meanwhile because it's like magic
00:21:22
when these things happen correctly learn
00:21:24
SEO it's filling out fantastic keyword
00:21:28
ideas
00:21:29
we've done it correctly this
00:21:31
time uh keyword
00:21:34
suggestions
00:21:36
beautiful and now it should be doing the
00:21:39
rest of all the
00:21:41
template
00:21:42
great congratulations now you have an
00:21:45
automation that you can reuse because
00:21:47
you have the Google sheet template so
00:21:50
next time you want to do this you can
00:21:51
just add more keywords here more
00:21:54
additional sheets will come out but you
00:21:55
can direct those sheets somewhere else
00:21:57
so you can have a look at the data but
00:21:59
within a second or a little upfront work
00:22:02
I've got an understanding of what are
00:22:04
the top search results for this keyword
00:22:08
some ideas that I need to look into and
00:22:10
some
00:22:11
suggestions and I can copy this over and
00:22:13
over and that took me less than I think
00:22:16
10 cents not
00:22:18
even so you don't have to use expensive
00:22:21
software to get really high quality data
00:22:24
because many SEO applications use data
00:22:28
for SEO again if you sign up using the
00:22:31
link below you'll get a dollar credit
00:22:32
which will be more than enough to do
00:22:34
just what we've done today and if you
00:22:37
want more help and more support in terms
00:22:39
of how to then write this content with
00:22:42
artificial intelligence in content that
00:22:44
ranks meaning it's high quality adds
00:22:47
value to the reader you should check out
00:22:48
our premium Community we've got a bunch
00:22:50
of things here we give you an 7-Day SEO
00:22:53
action plan so you can hit the ground
00:22:55
running right away and see results
00:22:57
pretty quickly we've got AI fundamentals
00:23:00
automation fundamentals if you've never
00:23:01
used make and want to get started we've
00:23:04
got all that stuff here for you most
00:23:07
importantly we have live q&as twice a
00:23:10
week where you can come in ask his
00:23:12
questions and get them answered right
00:23:15
away I hope you like this video I know
00:23:18
it was a long one but well done for
00:23:19
getting through if you went all the way
00:23:22
we actually offer the Json file of this
00:23:25
entire automation if you can't be
00:23:26
bothered building it that is in premium
00:23:29
Community but if you don't have the time
00:23:30
to build it and you want to join a
00:23:32
community of like-minded people that
00:23:33
will help you learn SEO you can join our
00:23:35
premium community and then you can
00:23:37
upload this automation right away save
00:23:40
yourself some time you just will have to
00:23:42
make a few connections but it's just a
00:23:44
way for you to do these things a little
00:23:46
bit quicker that'll be in our premium
00:23:47
Community if you like this video make
00:23:50
sure you hit the Subscribe button hit
00:23:51
the like button if you found some value
00:23:53
in it if you have any questions at all
00:23:55
on this and if you want me to use this
00:23:57
maybe for how to create a an SEO audit
00:24:01
tool with data for SEO or local SEO with
00:24:04
this same tool leave it in the comments
00:24:06
below and I'll get to it when I can
00:24:08
thank you so much for watching I'll see
00:24:09
you in the next one
