Generate custom GA4 BigQuery SQL using plain English prompts and structured inputs. The export schema is consistent for all GA4 users, but you can refer to
this official documentation
to understand how the data is structured.
User
user_id
user_pseudo_id
Session
session_id
traffic_source.campaign
traffic_source.medium
traffic_source.source
Device
device.category
device.mobile_brand_name
device.mobile_model_name
device.operating_system
device.operating_system_version
Geo
geo.city
geo.country
geo.region
geo.sub_continent
Page / Screen
page_location
page_title
landing_page
Platform
platform
stream_id
Ecommerce
transaction_id
item_id
item_name
item_category
Time
event_date
event_name
hour
minute
month
week
year
Count All
Total Users
New Users
Returning Users
Count Sessions
Engaged Sessions
Engagement Rate
Events Per User
Events Per Session
Event Count
Purchase Revenue
Average Revenue
Purchases
First Time Purchasers
Total Purchasers
Average Event Value
Sum of Event Value
🧾 Suggested SQL
Contact us
As a specialist analytics and CRO agency, we work closely with clients to make data a driving force behind smarter decisions and stronger performance.
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.
Unlock Our Free Big Query Generator
Enter your email to access the tool and get early access to future features and insights. We respect your privacy —
read our Privacy Policy.
