Data Studio

Overview

Data Studio is Google's free, browser-based BI tool. It connects natively to BigQuery, making it straightforward to build dashboards over the Decode GA4 events table with no additional infrastructure.

Requirements

  • A Google account with access to Data Studio
  • A Decode GA4 installation with the events table accessible in BigQuery
  • BigQuery read access for the Google account or service account used by Data Studio

Setup

1. Create a new report

In Data Studio, click Create → Report. When prompted to add a data source, select BigQuery.

2. Connect to the events table

In the BigQuery connector, select:

  • Project — your GCP project ID
  • Dataset — the dataset you configured as destination_dataset_id in your Decode GA4 installation
  • Tableevents

Click Add to connect.

3. Build your dashboard

Data Studio maps each column in the events table to a dimension or metric. Key fields to use:

Field Type Notes
partition_date Dimension (Date) Use as your date range dimension
event_name Dimension Filter to specific events
event_param.page_location Dimension Page URL
Record Count Metric Count of events

Add charts, scorecards, and filters using the toolbar. Use partition_date as the date range control dimension to enable date filtering across the report.

Further Reading