When using GA4 data through BigQuery is it possible to inclu

Question

When using GA4 data through BigQuery is it possible to include data from the intraday event tables when evaluating experiments so we don t have to wait for the daily event tables to update I think it s as simple as changing the `events ` tables in the experiment queries to `events intraday ` but not sure if that s possible

fresh-football-47124 · Answer

I m not sure but you can try it

fresh-football-47124 · Answer

you can edit that query from the data sources

many-wall-58468 · Answer

Oh I didn t realize I could edit those I ll try that out Thank you

many-wall-58468 · Answer

Just FYI I figured out that the current `events ` in the queries was indeed already pulling in the intraday data since those tables match that wildcard too but then they were filtered out with the ``` TABLE SUFFIX BETWEEN startYear startMonth startDay AND endYear endMonth endDay ``` I replaced that with ```REGEXP EXTRACT TABLE SUFFIX r 0 9 + BETWEEN startYear startMonth startDay AND endYear endMonth endDay ``` And it now includes all data from both daily events amp intraday events tables

fresh-football-47124 · Answer

Hi Joshua that s cool you got that working do you think others would want to do this as well Perhaps you could add something to the GA4 docs for this

many-wall-58468 · Answer

Sure I d be happy to Can you point me to the best place process to add it

fresh-football-47124 · Answer

maybe add a section here <https docs growthbook io guide GA4 google analytics 4 connect growthbook to bigquery>