https://www.growthbook.io/ logo
Join Slack
Powered by
This message was deleted.
# ask-questions
w
This message was deleted.
f
Hi Justin yes, this is a good place to ask. Looks like you’re very close to getting this working. the events_ table is created by GA4, its their data structure. All the events you fire with GA4 will be there. Yes, your idea for that metric is correct. You’ll want to select the rows that match that event name, and return the user id/anon id
Did the auto discovery metrics work for this?
n
No, but I was considering deleting my current Metric (which I've been fussing with) and starting over with a new one
f
from the metrics and data -> data sources page
click on your data source
and scroll down to the metrics section
click on discover and see if it works
n
Hm 🤔 could be an issue with my connection to BigQuery then
f
you may not have added the project id and database name when you added the connection - you can update this from the ‘edit connection info’
n
sanity check: 
analytics_* is the project ID, and events_ is the database name
f
the project id is the name that is just cut off in the image you pasted
n
Glad we did a sanity check
that did it 😄
f
the default data set is the analytics_307…
nice!
n
While I've got you here, what do you think about the issue with setting the hash attribute for 
user_id
to 
Date.now()
? I'm thinking this could be how Growthbook is going to try to connect a user from an Experiment to a result in the Metrics...
Which means Date.now() is a bad idea
f
yes 🙂
well, the GA4 will record the device id/client id automatically
but randomizing based on date() will cause lots of multiple exposure warnings, and is not a great idea
you want something sticky
n
I think I can get GA's user info out of the gtag
at least maybe that'll match up
f
yes, we have some docs on that
n
👀 looking now
f
and if the gtag is too slow, you can create your own id, and save it in a cookie - that should work similarly, though takes more work
n
My project already has good cookie-handling, might be okay
f
ok
s
@nutritious-beach-21644 Hey sorry to jump in, i'm having some similar issues. For Google BigQuery how did you get the events_ table to show up?
I have streaming also selected and still has been saying 0 events sent..
f
that’s interesting
are you sure you’re on the right property?
s
@fresh-football-47124 thank you so much for fast response. I believe I am. The project ID is the same ID as the BigQuery project
f
you should see the events_[date] tables automatically
s
So I enabled google analytics for the first time 24h ago - unsure if that matters.
Does it need like a full day to export the tables for the first time?
f
it might be that
s
(I thought the streaming would have fixed that)
f
yes, I would think streaming would
s
Okay, I'll keep investigating - also @fresh-football-47124 while I have you here 🙂 Had another question (I put in general)
Just a quick update for anyone who lands here - events started to finally show up in tables (took about 1.5 days)
🙌 1
154 Views
Open in Slack
PreviousNext
Powered by