In this post, we will go over the BigQuery organization of GA4 data in BigQuery. This opens up the BigQuery interface also called the BiQuery console. On the top of the console is a drop-down that shows you the projects you have access to. …

In the previous post. I provided various reasons to send the GA4 data to BigQuery. In this post, I will provide step-by-step instructions for connecting GA4 and BigQuery so that you can see your data in BigQuery. Go to Google Cloud Console (https://console.cloud.google.com/). Create a new Google Cloud Console project…

Audience triggers in GA4 let you trigger (fire) an event when a user matches the definition of an audience and becomes a member of the “Audience” group. What are the examples of Audience Triggers? A user reaching a key milestone like initiating a certain number of sessions within a time frame A user reading a certain number…

When you send GA4 data to BigQuery the event table has two fields event_date and event_timestamp. event_date field contains the date in string format and event_timestamp field contains the date and time of the event, which is not easily readable. Even though it is easier to read the event_date field…

Most of the sites these days have long pages, which means users must scroll down to view the complete page. If you want to track various scroll depths, that your users are scrolling to, using GA4 then this post is for you. GA4 automatically allows you to track the users…

GA4 Site Search tracking is a feature that lets you track the keywords users are searching on your site. These are not the keywords that users search on search engines but the keywords that people type in the search box of your site. For example on Optizent, in the blog…

Comparing Average Engagement Time in GA4 with Average Time on Page with UA is like comparing apples to oranges. Even though seems like Google Analytics just renamed the metrics but it is more than that. These two metrics are entirely different. If you are comparing these numbers and want to…

As you might already know, Universal Analytics (also called GA3 or UA, the old version of Google Analytics) will stop collecting data as of July 1st, 2023. The new version GA4 will be your only choice if you plan on using Google Analytics. So time to get up to speed…

As you migrate from Universal Analytics to GA4, you are going to be comparing the metrics between the two versions of Google Analytics. Keep in mind that these two versions of Google Analytics have different data models and different ways of calculating various metrics, as a result, the metrics won’t…