Looker Studio
Overview
Looker Studio (Google's free BI tool) connects through BigQuery. We load your data into BigQuery, and you build dashboards on top of it.
Setup
- 1
Set up the BigQuery destination first (see BigQuery guide).
- 2
Go to lookerstudio.google.com and create a new data source connected to your BigQuery dataset.
- 3
Build dashboards using your synced ecommerce data.
Tips
- Looker Studio is completely free. The only cost is BigQuery storage/queries.
- You can share Looker Studio dashboards with clients or team members.
Fields Required
GCP Project ID
my-gcp-project
Dataset ID
ecommerce_data
Service Account JSON
{"type": "service_account", ...}
Setup Guide
- 1
Follow the BigQuery setup below to get your Project ID, create a Dataset, and generate a Service Account JSON.
- 2
Go to Looker Studio and click "+ Create" > "Data source", then select BigQuery.
https://lookerstudio.google.com/ - 3
Select your project and dataset — Looker Studio will read tables from it automatically.
- 4
Paste the same Project ID, Dataset ID, and Service Account JSON in our form.
Tips
- We load data into BigQuery, and Looker Studio reads from it — no separate Looker credentials needed.
- Looker Studio is free. The only cost is BigQuery storage and query usage.