Write GA4 BigQuery Queries
Without Writing SQL

This tool lets you skip the code and get straight to insights. Build clean SQL queries with AI, no syntax required. Just select dimensions, filters, or metrics and watch the query generate in seconds.

Faster SQL
Let AI handle the syntax so you can focus on what you want to analyse.

Cleaner Joins
Join tables automatically using AI-recommended logic and structure.

Standardised Output
Reduce messy SQL variants across teams and improve readability.

Perfect for marketers
No BigQuery experience required. Build, run, and interpret data confidently.

Want to explore the data structure manually? Read the GA4 export schema.

Start Building a Query

Project ID:
Dataset:
Start Date (YYYYMMDD):
End Date (YYYYMMDD):

User

user_id

user_pseudo_id

Session

session_id

traffic_source.campaign

traffic_source.medium

traffic_source.source

Time

event_date

event_timestamp

hour

minute

month

week

year

Event

event_name

event_parameter_string_value

event_parameter_integer_value

event_parameter_float_value

event_parameter_double_value

Privacy

ads_storage

analytics_storage

uses_transient_token

Device

device.category

device.mobile_brand_name

device.mobile_model_name

device.operating_system

device.operating_system_version

device.web_info.hostname

Geo

geo.city

geo.country

geo.region

geo.sub_continent

Page / Screen

page_location

page_title

screen_name

screen_class

Platform

platform

stream_id

Ecommerce

transaction_id

item_id

item_name

item_category

Order By:

🧾 Generated SQL Preview

Ready to fix your tracking or run smarter tests? Let’s talk.

Whether you need to fix your tracking, improve your reporting, or run better experiments, we help businesses of all sizes turn analytics and CRO into a real growth engine. Get in touch to see how better data and faster testing can accelerate your results.

Thank you! Your submission has been received!

Oops! Something went wrong while submitting the form.

Write GA4 BigQuery QueriesWithout Writing SQL