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 events table 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 desc

Replace your_dataset with the dataset containing the Decode GA4 events table.

Further Reading