Every day of Google Analytics 4 data in BigQuery is stored in a separate table. If you only need data from one day (let's say January 3rd, 2021) the
from clause in your query will look something like this:
select * from -- change this to your google analytics 4 export location in bigquery `ga4bigquery.analytics_250794857.events_20210103`
But in most cases you will need to query a larger period of time. Enter
_table_suffix. More details on the general usage here, but to be able to query multiple tables of GA4 data you only need to look at the example queries I present you here.
Note that you can use static dates, dynamic dates for a rolling period (the last 90 days) or combine static and dynamic dates. It is also possible to include the intraday table in your query.
- Get new articles in your inbox