So your customer has bought the shoes, the shirt, the trousers so perhaps the jacket or belt next? They've flown to Bali, Brisbane, the Bahamas so maybe the next destination will be Bahrain? They've gambled on a win, the scoreline, a player starting the match so perhaps they will fancy their chances on a half-time result? Maybe they've downloaded Rihanna and Justin Timberlake and they just need a bit of encouragement to download Will.I.Am!
Many companies have implemented next best offers or are looking at getting into it as part of speaking to their customers on a one to one basis. Really getting to know their customer and to be able to understand their needs and what they would like to do next. Some companies call this their recommendation engine.
How do I build a simple recommendation engine?
Firstly go into your product table and do a distinct on the product names and pick one out at random. Then go into your transaction table find all of the transactions where that product was purchased and then link that to the customer id to give a full list of customers who have purchased that particular product over a given amount of time.
The next step is to go back into your transaction table and look for what else a customer has purchased in a given amount of time and prior to purchasing the particular product that was purchased (this is not always necessary).
The next step is to do a distinct on the customer id and product names of the prior purchases. Then order this data by customer id and product name so that it is all uniformly ascending. The next step is to concatenate the rows of product names by customer id so that for each customer id the products will be listed in the column next to it such as product A, product B, product D.
So if our initial product was Product C, we can now understand which combination of product purchases happened prior to Product C purchase.
Why is that useful to know?
It means that if we produce the same steps for each and every product and then count the number of customers who have purchased the same products groups prior to purchasing another product, we can then understand what is the most probable next product they will buy based on what everyone else is doing.
Turning it into a marketing campaign
Sending out an eDM based on this data can be tricky because it involves creating multiple pods of creative that are selected to be in each customer's email based on what the data from the simple recommendation engine recommends. However, there are many agencies that specialise email segmentation and can assist with developing the creative.
The way to select which product to offer a customer next is based on what their current product mix is (ie what they have purchased recently) and the product that was purchased the most times by customers who had the same previous product mix.
It may sound fairly convoluted for the average punter but coding this up in say SQL for this simple recommendation engine is fairly straightforward. There are other ways of doing it as well for the more stats savvy of you out there and happy to discuss that in a future post.
So is this something your company does already? Are you interested in implementing a simple recommendation engine?
Many companies have implemented next best offers or are looking at getting into it as part of speaking to their customers on a one to one basis. Really getting to know their customer and to be able to understand their needs and what they would like to do next. Some companies call this their recommendation engine.
How do I build a simple recommendation engine?
Firstly go into your product table and do a distinct on the product names and pick one out at random. Then go into your transaction table find all of the transactions where that product was purchased and then link that to the customer id to give a full list of customers who have purchased that particular product over a given amount of time.
The next step is to go back into your transaction table and look for what else a customer has purchased in a given amount of time and prior to purchasing the particular product that was purchased (this is not always necessary).
The next step is to do a distinct on the customer id and product names of the prior purchases. Then order this data by customer id and product name so that it is all uniformly ascending. The next step is to concatenate the rows of product names by customer id so that for each customer id the products will be listed in the column next to it such as product A, product B, product D.
So if our initial product was Product C, we can now understand which combination of product purchases happened prior to Product C purchase.
Why is that useful to know?
It means that if we produce the same steps for each and every product and then count the number of customers who have purchased the same products groups prior to purchasing another product, we can then understand what is the most probable next product they will buy based on what everyone else is doing.
Turning it into a marketing campaign
Sending out an eDM based on this data can be tricky because it involves creating multiple pods of creative that are selected to be in each customer's email based on what the data from the simple recommendation engine recommends. However, there are many agencies that specialise email segmentation and can assist with developing the creative.
The way to select which product to offer a customer next is based on what their current product mix is (ie what they have purchased recently) and the product that was purchased the most times by customers who had the same previous product mix.
It may sound fairly convoluted for the average punter but coding this up in say SQL for this simple recommendation engine is fairly straightforward. There are other ways of doing it as well for the more stats savvy of you out there and happy to discuss that in a future post.
So is this something your company does already? Are you interested in implementing a simple recommendation engine?
No comments:
Post a Comment