What data types does Mixpanel accept as Properties?

Mixpanel supports five data types for Properties, which are detailed below. The images represent how each data type will appear in the Properties drop-down in Mixpanel reports so that you can tell the type of Property you’re selecting:

alt text

alt text

String

Mixpanel will treat any value sent that doesn’t match any other data type as a string. In reports, Properties sent as strings will allow Events to be broken out by each unique value.

Example:

mixpanel.track('AccountCreated',{'AccountType':'Paid'});


alt text

Numeric

Mixpanel treats any value that is a number (whether integer or decimal) as a numeric Property. Reports can display numeric Properties as histograms.

Example:

mixpanel.track('Application Loaded',{'Load Time (seconds)':1.231});


alt text

Boolean

Mixpanel treats Properties as booleans if the value is either the JSON constant true or false.

Example:

mixpanel.track('Played Video',{'Ad Included':true});


alt text

Date

To guarantee appropriate typecasting across all Mixpanel reports, use the date format YYYY-MM-DDTHH:MM:SS. Make sure you’re sending dates in this format by using the .toISOString method in JavaScript if possible, which will also ensure dates are sent to Mixpanel in UTC.

If you send a unix timestamp as a date, Mixpanel will treat it as an integer; however, in the Mixpanel UI, you can force it to be treated as a date (see Typcasting section below).

Example:

mixpanel.track('Account Created',{'Date First Seen':'2016-06-01T12:34:56'});


alt text

List

Send a list of values (for example, the products in a shopping cart) as a JSON array. In Segmentation, when querying for a particular item, list Properties allow you to see all events where that item was included in the list.

Example:

mixpanel.track('Order Successful',{'Products':['Jacket','Helmet','Gloves']});