I work for a business which sells a one year license to use our product. We’re trying to understand if that 1 year license is the most effective time frame, and doing so by understanding if there’s a difference in the way users use the product in month one compared to, say, month six.
Because our users will start using the service in different months (one user might have a license that runs from January 2019 to January 2020, and another user might have a license that goes from July 2019 to July 2020), we need to be able to ‘normalise’ those months in some way to show us what my users’ collective usage is over a 12 month period. We’d like to define a date property of ‘Month 1’ which is 30 days after they signed up, ‘Month 2’ which is 30 days after ‘Month 1’ and so forth. I’ve attached a sketch (the pdf) to show how this would look.
Wondering if this is possible within Mixpanel or if anyone has any good resources on how to conduct this type of analysis!
Best answer by Peishan
We released a few months ago, a new user property called “First Seen”. This shows you the first time a user joined your site / app and did anything. You could create cohorts based on this user property like that:
And use it in a report like this to compare user behaviour. Would that work?
You can also run a similar analysis in a retention report, which might help answer your question on your customers’ retention rate, using the custom property to calculate the months from First Seen.