Hey everyone! We have set up GrowthBook pro tier for 2 years and want to measure new user retention now, we tried to build that metric through using Segment but failed, the metric looks really off. Can anyone help? Thanks!

hi Jay - the query looks off?

the numbers looks off, we did the SQL in the db and got accurate numbers, but when we add the metric to experiments it looks really wrong

we do a lot of joining when you use it as a segment

What's the right way to get new user retention(D1, D7, D14) on Growthbook?

so segments work to filter experiment results to just those users.

Yes! I recommend you create a "retention" metric on top of a fact table and use that for your analysis alongside any other metrics of interest.

Yea we did, but we already have a retention fact table, but we have no idea how to make one for new user retention

Hmm, I see. You want retention defined with respect to a signup event, not an experiment exposure event?

it should be both, I want to see if the experiment will affect the new user behavior