The Customer Table contains details of your Customers. This table has two mandatory fields: customer_id (string) and customer_since (date). You can also add additional data present in your Customer records, which can help improve accuracy of your Models.
The customer_id field is the primary key of this table. Each data record must have a Unique value for this field.
| Field Name | Data Type | Example | Description |
*customer_id | String | e131498 | This is the key field, used for Identification of Customers. All values in this field must be Unique. |
*customer_since | Date | 2010-12-21 | Date of first contact with the Customer. This field is vital for future predictions, and every customer should have a value for this field. |
customer_gender | String | female Ms. LLC | Gender or Title of the Customer; Used as Categories for Pattern Recognition. |
| customer_age | Date | 1997-06-22 | Date of birth of Customer / Date of foundation of Customer company. Missing values are acceptable. |
zipcode | String | 50676 | ZIP code of the Customer. |
| customer_country | String | France DE | Country where the Customer is based; Used as Categories for Pattern Recognition. |
email_ending | String | gmail.com live.com | Customer's email address provider. If email is mapped to this field, the part before @ is automatically removed; Used as Categories for Pattern Recognition. |
| phone | String |
0153 | The starting digits of the Customer's phone number; Used as Categories for Pattern Recognition. |