Topic-2: Adding the 'Total' row as the top row when calculating Page Titles and Pageviews

2 min read

Topic-1: Calculating Page Titles and PageViews

1 min read

Topic-19: Creating a Pivot Table

3 min read

Topic-18: Creating Nested Rows in a data table

4 min read

Topic-17: Creating a regular (flat) table

1 min read

Topic-16: Regular Table vs. Table with Nested Rows vs. Pivot Table

1 min read

Topic-15: Calculating the 'Sessions Source/Medium' field

2 min read

Topic-14: Tracking UTM Parameters in GA4 BigQuery

2 min read

Topic-13: Introduction to UTM Parameters in GA4 BigQuery

1 min read

Topic-12: Calculating AI Traffic

2 min read

Topic-11: How to extract event parameters sent along with an event

2 min read

Topic-10: Re-calculating Sessions and Engaged Sessions by Traffic Source and Medium

2 min read

Topic-9: The root cause of data type inconsistencies

Topic-8: Foolproof query logic to handle data type variations

Topic-7: Account for all possible data types when querying

1 min read

Topic-6: Why Google does not provide pre-calculated fields for every GA4 Dimension and Metric

1 min read

Topic-5: Difference between two methods

5 min read

Topic-4: Calculating Sessions and Engaged Sessions by Traffic Source and Medium (Alternative Method)

2 min read

Topic-3: Calculating Sessions and Engaged Sessions by Traffic Source and Medium

2 min read

Topic-2: Formula for calculating Engaged Sessions Metric

Topic-1: Formula for calculating Sessions metric

1 min read

Topic-41: Mixing Dimensions of Different Scopes

1 min read

Topic-40: Downward and Upward Analysis

1 min read

Topic-39: Mixing GA4 Dimensions & Metrics of different scopes

Topic-38: Importance of GA4 Scopes

1 min read

Topic-37: Do not Split GA4 BigQuery Tables - Keep them Nested

1 min read

Topic-36: Understanding Rule-4 for Data Aggregation in GA4 BigQuery

Topic-35: Understanding Rule-3 for Data Aggregation in GA4 BigQuery

1 min read

Topic-34: Understanding Rule-2 for Data Aggregation in GA4 BigQuery

Topic-33: Understanding Rule-1 for Data Aggregation in GA4 BigQuery