This article answers a real question raised by an Enolytics customer in support.

Create a list of the top 10 club members who have signed up in the last 90 days and have the most purchases during…

Go to Bookmarks and Click on the Search Bar. Type Start and find the 'Campaign Start' Bookmark under 'ENO Preset Campaigns' that will add all your customers to a list as your starting point.

Go to filters (New) and find Contact Days Since Last Signup. Click on the slider icon. Once the range picker is there, set the range from1 to 90. Be sure to wait till you see the bars in the range picker before entering the values (that can take up to 20 seconds based on the size of your data base). Apply the filter using the checkmark on top.

If you want it to be new members only (no rejoins or switches, you can use additional filters to filter those out).

Now go to filters (New) again and find the Channel Filter. Click on Club and then click on the 3 dots in the top right of the filter and select 'Exclude'. Apply the filter.

Now, using the column picker add net sales cp as a measure to your report and you can also add net sales rank cp. You can now rank from small to high using the sort icon in the header of teh rank column. You can also filter to just your top 10 customers.

That is it.

Have a related question? Reach out to support — we're happy to help.