---
title: SERPs Containing AI Overviews And My Domain Ranks Organically
description: Generate a report of SERPs that contain AI overviews and your domain ranking in other unpaid results.
---

[Skip to content](https://help.nozzle.io/serps-containing-ai-overviews-and-my-domain-ranks-organically#main-content)

[Customer portal](https://help.nozzle.io/tickets?hsLang=en)

![logo-blue copy 2.png\]](https://help.nozzle.io/hs-fs/hubfs/logo-blue%20copy%202.png?height=33&name=logo-blue%20copy%202.png)

- [Tickets](https://help.nozzle.io/tickets)

Open main navigation

Close main navigation

- [Tickets](https://help.nozzle.io/tickets)
- [Customer portal](https://help.nozzle.io/tickets)
- [Nozzle - Enterprise Keyword Rank Tracker](https://nozzle.io/)

[Nozzle - Enterprise Keyword Rank Tracker](https://nozzle.io/)

 How can we help you?

- There are no suggestions because the search field is empty.

1. [Support Home](https://help.nozzle.io/?hsLang=en)
2. [BigQuery](https://help.nozzle.io/bigquery?hsLang=en)
3. [Google Sheets/Excel Templates and Queries](https://help.nozzle.io/bigquery?hsLang=en#google-sheets-excel-templates-and-queries)

# SERPs Containing AI Overviews And My Domain Ranks Organically

Example Of This Report

[https://docs.google.com/spreadsheets/d/1omXTbvOrg0zKGM\_WQfJAMckp-geEA0u5BiibkrRSEQI/edit?gid=1209713781#gid=1209713781](https://docs.google.com/spreadsheets/d/1omXTbvOrg0zKGM_WQfJAMckp-geEA0u5BiibkrRSEQI/edit?gid=1209713781#gid=1209713781)

![](https://help.nozzle.io/hs-fs/hubfs/image-png-Jun-25-2025-06-32-04-1428-PM.png?width=688&height=351&name=image-png-Jun-25-2025-06-32-04-1428-PM.png)

```
WITHlatest_rankings AS (  SELECT AS VALUE    ARRAY_AGG(t ORDER BY inserted_at DESC LIMIT 1)[OFFSET(0)]  FROM nozzledata.nozzle_reidemo.rankings t  WHERE DATE(requested) >= '2025-06-01'  GROUP BY ranking_id),asd AS (  SELECT    keyword_id,    requested,    IF(COUNTIF(result.rank = 1 AND result.layout.in_ai_overview IS TRUE) > 0, TRUE, FALSE) AS has_rank1_ai_overview,    IF(COUNTIF(result.rank = 1 AND result.layout.in_ai_overview IS TRUE AND result.url.domain = 'rei.com') > 0, TRUE, FALSE) AS pinterest_in_rank1_ai_overview,    IF(COUNTIF(result.layout.in_ai_overview IS NOT TRUE AND result.url.domain = 'pinterest.com') > 0, TRUE, FALSE) AS pinterest_ranks_outside_ai_overview,  FROM latest_rankings  JOIN UNNEST(results) AS result  GROUP BY keyword_id, requested  HAVING has_rank1_ai_overview IS TRUE)SELECT  requested,  keyword_id,  phrase,  device_code,  country_code,  language_code,  asd.* EXCEPT(keyword_id, requested),FROM asdJOIN nozzledata.nozzle_reidemo.latest_keywords_by_keyword_id k USING (keyword_id)ORDER BY requested, phrase
```

- [Getting Started](https://help.nozzle.io/getting-started?hsLang=en)
- [Keyword Management](https://help.nozzle.io/keyword-management?hsLang=en)
- [Brand Management](https://help.nozzle.io/brand-management?hsLang=en)
- [Reputation Management](https://help.nozzle.io/reputation-management?hsLang=en)
- [Account Management](https://help.nozzle.io/account-management?hsLang=en)
- [Segments](https://help.nozzle.io/segments?hsLang=en)
- [BigQuery](https://help.nozzle.io/bigquery?hsLang=en#main-content)

    - [Looker Studio Templates And Queries](https://help.nozzle.io/bigquery?hsLang=en#looker-studio-templates-and-queries)
    - [Google Sheets/Excel Templates and Queries](https://help.nozzle.io/bigquery?hsLang=en#google-sheets-excel-templates-and-queries)
- [Dashboards](https://help.nozzle.io/dashboards?hsLang=en#main-content)

    - [Exports](https://help.nozzle.io/dashboards?hsLang=en#exports)
- [Keyword Clustering](https://help.nozzle.io/keyword-clustering?hsLang=en)
- [Troubleshooting](https://help.nozzle.io/troubleshooting?hsLang=en)
- [Data Engineering](https://help.nozzle.io/data-engineering?hsLang=en)
- [API](https://help.nozzle.io/api?hsLang=en#main-content)

    - [cURL](https://help.nozzle.io/api?hsLang=en#curl)
- [BI](https://help.nozzle.io/bi?hsLang=en)
- [Metrics](https://help.nozzle.io/metrics?hsLang=en#main-content)

    - [Share Of Voice %](https://help.nozzle.io/metrics?hsLang=en#share-of-voice)
    - [Metric Picker](https://help.nozzle.io/metrics?hsLang=en#metric-picker)

[![SMX\_weblogo.png](https://help.nozzle.io/hs-fs/hubfs/SMX_weblogo.png?width=159&height=85&name=SMX_weblogo.png "SMX_weblogo.png")](https://help.nozzle.io/?hsLang=en)

<https://twitter.com/nozzleio> <https://www.youtube.com/channel/UC6vTEcp-zzbgN2mJijLx6TA> <https://www.linkedin.com/company/nozzle/>

Copyright © 2026, Nozzle