#ask-questions
Title
f
fancy-candle-92347
05/15/2022, 7:53 AMHello 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 AMyes, 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 AMI 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_segmentsf
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 AMyes 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