Anil Batra – Medium

Anil Batra

SQL Fundamentals for Beginners

If you are new to SQL then this is for you. If you already know SQL fundamentals then skip this post and check out the latest edition of…

2 min readDec 14, 2023

--

SQL Fundamentals for Beginners

--

Anil Batra

GA4 captures a wealth of data in event parameter columns, representing custom parameters…

BigQuery uses a column (or field) of data type “record” to store the record of all the event parameters and their values.

3 min readDec 11, 2023

--

GA4 captures a wealth of data in event parameter columns, representing custom parameters…

--

Anil Batra

GA4 Pseudonymous Users and User Tables in BigQuery — Optizent

When you export GA4 data to BigQuery, you will see one or two user tables, depending on your GA4 implementation. These tables are

7 min readDec 9, 2023

--

GA4 Pseudonymous Users and User Tables in BigQuery — Optizent

--

Anil Batra

The Power of Internal and External Positioning

One Insight You Can Apply Right Away

3 min readDec 8, 2023

--

The Power of Internal and External Positioning

--

Anil Batra

What Happens When Cookies Go Away?

Three Insights You Can Apply Right Away

2 min readNov 28, 2023

--

--

Anil Batra

GA4 Data Organization in BigQuery

In this post, we will go over the BigQuery organization of GA4 data in BigQuery.

3 min readNov 12, 2023

--

GA4 Data Organization in BigQuery

--

Anil Batra

How to Connect GA4 with BigQuery — Optizent

In the previous post. I provided various reasons to send the GA4 data to BigQuery.

2 min readOct 31, 2023

--

How to Connect GA4 with BigQuery — Optizent

--

Anil Batra

Audience Triggers in GA4: What, Why and How — Optizent

Audience triggers in GA4 let you trigger (fire) an event when a user matches the definition of an audience and becomes a member of the…

4 min readOct 24, 2023

--

Audience Triggers in GA4: What, Why and How — Optizent

--

Anil Batra

GA4 BigQuery event_timestamp field Demystified

When you send GA4 data to BigQuery the event table has two fields event_date and event_timestamp. event_date field contains the date in…

2 min readOct 21, 2023

--

--

Anil Batra

How to Track Scroll Depth in Google Analytics 4 (GA4)? — Optizent

Most of the sites these days have long pages, which means users must scroll down to view the complete page. If you want to track various…

5 min readOct 20, 2023

--

How to Track Scroll Depth in Google Analytics 4 (GA4)? — Optizent

--

Anil Batra

Anil Batra

Digital Marketing Strategy and Analytics expert. Helping Fortune 50 customers with #GrowthHacking, #analytics #search #digitalmarketing #socialmedia #retail

Following

See all (1,143)

Help
Status
About
Careers
Blog
Privacy
Terms
Text to speech
Teams