Skip to content

Nozzle documentation

Data & BI

Reach Nozzle data in BigQuery, warehouses, spreadsheets, and BI tools.

Data & BI

Product guide

Data & BI

Reach Nozzle data in BigQuery, warehouses, spreadsheets, and BI tools.

View category
  1. Export Data to S3 BucketSet up a daily export of Nozzle keyword and ranking data into your own AWS S3 bucket, ready to load into Snowflake, Databricks, Redshift, or Athena.
  2. Generic QueryAn annotated BigQuery query for the Nozzle rankings dataset, covering SERP deduplication, base rank, SERP feature flags, and common filter patterns.
  3. How do I access my data in BigQuery?How to get BigQuery access to your Nozzle data: find your workspace and project slugs, request access for users or a Google Group, and open your dataset.
  4. How Do I Use My BigQuery Data in Google Data Studio?How to connect your Nozzle BigQuery data to Google Data Studio, with a starter SQL query, a basic rankings template, and a walkthrough video.
  5. Looker Studio Templates With BigQuery QueriesAn index of Looker Studio templates and BigQuery queries for Nozzle data, including PAA, PASF, product, video pack, and geo ranking reports.
  6. Which BI tools connect to Nozzle?Nozzle data lives in BigQuery, so you can connect Data Studio, Tableau, Power BI, or most other popular BI tools for reporting and visualization.
  7. Geo Ranking Report Query And TemplateA Looker Studio template and BigQuery query for a geo ranking report that maps rank by ZIP code and city using Nozzle location keyword groups.
  8. PAA Report Query And TemplateA Looker Studio template and BigQuery query for reporting on People Also Ask results in Nozzle SERP data, with the URLs and titles behind each question.
  9. Paid Product Report Query And TemplateA Looker Studio template and BigQuery query for paid product results in Nozzle SERP data, with merchant-level rank, product pack, and traffic metrics.
  10. PASF Report Query And TemplateA Looker Studio template and BigQuery query for People Also Search For results in Nozzle SERP data, with related phrases and ranking URLs.
  11. Unpaid Product Report Query And TemplateA Looker Studio template and BigQuery query for unpaid product results in Nozzle SERP data, with merchant, product pack, 3D, 360, and discount metrics.
  12. Video Pack YouTube Channel Report Query And TemplateA Looker Studio template and BigQuery query for tracking YouTube channel appearances in video packs, with channel rank, traffic, and video count metrics.
  13. SERPs Containing AI Overviews And My Domain Ranks OrganicallyGenerate a report of SERPs that contain AI overviews and your domain ranking in other unpaid results.
  14. Top 20 Ranking Results Report Query And TemplateThis report is an export of the top 20 results for all keywords being tracked in your Nozzle project. It only includes one row per ranking position.
  15. Top Stories Ranking Report Query And TemplateTop stories ranking report template that shows the rank, URL, and Domain of every visible top story result