All Collections
Mapping Data Types for traits
Mapping Data Types for traits
Derek Skaletsky avatar
Written by Derek Skaletsky
Updated over a week ago

By default, Sherlock ingests all user or account traits as Strings. But you may be sending Sherlock traits that are Numbers, Percentages, or Date / times * and would like to filter, sort, and/or segment by these different trait types.

You can do this by setting a specific Data Type for these traits - basically telling Sherlock how you would like these traits to be treated.

Mapping your traits

To set specific Data Types, simply to go the Data Types tab in Sherlock Settings (you can access Sherlock Settings from the top right icon):

From here you can, set custom Data Types for each of your user and account traits:

Select the Data Type from the drop down menu:

Don't forget to save your mappings:

Voila! Now you can filter, sort, and segment your data using your traits in the intended format.

Supported Data Types

Again, by default, all data sent to Sherlock is stored as a string. But you can change how Sherlock displays and stores this data for three different data types. They are:

  • Numbers: If you are sending numerical data that you would like to sort or filter on, you can set the values of that trait to Number.

  • Date/Time: To have Sherlock handle your date/time traits, you will need to send in the values for this trait in standard ISO format (ie - 2022-04-12T18:00:29Z).

  • Percentages: To display and sort data as percentages, you should send the values in as decimal values that will be multiplied by 100 and displayed as a percentage. For example, if you send in 0.75 as the v.alue for a trait set to display as a percentage, we will display it as 75.0% (we multiply the value - 0.75 - by 100 and then display the result as a percentage).

Did this answer your question?