-
In Google Analytics 4, ‘Engagement Rate’ is calculated as the total number of ‘Engagement Events’ divided by the total number of ‘Users’, (Engagement Events / Users)*100. In BigQuery, the calculation involves a similar approach. First, you will need to count the engagement events from the ‘events’ table, and then divide it by the total number of users from the ‘user_pseudo_id’ field. The ‘events’ table contains the details of each interaction or engagement event made by users, like first_open, app_remove, etc. The ‘user_pseudo_id’ is an identifier for each user that gets mapped to it across devices and platforms. You can use these to match your BigQuery analytics with GA4 UI for calculating the engagement rate. However, it’s pertinent to remember that applying filters and segments can lead to the discrepancy in the data points from the UI and BQ. Try to ensure that both data sets are identical before comparison.
