Howdy, I'm using GrowthBook with GA4 & BigQuer...
# ask-questions
e
Howdy, I'm using GrowthBook with GA4 & BigQuery. It's our first AB tasting tool. hence we don't have any data from previous provider. I'm currently stuck with the Metrics. Is there a list of metrics that can be used and how to integrate them with GB & GA4? Thanks
f
You can click on the discover metrics, which will let you add metrics by events
e
When I run discover metrics, I get this error: We were unable to identify any metrics to generate for you automatically. The query we ran to identify metrics returned the following error. Error: No tables found.
f
I see
when you edit your data connection, did you set the BigQuery Project ID?
e
Let me check...
Project id in BigQuery is DatasetID (organisation-name:db-name)?
For the BigQuery and GB setup, I pretty much followed this video to a step:

https://www.youtube.com/watch?v=w8MBaBqcVZI

f
it might need more permissions
it should be able to populate the event schema - did you just set up bigquery?
if you did. it could take a day to populate with data
e
I think it indeed might be a case of delay it data population
f
can you see any data from the BigQuery console?
e
I walked through the steps again with new db, since I deleted old one, I need to wait for the new db to be populated
Shall I link the db only once it gets populated, or is there a way to add metrics to the existing db?
f
you can click on 'discover metrics' any time
👍 1
e
Thank you for your help Graham
Hey @fresh-football-47124, I have metrics up and running now. I have feature flags set up. I'm kind of a stuck on Experiment feature now, especially with those two steps: • Verify your app is passing both attributes and a trackingCallback into the GrowthBook SDK • Verify your app is tracking events for all of the metrics that you plan to include in the analysis Do I also need to create separate BigQuery DB to store events / which variation of experiment user receives?
r
Jumping in here, Artur. Yes, you need BigQuery (or some other data warehouse) to store experiment viewed data and other events. Here's our guide for BQ: https://docs.growthbook.io/guide/bigquery
e
Hello @strong-mouse-55694, Thank you for jumping in! I was following the documentation, everything was going great until this part:
Copy code
Growthbook will use the Project Id and Dataset you enter as the default ones when creating queries. You can get the value for these fields from the Google Cloud explorer. You will see the top level project id, and when expanded, find the dataset which has your experiment exposure table (which will be experiment_viewed if you use Segment or Rudderstack).
Really lost with the
Project Id
and
Dataset
, as I can't seem to find them from Google Cloud Explorer Thank you for bearing with me.
f
You should see this when you select the parent project:
e
Inside Dataset ID, BigQuery Project ID is
foo
and Default Dataset is
bar
?
Upon fixing BigQuery Project ID & Default Dataset, How do I populate the bigQuery table with the events (like shown in documentation, ie
tracks
,
experiments_viewed
)? Apologies for somewhat thick questions, I still getting my head around the GA/bigQuery...