Revenue Growth Accounting (Retained, churned, expansion, contraction) per user basis

  • 6 May 2022
  • 1 reply


We would like to calculate revenue growth accounting on a per-user basis. After quite struggle, we couldn’t figure out how to achieve this in Mixpanel.

Let’s assume that we have 2 users, User A and User B. We want to know User A’s Retained Revenue and User B’s Retained Revenue separately and add them up in the end to see the total amount of retained revenue. Same for Churned Revenue. We want to know User A’s churned revenue and User B’s churned revenue separately and add them up in the end. 

How can we achieve this?

Thank you.


Best answer by alon 22 May 2022, 17:27

View original

1 reply

Userlevel 3
Badge +1

You can do that by sending a “LTV” profile property that holds the revenue or churned revenue.

Once you have that data you can use the profile queries and calculate sum