How to measure the CTR impact of Google’s AI Overviews using third-party visibility tools and the GSC API

2025-05-30

Download

Have you read AI Overview studies and wondered how *your own site* is being impacted? I got you covered. This video covers my blog post that walks you step-by-step through combining third-party AIO data with Google Search Console performance data (via the Search Console API) and using vlookup magic to see the change in clicks and CTR when AIOs are ranking for your queries. Note, this definitely works best for sites with a lot of search visibility and traffic from Google. So if your site doesn't have a ton of...

Note, this definitely works best for sites with a lot of search visibility and traffic from Google. So if your site doesn't have a ton of visibility, this process might not yield great results. BTW, having to write a 14-step process using multiple third-party tools, the GSC API, etc., to TRY to analyze AIO impact is RIDICULOUS, but that's exactly what Google wants unfortunately. And no, I don't think we will get AIO or AI Mode data broken out, so this may be the best approach for site owners trying to gauge the impact of AIOs on clicks and CTR.

Note, AIOs officially rolled out in May of 2024, so you can definitely compare to pre-AIO SERPs if you want (or any timeframe you want to compare to). I've been running this for several clients and it works pretty well (especially for larger-scale sites with a lot of search visibility and traffic from Google). So watch this video and read my blog post, walk through the steps, run the numbers, and analyze the impact of AIOs for your own site. You might be surprised with what you find -- or not. :) Have fun.

Blog post:

https://www.gsqi.com/marketing-blog/how-to-measure-the-impact-of-google-ai-overviews/

Chapters:

00:00 Tracking the impact of AI Overviews on CTR and clicks.

01:01 Combining third-party AIO data and GSC performance data.

03:00 Exporting all AIO data via third-party visibility tools.

04:08 Export GSC data via the Search Console API (for two timeframes).

05:40 Apply vlookup magic in Excel.

07:31 An example of CTR and clicks impact based on AIOs ranking.

08:41 Recommendations and tips for site owners.

11:08 My thoughts about why Google isn't breaking out AIO data in GSC.

13:07 Summary: Tell me how this goes for you!