Sample BigQuery Queries

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

 

PAA Report Query And Template

 

Unpaid Product Report Query And Template

 

Paid Report Query And Template

 

PASF Report Query And Template

 

Video Pack YouTube Channel Report Query And Template

 

Google Sheets/Excel Templates

SERPs Containing AI Overviews And Where Certain Domain Ranks

 

Top 20 Ranking Results Report Query And Template

top 20 ranking results export