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
