How to do KEYWORD RESEARCH For a local business // in 5 MINS, NO SEO EXPERIENCE and with FREE TOOLS

Get 300 checks per monthabsolutely FREE!

No credit card needed. No strings attached.

In today's video I'm going to show you how to do some local keyword research...
00:00
in today's video I'm going to show you how to do some local keyword research for your business in just five minutes using free tools only if that sounds interesting hold your breath because we're diving in now hi there my name is Luke Duran the founder of ranking Academy co uk if this is your first time here today and you want to grow your local business's online presence why don't you start by subscribing now and picking on the Bell button so you don't miss a thing human behavior is very predictable and people searching for local businesses are no exception they will pretty much follow the same pattern they go to Google enter a service or business start and include a specific location in the Google search box then click on one of the top results whether the search is made in what I would call Google classic or Google Maps the behavior remains the same and if your business does not get listed for the keywords that are being searched for in the top results then you won't get any traffic simple the question is which keywords should you be targeting if you don't know where to
Start and find local keyword research overwhelming here is a simple way of...
01:01
start and find local keyword research overwhelming here is a simple way of doing it quickly efficiently and for free open either a Google sheet or an Excel spreadsheet and simply start listing the various services you provide I'm going to use the example of one of my clients located in London who is in the cleaning business and offers services such as carpet cleaning rod cleaning office carpet cleaning mattress cleaning etc and create a column for each service with one column gap between each of them once you have added your services in a spreadsheet combine the location keyword you are targeting to each service in this example London that's it this handful of keywords are likely going to be your primary keywords list those services keywords can be used as the backbone of your website structure while the entire key phrase service plus location can be used within the content of your page if you are not entirely sure which services you should choose or if you feel you have forgotten some here is a nifty little tool you can
Use this SEO keyword tool has been specifically designed to help small...
02:01
use this SEO keyword tool has been specifically designed to help small businesses search for relevant local keywords for their business it's super simple to use select a business type from the drop down let's stick with our cleaner example and select the cleaning option this will automatically list a range of services you can easily select by using tick boxes next to what you think applies to your business so let's choose carpet cleaning rug cleaning mattress cleaning and office carpet cleaning I can see there are plenty of other options available such as Airbnb cleaning apartment cleaning that could easily apply to my business which I didn't think about so let's add them to the selection once you're done click on the service type and add the location you are targeting to the location box and click on generate keywords and that's it you have a nice keyword list automatically generated for you which you can download in a CSV format alternatively you can copy and paste the selection directly into your spreadsheet
And sort it according to the service type and add new categories or keywords...
03:03
and sort it according to the service type and add new categories or keywords variations straight to I can see some interesting keyword I didn't think about initially like cheap carpet cleaning professional carpet cleaning and carpet cleaning services let's pick another example but this time use an air conditioning type of business and use the following services 24 hour air conditioning repair air conditioning installation air conditioning maintenance and air conditioning repairs as Services but this time we're going to add multiple locations let's say our air conditioned business is located in Florida and we want to be found in Tampa Orlando and Jacksonville and look at this all you need to do is download your CSV file and import it into your Google sheet add a filter to your column and all that you need to do is select a specific location you want to look at this should take you under a minute to create you could stop right here if you
Wanted as it would be more than enough to cover most of what people are looking...
04:04
wanted as it would be more than enough to cover most of what people are looking for but let's try to expand our keyword list a little further this time we're going to use the simplest tools of them all Google Google always try to anticipate what searches are looking for and developed a long time ago a feature called autocomplete which makes it faster to complete searches that you beginning to type the suggestions are based on popularity meaning that any keyword suggested is likely to be a highly searched one if I type one of my main keyword in the search box such as carpet-cleaning London I can see another three suggestions I haven't thought about topic leaning on than prices carpet cleaning London costs and carpet cleaning efore teen which is an area of london i can add these to my google spreadsheet for the carpet cleaning service category just repeat this process for each of your services and add them to your spreadsheet quick tip you can use the autocomplete feature a little further
Using the wild-card symbol within your search which Google will substitute with...
05:04
using the wild-card symbol within your search which Google will substitute with more words so if I put a wild-card before a carpet cleaning London I can see other suggestions like best carpet cleaning London and deep carpet cleaning London you can even do it right in the middle of the query and here I get even more suggestions like carpet cleaning North London East London West London all of which I can add to my list you should by now have a fair amount of keywords you can play with but let's step it up even more and head over to a tool called Neil Patel comm slash Eber suggest I have mentioned this too many times before when it was entirely free sadly some features have now become available but it still offers a number of free options you can use enter the keywords you are looking for in the search box then select the appropriate country and click search you will be presented with a bunch of data in relation to your keyword including the monthly search
Volume and SEO difficulty which are very useful if you scroll down you'll see a...
06:05
volume and SEO difficulty which are very useful if you scroll down you'll see a short list of keyword ideas click on the button view all keyword ideas and it will bring up the entire list here I suggest you download the CSV file you will be prompted to log in to a Google account if you do not have one create one once you've logged in click on export to CSV you will see a pop-up window warning you that more than 100 keywords were found and therefore you could upgrade your account to get full access all available keywords simply ignore it and click on no thanks all you need to do now is import a CSV file from wherever it was save on your computer into a new Google sheet copy the keyword and volume column then paste it into your master keyword list in the appropriate category in this case carpet cleaning London remove the rule that says keyword and search volume if
You go back to Yuba suggests you will notice there are other possibilities you...
07:09
you go back to Yuba suggests you will notice there are other possibilities you should consider such as related keywords questions prepositions and comparison which you can also export and bring into your sheet we won't do this today and I will leave it up to you to make that decision at this point you might see some keyword duplicates within your list as we collected them from different sources so it might be an idea to do some cleaning up just highlight the column you want to check and select the format option and conditional formatting in a format rules option click on the drop-down and choose custom formula in the value field type the following formula don't worry it's in the description below you just have to copy and paste it and make sure the right column is entered in there so in my case it is B if your column is different just replace the B with the name of the column this will highlight all the keyword duplicates you have within your list simply delete them by now you
Should have a very exhaustive list of keywords you can refer to whenever you...
08:10
should have a very exhaustive list of keywords you can refer to whenever you want to create some content on your website but we need to choose which ones we should prioritize this is generally done through volume data as the more time the keyword is searched for the more traffic it will driver since we only have data for a selected number of keywords it's a bit tricky to do and ideally we need to understand the volume for all of our keywords or at the very least the ones we think are likely to drive the most traffic go to Google and search for keyword surfer then click on the keyword surfer Google Chrome link which should be the top results click the add to chrome' option and then the add extension which should automatically install the extension on your toolbar click on the keyword surfer icon and turn the show the main data insert slider off then open a new browser window and search for a keyword which we don't have the data for
Such as cheap carpet cleaning London you should now see the estimated volume for...
09:10
such as cheap carpet cleaning London you should now see the estimated volume for the keyword you've searched for which you can add to your list repeat this procedure for all the keywords you're missing data for if you want to see the results for a different country just click on the keyword surfer icon and amend accordingly keyword surfer will also add two tables to your search results which include similar keywords and related searches which can be very useful too once you've got volumes for all the keywords you feel are the most important ones you might want to create a separate sheet for each of your service and copy and paste the data you've collected so it's easier to use and clean up then order the volume from the highest to the lowest so you know which keywords you should be prioritizing keyword research is the cornerstone of online visibility and will be the driver of the content you need to create on your website failing to do an effective local keyword research will have dramatic consequences
For your business later on it's almost like building a house on quicksand these...
10:11
for your business later on it's almost like building a house on quicksand these steps are super easy to follow once completed you can refer to your spreadsheet time and time again to create additional content which you'll know matches what people are searching for that's it for today as always if you have any comments or questions post them in the comments below and I'll do the best to respond to them until next time happy marketing

Related Topics

Get 300 checks per month absolutely FREE!

No credit card needed. No strings attached. 👍