Icon

JKISeason3-24_​tofusa

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.

Level: MediumDescription: Your company wants to perform a cohort analysis to find customers that started purchasing goods on the same month (cohorts), and then track theirpersistence over time. To solve this challenge, you must explore a transactions dataset from 2016, identify its cohorts, calculate the customer retention ratio, separatethe purchases month by month, and then visualize the persistence of the cohorts over time. Note: Customer retention rate (CRR) is the percentage of customers acompany 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 numberof customers in the beginning of 2016, then CRR = [(E - N) / S] * 100.説明 貴社はコホート分析を実施し、同じ月に商品の購入を開始した顧客（コホート）を見つけ、その継続性を長期にわたって追跡したいと考えています。この課題を解決するには、2016年からのトランザクションデータセットを探索し、コホートを特定し、顧客維持率を計算し、月ごとに購入を分け、コホートの継続性を経時的に可視化する必要があります。注：顧客維持率（CRR）とは、企業が一定期間にわたって顧客を維持する割合のことである。Eを2016年末の顧客数、Nを期間中の新規顧客数、Sを2016年初めの顧客数とすると、CRR = [(E - N) / S] * 100となる。 load data Excel Reader view Level: MediumDescription: Your company wants to perform a cohort analysis to find customers that started purchasing goods on the same month (cohorts), and then track theirpersistence over time. To solve this challenge, you must explore a transactions dataset from 2016, identify its cohorts, calculate the customer retention ratio, separatethe purchases month by month, and then visualize the persistence of the cohorts over time. Note: Customer retention rate (CRR) is the percentage of customers acompany 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 numberof customers in the beginning of 2016, then CRR = [(E - N) / S] * 100.説明 貴社はコホート分析を実施し、同じ月に商品の購入を開始した顧客（コホート）を見つけ、その継続性を長期にわたって追跡したいと考えています。この課題を解決するには、2016年からのトランザクションデータセットを探索し、コホートを特定し、顧客維持率を計算し、月ごとに購入を分け、コホートの継続性を経時的に可視化する必要があります。注：顧客維持率（CRR）とは、企業が一定期間にわたって顧客を維持する割合のことである。Eを2016年末の顧客数、Nを期間中の新規顧客数、Sを2016年初めの顧客数とすると、CRR = [(E - N) / S] * 100となる。 load data Excel Reader view

Nodes

Extensions

Links

Download

To use this workflow in KNIME, download it from the below URL and open it in KNIME:

Download Workflow
Created by: user1
Created at: 2024-05-23
On NodePit since: 2024-10-28
Last update: 2024-11-21
Created with KNIME version: v5.3.2
Tags: JKISeason3-24

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!