---
title: How Do I Use My BigQuery Data in Google Data Studio?
description: Use these resources and example templates to start generating reports in Google Data Studio.
---

[Skip to content](https://help.nozzle.io/how-do-i-use-my-bigquery-data-in-google-data-studio#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)

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

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](https://help.nozzle.io/how-do-i-access-my-data-in-bigquery?hsLang=en). 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.

[Query SQL Code](https://gist.github.com/boydnorwood/e19086c77c477b8ad32f00d0c1247add)

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

[Basic template](https://datastudio.google.com/u/1/reporting/359d4414-0cd6-4da1-8df5-2c6908e0ddec/page/pyxcB)

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

 

<iframe class="hippo-embed-frame " width="720" height="405" scrolling="no" style="display: block; margin-left: auto; margin-right: auto" frameborder="0" marginwidth="0" marginheight="0" src="https://www.hippovideo.io/video/embed/uV4-nxKIqUuodH5Mb97C9qqKSythlWOrL3WyY89hufM?custom_asset_token=null&amp;hvlk=Vm7Pg841aQ5R&amp;org_tok=SMXMc2E_ccm7M8nQFzYxGQ&amp;autoplay=false" allowfullscreen></iframe>

 

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