https://www.growthbook.io/
Join Slack
When using GA4 data through BigQuery, is it possible to include data from the intraday event tables ...
# ask-questions
m
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
I’m not sure - but you can try it
you can edit that query from the data sources
m
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
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
Sure - I’d be happy to. Can you point me to the best place/process to add it?
f
148 Views
Open in Slack
PreviousNext
Powered by

GrowthBook Users

Open source platform for stress free deployments, measured impact, and smarter decisions.

Powered by