External ID for Creating and Updating Contacts

The external ID is a unique contact identifier generated in your system. We recommend using an external ID as the main identifier in the API request field externalCustomerId (or user_idin Mobile SDK). It will help you avoid duplicating contact profiles, collect all available data into a single contact profile, and get complete information about their interaction with your company.

Identifier Types

There are 2 types of contact identifiers β€” conditionally permanent and changeable:

  • Conditionally permanent β€” email, phone number, and other contact data received during the contact’s registration.
  • Changeable β€” web cookies, mobile, web, and telegram tokens.

As a rule, changeable IDs enter the system first, but the external ID is only linked to conditionally permanent IDs.

πŸ“˜

Important

The external ID must be created in your system at the time you first receive any conditionally permanent ID

To better understand how contact data enters the system and how to optimize contact identification, consider 2 basic use cases: creating contacts from mobile applications and websites.

Use Case 1. Creating and Updating Contact from the Mobile App

  1. Contact installs the application on a mobile device with Android OS.
  2. The application transfers the contact's mobile token to eSputnik ( Add/update a contact API method).
  3. eSputnik creates a contact profile with this token as an ID.
  4. Contact registers in the application.
  5. Conditionally permanent identifiers such as email, phone number, or name enter your system.
  6. Your system assigns this contact a unique ID and passes it to eSputnik along with other identifiers, including a mobile token (Add/update a contact API method).
  7. eSputnik finds the contact profile with this mobile token and updates it with new identifiers.

Use Case 2. Creating and Updating Contact for the Website

  1. Non-logged-in contact visits your site.
  2. Appropriate cookies are transmitted and recorded in eSputnik. The contact profile is not created (the web tracking script is used).
  3. Contact registers on the site or subscribes to the newsletter.
  4. Conditionally permanent identifiers such as email, phone number, or name enter your system.
  5. Your system assigns this contact a unique ID and passes it along with other IDs to eSputnik (Add/update a contact or Subscribe a contact).
  6. eSputnik saves the contact with all transferred identifiers and adds their previous history of interaction with your site (cookies).

After a contact profile has been created in eSputnik with the External ID field, we recommend making each profile’s update by this field β€” for example, at login (Add/update a contact) or creating order (Add orders or Generate event). In this way, you will be able to constantly maintain the relevance of all contact data since external ID is unique and immutable, while other identifiers, even conditionally constant ones, can change.

πŸ“˜

Note

If your system does not assign IDs to contacts, you can use eSputnik's system ID (contactId) and save it on your side as a contact ID. However, using the external ID is a better option because this identification 100% prevents the creation of duplicates.

External ID in Single Contact API Methods

Updated logic of single API methods:

The system searches for a contact by external ID when getting a request:

  • if the contact profile with this external ID is found, it is updated with the data from the request;
  • if the contact profile with this external ID has been removed, it will be restored;
  • if the contact profile is not found, it will be created in the system;
  • if there is no external ID in the request, the creation logic remains unchanged.

The contactId is specified in the request URL, and the external ID is passed in the body:

  • if this external ID already belongs to the contact with another contactId, an error will occur;
  • if the external ID does not belong to another contact, the contact will be updated and given that ID;
  • if there is no external ID in the request, the creation logic remains unchanged.

The external ID is added to contact data returned by request.

The external ID has the highest priority in the contact search logic; if the contact profile with this identifier is not found, the system searches for it by email address; if the email is not found β€” by phone number.

External ID in Bulk Contact API Methods

Updated logic of bulk API methods:

You can set the uniqueness of the contact search by the externalCustomerId field. In this case, you cannot set other search parameters.

When importing contacts to eSputnik, you can use any field to define their uniqueness. For example, import contacts with uniqueness by email and, at the same time, add or update their external ID.

Export External ID to BigQuery and PostgreSQL

Export external IDs to BigQuery and PostgreSQL β€” they will appear in the corresponding column in the contacts table. By default, this option is available for all new exports. If you need to create one for existing exports, please contact our support team.

Finding Empty External IDs in eSputnik Account

Create the dynamic segment to find all your contacts with empty external IDs.

  1. Go to Contacts β†’ Segments β†’ Add Segment and create the dynamic segment.
  2. Add condition: Fields β†’ External ID β†’ is empty and click Done.

The system will find all contacts without external IDs and place them into this segment. As the segment is dynamic, all new contacts without external IDs will be also automatically placed in it.