Explore the cluster details

The main purpose of the cluster details is to help you to understand the drivers for cross-selling within the context of the cluster and to initiate a dedicated marketing or sales action plan for the cluster's subscriptions.(See What is Cluster for more details about the key concept of cluster in Lifetime Analytics)

The UI is organized into 3 panels: 

  • Left panel - Cluster information : Revenue and volume of active subscriptions, cluster definition, monthly past cross-sellers, overlapping with others clusters, similar clusters existing in previous snapshots
  • Right panel - Action plan setup : picking some marketing or sales actions from the Action Library (see Action Library) and/or the recommendation performed by the application , writing some comments about the clusters
  • Central panel - Cross-sell factor comparison and cluster's subscriptions dashboard : analyse deeply the behavior of L6M cross-sellers in comparison with loyal subscriptions (staying with the same product family) before the cross-sell events (Horizon defines the number of months of comparison before the cross-sell events)

Cluster information panel

 

The panel displays displays the cluster information with different sections :

Cluster definition

  • Revenue LTM : sum of 12 months of revenue MRC of the cluster's active subscriptions
  • Volume : Number of the cluster's active subscriptions
  • Cluster definition displayed as a list of terms : passing over displays the definition of the data (see Data Reference), clicking onto the term display the Cross-sell factor evolution UI (see Factor explorer article)

Cluster cross-sellers

  • Number of monthly cross-sellers LTM : total number of monthly cross-sellers matching the cluster definition over LTM.
  • LTM Conversion rate (cluster) : total number of monthly cross-sellers matching the cluster definition over LTM divided by the total number of active subscriptions matching the cluster definition during the LTM period existing at the beginning of the LTM period (usually 12 months before)
  • LTM Value Conversion rate (cluster) : total revenue MRC of monthly cross-sellers matching the cluster definition over LTM divided by the total revenue MRC of active subscriptions matching the cluster definition during the LTM period existing at the beginning of the LTM period (usually 12 months before)
  • Median tenure : median tenure in months of the LTM cross-sellers
  • Migration path (from > to) : migration paths of the past cross-sellers matching the cluster definition, with mix% and the variation of average MRC between the "from" product family and the "to" product family. Pointing the cursor over the arrow displays the magnitude of the variation. Up arrow means an increase of the ARPU during the migration.

Overlapping clusters

List of clusters overlapping the same active subscriptions. The ratio gives a percentage about how much the active subscriptions are the same between the current cluster and the listed cluster. Pressing the arrow button navigates to the listed cluster details.

Prior clusters

List per snapshot date, the similarly existing clusters. Pressing the arrow button navigates to the listed cluster details.

Each section can be collapsed or expanded to ease the display while pressing the chevron buttons.

Cross-sell factors comparison Central panel

The panel allows to compare per cross-sell factor / data the behaviors for cross-sellers (violet) and the loyal subscriptions (green)  - n months (horizon) before the cross-sell event. The main concept is that monthly cross-sellers are analysed as cohort before they cross-sell to understand how they become cross-sellers.

 

Cross-sell factor comparison charts

Each chart displays the distribution of the values for the related data, depending the data type :

  • Bar chart is displayed for types : text, zip code, year, gender
  • Box plot is displayed for types : number, currency

The chart displayed as rank 1 (squared number) is a direct factor of the cluster definition. It contributes actively to the definition of the cluster. The chart displayed as rank 2 is a co-correlation of a rank 1 factor, having an absolute Pearson correlation coefficient greater than 0.8 between both data.

The "insights" button opens the factor evolution explorer for the related data associated to the chart.

The "importance" is an index of how the data is contributing to the detection of churn in the product family, using mean variation of the SHAP values. It is a direct measure of the importance of the factor as a churn factor.

The "remove" button removes the chart from the dashboard.

Bar chart

In absolute view (default mode or press # button) , the bar chart displays the mix of each value within cross-sellers and loyal populations.

In relative view (press the 0/00 button), the bar chart displays the percentage (in 1/1000) of the value for the cross-sellers over the loyals.

Box plot chart

The box plot displays into a single whisker shape : min without outliers, first quartile, median, mean, third quartile and max without outliers. It allows to compare the whole distribution of the values for churners and loyals, without loosing insights due to the mean aggregation.

The outliers are defined as any value below (min outliers) 1st quartile - 1.5 * IQR or above (max outliers) as 3rd quartile + 1.5 * IQR. IQR is the interquartile range interval as 3rd quartile - 1st quartile.

While pressing the double chevron button, it displays the box plot chart with or without the outliers.

Adding and filtering factor comparison charts

The right filter panel proposes a list of filters based on the factors / data. While refining the range (eg. revenue OOB) or selecting (eg. marketing product name) and pressing to the "filter" button, it applies the selected criteria to all the factor charts.

Pressing on the "123" switch the filter input as a range slider or as a numerical interval input. The effect is equivalent.

Pressing the "reset" button removes all the added factor charts from the dashboard.

The "save" allows to save the added filters and the selected ranges of values. Please press "save" when you are comfortable with the selected filters and ranges.

While pressing the "add" button opens a data selector panel, it lists by category name all the available data (see Data Reference as defined as dimension) from the Product Family.

While clicking onto the "circled plus" button, it adds the selected data as a factor chart into the dashboard.

The search box allows you filter the list of data by name, category or definition.

The "star" button allows you to define or remove the data as favorites, appearing always on the top of the list.

The "library" button navigates to the Data Reference UI (see Data Reference).

Press the "close" button to exit the data selector panel.

Changing the display of factor charts

Selecting the cluster view, displays only the churners matching the cluster definition. Selecting the Product Family view, displays with all the churners of the product family, for comparison.

Sorting differently the factor comparison charts, by :

  • adding order : following the picking order of the charts
  • importance : descending order of importance of churn factor
  • name : sorting by name

The refresh button allows to refresh the cluster metrics, filters, selection and notes as edited by the last user having saved.

The export button exports to an Excel file, the list of cluster cohort subscriptions including the selected data

Draft Action Plan - Right Panel

The purpose the panel is to draft some marketing or care action about the subscriptions at risk of the cluster. The details of the action plan can achieved later (see Define Action Plan).

The list of selected action contains the action you have selected from :

  1. You add from the recommended actions (automatically recommended by the application)
  2. You pick an action from the action library while pressing "library plus" button. The button opens a action selector panel.

Once you have set your actions, you just need to click on Create plan and navigates to your action plan to define it for the cluster. If the cluster has already an existing action plan, the button is renamed "Open Plan". However, if you want to create an addition plan, you can press the "plus" button (right side of the Create Plan button).

While you are deep diving into the cluster, you can drop your notes or review the notes from another team mate.