Customers that Spent Last Year but Not This Year


To create or export a list of customers that spent last year but have not been in this year:

  1. Click Customer > Find.
  2. On the General tab, check the boxes for Preferred Contact Methods Only (Phone / Address / Email / Social).
  3. If you only want customers that have email addresses, type =ANY into the Email field.  Likewise, if you only want customers that have addresses, type =ANY into the Address field.
  4. On the Results tab, set Addressee to Each Individually.
  5. On the Amt Spent tab, under Has Spent This Much, set $ Amount to $1,000 with a Date Range of Last Year.
  6. Below that, under Has NOT Spent This Much, set $ Amount to $1 with a Date Range of This Year.
  7. Click OK to generate the list.
  8. You can right click here to immediately export OR use the Group / Mailing List button to create a new group or add them to an existing group.
Updated on Tue, 17 Jun 2025 by Dominick Mastri

Glad we could be helpful. Thanks for the feedback.

Sorry we couldn't be helpful. Your feedback will help us improve this article.

How helpful was this page?