GA4 does not report on pages that received no traffic (zero pageviews) during the selected time period.
However, it does report on the pages that had zero pageviews on some days and one or more on others within that same period.
This means “no traffic” is dependent on the timeframe you choose.
Pages with zero pageviews do not contribute to your business goals because they generate no traffic.
By identifying these pages, you can either improve them to boost their search performance or repurpose their content.
If a web page had fewer than 30 pageviews in the last month, it means it had zero pageviews on at least one day.
This is the easiest method to determine zero-traffic pages on your website.
We would need the ‘landing page’ dimension and the ‘views’ metric to create the report that tracks web pages with zero pageviews in GA4 BigQuery.
#1 In BigQuery, you can calculate the values of the ‘Landing Pages’ dimension by extracting the values from the ‘page_location’ event parameter where 'event_name' top level field is 'page_view' and the value of 'entrances' event parameter is 1.
#2 Calculate the values of the ‘Views’ metric by counting the total number of 'page_view' events for each 'Landing Page'.
#3 We only want those rows of the data table where the value of 'Views' for each landing page is less than 30.
Once you understand the logic, tracking web pages with zero pageviews via text prompt is easy.
The SQL below is automatically generated via a text prompt in GA4 BigQuery Composer (a custom chatGPT) that calculates unique users in GA4 BigQuery: