How do I create a report that shows the customers who have not ordered in the last year?
Customers/Advanced Search/Order History Search -Customers who have not ordered since [date]. Then hit Enter.
Once you do this you will be able to export the results if you wish, using the blue export button at the top of the page.
Please note that all of the selections on this page string together with "AND" logic, so you can do even more detailed and segmented searches if you wish. For example, customers who have ordered at least $500 worth of products AND who have not ordered since Jan 1, 2108 (to do this search you would check both boxes then hit search.)
You will see that within some of the selections, you can also make a choice as to whether the elements within that particular selection are combined with AND or OR - for example - "Customers who have not ordered the following __2__ products (using ANY (or) or ALL (and) the following:"
In this case, while the elements within that selection might be OR (any), that selection will still string together with other selections with "AND" logic.
We recommend you play around with the combinations of searches that are available to you in this section - it can assist with targeted marketing efforts.