Contacts

What is the difference between a zero and a blank value for a numeric property?

Last updated: June 30, 2016

Available For:

Product: HubSpot Marketing
Subscription: Basic, Professional, & Enterprise

There are two types of numeric properties in HubSpot: default analytics numeric properties and custom created numeric properties. The default values for these properties are handled differently. Learn more below about how these types of properties are set and how values of zero differ from blank properties in terms of list membership.

Default analytics numeric properties:

  • Created by default in HubSpot accounts and cannot be manually edited by users in the account. 
  • The values for these properties are automatically set based on a specific action that has taken place either within HubSpot or externally, such as the number of pages a contact has viewed or the number of Twitter clicks. These properties are processed and set automatically when a contact is created, so if a contact doesn't have any page views or conversions, for example, the value will automatically be set to "0" for those properties.
  • It is normal to see a value of zero for these properties; these properties will default to zero unless an action or analytic event occurs to increase the value. 

Custom created numeric properties:

  • Created by users in a HubSpot account and can be edited by users who have access to the Contacts tool.
  • The values for these properties are not automatically set when a contact is created and appear as blank (no value) by default. You can choose to set the value to "0" or any other numeric value by manually editing the property on a contact record or by using a Workflow to automatically set a property value.
  • It is normal to see a blank value; these properties will remain blank by default unless a value is added by the user.

Creating lists using numeric properties

Example #1: "value is unknown"
  • Create a list with criteria: Contact Property > [Custom Numeric Property] > is unknown, contacts who have no value/blank for that property are included in the list. Contacts who have a value of "0" will not become members of the list because zero is still a known value.
Example #2: "value is known"
  • Create a list based on a number property with criteria: Contact Property > [Numeric property] > is known. Contacts who have "0" as a value or any numeric value will get pulled into the list. Contacts for whom this property is blank will not become members of the list because there is no known value. 
Example #3: "is Equal to 0"
  • Create a list based on a numeric property with criteria such as: Contact Property > [Numeric Property] > is equal to 0. Both contacts with "0" set as their value and those with no value/blank will be pulled into the list.
  • If you would like to exclude contacts with no value (blank) from this list, add an AND criterion of Contact Property > [Number property] > is known

Example #4: "is less than X" or "is less than or equal to X"

  • Create a list based on a numeric property with criteria such as: Contact Property [Numeric Property]is less than or is less than or equal to X. Both contacts with "0" set as their value and those with no value/blank will be pulled into the list.
  • If you would like to exclude contacts with no value (blank) from this list, add an AND criterion of Contact Property > [Number property] > is known