Open source platform for stress free deployments, measured impact, and smarter decisions.

GrowthBook Users

Hello, what is the best way to add dimensions for new users and returning users? Does anyone have any recommendations? I couldn't find any documentation, slack discussion a bit old and not clear how everyone implements this.:growthbook:

Hi Marius, in the SQL for the dimension you can query based on new/returning users based on their first­_seen date or any other data you have tracked that signifies new users VS returned users

This could be based on whether they have any activity before the start of the experiment. Here's an example of how you might structure this query:

SELECT 
  user­_id,
  CASE WHEN first­_seen &lt; experiment­_start­_time THEN 'returning' ELSE 'new' END AS user­_cohort
FROM 
  my­_table

In this example, ​`first­_seen`​ is the timestamp of the user's first activity, and ​`experiment­_start­_time`​ is the start time of the experiment.

There's an example of this here that may help- <https://linen.growthbook.io/t/34044/hi-have-you-ever-thought-about-adding-a-default-dimension-of|https://linen.growthbook.io/t/34044/hi-have-you-ever-thought-about-adding-a-default-dimension-of>