Hi - I tried to get the following report with Mixpanel with no avail:
|Date||Signups||Revenue from these signups within 45 days||ARPU|
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.