Steep
Overview
Steep is a product analytics tool built natively on BigQuery. Because it queries BigQuery directly, connecting it to the Decode GA4 events table requires only a BigQuery data source — no data movement or exports needed.
Requirements
- A Steep account
- A Decode GA4 installation with the
eventstable accessible in BigQuery - A Google Cloud service account with BigQuery Data Viewer and BigQuery Job User roles on the project
Setup
1. Connect BigQuery
In Steep, open Settings → Data Sources and add a BigQuery connection. Provide your GCP project ID and upload your service account JSON key.
2. Add the events table
Once connected, add the Decode GA4 events table as a data source. Point Steep to the dataset and table name you configured as destination_dataset_id during your Decode GA4 installation.
3. Query events
Use Steep's query editor or metric builder to query the events table directly. For example, to track pageviews:
select
partition_date AS event_date,
event_param.page_location,
count(*) as pageviews
from your-gcp-project-id.your_dataset.events
where event_name = 'page_view'
group by partition_date, page_location
order by partition_date descReplace your_dataset with the dataset containing the Decode GA4 events table.