I like that we are able to use cohorts to break down new vs churned vs existing users, etc. However, I want to do something similar with one of my events.
In a simplified form, what we have is 2 types of events:
- “Company Paid”
- “Company Created”
What I want to do is get an idea of:
- How many new companies were paid this month (new)
- How many existing companies were paid this month (existing)
- How many existing companies were paid last month but not this month (churn)
Getting the total number of companies paid is very easy, but I don’t see how I can break that number down by when the company’s “Company Created” event was created. Any thoughts on whether this is possible, and if so, how to do it?
Best answer by Muffaddal Qutbuddin
first is using people property. Say you store the data of company created and paid. You can filter to say date within 30 days and count paid for new. And date before 30 days and count paid for existing.
same for churn using last_paid_date filter.
Other way to get the numbers are using funnels and retention.
so create a funnel > company created > company paid. This can give you new paid
for existing > you can create retention report to calculate how many were paid last month and of those how many were paid next month.
for churn you simply subtract the above two number from total, assuming there isn’t a forth case.