Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
RFM analysis will demonstrate which customers need to be retained at the moment, whose loyalty should be maintained, and who are not worthy of the marketing efforts you put.
How we do that?
1) we will segment your customer base into 3 categories: Recency (How recently did the customer make a purchase?), Frequency (How often do they purchase), and Monetary Value (How much do they spend?)
2) next step is the building of matrix that contains 25 segments, each having a transparent name ("perspective", "in the risk zone", etc.)
As a result you get the analysis in the form of an interactive dashboard. You can choose any segment and explore the data.
eyJrIjoiMDk4ZWQzOTUtNjI3ZS00MmRmLWE1NmUtMDY5NmJlYWZlNWJiIiwidCI6ImU3N2EyNjdjLWE1ZjctNDQyNi1iYTA4LWM2ZTU5OWE2ZDExYiIsImMiOjl9
Hey, DatmarkLLC.
I really liked your model, especially the second page.
If possible, can you clarify how you calculated the revenue estimations on the second page? I wish to apply something similar in a dashboard I'm building.
Kind Regards,