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

incalculable-optician-34699

03/03/2023, 5:02 AM
Hello gb team. I have connected my big query data source with growthbook. When I am creating my test metric. It is showing me the error
Table "test" must be qualified with a dataset (e.g. dataset.table).
f

fresh-football-47124

03/03/2023, 5:38 AM
Hi Komal - what is your query?
i

incalculable-optician-34699

03/03/2023, 5:42 AM
WITH __table as ( SELECT user_id as user_id, timestamp as timestamp FROM test ) SELECT * FROM __table LIMIT 1
f

fresh-football-47124

03/03/2023, 5:43 AM
if you run that on BigQuery, does it work?
i

incalculable-optician-34699

03/03/2023, 5:48 AM
https://docs.growthbook.io/guide/bigquery I have fllowed the steps provided in documentation to create a datasource.
f

fresh-football-47124

03/03/2023, 5:48 AM
okay
i

incalculable-optician-34699

03/03/2023, 5:48 AM
After that, there is this error in metrics
f

fresh-football-47124

03/03/2023, 5:49 AM
what data do you have in bigQuery? what event tracker are you using (if any)?
i

incalculable-optician-34699

03/03/2023, 5:49 AM
no
f

fresh-football-47124

03/03/2023, 5:50 AM
what are you trying to AB test? is it a website?
i

incalculable-optician-34699

03/03/2023, 5:50 AM
yes, I am trying to implement it in a website.
f

fresh-football-47124

03/03/2023, 5:50 AM
do you have any event tracking currently?
i

incalculable-optician-34699

03/03/2023, 5:51 AM
I have only created one a/b experiment test feature
b

brash-raincoat-88597

03/03/2023, 5:53 AM
that error from bigquery means the table name inside the query need to be prefix-ed with the dataset. e.g. <dataset_name>.<table_name>. I see in your query you don’t have the dataset in front of
test
. Try adding the dataset and see if it works?
i

incalculable-optician-34699

03/03/2023, 5:53 AM
ok
f

fresh-football-47124

03/03/2023, 5:54 AM
it might be that Komal doesn’t have any data there yet
i

incalculable-optician-34699

03/03/2023, 5:57 AM
So, how can I populate the data of experiments there?
f

fresh-football-47124

03/03/2023, 5:59 AM
GrowthBook works a bit differnetly than other ab testing systems - we connect to your data warehouse and use almost any event tracking system
so you can use something like Google Analytics 4 to do web analytics, and push that data to BigQuery
i

incalculable-optician-34699

03/03/2023, 7:15 AM
I have tried that as well. But doesn't seem working with me Maybe I am missing any step somewhere. So what I have done is I have created a button in my UI where I am changing its label using a/b testing. I want to count how many users are clicking the button on which label. For that may I know the steps. How to do it from data source to creating metrics to creating experiment to analyse it.
f

fresh-football-47124

03/03/2023, 7:18 AM
just to clarify - “I have tried that as well” - tried what? GA4?
i

incalculable-optician-34699

03/03/2023, 7:18 AM
yes
f

fresh-football-47124

03/03/2023, 7:25 AM
GA4 steps roughly: 1. Make sure Google Analytics is tracking click events on your button 2. Add the GrowthBook SDK - when you set the Attributes in the SDK, make sure you pass in the clientId from Google (https://developers.google.com/tag-platform/gtagjs/reference?hl=en#set_examples) 3. Make sure your A/B test is set to split based on this clientId attribute
b

breezy-king-73167

05/10/2023, 1:26 AM
Having the same issue as this.
f

fresh-football-47124

05/10/2023, 1:27 AM
Hi Mark, want to make a new thread? This one is very old
and wasn’t very specific
b

breezy-king-73167

05/17/2023, 1:18 AM
Oh no worries. Sorry, I wasn't able to reply. I was able to solve this. I did not know before that I have to change something in the SQL query of the data source.
3 Views