Data & BI
Data & BI

Looker Studio Templates With BigQuery Queries

An index of Looker Studio templates and BigQuery queries for Nozzle data, including PAA, PASF, product, video pack, and geo ranking reports.

Updated March 4, 20261 min read

BigQuery

Generic Query

This gives you an idea of several things you can query from the database. It includes notes in the query to help you out.

Looker Studio Templates And Queries:

Geo Ranking Report

Geo Ranking Report template: a map of ZIP code areas shaded by rank beside a location and rank table

PAA Report Query And Template

People Also Ask report template in Looker Studio

Unpaid Product Report Query And Template

Unpaid product report template in Looker Studio, showing the Merchant Analysis page

Paid Report Query And Template

Paid product report template in Looker Studio, showing the Paid Merchant Analysis page

PASF Report Query And Template

People Also Search For report template in Looker Studio

Video Pack YouTube Channel Report Query And Template

Video Pack YouTube channel report template in Looker Studio, showing the Video Channel Analysis page

Google Sheets/Excel Templates

SERPs Containing AI Overviews And Where Certain Domain Ranks

Google Sheets template listing the SERPs that contain AI Overviews and where a domain ranks

Top 20 Ranking Results Report Query And Template

top 20 ranking results export

Related articles

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