Customers Retentions

[qwaiti27231]

These are the segments that i need to create report  on  

Segments: 

• Retained - users who have completed orders in previous 30 days and last 30 days 
• Reactivated - user who last completed orders between day 60 and day 90 and placed an order in the last 30 days 
• New - users who completed there first order in the last 30 days  

Sub-segments: 

• Rookie - Users who completed 1 order in a given time period 
• MV - Users who completed 2 orders 
• HV - Users who completed more than 2 orders 

there is two table where orders table and users table 

orders table contains id,amount , completed date,user_id

users table contain id,name,phone and email

[v-alq-msft]

Hi, @qwaiti27231 

Could you show us some sample data and expected result for better understanding? Do mask sensitive data before uploading. Thanks.

Best Regards

Allan

[Fowmy]

@qwaiti27231 

You can refer to these videos to know if it could be customized as per your scenario:

https://www.youtube.com/watch?v=kSy-7UHe4HE

https://www.youtube.com/watch?v=h9kRwgamLcw

________________________

If my answer was helpful, please click Accept it as the solution to help other members find it useful

Click on the Thumbs-Up icon if you like this reply 🙂

WebsiteYouTube  LinkedIn

[qwaiti27231]

@Fowmy  Thank for the quick response but this I tried. I want it this way 

[qwaiti27231]

@Fowmy if you can make this as report it would be of big help