0:00 What Google Search Console Actually Does
0:23 GSC vs Google Analytics Explained
1:31 Real Client GSC Walkthrough
2:33 Reading the Performance Tab Data
3:45 Why Google Hides Most Click Data
4:18 Finding Queries That Drive Traffic
5:35 Exporting GSC Data to Excel
6:25 Sorting and Reading the Spreadsheet
7:36 Moving Keywords into Rank Tracking
Full transcript
0:00 What Google Search Console Actually Does
Hey, I’m Jeremy with PushLeads and I help small businesses get more leads without Struggle or frustration and what I want to do in this little video is just show you what search console is And show you how you can find new search phrases that you can show up in Google using search console So the first thing is let me just explain what search console is
0:23 GSC vs Google Analytics Explained
Search console is essentially a tool that Google uses To tell you to track what’s going on in your website, but primarily track how people are finding you in Google So if you have a new business or an existing business or you’ve got someone working for you doing SEO They’re probably using this tool and this tool essentially just is great for discovering how people are finding you now You may have heard of this tool which is called Google analytics and you know This tool really kind of shows people which shows you what’s happening on your site. How where people are going? Somewhat how they’re finding you but where they’re going when they’re on your site and it’s called Google analytics And you can just sign in to Google analytics that kind of thing from there But in this situation we’re talking about search console so to get the search console just type search console and type search console tools and start now and And if you haven’t created search console before you’ll need to add a search console property But we’re not going to cover that in this little video So what I’m showing you right
1:31 Real Client GSC Walkthrough
now is what’s happening with one of my current clients So these guys do bathroom in bathroom renovation primarily in the Asheville area and so they’re two -day bath and shower So if you are looking for bathroom renovation and you’re in the Asheville area these guys are great they’ll essentially renovate your whole bathroom in a period of two days or so and So they’re paying me to do SEO to get them the top of Google for bathroom renovation and things like that So what I wanted to do is show you kind of what their search console looks like so within search console Once you log in you’ll need to select a property on the left -hand side if you have multiple properties in here if you already have one property you’ll just need to go ahead and click it and And generally the first thing I do is under overview This kind of shows you where the clicks are coming from how people are finding you in Google This is showing you how many pages are showing up in Google and kind of what the experience is things like that But really what I want to take your
2:33 Reading the Performance Tab Data
attention to is the performance tab This is how to find out essentially what are people searching when they find you and what we’re doing is we’re clicking on compare and Instead of doing like three or six months. We’re just comparing the last 28 days the previous period So that’s going to be comparing this month versus last month So as of the time of this recording around January of 2025 happy new year We have 99 clicks in the last net and the last 28 days and we had 69 clicks in December Ish right so so that’s kind of what this means is we had 99 clicks this month And we’re showing up for for a total of 2700 impressions and pressure as I went to when the sees you in Google But doesn’t necessarily click on your website the average CTR or average click -through rate It’s essentially 4% to how many people of your impressions are actually 0.4% So how many people are actually Clicking to your website when they search for you and then the average position Honestly, the most Thing that I the thing I really pay attention to is really just how many clicks are getting this month versus last month now before
3:45 Why Google Hides Most Click Data
I continue I want to explain something Google does not like to tell you where data comes from Don’t you love Google? I mean we love it We hate it at the love -hate relationship But Google doesn’t tell you where most of these clicks are actually coming from They are tracking how many clicks are happening and they know where all the clicks are coming from But you actually can see the data of when when people were searching for something and they found you you can see that maybe like 1% of the time 10% of the time not very much So so let’s continue and next thing we’re looking for here is we’re gonna
4:18 Finding Queries That Drive Traffic
scroll down and find out What exactly the searches were when people were finding you and so in this case I’m looking at the top queries or these are searches in Google So I can see that there were 17 clicks on their name two day bath and shower and And then there were 17 clicks this month and then there was 14 last month and then the bathroom remodel We had three clicks month three clicks this month zero last month bathroom model Asheville three clicks versus zero last month so I can scroll down here and see exactly where the clicks are coming from and Again, not exactly all of them. Maybe like 10 maybe 20% of them Can you actually see where they’re coming from? So if I add up these numbers here, this is probably maybe 30 clicks or so of the 99 right so a lot of times what we have to do is infer Use our super powers of intuition to find out where the clicks are coming from based on where they are in Google so I can scroll down and show you more But as you see as I scroll down, I’m gonna get down to the zeros here So we don’t know it’s saying zero for bathroom renovation services, but I guarantee you if this Search is at the top of Google it had some clicks.
5:35 Exporting GSC Data to Excel
So what we’re gonna do is we’re gonna scroll back up We’re gonna click on export Download Excel and what this is going to do is download a spreadsheet of all the searches in the last month So I’m gonna open up this Excel spreadsheet and I’m kind of a geek as far as when we’re talking about Excel So what I’m gonna do is sort it a little bit Okay, so all I really did was just kind of put a filter on here and and then sorted by zero from essentially from smallest to largest and then when I expand this out I can see exactly what the search is and Let me just show you some details here We can zoom in on this in case you’re on a phone looking at this video You might want to see a larger spreadsheet, right? We all love larger spreadsheets, okay?
6:25 Sorting and Reading the Spreadsheet
So this is a term here. I’m gonna highlight this Bathroom remodel showrooms near me. So this particular term now They don’t really have a showroom, but just for example for this example I’m gonna show you kind of what I’m looking at here So this is the search in Google column a is the other searches This is how many clicks happen this month versus last month. This is how many impressions and then this is where it is in Google So last month it was zero which means it wasn’t showing up somewhere on the first ten pages of Google and Really nothing really matters after the first page But us SEO geeks like to look at up to the first ten pages of Google And so we can see here that zero means it wasn’t showing up at all on the first ten pages of Google And then one means that it showed up at the top of Google in Arden, North Carolina where these guys are based out of Probably in a two mile radius or so of Arden So if you are in a two mile radius of Arden and you were searching for this then you would be then you know You would find these guys So it’s great to know that this is a term But in order to find out where we are in Google we have to take this data
7:36 Moving Keywords into Rank Tracking
Into a tool like SCM Rush Which SCM Rush tells us where exactly we are in all of the city of Arden or the nearby cities of Asheville or wherever you’re based out of So what I’m going to do is just go down this list and highlight terms that I think are important for this client Okay, so what I’ve done is I’ve highlighted about 10 or 15 different terms including the remodeled bathroom shower Zero like fast bathroom remodel last month wasn’t showing up in Google and now it’s at the top Bathroom construction was in this case was near the top position four and that moved up to position three Bathroom reconstruction was in the middle Google second page remember there’s 10 positions on a page And now it’s at the top of Google’s first page So go down this list and highlight terms that you think are important And once you are at a point where you’re like, okay, I’ve highlighted enough terms You can then take these terms and bring them in to a tool like SCM Rush to find out where you are in Google So I’m just going to filter by color I’m going to copy these And these and then I paste these into SCM Rush So within SCM Rush I can take these and then just go into here and I can paste these as new keywords to track And then when I hit add keywords to campaign It’s now tracking from it’s not tracking 10 additional keywords It’s so when I hit save it will take about an hour or so But this will it will then add those keywords in here and we can find out exactly where we are for these terms in whatever area you’re tracking In this case, it’s Asheville, North Carolina. I’m mobile phone on a mobile phone Alright, hopefully this has been beneficial and if you’re doing SEO be sure you’re doing this If you’re not working with the SEO person, I really recommend That you sit down with somebody who knows they’re talking about and they should be able to show you things like this When potentially working with somebody. Alright, I’m Jeremy with PushLeads It’s all about getting more leads with less struggle and efforts. Thanks
Jeremy explains Google Search Console for tracking SEO performance and discovering search queries driving traffic.
Read the full written guide: Understanding Google Search Console for SEO
Up next
SEO Services Greenville SC | Rank Higher & Get Leads
10:24What Is a Named Storm Deductible and How Does It Work?
12:39how do you get your restoration company cited by ChatGPT and Perplexity?
12:16How do contractors optimize Google Business Profile for better leads?
10:34HVAC SEO Asheville NC: Get More Local Calls Fast
11:24Multichannel Marketing for Contractors: Fill Your PipelineKeep Reading
Want more customers from Google & AI search?
Get a free SEO audit of your site — see exactly what to fix first.
