Hi all, we are getting our GrowthBook setup with o...
# ask-questions
m
Hi all, we are getting our GrowthBook setup with our first experiment. We have managed to track the proportion of visitors that create a lead on our site, so we can see the increase in the number of users who create a lead through a Metric setup as a Proportion. What I cannot figure out is how to do a simple count of the number of leads. This is important to us because a user might create multiple leads in the same session or over many sessions.
s
For that, you should be able to use a mean metric with
COUNT
as the aggregation. This will count all rows, that is, lead events per user in the table. (You can then multiply that by all users in the variation to get a sense of total leads) For experiment analysis, I think this is what you'd want, but if you're looking for something else. Let me know.
m
Thanks. That makes sense as a way to get the count across users for each variation. I cannot see where we can perform that multiplication though. Or were you suggesting a manual calculation outside of GB?
s
Right. It'd be a manual calculation. The reason is that the number doesn't make as much sense in the context of experiment results (if I'm understanding correctly). If you're just looking to pull that number, tho, I'd recommend using SQL Explorer. It allows you to run arbitrary SQL for metrics and can present this data.
m
Yeah I think this was an expectation issue. We can get rate of change, and that will have to be enough. Thank you