Hey there! We have recently connected BigQuery to Growthbook. Defining metrics for it and using them in experiments works like a charm. However, I can't find any exposure and result data being written to Bigquery. In fact, the dataset it's configured to write to doesn't even exist. Did anyone maybe experience this and could give me a pointer? Thanks 🙂

Do you see experiment data in Google Analytics? If not, then I think that first has to be set up (through Google Tag Manager)

Thanks for the reply! I don't think we're using Google Analytics here for that at all 🤔 We use the JS SDK from application code in the front-end. I can see all exposures in Growthbook itself, but I was expecting them to be automatically synced to BigQuery too. Maybe I was wrong there, though 😄

Ahh sorry, I thought you also always need GA if you use BigQuery for GrowthBook. Would have been an easy fix probably if you used GA

Thanks anyway, though 🙂

Hi Robin, As far as I have explored Growthbook, GrowthBook doesn't automatically create datasets in BigQuery. You have to do some workaround. 1. you must ensure that the dataset and table exist in BigQuery. 2. Ensure that your SDK (or backend code) is sending experiment exposure data to GrowthBook.

Ah, I need to create the table by hand as well? 🤔

Yes, You need to create it manually first. Then from the API, you need to have a logic which will write data to bigquery.

Oh so I need to manually call the API to trigger the write?

yes, because growthbook doesn't store any data. It simply does calculation on whatever query you feed it.

Ahhh I had no idea, thank you!

@acceptable-florist-18253 https://docs.growthbook.io/api?ref=blog.growthbook.io#section/Authentication.. refer this you might find your solution using one of these APIs

Amazing, thank you so much 🙏