Undefined & Null Properties

There are several reasons you might see “undefined” in your Properties list throughout Mixpanel reports when segmenting:

  • The specific Property you’re segmenting by isn’t always sent along with the Event you’re analyzing. For example, let’s say you’re segmenting the Event “App Open” by the Property “Account type” If there are instances where App Open fires without the Account type Property getting sent with it, these will be categorized as “undefined” when you segment by Account type. Another common example is UTM parameters - “undefined” represents users who fired an Event without any UTM in the URL that brought the user to your site.

  • When segmenting an Event by a User Profile Property, you’ll see “undefined” if there are User Profile Profiles that don’t contain that Property or if the Event was triggered by a user without a User Profile at all. For example, let’s say you’re segmenting the Event “Song Play” by the User Profile Property “Favorite Genre.” If there are Profiles that have triggered Song Play but don’t have the Favorite Genre Property, that value will be “undefined.” Triggers of Song Play by users without a User Profile will also show up under “undefined.”

  • For geolocation data (City, Region, Country), the user’s IP couldn’t be mapped to a location or IP was not included with the request. For JavaScript implementations, City, Region, and Country are default Properties. However, if the IP address of the user is not in Mixpanel’s geolocation database and can’t be mapped to a city, region, or country, they will be “undefined” in reports. For server-side implementations, City, Region, and Country can be “undefined” if the IP address is not included with the request. Read more about how Mixpanel maps IP to location.

Remove “undefined” & "null" values from reports

If you don’t want to see “undefined” or "null" values in your report, you can remove it by:

  1. Unchecking the “undefined/null” box in the visualization legend
  2. Looking only at instances where the Property in question “is set
    This will exclude values where you see "undefiend" or "null"
  3. Directly exclude undefined or null values from an Insights visualization by hitting the exclude action.

Troubleshooting tips

If you’re getting “undefined” Property values but think you should not be, troubleshoot the issue using the Events page. Click on Filter in the top left to look at Events coming in where the Property in question “is not set.” You can then use this data to look at your code and figure out why some Events are being fired without that Property.


Did this answer your question?



Article is closed for comments.