Hi Team My client is trying to setup Growthbook for their sh

Question

Hi Team My client is trying to setup Growthbook for their shopify store We ve setup GA4 amp 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 gt 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 <https linen growthbook io t 12025152 hey all i was kind of curious how stable and trustworthy the 598d4945 9d47 4c33 809c d5660841d2a9|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 slightly smiling face

helpful-application-7107 · Answer

gt 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

helpful-application-7107 · Answer

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>

helpful-application-7107 · Answer

image png

adventurous-computer-41819 · Answer

Thanks Luke we ll try to fix the BQ to get the events table appearing

adventurous-computer-41819 · Answer

< 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 gt Growthbook documentation says Auto discovery from environment variables or GCP metadata only available when self hosting gt We aren t using Self hosting

helpful-application-7107 · Answer

gt gt 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