Question

Revenue generated by daily signup cohort in X days

  • 15 June 2021
  • 0 replies
  • 34 views

Hi - I tried to get the following report with Mixpanel with no avail:

 

Date Signups Revenue from these signups within 45 days ARPU
2021-1-1 10000 2500 0.25

 

Where:

Date - Just the date

Signups - Users who signed up on that date

Revenue: The total revenue generated by just the users who signed up on that date in the first X days only - in this case I wrote 45. (Note: our revenue data is stored as a property of our payment event)

ARPU: This is just the revenue column divided by the number of signups on that day

 

And then I need to get a graph plotting the trend of the ARPU. 

 

Any pointers will be appreciated! Thanks in advance. 


0 replies

Be the first to reply!

Reply