This message was deleted.

You'll need to track an event in GA whenever someone is put into an experiment. Then, you would write the SQL to pull it out of BigQuery in that format. The query might not look exactly like what you pasted, but should be close. I'm not sure exactly how GA4 stores the data in BigQuery, but you might need to add a WHERE clause to that query in GrowthBook to pull the right events.

@future-teacher-7046 Thank you so much. 🙂