You can calculate decile in MySQL to identify best customers. You can come up with more focused, relevant retention initiatives. Here’s a query to do it.
Calculate decile from frequency or counts in MySQL. E.g, to rank customers based on number of purchases or orders instead of total sales
It can be a pain to calculate percentile in MySQL. There are no functions for it yet. Here’s a ready made query to do it.
Calculate percentile from recency in MySQL. E.g, to rank customers based on recency of purchases or orders
Calculating difference between two dates in MySQL is really easy. Here’s how you can do it. Let’s say dt1 and dt2 are 2 columns in table table_name.
Usually remote access to MySQL database is disabled for security reasons. However, if you need to provide remote access to MySQL, just follow these steps.
Sometimes you need to create a read-only MySQL user. You can follow these steps and use these ready made commands to create a read-only MySQL user.