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

eager-camera-84109

04/14/2022, 4:18 PM
Hello! Is it possible somehow create relative metric? By saying "relative", I mean something like this: I want for example OTS (open-to-search) metric. Right now I have two binomial metrics - open and search (yes/no, number of users who opened something and then number of users who find something and it's all with me experiment feature) then divide them, and now I want to check this metric in my experiment; test group - 45% OTS and control 40% OTS (and its significant). I hope I was able to explain
l

late-dentist-52023

04/14/2022, 4:51 PM
have you looked at Activation metrics? We use them for a similar “people who do x given they have already done y” analysis as a custom report within the results of an experiment
🔥 1
f

future-teacher-7046

04/14/2022, 5:47 PM
Activation metrics can help for some scenarios. We're working on a more general approach on what we're calling "ratio" metrics where the denominator comes from another metric.
👍 2
e

eager-camera-84109

04/14/2022, 9:38 PM
thanks guys. It worked for me in 95% cases.
In some cases scripts are running more than 9 min
🥲
@future-teacher-7046 I looked through activated metric script, and saw this. Is it possible to join users on anonymous ids? It would be better for my data
f

future-teacher-7046

04/14/2022, 10:42 PM
Yes. If you look at the __experiment and __activationMetric selects, are they using user id or anonymous id?
e

eager-camera-84109

04/14/2022, 10:46 PM
sorry, I see now that I can change it in configure analysis. sorry again for taking up time. At the same time I'll try to understand, why script is running for 35 min. If I will see any issues I'll write you
f

future-teacher-7046

04/14/2022, 10:48 PM
What database are you using? If you don't have this already, we support some SQL placeholders in the experiment and metric queries that can help a lot to limit the amount of data scanned. https://docs.growthbook.io/app/metrics#sql-template-variables
e

eager-camera-84109

04/15/2022, 10:55 AM
I'm using BQ. But I don't understand how to use placeholders in experiments.
f

future-teacher-7046

04/15/2022, 12:50 PM
The placeholders don't work in the "custom SQL filter" setting. You can add them directly to the experiment query in the data source
e

eager-camera-84109

04/15/2022, 1:06 PM
but what if I have 1-year experiment?
yeah, it uses all the data. But query still dont work
f

future-teacher-7046

04/15/2022, 2:02 PM
can you send me the full sql that it's trying to run?
e

eager-camera-84109

04/18/2022, 10:02 PM
yes, DM