Optimize SEO with Google Sheets and Google Search Console

0:00 Maybe you're sitting at your Google Search Console and you're really wondering like how do I optimize, how do I SEO, search engine optimization, what can I do? And I'm going to show you how to use Google Sheets in order to optimize your SEO or search engine. So we're going to export , we're going to go to Google Sheets and I'm going to open a brand new Google Sheet from this export . It's going to do it automatically here in a second. Now what I have here are queries on the second page. I have pages. And what I'm looking for are are unoptimized things. So, all of these ones that have high clicks, high impressions, and the position is, like, okay, right? Each of these can be fixed. Anything between one and ten is probably okay. Ten to, say, twenty is probably optimizable. And then anything from twenty to fifty is also probably highly optimizable. Optimize SEO with Google Sheets and Google Search Console Roasting Google Sheets SearchLord How To Bulk Search Google and YouTube

0:48 But I want to make sure that I have enough juice, meaning is there enough juice, if I squeeze, will we get something good? So what I'm gonna do is try to filter this page, oops try to filter this page for the things that I want. And what I can do is I can go here and I can say, okay, definitely, yes, if the position is something like 10 to actually let's do 5, 5 to 20. Yeah. And we're going to go, if, logical expression , if this is greater than 5, I'm going to wrap this with and, you might want to be able to see this better, and e2 is less than 21, okay? And if it's true, I'm going to say yes. There. And so we get some falses. Let's actually add, if it's false, just a little blank. Optimize SEO with Google Sheets and Google Search Console 5 Magical Ways To Use the IF() Formula in Google Sheets Votes for Approval

1:35 So these are all yes. But that's not the only thing. I want to make sure that I have actually one click. So at least one click. Clicks, yay. Equals if, logical expression is this, is over. Zero. And if it's true, I'm gonna be like, yes, if not, I want nothing. All right, we got a bunch of clicks. And of course everything down here is. We got zero clicks here. That's okay. We don't need any of these. We can actually look through these at some other time and be like okay, these pages are cool, maybe a position 42 that has 622 impressions, yeah, I can definitely optimize that, but I want to see things that have at least one click. So, cool, got those. Impressions. Let's look at this. What we can sort of figure out, this is a very crude work here. Optimize SEO with Google Sheets and Google Search Console One Million Checkboxes

2:23 But we can say potential impressions. What we can do is take this impressions that we're already getting and say we want to increase it we want to see what would we get if we were in position one. So a crude way to do that is to take the existing impressions, actually, let's say equal this, take the existing impressions we're getting, divide it by 1 divided by the position. And that's a very crude way of doing it, but we get a really interesting potential here, right? And they're ranked differently than if we were just looking at these impressions straight up. And so what we want to see here is. Anything where yes is both here. Let's look at that and let's say we're going to filter . So we want a through h of pages equals filter a through h pages a colon h Optimize SEO with Google Sheets and Google Search Console

3:15 condition is this equals yes and clicks. Equals yes. And we get all those, cool. And now we can sort by , I'm going to say, sort by 1, 2, 3, 4, 5, 6, 7, 8. Column 8. Do we want it ascending? We want it descending, so we want this to be false. And there we go. So these are pages that are within 5 to 20. We're definitely optimizable, And this gives me a really good shot of like, hey, I can go to this, I can work on it, I can see now, I can take this and go back to my SEO search console, sorry, go to the page and we're just going to look at one page and I can see what queries are we already ranking for, right? Optimize SEO with Google Sheets and Google Search Console SearchLord One Sheet to Search Them All

4:01 That's cool. Right there. We're already ranking for those. We can see position as well. Let's see if we have any. Recommendable positions. Ooh, all in number one. That's awesome. Here's number four for Google Sheets true false formula . Anything outside of four, five, count if. Here true false Google Sheets. We might be able to add this true false Google Sheets to the, to the keywords or maybe add it to the text in a little bit to sort of bump it up. In the top five, because this looks like a really great, we're already getting a lot of impressions for it at the 7th position, so if we moved up we'd get way more. Look for low positions, maybe even, yeah, 1931 count if formula , so maybe add a little, what we can do is add a little section to that blog post Optimize SEO with Google Sheets and Google Search Console Find New Additions to a Main List in Google Sheets I Built a Subreddit Scanner in Google Sheets

4:47 about the count if formula and how it, how it works with this page. And so this is something that I would do In SEO, but using Google Sheets and a few little formulas just to look at the pages that definitely could be optimized, the pages that might be optimized, and we're using Google Search Console, which is totally free and available. Google Sheets, totally free and available, especially if you have Google Workspace, and just a few filters, just using sort and filter here, and a couple of ifs, and a little bit of math, we find some really great potential. And can work through instead of having to like just search through this list and be like, okay, let's go down one by one. We have a nice little filter here. Wow. Over a hundred pages. We can definitely do something on and optimize for really cool. Optimize SEO with Google Sheets and Google Search Console Roasting Google Sheets SearchLord How To Bulk Search Google and YouTube