https://www.growthbook.io/ logo
a

adventurous-computer-41819

08/17/2023, 12:21 PM
Hi Team - My client is trying to setup Growthbook for their shopify store. We've setup GA4 & BigQuery (BQ) Note, we're not self-hosted GB, so can't use the discovery metrics method. Please can you help with these issues we've had, trying to setup Metrics... ā€¢ How do we setup an events_ table in BQ? In our BQ, we only see the events_intraday (11) table (it's been setup for >7 days, but the events_ table hasn't appeared) ā€¢ Can you share an example of SQL, for setting up a metric, I've tried using this add-to-cart SQL previously shown in this slack (link), but get the errors "No rows returned, could not verify result" and "No schema provided. Please edit the connection settings and try again." (GB shows GA4 as connected). Many thanks šŸ™‚
h

helpful-application-7107

08/17/2023, 3:52 PM
Note, we're not self-hosted GB, so can't use the discovery metrics method.
I don't think this is a problem? If you selected GA4 when Adding a datasource the "Discover Metrics" button should exist on the Metrics section of your Data Source page.
Reading the GA4 docs, it looks like you might want to ensure daily export is set up? https://support.google.com/analytics/answer/9358801?hl=en
šŸ™Œ 1
image.png
a

adventurous-computer-41819

08/18/2023, 8:11 AM
Thanks Luke - we'll try to fix the BQ to get the events_ table appearing
@helpful-application-7107 it seems your documentation says metric auto discovery is only available when self hosting....Maybe we miss-read, and we could always re-try once our BQ events_ table is up. The Discover Metrics button does exist, but it produced an error. Our dev said:
Growthbook documentation says - "Auto-discovery from environment variables or GCP metadata (only available when self-hosting)
We aren't using Self-hosting
h

helpful-application-7107

08/18/2023, 3:02 PM
> Growthbook documentation says - "Auto-discovery from environment variables or GCP metadata (only available when self-hosting)
This is in regards to providing credentials to GrowthBook, not the auto-metrics. I'd be happy to help you out with the auto-metrics error if you could share the error message you got. But yeah if the daily events table isn't there then I think our auto-metrics will fail.
7 Views