Icon

JKISeason3-24_​Performing Cohort Analysis for a Business

Performing Cohort Analysis for a Business

Challenge 24

Level: Medium

Description: Your company wants to perform a cohort analysis to find customers that started purchasing goods on the same month (cohorts), and then track their persistence over time. To solve this challenge, you must explore a transactions dataset from 2016, identify its cohorts, calculate the customer retention ratio, separate the purchases month by month, and then visualize the persistence of the cohorts over time. Note: Customer retention rate (CRR) is the percentage of customers a company retains over a period of time. If E is the number of customers at the end of 2016, N is the number of new customers during the period, and S is the number of customers in the beginning of 2016, then CRR = [(E - N) / S] * 100.

Author: Aline Bessa

Transactional dataMarketing spendingNode 3Node 4Node 5Node 6Node 7Node 8Node 9201601Node 11Node 13Node 14201601Node 17201602Node 19Node 20Node 21Node 22Node 23Node 24201602Node 26Node 27Node 28201602Node 30Node 31Node 32201602Node 34Node 35Node 36201602Node 38Node 39Node 40201602Node 42Node 43Node 44201602Node 46Node 47201602Node 49Node 50Node 51201602Node 53Node 54Node 55201602Node 57Node 58Node 59201602Node 61Node 62Node 63Node 64Node 65Node 66Node 68Node 69Node 70Node 71Node 73Node 74Node 75Node 76Node 77Node 78Node 79Node 80Node 81Node 82Node 83Node 84Node 85Node 86Node 87Node 88Node 89Node 90Node 91Node 92Node 93Node 94Node 95Node 96Node 97Node 98Node 99Node 100Node 101Node 102Node 103Node 104Node 105Node 106Node 107Node 108Node 109Node 110Node 111Node 112Node 113Node 114Node 115Node 116Node 117Node 118Node 119Node 120Node 121Node 122Node 123Node 124Node 125Node 126Node 127Node 128Node 129Node 130Node 131Node 132Node 133Node 134Node 135Node 136Node 137Node 138Node 139Node 140Node 141Node 142Node 143Excel Reader Excel Reader GroupBy Date&Time to String Table Creator Value Lookup Value Lookup String to Number Line Plot Row Filter Value Counter Value Counter DuplicateRow Filter Row Filter DuplicateRow Filter Row Filter DuplicateRow Filter Row Aggregator ConstantValue Column Row Aggregator ConstantValue Column ConstantValue Column Row Filter DuplicateRow Filter Row Aggregator ConstantValue Column Row Filter DuplicateRow Filter Row Aggregator ConstantValue Column Row Filter DuplicateRow Filter Row Aggregator ConstantValue Column Row Filter DuplicateRow Filter Row Aggregator ConstantValue Column Row Filter DuplicateRow Filter Row Aggregator ConstantValue Column Row Filter DuplicateRow Filter Row Aggregator Row Filter DuplicateRow Filter Row Aggregator ConstantValue Column Row Filter DuplicateRow Filter Row Aggregator ConstantValue Column Row Filter DuplicateRow Filter Row Aggregator ConstantValue Column Row Filter DuplicateRow Filter Row Aggregator ConstantValue Column Concatenate Table Rowto Variable ConstantValue Column Column Renamer Math Formula Value Lookup Row Filter Row Aggregator Column Renamer Table Rowto Variable ConstantValue Column Value Lookup Row Filter Row Aggregator Column Renamer Table Rowto Variable ConstantValue Column Value Lookup Row Filter Row Aggregator Column Renamer Table Rowto Variable ConstantValue Column Value Lookup Row Filter Row Aggregator Column Renamer Table Rowto Variable ConstantValue Column Value Lookup Row Filter Row Aggregator Column Renamer Table Rowto Variable ConstantValue Column ConstantValue Column Value Lookup Row Filter Row Aggregator Column Renamer Table Rowto Variable ConstantValue Column Value Lookup Row Filter Row Aggregator Column Renamer Table Rowto Variable ConstantValue Column Value Lookup Row Filter Row Aggregator Column Renamer Table Rowto Variable ConstantValue Column Value Lookup Row Filter Row Aggregator Column Renamer Table Rowto Variable ConstantValue Column Value Lookup Row Filter Row Aggregator Column Renamer Table Rowto Variable ConstantValue Column Value Lookup Row Filter Row Aggregator Column Renamer Table Rowto Variable ConstantValue Column Value Lookup Row Filter Row Aggregator Column Renamer Table Rowto Variable Line Plot Transactional dataMarketing spendingNode 3Node 4Node 5Node 6Node 7Node 8Node 9201601Node 11Node 13Node 14201601Node 17201602Node 19Node 20Node 21Node 22Node 23Node 24201602Node 26Node 27Node 28201602Node 30Node 31Node 32201602Node 34Node 35Node 36201602Node 38Node 39Node 40201602Node 42Node 43Node 44201602Node 46Node 47201602Node 49Node 50Node 51201602Node 53Node 54Node 55201602Node 57Node 58Node 59201602Node 61Node 62Node 63Node 64Node 65Node 66Node 68Node 69Node 70Node 71Node 73Node 74Node 75Node 76Node 77Node 78Node 79Node 80Node 81Node 82Node 83Node 84Node 85Node 86Node 87Node 88Node 89Node 90Node 91Node 92Node 93Node 94Node 95Node 96Node 97Node 98Node 99Node 100Node 101Node 102Node 103Node 104Node 105Node 106Node 107Node 108Node 109Node 110Node 111Node 112Node 113Node 114Node 115Node 116Node 117Node 118Node 119Node 120Node 121Node 122Node 123Node 124Node 125Node 126Node 127Node 128Node 129Node 130Node 131Node 132Node 133Node 134Node 135Node 136Node 137Node 138Node 139Node 140Node 141Node 142Node 143Excel Reader Excel Reader GroupBy Date&Time to String Table Creator Value Lookup Value Lookup String to Number Line Plot Row Filter Value Counter Value Counter DuplicateRow Filter Row Filter DuplicateRow Filter Row Filter DuplicateRow Filter Row Aggregator ConstantValue Column Row Aggregator ConstantValue Column ConstantValue Column Row Filter DuplicateRow Filter Row Aggregator ConstantValue Column Row Filter DuplicateRow Filter Row Aggregator ConstantValue Column Row Filter DuplicateRow Filter Row Aggregator ConstantValue Column Row Filter DuplicateRow Filter Row Aggregator ConstantValue Column Row Filter DuplicateRow Filter Row Aggregator ConstantValue Column Row Filter DuplicateRow Filter Row Aggregator Row Filter DuplicateRow Filter Row Aggregator ConstantValue Column Row Filter DuplicateRow Filter Row Aggregator ConstantValue Column Row Filter DuplicateRow Filter Row Aggregator ConstantValue Column Row Filter DuplicateRow Filter Row Aggregator ConstantValue Column Concatenate Table Rowto Variable ConstantValue Column Column Renamer Math Formula Value Lookup Row Filter Row Aggregator Column Renamer Table Rowto Variable ConstantValue Column Value Lookup Row Filter Row Aggregator Column Renamer Table Rowto Variable ConstantValue Column Value Lookup Row Filter Row Aggregator Column Renamer Table Rowto Variable ConstantValue Column Value Lookup Row Filter Row Aggregator Column Renamer Table Rowto Variable ConstantValue Column Value Lookup Row Filter Row Aggregator Column Renamer Table Rowto Variable ConstantValue Column ConstantValue Column Value Lookup Row Filter Row Aggregator Column Renamer Table Rowto Variable ConstantValue Column Value Lookup Row Filter Row Aggregator Column Renamer Table Rowto Variable ConstantValue Column Value Lookup Row Filter Row Aggregator Column Renamer Table Rowto Variable ConstantValue Column Value Lookup Row Filter Row Aggregator Column Renamer Table Rowto Variable ConstantValue Column Value Lookup Row Filter Row Aggregator Column Renamer Table Rowto Variable ConstantValue Column Value Lookup Row Filter Row Aggregator Column Renamer Table Rowto Variable ConstantValue Column Value Lookup Row Filter Row Aggregator Column Renamer Table Rowto Variable Line Plot

Nodes

Extensions

Links