Revenue generated by daily signup cohort in X days

  • 15 June 2021
  • 0 replies

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



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!