Icon

SAP ECC Customer Life Time Value Analysis

SAP ECC Customer Life Time Value Analysis
SAP ECC Customer Analytics Accelerator: Customer Life time Value Analysis and SegmentationWorkflow Description:CLV is a measurement of how valuable a customer is to your company, not just on a purchase-by-purchase basis but across the whole relationship. With DVW KNIME Connector for SAP andKNIME, this workflow shows how a sales/account manager can easily extract the total revenue of a set of customers from ECC and calculate their CLVs and segment customers into differentbands by value and lifetime (e.g. 30+years and 1m+ as platinum). Prerequisites:KCS SAP ExecutorTools used:SAP Table tool This workflow requires the DVW KNIME Connector for SAP. For more details and to request a trial, visit us at www.dvwanalytics.com Table creator toprovide input of list ofcustomer numbersand associated costs Column expressionsand table manipulatorto transform the tabledata to theappropriate format forKCS table tooldynamic input KCS SAP Executortable read tool toextract order detailsfor the list ofcustomers provided Stringmanipulation toremove anyhidden characters Table Manipulatorto convert ordervalues from stringto number GroupBy to extractthe first and lastorder date for thecustomer Combine first andlast order dateinto the samecustomer record Convert SAP dateformat to arecognised formatfor Knime Convert datestring to date field Work out thenumber of yearscustomers havebeen placingorders Segment thecustomer base toplatimum/gold/silver/bronze etcbase on the no ofyears customerhas been ordering Output to thesegmentationdate to a pie chart KCS SAP Executortable read tool toextract generalcustomer data Stringmanipulation toremove anyhidden characters Join custome CLVsegmentationdata withcustomer generaldata Output to Tableauformat for furtherexploration inTableau GroupBy to sumup customerrevenue Join withcustomer costfigures from theinput table Calculate CLV astotal revenue -acquistion ccost -cost to serv Segment thecustomer base toplatimum/gold/silver/bronze etcbase on the CLVvalue e.g. > 1m asplatinum Customer and cost inputNode 6Node 7Node 8Node 9Get First order DateGet Last Order DateNode 12Node 13Node 14Node 15Node 16Node 17Node 18Node 19Node 20Node 21Node 22Node 24Node 25Node 26Node 27Node 28Node 29Node 30 Table Creator Column Expressions Table Manipulator KCS SAP Executor Table Manipulator GroupBy GroupBy Joiner Column Expressions Date&TimeDifference String to Date&Time Column Expressions Pie/Donut Chart GroupBy Joiner Column Expressions Column Expressions Pie/Donut Chart String Manipulation String Manipulation KCS SAP Executor Joiner Joiner String Manipulation Tableau Writer SAP ECC Customer Analytics Accelerator: Customer Life time Value Analysis and SegmentationWorkflow Description:CLV is a measurement of how valuable a customer is to your company, not just on a purchase-by-purchase basis but across the whole relationship. With DVW KNIME Connector for SAP andKNIME, this workflow shows how a sales/account manager can easily extract the total revenue of a set of customers from ECC and calculate their CLVs and segment customers into differentbands by value and lifetime (e.g. 30+years and 1m+ as platinum). Prerequisites:KCS SAP ExecutorTools used:SAP Table tool This workflow requires the DVW KNIME Connector for SAP. For more details and to request a trial, visit us at www.dvwanalytics.com Table creator toprovide input of list ofcustomer numbersand associated costs Column expressionsand table manipulatorto transform the tabledata to theappropriate format forKCS table tooldynamic input KCS SAP Executortable read tool toextract order detailsfor the list ofcustomers provided Stringmanipulation toremove anyhidden characters Table Manipulatorto convert ordervalues from stringto number GroupBy to extractthe first and lastorder date for thecustomer Combine first andlast order dateinto the samecustomer record Convert SAP dateformat to arecognised formatfor Knime Convert datestring to date field Work out thenumber of yearscustomers havebeen placingorders Segment thecustomer base toplatimum/gold/silver/bronze etcbase on the no ofyears customerhas been ordering Output to thesegmentationdate to a pie chart KCS SAP Executortable read tool toextract generalcustomer data Stringmanipulation toremove anyhidden characters Join custome CLVsegmentationdata withcustomer generaldata Output to Tableauformat for furtherexploration inTableau GroupBy to sumup customerrevenue Join withcustomer costfigures from theinput table Calculate CLV astotal revenue -acquistion ccost -cost to serv Segment thecustomer base toplatimum/gold/silver/bronze etcbase on the CLVvalue e.g. > 1m asplatinum Customer and cost inputNode 6Node 7Node 8Node 9Get First order DateGet Last Order DateNode 12Node 13Node 14Node 15Node 16Node 17Node 18Node 19Node 20Node 21Node 22Node 24Node 25Node 26Node 27Node 28Node 29Node 30 Table Creator Column Expressions Table Manipulator KCS SAP Executor Table Manipulator GroupBy GroupBy Joiner Column Expressions Date&TimeDifference String to Date&Time Column Expressions Pie/Donut Chart GroupBy Joiner Column Expressions Column Expressions Pie/Donut Chart String Manipulation String Manipulation KCS SAP Executor Joiner Joiner String Manipulation Tableau Writer

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: JieZhao
Created at: 2021-04-13
On NodePit since: 2022-03-25
Last update: 2024-04-27
Created with KNIME version: v4.3.2
Tags: SAPDVW Analytics

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

Try NodePit Runner!