Forum Discussion
Resurrected Users
Hi 👋🏻 I’m trying to build a segment of resurrected users — people who are active today but were inactive for the past 30+ days before that, so in other words: Users who have returned today after ...
You could try:
- Last Used < 1 day ago (for activity today)
- AND
- Has had exactly 1 session in the past 30 Days
That would then remove anybody who has had sessions more recently than today.
Hi! Thanks, yeah, that would work, now the follow-up question I guess, how would I work out when there "exactly 1 session in the past 30 Days" took place? If they had a couple of days off and came back, that's not a resurrected user, is it? If they had 27 days off and came back, then that is a resurrected user. If I'm understanding the "in the past 30 Days" correctly, then it can be that they had it any time during that length of time, right?
So, if you have the first part as "Last Used < 1 day ago" and they've only had that 1 session in 30 days, that one session would have to be within the past 1 day.
To confirm, you can download a CSV of the users and check when their last session was!
