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 PeishanView original