---
title: PAA Report Query And Template
description: PAA report template in Looker Studio using Nozzle data in BigQuery.
---

[Skip to content](https://help.nozzle.io/paa-report-query-and-template#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. [Looker Studio Templates And Queries](https://help.nozzle.io/bigquery?hsLang=en#looker-studio-templates-and-queries)

# PAA Report Query And Template

PAA Ranking Report Template:

[https://lookerstudio.google.com/u/0/reporting/25688d09-231c-4b15-9073-506c80c03aad/page/p\_gfuejdk4jd](https://lookerstudio.google.com/u/0/reporting/25688d09-231c-4b15-9073-506c80c03aad/page/p_gfuejdk4jd)

![](https://help.nozzle.io/hs-fs/hubfs/image-png-Jun-24-2025-06-08-21-2888-PM.png?width=688&height=515&name=image-png-Jun-24-2025-06-08-21-2888-PM.png)

```
--PAA Report: REI >> PAA Deep Analysis QueryWITH-- this grabs the latest version of each SERP, in case we reparselatest_filtered_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) BETWEEN '2024-07-01' AND '2025-01-31'  GROUP BY ranking_id),raw_data AS (  SELECT *  FROM latest_filtered_rankings  JOIN nozzledata.nozzle_reidemo.latest_keywords_by_keyword_id USING (keyword_id)),paa AS (  SELECT    ranking_id,    result.rank,    result.item_rank,    related_phrase,  FROM raw_data  JOIN UNNEST(results) AS result  WHERE result.people_also_ask.is_people_also_ask IS TRUE ),paa__featured_snippets AS (  SELECT    keyword_id,    requested,    phrase,    (SELECT ARRAY_AGG(kg) FROM UNNEST(keyword_groups) kg WHERE NOT STARTS_WITH(kg, '- ')) AS keyword_groups,    keyword_metrics.adwords_search_volume AS search_volume,    device,    paa.related_phrase,    result.url.domain,    result.url.url,    result.title.text AS title,    result.description.text AS description,  FROM raw_data  JOIN UNNEST(results) AS result  JOIN paa ON paa.ranking_id = raw_data.ranking_id AND paa.rank = result.rank AND paa.item_rank = result.parent_item_rank)SELECT * FROM paa__featured_snippets
```

- [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