# Segmentation based upon deal activity - RFM Data **URL:** \ **Category:** HubSpot Ideas\ **Tags:** object\ **Created:** [December 21, 2020, 6:12pm UTC](https://community.hubspot.com/t/segmentation-based-upon-deal-activity-rfm-data/29440 "2020-12-21T18:12:34Z")\ **Posts on this page:** 2\ **Page:** 1
**Author:** ![Tnichs](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/tnichs/32/2829_2.png) [@Tnichs](https://community.hubspot.com/u/Tnichs)\ **Post date:** [December 21, 2020, 6:12pm UTC](https://community.hubspot.com/t/segmentation-based-upon-deal-activity-rfm-data/29440/1 "2020-12-21T18:12:34Z")
Hi, we want to be able to segment both company and contact records based upon deal activity within a certain amount of time. Taking the Ecommerce model of RFM data - Recency, Frequency and Monetary we want to segment based on things like If someone places 2 or more orders in the last 6 months make them a VIP customer If someone places £50,000 or more within the last 12 months, make them VIP If someone places more than 2 orders per month on a consistent basis, make the VIP Other examples needed that there doesn’t seem to be a straight forward approach If someone isn’t a new customer (has previously ordered before a 6 month period) and then orders twice in the last 6 months, make them a retained customer If we have a lapsed customer - e.g. they haven’t ordered within 12 months, and then they order, make them status= winback customer. ---
**Author:** ![AndreaK](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/andreak/32/87811_2.png) [@AndreaK](https://community.hubspot.com/u/AndreaK)\ **Post date:** [March 18, 2022, 3:03pm UTC](https://community.hubspot.com/t/segmentation-based-upon-deal-activity-rfm-data/29440/2 "2022-03-18T15:03:00Z")
Very good idea! A standard set up of properties for RFM data to ble able to set this up would be very usefull for many of my clinets.