Complex data processing that was difficult to express with SQL alone, and calculations using powerful Python libraries, can now be executed seamlessly within BigQuery. In this article, I will explain ...

You can track the values of the GA4 Unique Users metric in BigQuery by counting the unique values of the 'user_pseudo_id' or 'user_id'. Use the following SQL (automatically generated via a text prompt ...

You can calculate the values of the GA4 ‘Engaged Sessions’ metric in BigQuery by counting distinct sessions for which the value of the ‘session_engaged’ event parameter is 1. The ‘session_engaged’ is ...

I am S from the analytics team. Are you all familiar with BigQuery's text generation AI functions? These are new functions released about half a year ago, and since there is still little knowledge ...

The analysis is based on Google Analytics 4 (GA4) data exported to Google BigQuery, representing the Google Merchandise Store, a real e-commerce website selling branded merchandise. It contains data ...