Topic-2: Introduction to Data Aggregation Levels

Topic-1: Introduction to Query Logic

Topic-5: When users are most likely to visit your website

2 min read

Topic-4: Show total pageviews for each day in the last 30 days

1 min read

Topic-3: Retrieving data based on dynamic dates

2 min read

Topic-2: Working with Dates

2 min read

Topic-1: Working with Time

1 min read

Topic-49: Calculating Conversion Paths

3 min read

Topic-48: Logic for Calculating Conversion Paths

Topic-47: Calculating User Paths (Example-2)

3 min read

Topic-46: Calculating User Paths (Example-1)

2 min read

Topic-45: Logic for Calculating User Paths

1 min read

Topic-44: How does 'engagement_time_msec' work?

2 min read

Topic-43: Understanding 'engagement_time_msec' in GA4 BigQuery

1 min read

Topic-42: Understand User Engagement in GA4

Topic-41: Calculating Engaged Users

2 min read

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