Next

Many users are moving from "Resurrected" to "New".

Example of users with this pattern in August 2019:

+-------------------+-------------------------------+
|user_guid_kite     |journey_string                 |
+-------------------+-------------------------------+
|1003452005647130643|resurrected, new, curious, cold|
|1003452092720881668|resurrected, new, curious, cold|
|1003452215974699011|resurrected, new, curious, cold|
|1003452303409160198|resurrected, new, curious, cold|
|1003452584448499723|resurrected, new, curious, cold|
|1003452662076678154|resurrected, new, curious, cold|
|1003452714325123076|resurrected, new, curious, cold|
|1003452818838790156|resurrected, new, curious, cold|
|1003452841710329863|resurrected, new, curious, cold|
|1003453225631752204|resurrected, new, curious, cold|
|1003453273140633602|resurrected, new, curious, cold|
|1003453281386635271|resurrected, new, curious, cold|
|1003453356783443971|resurrected, new, curious, cold|
|1003453479206789136|resurrected, new, curious, cold|
|1003453534567407624|resurrected, new, curious, cold|
|1003453692046745605|resurrected, new, curious, cold|
|1003453723172675588|resurrected, new, curious, cold|
|1003454204951404556|resurrected, new, curious, cold|
|1003454372992000012|resurrected, new, curious, cold|
|1003454424493858820|resurrected, new, curious, cold|
+-------------------+-------------------------------+

If we focus on the first user for example, we can see the follow:

For reference check the kite records: 1003452005647130643-1564617600000 (1st of August 2019, resurrected), followed by 1003452005647130643-1564704000000 (2nd of August 2019, new)

changed the description 2 times within 4 minutes

changed the description 3 times within 2 minutes

Resurrected state is 1 day of activity within 7 day period and that day is the most recent day.

New state is determined by the guid being within a range of guids that represent the 24 hours up to the reference day start.

This makes sense now. The new state is only seen during the second day, during the first day if there is activity on that day it actually fits the logic for resurrected so there would be a transition from resurrected -> new.

This is still the case after the changes I have made because I preserved the flawed new state logic. It's also a sporadic state to test because it's only seen when a new user is created.