Topic-16: (not set) Landing Pages in GA4 UI

1 min read

Topic-15: (not set) Landing Pages often show 0 Entrances

1 min read

Topic-14: Understanding (not set) Landing Pages

1 min read

Topic-13: A Landing Page is tied to a unique session

1 min read

Topic-12: The Logic for Calculating Landing Page Dimension

1 min read

Topic-11: Calculating Unique Pageviews in BigQuery

2 min read

Topic-10: Formula for calculating Unique Pageviews

Topic-9: Unique Pageviews for (not set) Page Titles

1 min read

Topic-8: Method 2: user_pseudo_id + ga_session_id + page_title

Topic-7: Issues with NULL or (not set) values in 'page_title'

Topic-6: Loss of Page Level Granularity

1 min read

Topic-5: Method 1: user_pseudo_id + ga_session_id

Topic-4: Methods to calculate Unique Pageviews

Topic-3: Calculating Page Titles, Page Paths and PageViews

2 min read

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