This message was deleted.
# ask-questionsw
worried-planet-2191
09/19/2024, 12:01 PMThis message was deleted.
r
rhythmic-agent-34208
09/19/2024, 3:06 PMHi 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
rhythmic-agent-34208
09/19/2024, 3:07 PMThis 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:
rhythmic-agent-34208
09/19/2024, 3:07 PMSELECT
user_id,
CASE WHEN first_seen < experiment_start_time THEN 'returning' ELSE 'new' END AS user_cohort
FROM
my_table
rhythmic-agent-34208
09/19/2024, 3:07 PMIn this example, `first_seen` is the timestamp of the user's first activity, and `experiment_start_time` is the start time of the experiment.
rhythmic-agent-34208
09/19/2024, 3:08 PMThere'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
c
cold-nightfall-57392
09/20/2024, 5:33 AMThank you Natasha! Will try these ones
🙏 1
122 Views