BookmarkSubscribeRSS Feed
Question
Fluorite | Level 6

Hi All,

 

Could you please advise which technique I could use and examples (if you have) to predict in which day/week after the last purchase, the customer is more likely to come back. I would like to have a final output like this below.

 

I have transactional data.., not sure what's going to be the target here.

 

Your help would be much appreciated .

 

Thank You

 

 

Customer_id Expected return
10001 This week
10002 Last week
10003 Next 2 weeks
10004 Next 3 Weeks
1 REPLY 1
sinabl
SAS Employee

Hi,

 

You can think of implementing two stage model here. In the first stage, you can predict the probability of a customer who is likely to return (binary classification problem that can be solved with logistic regression). If that probability is high, then in second stage, you can actually calculate the "time to return" (a continuous variable...so essentially you need to build a regression model where target variable is "time to return". 

I do not have any readymade example to share. Also, i am not sure what all data is available with you. You can think of following set of features that you can include in your both models:

1. User demographics

2. User characteristics

3. Few geography specific things (e.g. store location, users' residence, how far / near the store is....assuming you have information about the registered users)

 

Hope this helps,

best,

abhijit

SAS Innovate 2025: Call for Content

Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!

Submit your idea!

How to choose a machine learning algorithm

Use this tutorial as a handy guide to weigh the pros and cons of these commonly used machine learning algorithms.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 1 reply
  • 873 views
  • 0 likes
  • 2 in conversation