Understanding User Activation Metrics: Analyzing A, C, R, N, D Values
đź‘‹ Hi there... I'm trying to build a plot with users:
Active (A)
users that have performed an activation event in the last 30d
Current (C)
users first seen before the last 60 days
and did perform an activation event in the last 30d (active this month)
and did perform an activation event in the last 30d ending 30d ago (active the previous month)
Resurrected (R)
users first seen before the last 90 days
and did perform an activation event in the last 30d (active this month)
and did NOT perform an activation event in the last 30d ending 30d ago (not active the previous month)
and did perform an activation event in the last 30d ending 60d ago (were active the month before the previous)
New (N)
users that where first seen and active in the last 30 days
Dormant(D)
users first seen before the last 60 days
and did perform an activation event in the last 30d ending 30d ago (were active the previous month)
and did NOT perform an activation event in the last 30d (are not currently active)
🤕 I have a couple of problems:
Given month n, I would expect the values should follow these rules:
A(n)=C(n)+R(n)+N(n)
A(n-1)-D(n)=A(n)
But the values don't add up.
Also, New users only show up on the last plotted 30 days, so only see values for the current and previous month when plotting mid-month
Any idea how to achieve the desired outcomes? Any flaw in my setup?
