Hi Mixpanel Team, I’m trying to create a weekly report to track changes in our MRR over time. I’m using a custom property called sub_mrr, which is set on the Account profile. However, the result shows the same value for every week, even though I expect MRR to change. I suspect this might be because sub_mrr is a static profile property. Is there a way to visualize how MRR changes over time in Mixpanel using this setup, or do I need to track MRR changes as a custom event instead?
Hi Thanh- Julianne from Mixpanel Support here.
You're correct in your understanding that profile properties in Mixpanel are static and only reflect the current state of a user or account. This means that if a property like sub_mrr
changes, the profile will only reflect the current sub_mrr
and not the historical changes. This is why you're seeing a constant value when displaying the sub_mrr
for the Accounts.
An event sent to the project is a great option to track the MRR over time. For example, you could create a "Subscription" event that records the MRR at that moment in time. Event data would allow you to see changes in MRR over time. I'd recommend sending some test data to your project and seeing if it answers the questions that you're interested in.
Alternatively, Mixpanel does have a new feature called Profile History that allows you to analyze users and groups based on their attributes at any given time. However, this feature is only available through Warehouse Connectors add-on.Â