Counting GA4 Events and Other Records in BigQuery

The most common SQL that you will write in BigQuery will be related to counting events or other records in the BigQuery tables.

For example, you might want to know

1. The total number of events on a given day

2. The total number of specific events e.g. ‘first_visit’ on a given day.

These are the two examples that we will look at in this post.  These types of queries will form the basis of what you will see in future posts. Let’s take a look at these one by one.

The total number of events in a given day

The function that will need to perform the total is called “COUNT”.  

Here is the query that you will use to count the number of events on a given day

SELECT COUNT(*) FROM optizent-test-project.analytics_219941990.events_20221204