Export of Attrition Risk scores
If the transaction data is loaded with the available data import options, then this call exports the data:
attrisk -d "jdbc:postgresql://192.168.56.102/crm_db?user=crm&password=crm" -p c\:/tmp/demo20-11/attrition_coeffs.json -st 2015-01-01 -e 2016-01-01 -l 0.25 -c 1.15 -r 3
This table shows the command line parameters of the call:
| Option | Abbreviation | Required | Comment |
|---|---|---|---|
| dburl | -d | Yes | SICRM db connection string. |
| schema | -sc | No.
Default public |
Database schema. |
| csv | -cs | No.
Default JSON |
Output format for the results. |
| lsparams | -p | Yes | File with model parameters. |
| lookback | -l | No.
Default 0.25 |
Length of attrition historic period as a fraction of the historic period for Purchase Likelihood. |
| cutoff | -c | Yes | Border value for estimating risk customers. If Attrition Risk is greater than cutoff, then customer is marked at risk. |
| reasons | -r | No.
Default 2 |
Number of reasons provided for risk. |
| start | -st | Yes | Start of the historic period for Purchase Likelihood. |
| end | -e | Yes | End of the historic period for Purchase Likelihood. |
| output | -o | No.
Default STDOUT |
Output to the file. |
| threshold | -t | No.
Default 0 |
Minimum total sales for the last 12 months. If total sales is less than threshold, then customer is ignored. |
| lsthreshold | -lt | No.
Default 0 |
Minimum PL score. If score is less than lsthreshold, then customer is ignored. |
| endlastpurchase | -el | No.
Default from lsparams |
Use end date as the last purchase period date if endlastpurchase is present, otherwise take from lsparams. |
| verbose | -v | No.
Default false |
Output detailed debug information for each customer into the current working directory. |