Icon

SAP ECC Customer Life Time Value Analysis

SAP ECC Customer Analytics Accelerator: Customer Life time Value Analysis and Segmentation

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 and KNIME, 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 different bands by value and lifetime (e.g. 30+years and 1m+ as platinum).

Prerequisites:
KCS SAP Executor
Tools 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.

SAP ECC Customer Analytics Accelerator: Customer Life time Value Analysis and SegmentationCLV 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 and KNIME, this workflow shows how a sales/account manager can easily extract the total revenue of a set of customers from ECCand calculate their CLVs and segment customers into different bands by value and lifetime (e.g. 30+years and 1m+ as platinum). Data extraction from SAP1. Read data from SAP sales order table - VBAK2. Read data from SAP customer master table - KNA1 Data preprocessing1. Calculate CLVs2. Customer Segmentation Data Output1. Format data for charting2. Output data to Tableau Table withcustomer numbersandassociated costsTransform table datato the appropriate formatfor KCS tabletool dynamic inputTable read tool to extractorder details forthe list of customers providedConvert order valuesString > DoubleGet First order DateGet Last Order DateConvert SAP dateto KNIME date formatWork out the numberof years customershave been placingordersSegment the customer basebased on the no of yearscustomer has been orderingDisplay customersegmentationby no. of yearsSum up customer revenueCalculate CLV = total revenue- acquistion cost- cost to servSegment the customer basebased on the CLV value e.g. > 1m as platinumDisplay customersegmentationby value of ordersRemovehidden charsTable read tool to extractgeneral customer data Remove any hidden charactersTo Tableau format for further explorationCombine firstand last order dateinto the same customer recordJoin with customercost figuresfrom the input tableJoin customer CLVsegmentation datawith customer general data Table Creator Column Expressions Table Manipulator KCS SAP Executor Table Manipulator GroupBy GroupBy Column Expressions Date&TimeDifference String to Date&Time Column Expressions Pie/Donut Chart GroupBy Column Expressions Column Expressions Pie/Donut Chart String Manipulation String Manipulation KCS SAP Executor String Manipulation Tableau Writer Joiner Joiner Joiner Joiner SAP ECC Customer Analytics Accelerator: Customer Life time Value Analysis and SegmentationCLV 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 and KNIME, this workflow shows how a sales/account manager can easily extract the total revenue of a set of customers from ECCand calculate their CLVs and segment customers into different bands by value and lifetime (e.g. 30+years and 1m+ as platinum). Data extraction from SAP1. Read data from SAP sales order table - VBAK2. Read data from SAP customer master table - KNA1 Data preprocessing1. Calculate CLVs2. Customer Segmentation Data Output1. Format data for charting2. Output data to Tableau Table withcustomer numbersandassociated costsTransform table datato the appropriate formatfor KCS tabletool dynamic inputTable read tool to extractorder details forthe list of customers providedConvert order valuesString > DoubleGet First order DateGet Last Order DateConvert SAP dateto KNIME date formatWork out the numberof years customershave been placingordersSegment the customer basebased on the no of yearscustomer has been orderingDisplay customersegmentationby no. of yearsSum up customer revenueCalculate CLV = total revenue- acquistion cost- cost to servSegment the customer basebased on the CLV value e.g. > 1m as platinumDisplay customersegmentationby value of ordersRemovehidden charsTable read tool to extractgeneral customer data Remove any hidden charactersTo Tableau format for further explorationCombine firstand last order dateinto the same customer recordJoin with customercost figuresfrom the input tableJoin customer CLVsegmentation datawith customer general data Table Creator Column Expressions Table Manipulator KCS SAP Executor Table Manipulator GroupBy GroupBy Column Expressions Date&TimeDifference String to Date&Time Column Expressions Pie/Donut Chart GroupBy Column Expressions Column Expressions Pie/Donut Chart String Manipulation String Manipulation KCS SAP Executor String Manipulation Tableau Writer Joiner Joiner Joiner Joiner

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: 2024-11-06
Last update: 2024-11-21
Created with KNIME version: v4.6.3
Tags: SAPDVW AnalyticsMarketing AnalyticsCustomer Lifetime ValueCustomer Segmentation

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

Try NodePit Runner!