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

GrowthBook Users

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.

you can edit that query from the data sources

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
```_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.

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?

Sure - I’d be happy to.  Can you point me to the best place/process to add it?

maybe add a section here? <https://docs.growthbook.io/guide/GA4-google-analytics#4-connect-growthbook-to-bigquery>