https://www.growthbook.io/ logo
#ask-questions
Title
# ask-questions
m

many-wall-58468

04/26/2023, 2:22 PM
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.
f

fresh-football-47124

04/26/2023, 3:57 PM
I’m not sure - but you can try it
you can edit that query from the data sources
m

many-wall-58468

04/26/2023, 3:58 PM
Oh I didn’t realize I could edit those - I’ll try that out. Thank you!
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
Copy code
_TABLE_SUFFIX BETWEEN '{{startYear}}{{startMonth}}{{startDay}}' AND '{{endYear}}{{endMonth}}{{endDay}}'
I replaced that with:
Copy code
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 & intraday events tables.
f

fresh-football-47124

04/28/2023, 4:21 PM
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?
m

many-wall-58468

04/28/2023, 5:24 PM
Sure - I’d be happy to. Can you point me to the best place/process to add it?
f

fresh-football-47124

04/28/2023, 7:54 PM
45 Views