Data & BI
How Do I Use My BigQuery Data in Google Data Studio?
Use these resources and example templates to start generating reports in Google Data Studio.
Updated June 3, 20241 min read
Contents
You can connect your BigQuery data to Google Data Studio to generate your reports.
The first thing you need to do is request access to BigQuery. Then, you can use the following code and template to get started.
Get the code to create a query
You will need to use this SQL code to create a query in BigQuery.
Get a basic rankings template
You can use this basic template to get started. This is a simple way to display all the information the query is retrieving.
How to put it all together
Now that you have the query code and a basic template, check out this video to see how you can use them to get the data you need.
Related articles
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.How do I export my Nozzle data?An overview of the ways to get data out of Nozzle, from one-off CSV downloads to live BigQuery access, and which to pick for what you're doing.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.