Create a STRUCT that returns true for IS NULL if all values are NULL
When I create a column of type STRUCT in a query then IS NULL always returns false, even through all values in the struct are NULL.
AVG Engagement Time for each page in Big Query and GA4
I get different results between GA4 and Big Query by calculating Enagement Time.
Session duration longer than 30 min GA4 Bigquery
Someone could help me? I don’t know how it is possible to have sessions with this duration in GA4 BigQuery. (The limit set in GA4 is 30 min, as is by default). What could be happening? I attach an example of a user and their behavior. The number of users with this behavior is small, but it affects my calculations.
enter image description here
need help matching up Big Query to Google Analytics 4 – daily active users per cohort
We also are using the EXTRACT(DATETIME FROM TIMESTAMP_MICROS( …see below method to convert the event timestamp column to the date in the time zone of the property.
GA4 BigQuery traffic referral / acquisition fields are capturing multiple channels
I’ve just started working with the BigQuery export of GA4 data.