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

fancy-candle-92347

05/15/2022, 7:53 AM
Hello team, I am trying out Growthbook for the first time and not able to find examples on how to do split testing. I user, action (impression vs click) in 2 different table for 2 different models. As I see we can only use one bucket I merged both the tables and added new column as varient 0/1. I am trying to sample the data between 2 variant and see clicks/impression similar to "sample conversion" example but I dont see any reference data for it. I see the sample conversion result data is entered manually (user count, conversion for control and variation). How can built these metrics dynamically? Is there any walkthrough example?
f

fresh-football-47124

05/15/2022, 7:54 AM
Do you have event tracking currently?
f

fancy-candle-92347

05/15/2022, 8:00 AM
yes, most of our campaigns are offline
f

fresh-football-47124

05/15/2022, 8:11 AM
so you're importing manual data into growthbook?
f

fancy-candle-92347

05/15/2022, 8:21 AM
I am pulling my data from Athena
Copy code
SELECT
  user_id,
  DATE_ADD('hour', -20, CURRENT_TIMESTAMP) as timestamp,
 'tune_in_test' as experiment_id,
  variant as variation_id,
type as value
FROM
  growthbooks_demo_segments
type signifies events and variant(0/1) signifies which model that user was assign to.
f

fresh-football-47124

05/15/2022, 8:38 AM
okay
so that is the experiment exposure query and you want to know how to construct the metric queries?
f

fancy-candle-92347

05/15/2022, 8:51 AM
yes similar to the "sample conversion" in the examples. A simple walkthrough of that example wrt to segments and metrics would help.
f

fresh-football-47124

05/15/2022, 9:06 AM
Ya, our documentation and walkthroughs could use some work. We're happy to meet and help if you like
2 Views