Dormant customers= Active customers but hasn’t done any sales transaction for past few months or for more than 1 year, as defined by client. Browsing the customer record, we can see the list of sales done under them, as in below: To identify such customers who hasn’t done any sales transaction for past 1 year,… Continue reading Identify dormant customers: Date of Last Sale