Churn: Input for CLTV
Churn: Input for CLTV
Technical name: 0CRM_CUST_Q0001
Use
In the analytical application
Churn Management, you use this query to run the CLTV model and the CLTV prediction in order to determine which customers are active.Filters
|
InfoObject |
Description of the InfoObject (and Restriction or Calculation Formula) |
|
0CURTYPE |
Currency type (= #, B0) |
|
0REC_TYPE |
Record type (= #, B, C, D, F) |
|
0VALUATION |
Valuation view (= #) |
|
0VTYPE |
Value type for reporting (= #, 10) |
Lines
|
InfoObject |
Description of the InfoObject (and Restriction or Calculation Formula) |
 0BPARTNER |
Business partner |
|
0DM_CLUSNO |
Cluster number (attribute for 0BPARTNER) |
|
0CRM_CUSSIN |
CRM: Customer Since Date for BP (attribute for 0BPARTNER) |
|
0CRMACSTAT |
Customer status (attribute for 0BPARTNER) |
|
0CALMONTH |
Calendar year/month |
Columns
|
InfoObject |
Description of the InfoObject (and Restriction or Calculation Formula) |
|
0COPAREVEN |
Revenue |
|
0COPAMRGN1 |
Contribution Margin 1 |