Customer Data

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

ZipCode 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

0176 0153

The starting digits of the Customer's phone number; Used as Categories for Pattern Recognition

Last updated