When you use Google Advanced Consent Mode, the data discrepancy between your GA4 property and GA4 BigQuery export increases considerably.....

Here is how you can calculate the total number of users in GA4 BigQuery. GA4 defines ‘Total users’ as the total number of unique users who have logged an event....

Here is how you can report on New vs. Returning Users in GA4 BigQuery data table. Both ‘New’ and ‘Returning’ users metrics need to be manually calculated. ...

Here is how you can calculate ‘sessions’ and ‘engaged sessions’ in GA4 BigQuery. First thing first.  Both ‘sessions‘ and ‘engaged sessions’ metrics need to be manually calculated.  They are no...

Here’s a breakdown of GA4 Advertising Metrics and their corresponding BigQuery fields:...

Here’s a breakdown of GA4 User Metrics and their corresponding BigQuery fields:...

Here’s a breakdown of GA4 User Dimensions and their corresponding BigQuery fields:...

Here’s a breakdown of GA4 Session Metrics and their corresponding BigQuery fields:...

Here’s a breakdown of GA4 Session-Scoped Traffic Dimensions and their corresponding BigQuery fields:...

Here’s a breakdown of GA4 User-Scoped Traffic Dimensions and their corresponding BigQuery fields:...

Here’s a breakdown of GA4 Platform/Device dimensions and their corresponding BigQuery fields:...

Here’s a breakdown of GA4 Page/Screen metrics and their corresponding BigQuery fields:...

Here’s a breakdown of GA4 Page/Screen dimensions and their corresponding BigQuery fields:...

Here’s a breakdown of GA4 Link dimensions and their corresponding BigQuery fields:...

Here’s a breakdown of GA4 Geography dimensions and their corresponding BigQuery fields:...

Here’s a breakdown of GA4 event metrics and their corresponding BigQuery fields:...

Here’s a breakdown of GA4 event dimensions and their corresponding BigQuery fields:...

Here’s a breakdown of GA4 Revenue metrics and their corresponding BigQuery fields:...

Here’s a breakdown of GA4 item-scoped ecommerce metrics and their corresponding BigQuery fields:...

Here’s a breakdown of GA4 event-scoped ecommerce metrics and their corresponding BigQuery fields:...