-
Sure, you can achieve this by querying multiple days across the different tables. It’s simply a matter of adjusting the ‘_table_suffix’ in your SQL code to the date range you’re interested in.
Here’s a quick example that might help:
`
select
*
from
— replace this with your Google Analytics 4 export location in BigQuery
ga4bigquery.analytics_(change_to_yours).events_*
where
_table_suffix between ‘20230101’ and ‘20230327’
`The ‘_table_suffix’ represents the dates, so when you specify ‘between 20230101 and 20230327’, you’re asking for data from all of the tables (or days) within that range.
For more details, check this [tutorial](https://www.ga4bigquery.com/tutorial-how-to-query-multiple-analytics-events-tables-with-table-suffix-ga4/). Quite handy!
