Among the registered customers of each store, this filter lets you filter customers that are in the top in the number of purchases, purchased value, or purchased quantity in their lifetime in the org.

For example, you can get the top 10 customers of each store who have the highest lifetime purchase value (org-level) among those who registered in the same store.


Mandatory filters

Top customers:

  • Absolute value or Percentage value: Select Number to get the exact number of customers [or] percentage to get a proportion of customers and enter the value in top ____.
    For example, Include top 10 percent of customers.
  • Filter criteria: Choose on what basis you want to filter the top customers.
    • Sales: Get top customers by total purchase value.
    • Quantity: Get top customers by the total quantity of items purchased.
    • Transaction: Get top customers by the number of transactions made.

Adding to the previous example, Include top 10 percent of customers having highest sales.

  • Registered store (s): Get top customers from each selected store (registered store). By default, all stores are selected.
    Continuing the previous example, Include top 10 percent of customers having highest sales in Registered Stores StoreA.

The value for sales, quantity, or transactions is considered on lifetime purchases of customers. However, The top list is fetched from only among the customers that registered in that particular store. 

So, if you select two stores to get the top 10 customers, you get 10 customers from store1 and 10 customers from store2 separately.

Optional filters

You can further filter customers by the following parameters.

  • Transacted store/zone/concept: Among the top customers, you can get customers who shopped at least once in a specific store, zone, or concept.
    • Store: You can select stores using Upload list, enter values manually, or based on attributes. For more information, see store.
    • Zone: You can select all stores of a zone (any store) or stores with specific attributes. For more information, see zone
    • Concept: You can select all stores of a concept (any store) or stores with specific attributes. For more information, see concept.
  • Purchased product: Among the top customers, you can get only customers who purchased a specific product, category, or product with the specific product attribute. For detailed information, see product.
  • Purchased duration (Date): Among the top customers, you can get only customers who shopped at least once in a specific duration. You can select duration using specific dates or relative days.

Example

Consider the following example where the first table shows the top customers by lifetime purchases at the org level and the second table shows the top 3 customers by lifetime purchases as per each store of the org according to stores at which customers registered.


Top 10 customers at the Org-level

CustomersLifetime purchasesRegistered stores
Customers 1$5700Store C
Customers 2$5400Store B
Customers 3$5100Store A
Customers 4$5000Store C
Customers 5$4900Store B
Customers 6$4800Store A
Customers 7$4700Store B
Customers 8$4600Store C
Customers 9$4600Store C
Customers 10$4500Store B
Customers 11$4400Store C
Customers 12$4200Store A


Top 3 customers by lifetime purchases per each store

StoresTop customersLifetime purchases
Store ACustomers 3$5100
Customers 6$4800
Customers 12$4200
Store BCustomers 2$5400
Customers 5$4900
Customers 7$4700
Store CCustomers 1$5700
Customers 4$5000
Customers 8$4600