Icon

02_​Customers_​Trx_​Money_​vs_​Loyalty

Data Chef ETL Battles. Customer Transactions: Money vs. Loyalty.
In this workflow we convert raw customer transactions, i.e. contract registrations, into money measures on the one hand and loyalty features on the other.For more information see the workflow metadata. Find it here: View -> Description Loyalty. Calculate loyalty ratio for each customer as the effective # of days till total # of days till now (Feb 1, 2017) Money. Calculate total amount of money from contracts and amount of money per year. sales records total money amtby customer# daysfrom first startto nowby total amount# daysfrom first startto last endsum # dayson Cust_IDeffective # daysloyaltyratioby loyaltyratiomax intervalon overlappingstart-end intervalsYear fromstart_dateavg amount Cust_ID vs. Yeartotal amount+ amount /yearon Cust_IDresortingyearsmoney+loyaltyfeaturesamount(year)on radar plotif amount(Year)missing => 0keep itbasic!total amount vs.loyaltySelect customerwith highest loyaltyand highesttotal amountcolor by Cust_IDextractselected customersfrom Stringto DateTimemin start_datemax end_date# days File Reader GroupBy Time Difference(legacy) Sorter Time Difference(legacy) GroupBy Column Rename Math Formula Sorter Time Alignment Date FieldExtractor (legacy) Pivoting Column Rename(Regex) Joiner Column Resorter Joiner Radar Plot Appender Missing Value Column Filter Scatter Plot Color Manager Row Filter To DateTime GroupBy Table Column toVariable (deprecated) In this workflow we convert raw customer transactions, i.e. contract registrations, into money measures on the one hand and loyalty features on the other.For more information see the workflow metadata. Find it here: View -> Description Loyalty. Calculate loyalty ratio for each customer as the effective # of days till total # of days till now (Feb 1, 2017) Money. Calculate total amount of money from contracts and amount of money per year. sales records total money amtby customer# daysfrom first startto nowby total amount# daysfrom first startto last endsum # dayson Cust_IDeffective # daysloyaltyratioby loyaltyratiomax intervalon overlappingstart-end intervalsYear fromstart_dateavg amount Cust_ID vs. Yeartotal amount+ amount /yearon Cust_IDresortingyearsmoney+loyaltyfeaturesamount(year)on radar plotif amount(Year)missing => 0keep itbasic!total amount vs.loyaltySelect customerwith highest loyaltyand highesttotal amountcolor by Cust_IDextractselected customersfrom Stringto DateTimemin start_datemax end_date# daysFile Reader GroupBy Time Difference(legacy) Sorter Time Difference(legacy) GroupBy Column Rename Math Formula Sorter Time Alignment Date FieldExtractor (legacy) Pivoting Column Rename(Regex) Joiner Column Resorter Joiner Radar Plot Appender Missing Value Column Filter Scatter Plot Color Manager Row Filter To DateTime GroupBy Table Column toVariable (deprecated)

Nodes

Extensions

Links