-
You’re not alone facing this issue as Google Analytics 4 (GA4) has changed how it handles certain data, especially around high-cardinality dimensions. High-cardinality dimensions like pagePathPlusQueryString and FullPageURL can’t be mixed with a time-series dimension like dateHourMinute in GA4. This is a limitation set by Google to avoid queries that could return an excessive number of rows. There’s currently no perfect solution to overcome this limitation in GA4, however, alternative approach can be applied. You might consider exporting your GA4 data to BigQuery, where these restrictions won’t apply, and then using SQL to return the result you’re looking for. Another alternative might be to look at using other tools that specialize in this kind of data analysis.
