How to Find SEO Keywords with Search Console

0:00 What This Training Covers
so let’s jump right into it um and so this particular training is how to find SEO keywords with search console so I’m just going to go through a little PowerPoint and from here U we’re going to rock it here so those of you guys who don’t know it this is going out to my Facebook and YouTube but uh my background is in gravid design and I work for an ad agency when I first graduated but for a number of years I worked for um an executive recruiter here on in Asheville where I’m based and on the side I started making websites and learning how to get websites to the top of Google and one of my experiments was uh really successful actually a lot of them were but one of them uh was reaching the top of Google really by 2028 20072 2008 and it was generating about $20,000 of business a month so I was like this is pretty exciting I’m going to start you know doing web design and helping U clients show up in Google so I created push leads and did some online mentoring for the first couple years that really have been working with local companies the last um it’s probably been the last seven or eight years doing digital marketing um so that’s my background but let’s get into

1:14 Jeremy’s Background and PushLeads Origin
search console so what is search console there’s Google provides a lot of different tools and one of them is called search console it’s a free tool um essentially search console tells people how people are finding you in Google um and so that’s really important

1:33 What Google Search Console Is
essentially it helps you find keywords that people are searching for right so for example for me I do SEO which is you know showing up in Google right so if I want to know how people are finding me um then you know I need to find out what people are looking for right and so seo seo services or Asheville SEO these are all keywords that people are looking for and so it also shows you kind of what people are clicking on and uh the the last thing to make a note of is that it’s only local searches so this console search console tool will not show you where you are in a city but only like in your neighborhood so let me show you

2:14 Search Console Shows Only Your Local Neighborhood
what I’m talking about okay so here’s the little map of D map diagram of Asheville and um you know this is the part of Asheville that my company is based out of right it’s technically in East Asheville and so so um for whenever you know so for when you’re using search console essentially you have a little bubble or a neighborhood essentially in your city that um where you’re showing up okay and so basically um search console is showing me that where I’m show where I’m ranking or I’m showing up in Google in this neighborhood right um but if I wanted to know where I was in Olive Asheville search console will not show you that so search console just shows you your local neighborhood um and so really you have like about essentially four different areas you know that people care about showing up in Google they care about your neighborhood your city or other cities right so

3:16 Four Levels of Local Search Visibility
Asheville um Greenville Charlotte Spartanburg Knoxville these are other cities so most of the companies I work with just care about showing with um showing up in one city in Google not multiple cities but other clients I work with actually want to show up in multiple cities or the fourth level they want to show up Nationwide so we’ve got a a client in California that wants to show up Nationwide for um a variety of high quality um uh makeup uh lighting material excuse me makeup uh lighting sort of products um and so they’re tracking Nationwide but I said like I said most clients just care about showing up in a city so just be aware that when you set up search console it’s only going to show you where you are in your neighborhood and you can find keywords where you are in your neighborhood and then you can add them to tools or just mainly track where you are in all of your city okay so just feel free to ask me um a question if you as I go along and we get p this all right so um so let’s talk about how to

4:27 How to Export Keywords from GSC
find keywords in search console essentially what we’re going to do is log into search console and if you haven’t ever done that um you don’t know what I’m talking about you can um you know there’s plenty of tools that show you how to do this but it’s called search console you just Google search console and then click on the first result if you haven’t ever used this tool you’ll need to actually set up um connect to your website or your domain to search console and that really just involves um a couple different technical twick uh tools and tweaks right to get in there you know to verify it but anyway after it’s set up then you can then open up your domain so my domain is push leads for my business name and what I’m going to do is I’m going to log into it okay and then next we’re going to do is open up my property and then third thing is I’m going to click on the performance Tab and I’m going to um compare the last 28 days of the previous period okay so here’s uh the performance Tab and then I’m going to click on this little thing here that says what date range and I’m going to click compare tab compare last 28 days to previous period so what this is telling me is hey I’m showing up uh or excuse me I’ve received 22 Clicks this month versus last month um and uh let’s see um and then I can see what people are searching for down here right but what we really care about is not really what’s on this page but using this export button okay so we’re going to export this as an Excel spreadsheet and what this will do is open up a spreadsheet that we can then find searches okay so just catching this up here what you’re going to do then is export the spreadsheet and you’re going to filter the spreadsheet and sort by the last 28 days okay so what we’re going to do is here’s the spreadsheet

6:28 Reading the Exported Spreadsheet
and i’ and I’ve actually already sorted this spreadsheet and what I’m going to do here is it will sort it sort of by one of these factors here like last 28 days clicks so usually it starts with that um Google doesn’t tell you all the clicks I can see that somebody searched for marketing companies in ashro and they clicked on me but you remember I had like 23 clicks this is only showing four right so Google doesn’t show you they show you like a the tip of the of the iceberg and it’s not the whole thing so anyway but what we can do is look at this one the last 28 day days position which basically means where are you in Google in your neighborhood over the last 28 days so when I click on sort the smallest to largest I’m going to ignore all these zeros and I’m going to go down to the very first one okay and these are all searches so Asheville SEO service right best digital agency small business marketing companies local SEO firms Asheville SEO PPC and here’s Ash SEO services Asheville North Carolina so anyway these are all searches in Google okay and so what I can do is go down this list and highlight them digital marketing agency digital marketing company internet marketing agency I can highlight all this if I you know care about Plumbing web design I can highlight that so these are all search phrases and um some of these don’t don’t apply at all like collection agency best collection agency or Google update algorithm you know I don’t really care about that keyword I really care about searches or keywords that are important right so online marketing companies so I can highlight these keywords and then I can check to see where I am not just in the in my neighborhood but where am I in allive Ash okay and so that is a tool

