Customer Churn Prediction [deprecated]
Available since: v1.0.0
These special export contains data intended for use with Machine Learning system that can identify customer churn patterns.
predict_yyyy_MM_dd.csv contains all active user subscriptions that should be run churn prediction on for identifying possible needed winback actions.
training_yyyy_MM_dd.csv contains a snapshot of all active and historic users for Machine Learning use to identify churn patterns.
The actual churn prediction and possible winback actions are done via 3rd party integrations and require additional service agreements. Please contact your Vimond Account Manager for more details.
| File | Frequency |
|---|---|
| /churn/predict/predict_yyyy_MM_dd.csv | Daily |
| /churn/training/training_yyyy_MM_dd.csv | Weekly |
| Attribute | Value | Description |
|---|---|---|
| CUSTOMERID | NUMBER | Foreign key for Users |
| GENDER | NUMBER | |
| AGE | NUMBER | |
| TOWNCODE | VARCHAR | |
| STATECODE | VARCHAR | |
| COUNTRY | VARCHAR | |
| PHONENUM | VARCHAR | |
| MOBILENUM | VARCHAR | |
| MAINDEVICE | VARCHAR | Main device used for watching |
| N_ACTIVEDAYS | NUMBER | Number of days in total that user has watched a video |
| TENURE | NUMBER | Number of days since signed up |
| RECENCY | NUMBER | Number of days since last video view |
| SUBSCRIPTIONPERIOD | NUMBER | Number of renewed subscription periods |
| PAYMENTMETHOD | VARCHAR | |
| TOTALCHARGE | NUMBER | Price paid for current subscription |
| PRODUCTNAME | VARCHAR | Name of current subscription |
| AUTOSUBSCRIPTION | Y or N | Flag indicating if the subscription is set to auto-renews |
| N_SUBSCRIPTIONEXPIRY | NUMBER | Number of days until subscription expires |
| D_STARTSUBS | DATE | State date of current subscription |
| D_ENDSUBS | DATE | End date of current subscription |
| TYPEVIEW | LIVE or VOD | Type of video last watched |
| USER_CHURN | 0 or 1 | Flag indicating if user has churned or not |