Creating a Search for Customers with No Recent Activity

To get a list of customers who have not made any purchases for a specified period of time, create a saved search for customers with no recent activity. You can use this search to identify customers you may want to contact.

Watch the following video for a tutorial on how to create a saved search for customers with no recent activity.

To create a search for customers with no recent activity:

Go to Reports > Saved Searches > All Saved Searches > New and click Customer.
Enter a title for the saved search.
On the Criteria subtab, click Summary.
1. In the Summary Type field, select Maximum.
2. In the Field column, select Activity Fields....
3. In the popup, select Date.
4. Select not after, and then (Relative). On the next line, enter 1 and select months ago.
5. Click Set. This filter limits results to customers with no activity in the past month. You can enter a different relative time period to search for customers with no activity for a different period of time.
On the Results subtab, click Columns.
1. Select Name from the list. In the Summary Type field, select Group.
2. Click OK.
3. Add a new column and select Activity fields....
4. In the popup, select Date.
5. In the Summary Type column, select Maximum.
6. Click Add.
Save the search.

To create a search for customers with no recent activity:

Related Topics