Churn: CLTV Prediction: Active and Lost Customers
Churn: CLTV Prediction: Active and Lost Customers
Technical name: 0CRM_CUST_Q0007
Use
This query shows detailed information on the active and lost customers determined during CLTV prediction in the analytical application
Churn Management.Filters
|
InfoObject |
Description of the InfoObject (and Restriction or Calculation Formula) |
 0CRMAFCPER |
Prediction period (< 1) |
Free Characteristics
|
InfoObject |
Description |
|
0CRMAFOREC |
CLTV prediction (variable 0P_CLTW) |
Variables used
|
Variable |
Description |
|
0P_CLTW |
CLTV Prediction |
Lines
|
InfoObject |
Description of the InfoObject (and Restriction or Calculation Formula) |
|
0CRMADATE |
CLTV key date |
Columns
|
InfoObject |
Description of the InfoObject (and Restriction or Calculation Formula) |
|
0CRMACACT |
Active customers |
|
0CRMACLOS |
Lost customers |
|
Churn rate ("lost customers" / "active customers") |
|
|
0CRMAPROF |
Total profit |
|
Lost profit (( "active customers" > 0 ) * "total profit" * "lost customers" / "active customers") |