---
title: Customer Segmentation - Identifying Older Vs. Newer Customers | Rollup Helper Use Case Library
description: Customer Segmentation
---

[GET DEMO](https://www.passagetechnology.com/any-product-one-on-one) **+1 (224) 655-6779

[![Trusted Salesforce service partner Passage Technology](https://www.passagetechnology.com/hubfs/2021/Nav-header-logo_PT.png) ](https://www.passagetechnology.com)

# Customer Segmentation - Identifying Older Vs. Newer Customers

[![Free Salesforce business guides to help admins/developers, project managers, sales managers, and decision makers. Download the free PDF series now: Reinventing Your Business, Reimagining Your Salesforce®.](https://www.passagetechnology.com/hubfs/2021/Essential-Salesforce-Guide_Helper-Suite.png) ](https://www.passagetechnology.com/en/essential-guide-for-salesforce-admins-developers)

## Problem: Need to segment for customers based on how recently you have closed won business with an existing customer.

 

 

You need to segment your customers based on how recently you have closed won business with an existing customer. For example, a report showing those customers that you have not had a recent closed won opportunity within the last 4 years and customers that have had a recently closed won opportunity within the last 4 years. Salesforce does not allow you to easily find this information.  

## Solution: Start by creating a date field on the Account object.

1) Create a date field on the Account object that will store a value calculated by Rollup Helper for the first closed won opportunity in the last 4 years.

2) Create a MIN rollup to grab the first closed won opportunities close date and roll it up to the Account Object. 

3) Create a new filter where Won = True and where the close date is greater than the last 4 calendar/fiscal years.

4) Create a schedule to run every year to make sure as a new year comes and goes, that the roll ups are recalculated.

Tags: [Account](https://www.passagetechnology.com/rollup-helper-use-cases/topic/account), [MIN](https://www.passagetechnology.com/rollup-helper-use-cases/topic/min), [Opportunity](https://www.passagetechnology.com/rollup-helper-use-cases/topic/opportunity), [Scheduled Rollups](https://www.passagetechnology.com/rollup-helper-use-cases/topic/scheduled-rollups)

| [** Track Your First Response Time for a Lead Using Rollup Helper ](https://www.passagetechnology.com/rollup-helper-use-cases/track-your-first-response-time-for-a-lead-using-rolluphelper) | [Rollup Helper Use Case Library](https://www.passagetechnology.com/rollup-helper-use-cases) | [ FinancialForce - Master Project Budgeted Hours Allocated ** ](https://www.passagetechnology.com/rollup-helper-use-cases/financial-force-master-project-budgeted-hours-allocated) |
| --- | --- | --- |

[ Optimize Sales Rep Reporting and Leaderboards in Salesforce ](https://www.passagetechnology.com/rollup-helper-use-cases/sales-rep-reporting)

[ Rolling Up Marketing Cloud Account Engagement (Pardot) Activity ](https://www.passagetechnology.com/rollup-helper-use-cases/rolling-up-marketing-cloud-account-engagement-pardot-activity)

[ Streamline Sales Pipeline ](https://www.passagetechnology.com/rollup-helper-use-cases/streamline-sales-pipeline)

[ Creating Grandchild Rollups ](https://www.passagetechnology.com/rollup-helper-use-cases/creating-grandchild-rollups)

[ Calculate the Number of Cases on a Salesforce Contact Record ](https://www.passagetechnology.com/rollup-helper-use-cases/number-of-cases-on-a-contact)

[ Creating Account Hierarchy Rollups without Coding ](https://www.passagetechnology.com/rollup-helper-use-cases/account-hierarchy-rollup-without-code)

[ Easily Create a Custom Last Activity (Task/Event) Date ](https://www.passagetechnology.com/rollup-helper-use-cases/last-activity-task-event-date)

[ Roll-ups Using Formulas Rather than Static Criteria ](https://www.passagetechnology.com/rollup-helper-use-cases/roll-ups-using-formulas-rather-than-static-criteria)

[ Identify The Primary Contact On An Account ](https://www.passagetechnology.com/rollup-helper-use-cases/identify-the-primary-contact-on-an-account)

[ Opportunity Line Item Schedule Rollups ](https://www.passagetechnology.com/rollup-helper-use-cases/opportunity-line-item-schedule-rollups)

© 2026 Passage Technology LLC All Rights Reserved. [Privacy Policy](https://www.passagetechnology.com/privacy-policy) | [Purchasing & Legal](https://www.passagetechnology.com/purchasing-and-legal) | [Terms of Service](https://www.passagetechnology.com/terms-of-service) | [App Security](https://passagetech.my.site.com/KnowledgeBase/s/article/Security-and-Privacy-Policy-1578080055496)

- [** ](https://www.facebook.com/passagetech)
- <https://x.com/passagetech>
- [** ](https://www.linkedin.com/company/passage-technology)
- [** ](https://www.youtube.com/channel/UCK2tzaCWVC7PmFCXrLirnZw)

```json
{
  "@context" : "https://schema.org",
  "@type" : "BlogPosting",
  "author" : {
    "@type" : "Person",
    "name" : "Passage Technology",
    "url" : "https://www.passagetechnology.com/rollup-helper-use-cases/author/passage-technology"
  },
  "dateModified" : "2026-04-28T14:20:49.853Z",
  "datePublished" : "2014-05-08T02:45:57.000Z",
  "headline" : "Customer Segmentation - Identifying Older Vs. Newer Customers",
  "mainEntityOfPage" : {
    "@id" : "https://www.passagetechnology.com/rollup-helper-use-cases/customer-segmentation",
    "@type" : "WebPage"
  },
  "publisher" : {
    "@type" : "Organization",
    "logo" : {
      "@type" : "ImageObject",
      "url" : "https://www.passagetechnology.com/hubfs/Logo%20PT_colors_wide_on-white.png"
    },
    "name" : "Passage Technology LLC"
  }
}
```