8:36 Spot-Checking Rankings with Ad Preview Tool
called It’s called The SE it’s called the ad preview and Diagnostics tool it’s such a mouth you could tell an engineer wrote the name came up with the name of this tool add preview and Diagnostics tool anyway so I’m going to put my search in there yep yep yep and I can see here I’m seeing Maps I’m seeing white fox and then whatever the name of this company is and then me so I’m number three in maps for this and let’s see I am not showing here I am I’m like a number five so let me count here so one two three 4 five six seven so for this particular search I’m number three here and also number seven so the name of the SEO game is to show up in as many map searches you know somewhere in the top three and as many of these in the regular search as well um and so these guys white fox are showing up here and here so they’re getting the line share of the traffic uh but it’s okay we’ll take them out uh but if you’re like a psychotherapist one of my new clients is a psychotherapist and so she really cares about psychotherapist or EMDR therapy or any number of keywords I have another local plumber and they care about Asheville Plumbing Asheville plumber so um finding all these keywords and then making a list of them and then you can spot check them um and now there’s another you can do um obviously spot checking your ranking is great but those of us who actually do SEO for a living um and you know we’ve got 15 20 ongoing clients or more you know we use tools to track this so instead of just manually checking it you can use a tool um yourself the one of the best tools

10:32 Tracking Keywords in SEMrush
that I found is called sem rush and this tool is like $1 or $200 a month um might be cheaper for just you know one business uh but uh what you what you can do here is um open this tool and you can click on view all keywords and I can see here um you know I can track my positions over time so what I’m going to do here is is look at the last 30 days and I can see here on April 10th that I had about 6% 6.59 was called visibility this is a number that really on goes on a scale of 1 to 100 um and typically um most people have like a two or five or you know maybe a 10% visibility you can see I’ve gone from a 6% visibility to a 16% visibility and part of that has been blogging but there’s other things that we’ve been doing as well to get the the ranking up and so um as my current ranking has gone up we’ve gone from getting one or two calls a month to about 5 to 10 5 to 15 calls a week uh excuse me a month and um that’s great I mean more leads are perfect so of course we practice what we preach we do our own SEO and you can tell the difference here you can see we’ve gone from you know 6% up to 16% so what I can do is take these keywords in this list and I can highlight them like I have already done and filter by color I can then take all of these keywords and some of them I’m already tracking and I can add keywords to my tracker so I can just put them all in here add them to the project update so now it will track these 100 I think I just added in another 22 more keywords it will track totally um and then it will influence it’ll make my visibility go to up or down you know based on adding the keywords but what we really care about is getting as many of these keywords um that aren’t at the top to the top of Google okay so it will then find out the ranking let me just refresh it takes about a minute and some of these keywords actually have no traffic um so if I

12:58 Deleting Zero-Traffic Keywords
scroll down here here see it says volume here so I can see the volume is 10 this one local SEO Services North Carolina has no traffic right so I can delete that keyword um I can scroll down and I can delete keywords that have no traffic so there’s no one actually even looking for these terms it’s not really like no one is searching for SEO agency Asheville no one’s searching for SEO Company Asheville Asheville PPC so I can delete these keywords that um that where there’s no traffic and that’s one of the things I’ve found um when talking to other people that say they do SEO is you know if you are doing SEO but yet nobody is actually searching for any of these terms in Google like what’s the point right um so anyway I can go through and highlight and delete them and that’s another story for another day so just wanted to show you this whole process you can check your local rankings manually with that tool I showed you or use sem rush and that’s really it um if

14:09 Running a Free Scan at PushLeads.com
you have any questions just feel free to um you know leave a comment below this video or you can reach out to me um You can call me directly and have any kind of conversation with me anytime you want um my local B business phone number is 828 3487 686 and let me just make sure I’m seeing it right yep 828 348-7617 so you can fill that out um and I generally will have a conversation with people that do these um but feel free to do that um and so let me just show you when you go to push leads.com you’ll see this little tool here and you could just put in your url your search phrase and your name or email if you want to or whatever and then you hit scan now and then this tool will tell me so I can even try this for push leads right now so I can go here I’m going to put Ashville SEO and just put my name and 7686 so when I hit scan now this tool will tell me how well my website is performing for this one search phrase so all you do is go to push leads.com and then you can do this um and and then it will then give you the result um and and what it will do is it emails it to you right and so on your in your email box you’ll get like the result you can look at it you can have the conversation um and uh go from there so awesome well let me know if you have any questions love to help you out with any questions um you know thoughts or concerns you have and uh I’m Jeremy Ash with push leads we play in traffic talk