Topic-40: Decoding Engagement in GA4 BigQuery

1 min read

Topic-39: The Query Logic for Calculating Engaged Users

1 min read

Topic-38: Introduction to Engaged Users

1 min read

Topic-37: Re-calculating Active Users with more precision

2 min read

Topic-36: More Accurate Query Logic for Calculating Active Users

1 min read

Topic-35: Limitations of Calculating Active Users via 'is_active_user'

1 min read

Topic-34: Calculating Active Users

2 min read

Topic-33: Calculating 'Total Users', 'New Users' and 'Returning Users'

1 min read

Topic-32: Calculating New vs Returning Users in GA4 BigQuery

2 min read

Topic-31: The best logic for calculating New, Returning and Total Users

1 min read

Topic-30: The new logic to identify New and Returning users

1 min read

Topic-29: The old logic for calculating New and Returning users

1 min read

Topic-28: Any GA4 event can start a new session

1 min read

Topic-27: Understanding 'ga_session_number'

1 min read

Topic-26: Tracking the journey of an individual user

1 min read

Topic-25: How to extract the User Property data

3 min read

Topic-24: User Property fields in GA4 BigQuery data table

1 min read

Topic-23: 10,000 foot view of using User Properties

3 min read

Topic-22: When to create a User Property?

1 min read

Topic-21: Categories of User Properties in GA4

Topic-20: Introduction to User Property in GA4

Topic-19: Calculating Unique Users by Device Category

1 min read

Topic-18: Accessing Device Information of users

2 min read

Topic-17: Make sure any empty value is converted to NULL

2 min read

Topic-16: Working with Geolocations in GA4 BigQuery

2 min read

Topic-15: Calculating unique users by Traffic Source, Medium and Campaign Name

2 min read

Topic-14: Calculating First Time Users

2 min read

Topic-13: Calculating Unique Users

1 min read

Topic-12: Default vs Calculated Dimensions and Metrics in GA4 BigQuery

1 min read

Topic-11: Returning users in BigQuery

2 min read