Creating Cohorts Based on User Activity After Signup in SaaS Analytics

I am working for a SaaS client that needs to create cohorts like "Companies that have uploaded a spreadsheet the following two months after the signup." Is there a way of doing that with Cohorts? Maybe using the Time property?

👀1

4 comments

Christopher C.
·
·
Not sure about the companies side if you're using group analytics, but if you have a user property for when they signed up, you can create a custom property for events for 'Months since signup' etc which is just something like DATEDIFF([User Created Property], [Event Time property], "M") and you can then use that as a filter on the cohort to restrict it to that 2 months since signup timeframe etc
Iván M.
·
·
Thanks, Christopher C.! I forgot that pre-built custom property. Can you see this report? https://mixpanel.com/s/2a3VzS Do you think it is accurate? This is like "# users who create a workspace 60 days after sign up."
Christopher C.
·
·
I THINK that's right yeah, 2637 created in the past 30 days total, only 5 of those being exactly 60 days after signup looks reasonable. I am discovering I have no idea how group analytics works when I play with a funnel in this sample dataset, too used to eCommerce stuff etc 😂
Iván M.
·
·
Great, thanks for checking in. For group analytics, you only need to change the user property for the company property and switch to "company" on the menu. See attached. Yeah, SaaS and e-commerce are like oil and water 🙂