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

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 modified 2mo ago