I have three tables:
I want to build a model to predict the probability that a specific client will negotiate with us, during a certain time frame (length could be anywhere from 1 week up to 1 year), based on the history of the credit bureau.
An easy way would be:
However, I feel I am losing a lot of information by doing that. What would be the state-of-art to solve this? I imagine that with a good technique: