Customer Count and Churn Rate by Time-based Cohort

This component shows the (cumulative) customer count or churn rate by time and time-based cohort. Cohorts are used to group individual records by the characteristics that they share, which is their starting time in this case. Analysis of cohorts reveals trends and patterns that could not be identified from the individual records.

A time-based cohort for each ID is defined based on the first time when the ID appears in the data.

Four types of churn analysis are possible:
1. The cumulative customer count by time and time-based cohort (stacked area chart)
1. The cumulative churn rate by time and time-based cohort (stacked area chart)
2. The customer count in each time-based cohort over time (line plot)
2. The churn rate in each time-based cohort over time (line plot)

Required extensions:
- KNIME Expressions
(https://hub.knime.com/knime/extensions/org.knime.features.expressions/latest)
- KNIME Plotly
(https://hub.knime.com/knime/extensions/org.knime.features.js.plotly/latest)
- KNIME Math Expression (JEP)
(https://hub.knime.com/knime/extensions/org.knime.features.ext.jep/latest)
- KNIME Quick Forms
(https://hub.knime.com/knime/extensions/org.knime.features.js.quickforms/latest)

Options

Generate image:

If enabled, the chart will be generated as a static image in SVG format. Disabling this option makes the component execute faster.

Select value column:

Values assigned to each record. If the data don't contain any value column, select "Count" here. This column is used to check for invalid records: zero values in this column will be ignored in the calculation.

Select ID column:

Identifies the records in the data.

Select time column:

Indicates the time point of each record.

Select cohort granularity:

The time-based cohorts are defined based on the granularity selected here.

Select metric:

The development of this metric (customer count/churn rate) is visualized by time and time-based cohort.

Select chart type:

Select whether to visualize the cumulative or the actual value of the metric.

Nodes

• Breakpoint4 ×
• CASE Switch Data (Start)4 ×
• Column Filter4 ×
• Rule Engine Variable4 ×
• Column Selection Configuration3 ×
• Show all 43 nodes

Extensions

• FeatureKNIME Base nodes
• FeatureKNIME Column Expressions (Labs)
• FeatureKNIME JavaScript Views
• FeatureKNIME Javasnippet
• FeatureKNIME Math Expression (JEP)
• Show all 6 modules

Links

• No links available