Icon

Clustering and RFM - Solution

RFM-Score and Customer KPI

This workflow analyzes transactional data to devise a scoring system that clusters customers based on RFM scores. Additionally, the analysis is enirched with CLV calculation, and customer insights are presented using interactive visualizations.

CLV calculation Correlation preparation RFM & CLV merging RFM preparation RFM calculation Visualization RFM-Score and Customer KPIThis workflow analyzes transactional data to devise a scoring system that clusters customers based on RFM scores. Additionally, the analysis is enirched with CLV calculation, and customer insights are presented using interactive visualizations. Data ingestion MatrixProduct Dummiesper customerRFM informationper customerRecencyFrequencyMonetaryValueASCRow IndexRow IndexDESCRow IndexASCRFM ScoreScoreRow IndexASCorder<6 montsCLVRFM -> CLVRFM ClusterRFM -> CLVRFMorder.csvtransactional datasignum+ Cluster+ Cluster+ RFMClusterRFM + CLV+ Cluster+ Cluster+ Clusterresults.xlsxno ofcluster centroidsNode 56 Linear Correlation Pivot Missing Value GroupBy k-Means k-Means k-Means Sorter Math Formula Math Formula Sorter Math Formula Sorter Math Formula k-Means Math Formula Sorter Row Filter GroupBy Column Rename(deprecated) Scatter Plot(JavaScript) Color Manager Number to String Conditional BoxPlot (JavaScript) Bar Chart(JavaScript) CSV Reader Math Formula(Multi Column) Joiner Joiner Joiner Joiner Joiner Joiner Joiner Excel Writer Variable Creator Hier. Clustering CLV calculation Correlation preparation RFM & CLV merging RFM preparation RFM calculation Visualization RFM-Score and Customer KPIThis workflow analyzes transactional data to devise a scoring system that clusters customers based on RFM scores. Additionally, the analysis is enirched with CLV calculation, and customer insights are presented using interactive visualizations. Data ingestion MatrixProduct Dummiesper customerRFM informationper customerRecencyFrequencyMonetaryValueASCRow IndexRow IndexDESCRow IndexASCRFM ScoreScoreRow IndexASCorder<6 montsCLVRFM -> CLVRFM ClusterRFM -> CLVRFMorder.csvtransactional datasignum+ Cluster+ Cluster+ RFMClusterRFM + CLV+ Cluster+ Cluster+ Clusterresults.xlsxno ofcluster centroidsNode 56 Linear Correlation Pivot Missing Value GroupBy k-Means k-Means k-Means Sorter Math Formula Math Formula Sorter Math Formula Sorter Math Formula k-Means Math Formula Sorter Row Filter GroupBy Column Rename(deprecated) Scatter Plot(JavaScript) Color Manager Number to String Conditional BoxPlot (JavaScript) Bar Chart(JavaScript) CSV Reader Math Formula(Multi Column) Joiner Joiner Joiner Joiner Joiner Joiner Joiner Excel Writer Variable Creator Hier. Clustering

Nodes

Extensions

Links

Download

To use this workflow in KNIME, download it from the below URL and open it in KNIME:

Download Workflow
Created by: th
Created at: 2020-02-04
On NodePit since: 2024-10-03
Last update: 2024-10-18
Created with KNIME version: v5.2.0
Tags: Marketing AnalyticsRFMCLVClusteringKPIRecencyFrequencyMonetary Value

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!