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.

Free

$0

  • Get new articles in your inbox