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

bulky-soccer-51365

06/30/2021, 2:51 PM
Ok. basic a/b up and running. i have little to no experience with bigquery / google analytics, but i’m trying to set up the metrics. i’ve created a set of 3 tables in bigquery that are shaped like the example,
Copy code
SELECT
  user_id,
  anonymous_id,
  received_at as timestamp,
  experiment_id,
  variation_id,
  context_page_path as url,
  context_user_agent as user_agent
FROM
  experiment_viewed
and … so on. … now i need to create a service account? and then within the tracking cb I’ll make a call to the bigquery api to write data?
f

fresh-football-47124

06/30/2021, 3:46 PM
you have GA for event data currently?
f

future-teacher-7046

06/30/2021, 3:57 PM
Instead of writing directly to BigQuery, You typically want to use an analytics event tracking system like Segment, Rudderstack, or Jitsu. Those systems queue up events and batch insert them to BigQuery. Much better scalability. Alternatively, you can use an all-in-one system like Mixpanel or Google Analytics which combines event tracking with data storage. In that case you don't need BigQuery at all.
b

bulky-soccer-51365

07/01/2021, 1:15 PM
for event data, currently, the only platforms I have any real experience with with are adobe analytics and optimizely
i can sign up for segment/rudderstack, etc, but I’m trying to stick with things that are currently in play elsewhere.
prob. going to set up a rudderstack acc just to see the whole pipeline in effect.
f

future-teacher-7046

07/01/2021, 1:23 PM
Ok. I'm happy to jump on a call if you have any questions or need any data pipeline advice.
b

bulky-soccer-51365

07/01/2021, 2:53 PM
Hah. thats awesome. Yah, lets talk. I’ve got a meeting at 11 but i’m otherwise available before noon and after 2, est.
f

future-teacher-7046

07/01/2021, 3:20 PM
How about 2:30pm est?
We can do Google Meet if you want instead - meet.google.com/zsk-jnmr-mho Might be easier in case we need to screen share for anything
3 Views