Video Review
Video Transcription
Hey, this is Jeremy Ashburn with PushLeads. This particular training is how to find SEO keywords with the Search Console.
So I’m just going to go through a little PowerPoint. And from here, we’re gonna rock it here. So, for those of you guys who don’t know it, this is going out to my Facebook and YouTube. My background is in graphic design. Then I worked for an ad agency when I first graduated. For a number of years after that, I worked for an executive recruiter here in Ashville where I’m based. While doing that job, I started making websites and learning how to get websites to the top of Google.
And one of my experiments was really successful, reaching the top of Google by 2008, 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 clients show up in Google.”
So I created PushLeads, did some online mentoring for the first couple years, and since then I’ve been doing digital marketing.

Search Console
So that’s my background. But let’s get into Search Console.
So what is Search Console?
Google provides a lot of different tools, and one of them is called Search Console. It’s a free tool. Essentially, Search Console tells people how people are finding you in Google. And so that’s really important. Essentially, it helps you find keywords that people are searching for.
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, then you know, I need to find out what people are looking for, right.
Keywords like “seo services,” “asheville seo,” and so far. These are all keywords that people are looking for.
Search Console shows that data as well as searches that people are clicking on when they go to your site.
The last thing to make a note of is that it’s only local searches.

Local SEO Searches and Areas
The thing is, Search Console tool will not show you where you are in a city, but only where you are ranking in your neighborhood.
So let me show you what I’m talking about. Okay, so here’s the little map of dot map diagram of Asheville. And, you know, this is the part of Asheville that my company is based out of right; East Asheville.
And so, when you’re using Search Console, it shows where you are showing in Google in your local neighborhood, not your entire city. But, if I wanted to know where I was in all of the Asheville, Search Console will not show you that.
Really, you have like about essentially four different ranking areas with Google: your neighborhood, your city, or other cities, and all of the United States. So most of the companies I work with just care about showing with 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 client in California that wants to show up nationwide, for makeup lighting products. And so, we’re working with them nationwide to track results.
But I said, like I said, most clients just care about showing up in a city.
So just be aware that it when you set up Search Console, it’s only going to show you where you are in your neighborhood.

How to Find Keywords in Search Console
Alright, so let’s talk about how to find keywords in Search Console. Essentially, what we’re going to do is log into Search Console.
If you haven’t ever used this tool, you’ll need to actually set up connect to your website or your domain. That really just involves couple different technical tweaks to verify it.
But anyway, after it’s set up, then you can then open up your domain. So my domain is PushLeads for my business name. And what I’m going to do is I’m going to log into it.

Okay. And then next thing I’m 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 compare the last 28 days in the previous period. Okay, so here’s the Performance tab. And then I’m going to click on this little thing here that Date Tange. And I’m going to click compare tab, compare last 28 days to previous period.
So what this is telling me is that I’ve received 22 clicks this month versus last month. 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.
Next, you’re going to export the spreadsheet and filter the spreadsheet and sort by the last 28 days. Okay. Here’s the spreadsheet that I’ve actually already exported. And what I’m going to do here is it will sort it by the last 28 days clicks.
Always remember that Google doesn’t tell you all the clicks. I can see that somebody searched for marketing companies in Asheville, and they clicked on me, but remember, I had 23 clicks, this is only showing four clicks. Right? So Google doesn’t show you all the clicks. They only show you the tip of the of the iceberg, not the whole thing.
So anyway, but what we can do is look at this one the last 28 days position. This is showing me where I am in Google in Google in your neighborhood over the last 28 days. So, I’m going to sort from smallest to largest, and ignore all these zeros, and 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. These are all searches in Google.
And, what I can do is go down this list and highlight them the search phrases that apply to me. And some of these longer apply it all like collection agency, best collection agency, or Google update algorithm. You know, I don’t really care about those keywords, 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 my neighborhood, but where am I in all of Asheville.
Finding SEO Results Manually
There’s a tool called the ad preview and diagnostics tool that shows your local ranking. And I can see here competitors and my own busines in the search. So, for this particular search, I’m number three in Maps and number search in search. The focus on the SEO game is to show up in as many maps searches and as many of these in the regular search as well.
And so these white fox guys are showing up here and here and getting the lion’s share of the traffic. But it’s okay, we’ll take them out. One of my new clients is a psycho therapist, and so she really cares about the “psycho therapist” and “EMDR therapy” searches.
I have another local plumber and they care about “asheville plumber” searches. So finding all these keywords and then making a list of them is what you do.
Spot checking your ranking is great, but those of us who actually do SEO for a living, and you know, we use tools to track keyword rankings.

Finding SEO Results with SEM Rush
So instead of just spot checking, you can use a tool yourself.
One of the best tools that I’ve found is called SEMRush. And this tool is like $200 a month.
What you what you can do here is open this tool, and then you can click on View All keywords, and I can track my positions over time. So what I’m gonna do here is look at the last 30 days. And I can see here on April 10, that I had about 6.59% visibility.
Visiblity is a number that represents your local SEO market share. This is a number goes up in a scale from 0 to 100. And typically, most businesses have a 2%, 5%, or maybe 10% visibility.
Yyou can see I’ve gone from a 6% visibility to a 16% visibility over the last 30 days.
Part of that growth has been blogging as well as other things that we’ve been doing as well to get the ranking up. And, since my current ranking has gone up, we’ve gone from getting one or two calls a month to 10 to 15 calls per month.
And that’s great. I mean, more leads are perfect. So, of course we practice what we preach, we do our own SEO, and we can tell the difference.
So, what I can do is take these keywords in this list, highlight them, and import all 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.
And then it will influence it’ll make my visibility goes up or down, based on adding new keywords, So, let’s find out their ranking.
Let me just refresh it takes about a minute. And some of these keywords actually have no traffic. So if I scroll down here, see it says 0 volume here. So I can see the volume is 10 this one local SEO servers that North Carolina has no traffic, right? So I can delete that keyword. I can scroll down and I can delete keywords that have no traffic.There’s no one actually even looking for these terms.
So just wanted to show you this whole process, you can check your local rankings manually with that tool or use SEMRush.

Contact Us with Questions
That’s really it. If you have any questions, just leave a comment below this video. Or you can reach out to me.
My local business phone number is 828-348-7686. You can also email me at jeremy@pushleads.com.
And on my website, you can do a free SEO audit that will tell you how well your website is performing for a search phrase in Google.
Well, let me know if you have any questions. I would love to help you out with any questions, thoughts or concerns you have.
I’m Jeremy Ashburn with PushLeads.
We play in Traffic.
What’s Your SEO Score?
Enter the URL of any landing page or blog article and see how optimized it is for one keyword or phrase.