Cohort Analysis Tutorial Solution

0 ×

This workflow shows step-by-step how to calculate the customer retention ratio by relative month (1, 2, 3, and so on months after the first purchase) and cohort. The cohort is defined based on the date of the first purchase, so it is a time-based cohort.

Nodes

• GroupBy3 ×
• Joiner2 ×
• Math Formula2 ×
• Color Manager1 ×
• Column Rename1 ×
• Component Input1 ×
• Component Output1 ×
• Date&Time Difference1 ×
• Date&Time to String1 ×
• Excel Reader1 ×
• Extract Column Header1 ×
• Line Plot (JavaScript)1 ×
• Missing Value1 ×
• Pivoting1 ×
• Rule Engine1 ×
• Stacked Area Chart1 ×
• String Manipulation (Multi Column)1 ×
• String to Date&Time1 ×
• Transpose1 ×

Extensions

• FeatureKNIME Base nodes
• FeatureKNIME Excel Support
• FeatureKNIME JavaScript Views
• FeatureKNIME Javasnippet
• FeatureKNIME Math Expression (JEP)

Links

• Seeing the Forest for the Trees - Cohort Analysis

  www.knime.com/blog/seeing-the-forest-for-the-trees-cohort-analysis
• MRR and ARR for Customer Groups

  kni.me/w/yTB96vTl8wN7u89q
• Get Started with a Cohort Analysis Tutorial in KNIME

  www.knime.com/blog/cohort-analysis-tutorial