Customer data format
Required columns:
uniq_id
: Customer ID. For example, the customer ID in the CRM. An arbitrary string.
Optional columns:
You can change any data.
name
: Customer name. An arbitrary string.create_date_time
: Date and time of contact creation in the tag's time zone.More informationupdate_date_time
: Date and time of contact update in the tag's time zone.More informationclient_ids
: List of ClientIDs. For more information, see Preparing data to be linked to sessions.emails
: List of client's email addresses. A string in Latin including the @ symbol and domain name. You can't use uppercase letters. Example:mail@yandex.ru
.phones
: List of client's phone numbers. A numeric string containing a mobile phone number with a country code. You can't use spaces or extra characters. Example:79995551111
.emails_md5
: List of client's email addresses that are md5 hashed. You can use the email addressmail@yandex.ru
to test your hashing algorithm. The expected hash for this address is3c56ff8fef0f6c65b36b2d25720fe276
.phones_md5
: List of client's phone numbers that are md5 hashed. You can use the number79995551111
to test your hashing algorithm. The expected hash for this number isf09f2c3d48f31e2a802944ade2e5aec5
.
Tip
To match orders from your CRM to Yandex Metrica sessions, pass the following customer data: ClientID, email address, and phone number. Or at least one of the customer characteristics.
You can also transmit additional information about customers, such as the type of customer (individual or business). To do this:
- Create an attribute that will match your additional parameter using the POST /cdp/api/v1/counter/{counterId}/schema/attributes method.
- Pass this attribute along with other customer data using the POST /cdp/api/v1/counter/{counterId}/data/contacts method (CSV or JSON). When using JSON, you can use the
attribute_values
array for convenience.