After a short break, I am back with another proposed solution.
Here in my solution, you can observe some new column creations, assigning coefficients to calculate new metrics such as loyalty scores and segments and ultimately a little dashboard to visualize and summarize the whole project.
-Aydin Baris Ustun 07.07.2025