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…

Dec 14, 2023

SQL Fundamentals for Beginners

Dec 14, 2023

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.

Dec 11, 2023

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

Dec 11, 2023

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

Dec 9, 2023

GA4 Pseudonymous Users and User Tables in BigQuery — Optizent

Dec 9, 2023

The Power of Internal and External Positioning

One Insight You Can Apply Right Away

Dec 8, 2023

The Power of Internal and External Positioning

Dec 8, 2023

What Happens When Cookies Go Away?

Three Insights You Can Apply Right Away

Nov 28, 2023

Nov 28, 2023

GA4 Data Organization in BigQuery

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

Nov 12, 2023

GA4 Data Organization in BigQuery

Nov 12, 2023

How to Connect GA4 with BigQuery — Optizent

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

Oct 31, 2023

How to Connect GA4 with BigQuery — Optizent

Oct 31, 2023

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…

Oct 24, 2023

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

Oct 24, 2023

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…

Oct 21, 2023

Oct 21, 2023

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…

Oct 20, 2023

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

Oct 20, 2023

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,142)

Help
Status
About
Careers
Press
Blog
Privacy
Terms
Text to speech
Teams