Even if you do not use artificial intelligence or machine learning, you can increase profit depending on how to use SQL

Even without using fashionable "artificial intelligence" or "machine learning", it is appropriateSQLIf you can write letterLifetime valueSoftware engineers come up with the opinion that they can raise.

Thread by @ cyberomin: "It's always fun when I have speak to finders and potential founders and they have a want to use AI / ML to improve customer [...]"
https://threadreaderapp.com/thread/987602838594445312.html

Celestine Omin, a software engineer, is proposing to make effective use of SQL. A series of threads are hanging on the following tweets.

Truth is, they do not even need ML. A properly written SQL is what you need.

- Celestine Omin (@ cyberomin)April 21, 2018

Omin once wrote the customer who bought the most products every week from the databaseSELECTI heard that you have sent a Thank You Mail with a small coupon. Then, 99% of the customers who sent the e-mails said they repeated it. Even without using machine learning, it is possible to collect such information simply by writing a simple SQL sentence.


In addition, from the database this time SELECT customers who last shopping date more than 3 months ago and send an e-mail with the content saying "I will be pleased if you will come back.You will attach a yen coupon." There seems to have been something. When I send this mail, more than 50% of people always said that they returned the action.

According to Omin, these efforts are still much more effective than paying advertising expenses to Google and Facebook, and when I look at the shopping basket and send related e-mails in the newsletter, it is generally 7% The opening rate of about 10% has reached as much as 25% - 30%.

further,CRONSometimes I wrote a script to SELECT people who left merchandise for over 48 hours in shopping cart and send reminds automatically. Again, artificial intelligence and machine learning are not necessary, just working with SQL and Bash.

Also, if you cancel redemption purchase three times in a row, give a red mark so that you can listen to whether the product you really need is a phone when you receive the next order and also do not accept cash on delivery orders He also said that he had also tried to make it. We also use SQL here.


Even if the delivery is delayed, by setting up a cron job that SELECTs mails sent to customers after 7 days or more from the order but has not yet been delivered, let us feel that customers are properly watched You can rest assured.

As in the above example, by using SQL successfully without using artificial intelligence or machine learningNPSYou can dramatically improve. Omin's tweet was meant to make me feel that "What is important is not what you use, how to use".