Solved

How to exclude customers who purchased on the same day in a cohort?


I've built a cohort with customers who purchased at least 2 orders in 1 month. I want to exclude the customers who only purchased 2 (or more) orders on the same day. If you purchased 2 orders on Monday and 1 on Wednesday you are included in the cohort, but if you only purchased 2 orders on Monday you're excluded.

I already tried to build a custom formula to add to the cohort, but I could not figure out how to tell mixpanel to filter on orders purchased on the same day. 

Does anybody have any tips?

icon

Best answer by Surge 28 May 2020, 09:54

Hello,

 

We have a Cohort feature called ‘Times, on unique days’. In case you’ve considered this, would love to know why this will or won’t work for your scenario.

 

Best,

Eric

 

 

View original

2 replies

Hello,

 

We have a Cohort feature called ‘Times, on unique days’. In case you’ve considered this, would love to know why this will or won’t work for your scenario.

 

Best,

Eric

 

 

I didn't know this was an option, this works perfectly. Thank you for your help! 

Reply