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

Get an email whenever Anil Batra publishes.

By signing up, you will create a Medium account if you don’t already have one. Review our Privacy Policy for more information about our privacy practices.

Medium sent you an email at to complete your subscription.

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

GA4 Site Search Tracking & Report — What, Why and How — Optizent

GA4 Site Search tracking is a feature that lets you track the keywords users are searching on your site. These are not the keywords that…

Oct 20, 2023

GA4 Site Search Tracking & Report — What, Why and How — Optizent

Oct 20, 2023

Average Engagement Time vs Average Time on Page (GA4 vs/ UA) — Optizent

Comparing Average Engagement Time in GA4 with Average Time on Page with UA is like comparing apples to oranges. Even though seems like…

Jul 30, 2023

Average Engagement Time vs Average Time on Page (GA4 vs/ UA) — Optizent

Jul 30, 2023

5 Action items to get you up to speed on GA4 — Optizent

As you might already know, Universal Analytics (also called GA3 or UA, the old version of Google Analytics) will stop collecting data as…

May 11, 2023

May 11, 2023

Why are Metrics Different Between Universal Analytics and GA4?

As you migrate from Universal Analytics to GA4, you are going to be comparing the metrics between the two versions of Google Analytics…

Mar 29, 2023

Mar 29, 2023

GA4 is Bad. I Don’t Like GA4.

GA4 is bad. I don’t like GA4. If you have heard that or felt that then you are not alone. This is a sentiment that many long-time users of…

Feb 14, 2023

GA4 is Bad. I Don’t Like GA4.

Feb 14, 2023

Top 10 Tips for Learning Digital Analytics — Optizent

Here are my top 10 tips to help you learn and master Digital Analytics. Even though I am focusing on Digital Analytics, these same tips…

Sep 15, 2022

Sep 15, 2022

Bounce Rate in Google Analytics 4 — Optizent

Bounce Rate is one of the most common metrics used by marketers and analysts using Google Analytics. However, if you are transitioning or…

Jan 5, 2021

Bounce Rate in Google Analytics 4 — Optizent

Jan 5, 2021

What is Google Analytics 4 (GA4)? — Optizent

What is Google Analytics 4

Nov 28, 2020

Nov 28, 2020

Google Analytics 4 — What, Why, and How

What is Google Analytics 4?

Oct 20, 2020

Oct 20, 2020

Risks With Third-Party JavaScripts And How To Mitigate Them

You likely have plenty of 3rd party JavaScript and tags implemented on your site. These JavaScript allow you to track user behavior, help…

Jul 20, 2020

Jul 20, 2020

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

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