How to Define Unique Visitors in GA4 BigQuery (Properly!)

Описание: 🔗 Try OWOX Data Marts free https://c.owox.com/8Dd7rc

👇 Grab the full SQL script and build your own GA4 Visitors Data Mart.
https://github.com/OWOX/owox-data-mar...

Ever tried answering “How many visitors did we have last week?” in GA4?

It’s not as simple as it sounds — especially if you’re using GA4 BigQuery exports.

Some dashboards use user_pseudo_id, others count sessions, and suddenly every team sees a different “visitor” number.

In this video, I’ll walk you through the exact SQL logic I use to define GA4 Visitors consistently — and show you how to document it properly using OWOX Data Marts.

👇 What you’ll learn in this video:
Create a Data Mart for Visitors using GA4 BigQuery export
SQL logic that aggregates user_pseudo_id into one row per visitor
How to define first and last seen dates
Why traffic source and geo aren’t visitor attributes
How to document your output with aliases and descriptions
Reuse your visitor logic in Looker Studio, Sheets, Tableau, or Power BI
Avoid duplicated logic, misalignment, and wasted time across teams

If you care about having clean, reliable metrics across all your dashboards, this one’s for you.

📺 Also check out:
[GA4 Sessions Video]    • Define GA4 Sessions SQL That Actually Works  
[GA4 Pageviews Video]    • How to Define GA4 Pageviews in BigQuery (S...  

⏱ TIMESTAMPS

00:00 Why “visitors” is confusing in GA4 BigQuery
00:45 Step 1 — SQL logic to define GA4 visitors
01:35 Step 2 — What NOT to include (like traffic source & geo)
02:17 Step 3 — Add business-friendly aliases & descriptions
03:14 Step 4 — Reuse in Google Sheets, Looker Studio, etc.
Consistent metrics, documented once

#ga4 #ga4bigquery #googleanalytics #marketinganalytics #sql #dataanalytics #digitalanalytics #dataengineering #owox #reusablesql