Turn Google Search Console 7-Day Data into SEO Wins with AI Automation (Gemini Gems)
Chris Bernard from Content Engagement Lab and CB knows AI explains how to use Google Search Console’s “last 7 days vs previous 7 days” clicks and impressions report to identify pages gaining impressions but not clicks, signaling a need to improve SERP snippets. He shows how sorting by impressions difference reveals where Google is increasing visibility, and why weak click performance can cause Google to reduce exposure. Bernard demonstrates a workflow that uses a screenshot of the report uploaded to a custom Google Gemini Gem (“SERP Architect and CTR strategist”), trained with a client knowledge-base document, to automatically research and recommend meta title and meta description updates (and potential content changes) to boost CTR, rankings, and AI Overviews visibility, saving significant manual analysis time.
Time Stamps
00:00 Welcome and Goal
00:38 Search Console Basics
01:35 Impressions vs Clicks
03:35 Report Columns Setup
05:46 Reading Real Examples
07:58 Automate With Gemini Gem
10:13 Build Client Knowledge Base
11:58 Sample Output Improvements
14:04 Time Savings and Wrap Up
Transcript
Transform Impressions into Clicks: AI and Google Search Hack
[00:00:00] Hello. Hello, Chris Bernard here from Content Engagement Lab and CB knows ai. Thank you for joining me today. We’re going to be helping you get work done using AI and automation, so thanks for joining me. We are going to talk about taking ripe, beautiful Google Search Council seven day last seven day to previous seven day and impressions and clicks data and turning those into.
Gold in terms of SEO rankings and AI overviews visibility. So stay with me on that. We are going to talk about that. I’m just gonna share with you some of the stuff going on. Everyone knows our friends over at Google. But you may not be familiar. I’m pulling up actually Google Search Council. So some of you are not familiar with that.
Google Search Council will be found@search.google.com for our listeners. That information. Is where we can
[00:01:00] listen to what Google is telling us in terms of our website performance, not just clicks and pages and things like that, but also impressions, data very important. This is the listening part of it.
One of these really great tools in there is a tool that will show the last seven day impressions. And clicks to the previous seven day impressions and clicks. Some of you’re gonna ask, what can you do with that information? This is the part where we listen to what Google is saying. If Google is showing a page.
More often than it did previously. It’s saying there’s interest there and it’s share. It’s saying that basically that page has stuff on it that it wants to present to people doing certain searches or would be interested in hearing that information, if you will. Okay, so we’re listening to what Google is actually telling us.
Then we should also see, as they show that
[00:02:00] impressions data, more often we should see an IMP increase in clicks. If we don’t, then Google’s going to show that stuff less, right? If it improves the performance and they show it more often and it improves or increases the click rate, Google’s gonna reward that behavior a little bit more.
So in this concept of big data and OAIO reviews and all of that stuff. Visibility is one thing, but the where the real rubber hits the road is those clicks coming into the website or actual engagement. Okay? People would argue, okay, clicks with AI overviews, clicks are actually going down. Impressions are going down.
People aren’t actually going and clicking those little links in the AI overviews area, guys, it doesn’t matter. The concept here is your content resonates and your business resonates with specific. Concepts, issues, et cetera. That’s where this matters. Okay. So what we typically do, this is the research side of it.
So taking this information,
[00:03:00] knowing that it has an impact in the meta description, in the title, when somebody does a search or what’s presented in AI overviews, we can listen and optimize that content. Let me take you through the report in Google Search Council and just by taking the screenshot.
And then bringing it into a custom gem that we built with some automations. It will actually tell us it’ll do the research for us and based on the client information it’s been trained on, give us actual adjustments to make to the meta description, the title, description, as well as potentially content based on the actual data.
Okay. So that’s pretty cool. No, what I have up on my screen right now for our listeners. It is basically a screenshot of the Google Search Council information minus the, I covered up the top pages ’cause this is client, actual client information. Okay. The columns going across in this guys from left to right are clicks last seven days.
So it’s got pages right, then clicks
[00:04:00] last seven days, then clicks the previous seven day count and then the clicks difference. So the vari the variance between the previous seven days in the previous, the actual last seven days, and then the fourth column over his impressions. Last seven days. And then the next column over that is the impressions that previous seven days.
And then the last column in that Google Search Council report is the impressions difference. And this is the one that actually is where our key is. We sort descending on that. ’cause I wanna see basically. Which page is Google’s finding more interesting and showing our content more for in the last seven days?
From the previous seven days. So we’re just doing a really good job of listening. So instead of spending tens of thousands of dollars on like focus groups with information and that is dated and. Basically irrelevant at that point because it’s now passed us. You can actually go ahead and see what Google’s telling you.
Your content is resonating and it’s trying to
[00:05:00] reward you for that. If we don’t get the same boost from impressions, let’s say we have a two x on impressions and we don’t have that same boost in clicks, we got a problem because Google’s no longer gonna show that. That page is often because it went up 200% in terms of impressions, but your clicks didn’t go up that much.
You need to be able to make those adjustments. That’s the point of this. This is regular, ongoing SEO and engaging content that not only attracts people but also then results in a sale or whatever. It’s, but if you don’t have the impressions, you don’t have the clicks. You don’t have the clicks, you don’t have the sales.
That’s the improvement opportunity. Okay, so the actual Google search accounts report is descending on impressions on that right hand column. So I’m gonna walk you through the first example to give you the concept here. The page, the number one page that’s ranking in terms of impressions. Variance is 1300 different from the previous.
The last seven days, this one specific page got 7,500
[00:06:00] impressions. It, the previous seven days got 6,200 impressions. So that 1300 variance is really, represents about 20%. Okay, so I should see my clicks go up by 20%. And so we look over into the column on the clicks variance, and it’s actually down negative one.
So it didn’t, it not only didn’t the previous seven days was 43. The last seven days was 42. It went down one. We should have expected at least a 20% increase, 10%. 4%. So we ought to see an eight to nine increase. So it should have been above 50. It’s not, it’s 42, so Google’s not gonna continue to show that page with the same ferocity ferocity.
Accelerated value, whatever, right? The increase, it’s not gonna continue on that pattern unless I fix something, right? So at least it’s being presented at the increase in click value that the impressions worth. Does that make
[00:07:00] sense? So the next URL example had 586 impressions in the last seven days.
The previous seven days was 1 52, so that’s a variance of 400, over 400% 400 difference. So that represents a four x. If you compare it to the 152, it had that previous seven days. So you’d expect to see a four x. Right? It had one. From that previous seven days, and it didn’t have a four, it went up zero.
So a negative one actually on that. So again, what it’s saying to us is that the content that’s showing up in that meta description, that title is not engaging enough. We’re falling behind, so we need a fast way to improve it. Now you could simply go in, go look at, your hres, your SCM rush, go into incognito mode and Google Chrome, and do the search, and try to get that page to flag right, to show up in the search results, and then compare it to the other results and go ahead and do that.
But
[00:08:00] opportunity for AI and automation is to go ahead and allow the tools to go ahead and do that. So basically I uploaded a screenshot. I took a screenshot of this, and I have a custom bot that I have. And by the way, I used a custom gem. It’s a, basically, if any of you’re familiar with, obviously chat.
GPT has custom gpt. If you don’t know what that is, you need to learn, but this is the exact same equivalent in Google Gemini. You can simply go to gemini.google.com and go ahead and click gems and you can create your new gem. There’s a button there, it says New Gem, so you can go ahead and create it. I’m gonna show you potentially what that opportunity looks like.
Let me go ahead and pull up. Let me pull up my safe version of it here. So it’s not actual client specific data and information, but I created a Google Gem, which does the work
[00:09:00] for me. Okay. Which just based off that screenshot. So I call it the SERP Architect and CTR strategist. So SERP stands for. Search engine results, page architect and CTR stands for click-through rate.
So this in the instructions, and I can share this with anybody if they want, I can drop it in the comments and stuff like that. But what it does is it’s been trained and given parameters to be this. Basically an SEO, god, lowercase G who is just really familiar with how this works in terms of looking at that data from Google Search Council, looking at the data in terms of what’s actually being presented online, and then rewriting the meta description, the title, so that based on what it’s seeing.
We’re gonna increase performance. So instead of you trying to figure it out, it does the research for you. And then gives you the guidance to be able to go ahead and make those changes in your whatever website, CMS you have for
[00:10:00] those pages. And then you can obviously submit those manually using Google Search Council, and then, Google will visit them and hopefully, God willing.
Your rankings improve off of that, or you get better vis and you get, get better visibility on a I overviews. So this, the actual instructions area is the same we’ve got it built out for every client at this point, but it makes reference it. So it’s not specific to an actual client what is specific.
And you notice it here for our listeners, I’ve got the instructions going on for the regular Google Gem, which is just this awesome SEO lowercase g god. Okay, but it’s attached. What’s in there is attached is the knowledge base for the client. So it’s just a simple word document for me, but it’s the who, what, when, where, why, and how are the client, right?
Who are they? What they do, what they’re unique at what sales territory they are, their products and services, what makes ’em special about their competitors maybe even keywords. All that stuff. You can ram it in one
[00:11:00] document. And then make reference to it. It’s it’s told to make reference to the actual attachment anyway.
It has client information in it to go ahead and craft the right stuff. So it’s really beneficiary. You’re marrying an expert in SEO and strategies along with the knowledge base of the client. Those two things are really critical when it comes to writing really good content that’s engaging.
It’s going to help drive not only impressions, but also. Engagement or clicks and hopefully conversions. You should be tracking that too, by the way. Phones and clicks submission. So anyway, when you actually run that sucker, you end up getting a, let’s see if I can find it here. Oh, I have it right there.
Sorry. The word doc. I, so I threw it in a Word document, right? So the output in Google Gemini, you can export it out to docs and then you can download it in terms of word. I just did this so I, I wouldn’t screw with things. NetNet is, it, did the assessment. Okay. For our audio listeners,
[00:12:00] the SEO strategy demo, the CTR Clickthrough rate efficiency framework.
Objective to capture lost organic traffic by engineering SERP snippets that prioritize user intent over simple keyword density. So it looked at that first article, that first link, and again, all I did guys was in the prompt. I uploaded the screenshot of Google Search Council. That’s all I did with a simple prompt instruction.
So I can, again, I can share any of that with the comments in here, but you guys need to know this is available ’cause it saves so much time, screenshot, enter, done. And it’s a custom bot that you can do this every other, every week on a Friday or something like that for your teams to increase that stuff.
So anyway, the process clarity assets, so this is the first this would’ve been the first URL in here. Original issue, high impressions for how to get treatment queries with low clicks. Obvi identified the problem. Demo URL, so it gave me the demo URL, so you can verify that. That’s the first one, right?
It gave me the demo
[00:13:00] stats, so it told me it was 1500 impressions only achieved four clicks, which is a 0.2% CTR, so you can verify that on your Google search Council screenshot if you want. Propose meta title Telehealth Medica. Medication guides, 95% success rate. Verified MDs, much better title for this.
Much more engaging. Okay. Also the proposed meta description. Skip the pharmacy stress, learn our three step telehealth process for medication management with board certified MDs. Keep your local pharmacy. Start here. Way more engaging. ’cause literally it was much more of a dry article. It was bland.
And it did. It did rewrite it provided that suggestion. And because you know your business or your client’s business, you’re gonna be able to go ahead and say, yep, that definitely makes some sense to me. Okay. And you can adjust that instructions. If you want more detail, less detail, tell me why. Score it.
You can do all those things, but this saves a lot of
[00:14:00] time researching, pulling stuff up in incognito mode and all of that. So what would normally take 45 minutes literally will take. Maybe even more than 45 minutes with some of these. ’cause you’re not looking at AI overviews and trying to get the prompt.
If you’re doing it in incognito mode, let’s say an, let’s say it takes an hour. It now took, what, 45 seconds, right? And it has better results and your head doesn’t hurt. sign me up anytime you want for that kind of stuff. Yeah. Good information to know. Guys. I hope this is helpful for you.
If it was, feel free to share, follow, right comment. I’d love to hear from you If you don’t know what I’m talking about or you say, wow, that’s interesting, but I don’t even know where to start, reach out. But if I’ve missed anything, by all means, go ahead and let me know. Share that in the comments.
You may have better suggestions in that. This was just my way of helping to accelerate ai. For all in this case. So have a great week, folks. Again,
[00:15:00] my name is Chris Bernard from Content Engagement Lab and CB knows ai. Again, love to hear from you. Please share please have a blessed week.
Bye-bye. Okay.